Read Excel file Time

Hello All,
I have an excel file with 473 columns and 1 lakh+ rows, so in excel application scope, read range workbook and Excel process scope to read the data it’s taking around 30-40 min of time. Is there any other possible way to read the data in least time. Please help me in sorting this issue.

Hi @isbsrobot2

If that’s the case then I would recommend to host the data in a database instead of an excel file
Then it becomes very easy to query out the data we need

Or

Treat excel file as a database and extract the data from it
Refer this for more details

Or finally you can try with marketplace component

Hope this helps

Cheers @isbsrobot2