Reading a CSV file and Putting into Multiple Excel Files

excel

#1

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.


#2

Hi @Divyansh2405,

I have some suggestions.

  1. Read the csv into a datatable.
    2.Use assign activity to give condition in the datatable.Selection and copy into a new datatable “dtNew”.
  2. You can write into a new excel sheet by dtNew.

Regards
Balamurugan.S


#3

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?


#4

on what criteria are you separating the different excel files to be posted into?