Hi All,
For one of my automations I have been using workbook write range activity to update an excel file but as the data volume has incresed it is failing at time to update the row properly, Can anyone please suggest any alternative solution to update few columns based on row index .
Hi @Yoichi any help from your end would be really appreciated.
Looking forward!
Hi,
I would try UseExcelFile as the first thing to come up with, but that’s out of your requirements, isn’t it?
If root cause is simply data size, it might be necessary to split the file and reduce size per file.
Regard,
Hi,
The catch is we want to write/update the excel for every transaction in last 4 columns only,
the file which we want to write in is larger in size, we have argumnet been passed as we are reading it in chunks,
so while writing we do have columns names in particular sheet, we need to write it at particular row and column index.
Regards,
Mayank.