Excel Remain Open Issue

Help Activities
, , ,
1

Hello @UiPath_Community

I am using Read Range and Write Cell activity to read and update data in excel. But while running my automation bot use to open excel for reading as well as for updating data. Sometime it do not close excel and due to which my automation stucks in between and fails.
What should I do so that bot can read and update excel with out opening it in background.

Thanks In advance

2

Hi @Vaibhav_Shukla

In the Excel process scope activity open the properties in Existing processes action option select the Force kill option in dropdown. It will close the excel automatically after the activities inside Excel Process scope activity ended. Keep Show Excel Window as False

image
image435×552 14 KB

Regards

3

@Vaibhav_Shukla ,

You can use Read Range - Workbook activity to red the data into DataTable and do the update in Datatable.

Once everything is ready you can use Write Range - Workbook activity to write the data back again to Excel.

Thanks,
Ashok :slight_smile:

4

@Vaibhav_Shukla

Use workbook activities to read the excel Instead of Excel Process scope or Excel application Scope.If you have huge data then use Excel process scope then

image
image1244×271 21.5 KB

This will not open the excel in background it will open

5

Hi @Vaibhav_Shukla

Try this:

image
image1322×340 23.6 KB

OR For safe side you can use Kill Process Activity after you complete the excel tasks with Continue On Error as True

image
image1252×303 21.4 KB

Hope it helps you to understand :slight_smile:

6

Hello @Nawazish_Ahmad

If we use kill process to close excel and if again we open excel below kill process, so will it not create any error or issue while reopening ??

1 Like
7

@Vaibhav_Shukla No, it will not create any problem.