I am in the middle of a module where I want to convert the String into Datatable to write into excel file. 10000+ lines.
Now suppose I have these 12000+ lines with the data separated by 15 “|” signs, making it to be 16 columns.
I am using Generate Data table activity to insert the text file and setting “|” as a separator.
As I get the output of Generate Data table as a DT, I am writing it into the excel file, following are my obsevations:-
Only 5000 lines are outputted into the excel file,
Excel file got corrupted and opens in read only mode.
Looks fine in the Preview of the generate data table
I want to know if there are some limitations for the generate data tables. If not, please help me understand where I am going wrong.
Kindly help, it is urgent.
Thanks and Regards,