Question
TATA Consulting Services
TATA Consulting Services
CO
TATA Consulting Services
Posted: Jun 24, 2020
Last activity: Apr 30, 2021
Last activity: 30 Apr 2021 17:26 EDT
Closed
Optimize loop excel
Good Morning. I need to search for some fields in an excel file and concatenate them to paste that value in another excel file, however there are many records and the process takes a long time to paste, it is possible to optimize this automation, or it is better to make a script that would take a few seconds ? Attached screen. Thank you very much.
***Edited by Moderator Marissa to update Content Type from Discussion to Question***
***Edited by Moderator Marissa to change type from General to Product, update Product details and Platform Capability tags***
To see attachments, please log in.
Posted: 3 years ago
MOD
Pegasystems Inc.
US
@fredyalexandera9551 Iterating through each row using GetCellValue will be the slowest option. I would suggest using a script where you can accept a DataTable as an input and then output anotjer DataTable object to insert into the new spreadsheet. Each Excel connector has a method for exporting a range of cells as a DataTable. This can be passed to a script and manipulated there much faster than in an automation. Each connector also has a corresponding method for imp[orting data from a DataTable that you'd use once you produced an updated DataTable. Let me know if you need an example.