Use Excel Activities for convert in Data Table is very slow

[vzipperer (Victor Luiz Cardoso Zipperer)]

Hello all,
I’m using the package UiPath.Excel.Activities 2.12.3, but when I running my process, the part of excel reading is very slow, and take about 8 minutes to read a simple sheet, I have others projects with same package, but other version 2.11.4, and take about less than 5 secons to read.

I am make sonthing wrong?

ExcelExample.zip (258.8 KB)
Plan_Example.xlsx (689.7 KB)

[Yoichi]

Hi,

For some reason, ReadRange in ModernExcel (ReadRangeX) is very slow in some cases.
As a workaround, can you try classic ReadRange (ExcelReadRange) as the following?

In my environment, classic ReadRange took just 4 sec but ReadRangeX took 4min 33 sec.

Regards,

[vzipperer (Victor Luiz Cardoso Zipperer)]

Thank you very much! It’s worked very well, this bug the Ui Path needs fix this problem, oldest version is better than recent version…