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