How to copy all contents of excel columns into new excel sheet by spliting it

Hi all,

I have 1 excel sheet which has 100 columns and i need to copy all those columns into another excel by spliting it. contents should be same and it should be delimited by using comma “,”.

Please help me on this guys.

Hi @Kiran_Bg,
Please check out other forum topics. There are a lot of topics about excel, columns, rows etc :slight_smile:
Check out this for example:

hope these steps would help you resolve this
–use a excel applications scope and pass the file path as input
–inside the scope use a READ RANGE activity and get the output with a variable of type datatable named dt
–now use a WRITE CSV FILE activity where pass the above datatable variable as input and pass the file path of the comma delimited file (.csv) so that the data in datatable will be written to a csv file

Cheers @Kiran_Bg

Hi @Palaniyappan. I need to do operation using split function by delimiting comma “,” as separator.
Like i have to take for loop ,inside for loop i have to use split function for each column ,
Then i have to pass all these data to another excel.
This is my requirement.

can i have a example of the process

MinMax.xaml (17.0 KB) Hi @Palaniyappan Please find the attached eexample.Test.xlsx (8.2 KB)

My requirement are in below step:


  1. Read excel sheet.
  2. Fetch the data using split function delimiting comma “,” as separator.
  3. Add all these data’s to queues by using single argument.
  4. From queues fetch the data column by column.
  5. Now find the Min value for each column.
  6. Store output in excel sheet.

Hi @Palaniyappan Did you find any answer, if yes means please share me , i’m facing difficult to find this.


1 Like