I am trying to read excel file using excel application scope activities, but excel gets stuck and wont throw any exception until force close the excel

Help Activities
1

I try to replace it with workbook read range activity, then for same excel i m getting file is corrupt error.

2

Hi @p.kalbhor

Can you try like below

image
image829×892 28.7 KB

Regards,

3

in current flow i m doing the same, but excel gets stuck for longer to read

4

@p.kalbhor

1.If possible can you please share that excel if the data is not confidential
2.Try to update UiPath.Excel.Activities Package
3.In Excel Process Scope activity properties change the Existing processes action property to Force Kill
4.Read Formatting as Display Value

image
image1071×612 69.7 KB

image
image599×607 38.3 KB

Regards,

5

@p.kalbhor,

It seems your file is big or have many rows. This could result in slow reading. Also Modern Read Range is slower compared to Classic.

Add log message before Read Range so you will get to know if file is opened.

Thanks,
Ashok :slight_smile:

6

This indicates something is wrong with the Excel file.

Open the Excel file, save it as CSV, then open the CSV in Excel and re-save it back to Excel. Now try it with your automation.