I have been trying to Read a csv file and posting it into Multiple Excel Files. Anyone have any Solutions?
Just FYI: I am able to do it with a single file using READ CSV and WRITE CELL.
Hi @Divyansh2405,
I have some suggestions.
- Read the csv into a datatable.
2.Use assign activity to give condition in the datatable.Selection and copy into a new datatable “dtNew”. - You can write into a new excel sheet by dtNew.
Regards
Balamurugan.S
Thanks @balupad14 for the reply. But I already made one variable for Data table. Its the condition thing that I am struggling with. How do I give conditions based on the column names?
on what criteria are you separating the different excel files to be posted into?