I’m trying to copy a whole column from an excel file to another, using datatable tools. The thing is that the first time this doesn’t work (Write cell activity gives me an exception : IndexOutOfRangeException), but the second time i launch the workflow, it works !
I even tried to count the columns using Datatable.Columns.count. The first time I do that (When I launch the workflow for the first time), it gives me 13 (This is way I have the exception after! ), and the second time, 14. I really tried to figure out what is the problem, and what happens in the workflow that makes it work the second time, but I didn’t succeed.
You will find attached an exemple of the workflow I use, with two excel files. I’m trying to copy column “N” from one.xls to two.xls. This is just a dummy example that works from the first time (Since I can’t upload the original one because of my company’s restrictions). So do you see any clue about what happens or do you have any idea why this happens ?
Any help will be much appreciated.
CopyExcelProject.zip (16.2 KB)