I have 2 lakhs row. I used both excel as well as workbook activities but read range taking too much time.
Plz help
Hi @AsadPathan2665 ,
unfortunately, we have only these activities and please don’t worry it will take less time than human being. Thanks
can you check following:
Hey @AsadPathan2665 you can try using excel as db.
It may help you to reduce the reading time as it is considering the excel as a database and write a query to select all thew datas from the excel.The output will be in datatable.
Thanks and Regards…
Sreejith…