I have read a range then added a Data Column to this range.
When I try to append my range to excel file, I receive exception: range doesn’t exist.
2.While debugging I tried to append this name to csv file just to check, and it worked fine. So the range exists.
3.Also, when I append this range to excel as it is without adding a Data column, it is also works fine.
What’s the problem why it doesnt work for me in 1. ?
Are you Reading Range in the beginning, then adding this column, adding some more rows and then want to write back to the same excel? If so, i would just use write range and overwrite everything…