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.
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.