Why taking too much time in Modern read range Activity

Help Activities
, ,
1

Hi Guys,
I am working on Excel automation, i need to read 5 excels like bank statements, ERP reports etc. its huge data with date columns, if i read with workbook activities it will complete within seconds of time but dates will come as a numbers. so i am using Excel activities (Modern) but its take too much time. my process execution time is below one minute (developed only linqs) but only reading time is more than 20 minutes. Even excel classic activities also reading quickly , but i dont want mix with classis activities in modern activities process). I am not satisfied with this, please help me to reduce time to reading.
(i already tried with number of new processes with updated and degraded versions, not only my laptop, tried in colleagues and sever systems also same timing)

please look differences in below images(Same file with different timings).

image
image871Ă—215 13.7 KB

image

2

@Vijay_0815,

Try this solution if not tried already.

Thanks,
Ashok :slight_smile:

3

Thanks for reply.
its not working bro, same timings

4

I suppose these “numbers” are OADate data type and that you can simply convert to DateTime
datetime = DateTime.FromOADate(your_date_as_number)

Cheers

1 Like
5

Thank you so much. its working without depending on Excel activities :heart:

6

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