How to speed up excel data reading?

Help Studio
, ,
1

Hi,

Im trying to troubleshoot and need your idea on how do i speed up the reading in excel data says up to thousands of row.

image
image473×734 62.4 KB

im using user browser/application then read range, then assign then for each row

assign work as below
ZDATA.AsEnumerable.Where(Function(x)Date.FromOADate(CDbl(x(“DATE”).ToString)).Date = Now.Date).Select(Function(x)x(“JOB NO”).ToString).ToArray

basically this process is to read today’s date, then copy job number column and paste.

It works in low data row like few hundreds, but slow and no respond in thousands.

Thanks.

2

Hi @Alfred_Gan

after reading datatable, try to work on specific column with valid condition and in properties set timeout to 0 sec.

3

Hi @caggarwal

Do you mean under this timeout for typeinto activities?

image

4

Use mysql to retrieve data from the Excel into a data table - Learn / Video Tutorials - UiPath Community Forum Maybe this will be helpful for you because you can use sql to manipulate the data during the reading

5

This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.