Hello Balakrishna,
You can load the data in 2 ways:
Using OLEDB VBO and get data into collection
Save the in csv format and use the Utility - File management VBO - > Get CSV text as collection.
In the first method, Though this is simple and reliable to use OLEDB with excel file, We need to install the ODBC drivers if not installed. So there might be chances of unavailability of OLEDB drivers where we deploy the bot
In second method, we just need to save the file into CSV format, as size of CSV file format will be smaller as compare to .xls/.xlsx, so will be easily load into the collection without having the out of memory exception. We need to take care of some special character like (`) to be on safer side.
Thank you.
Regards,
Vijay Rudrappa Dodamani
