How to work on heavy excel files

J

jassi_123

Member
Hello Team,

I have a excel file which contains around 1,00,000 records and I would like to export this data to a collection but the blueprism gets hanged. So is there any way by which I can export this data to a collection and then process each record via robot one by one.

Regards,
(Jaspreet Singh)
 
A

Anton Hosang

Member
If that Excel file is growing, you're going to hit a sheet limit soon!

Perhaps look into an OLEDB connection to the closed Excel file, and read into a collection that way.
 
You must log in or register to reply here.
Top