Using collection loop the record one after another and paste it in excel

KK — Mon, 25 Sep 2023 07:57:00 GMT

Hello Team

We have one issue from collection --where writing the data in to excel from collection using the loop record by record. We miss some of the rows in writing to the excel. For example we have 80000 rows in collection after writing in to the excel we only get 60000 where we are missing 20000 hence sum of the column total value is not correct. So Please let us know if you have any idea or faced this kind of situation.

Thanks in advance..

------------------------------
KK
------------------------------

RE: Using collection loop the record one after another and paste it in excel

Mukeshh_k — Mon, 25 Sep 2023 08:39:00 GMT

Hi @KK - I would recommend to take the other approach as people did in the past - if there are higher volume of records - use CSV Text file approach -

Use Strings::Get Collection as CSV to transform your large collection into CSV text data item.
Use File Management::Write Text File to create .csv file from your CSV-like text data item. Use MS Excel VBO::Import CSV to import your new .csv file into excel (you can set specific cell to start from).

You can customise this action in your extended MS Excel object(Record Macro - try replicating the Import CSV - copy the code and compare with Import CSV action in MS excel VBO to add the extra params)

------------------------------
Regards,

Mukesh Kumar - Senior Automation Developer

NHS, England, United Kingdom, GB
------------------------------

topic RE: Using collection loop the record one after another and paste it in excel in Product Forum

Using collection loop the record one after another and paste it in excel

RE: Using collection loop the record one after another and paste it in excel