Since i developed the process to load (text file) into datatable, and add the column header, then want to save datatable to CSV File (using Write Range activity). But i encounter the exception error for (Row number must be between 1 and 1048576, Parameter name: cellAddressInRange). Please help to suggest the solution on this. Thank you all in advanced.
Hello @mita29 ,
It seems there was an issue with extracted text file, Do you have any sample of text file.
Also Please share, What are the activities you have used to load text file to datatable.
Thank for your comment, pls let me elaborate more per your concern.
- Iām using write csv activity to save data from datatable to csv file.
- i could read csv file to datatable with out any issue.
Hi, thank you for your reply. Iām using āwrite csv activityā to save datatable to csv file.
I have work-around by looping each datatable row, then append line to text file with ā,ā delimeter. But took so long to finish the process.
Oh, I see, you can not write data to csv by āwrite rangeā , and āwrite csvā with loop it will take a lot of time with large data
Have you try write it to excel by āwrite range workbookā then convert this excel to csv
Hi @mita29 ,
Just checking in here to see if we can have a sample project to help us investigate this further.
Thanks,
Raluca
This topic was automatically closed after 3 days. New replies are no longer allowed.