Hoe to write Datatable in different excels - no repetition of data

Help
1

Hi Everyone,

I’m running a query in data base that returns 10,000 records. I want to store 1000 records per excel. I’m trying multiple options but not able to get the results.
Any help is much appreciated.

Regards,
Isha

2

@IshaSharma,

Try with the attached xaml, you need to make the “YourDataTable” variable as your input data table, then run with that, it will write all the data into multiple sheets based on tables count passed in.

SplitDataTable.xaml (6.6 KB)

3

Hi Sarathi,
Thanks for quick reply, I ran the code and getting the below error.
I have defined all the variables under most outer sequence.

image _Test.xaml (8.6 KB)

4

@IshaSharma, Sorry, missed a .ToArray in the query, now it is working, I have tested it form my end.
_Test (1).xaml (8.0 KB)

5

Thank you so much Sarathi. Above solution Worked.

1 Like
6

This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.