Write the sheet name in the multiple cells for multiple csv files

Help Activities
, ,
1

Dear Team,

I have a multiple csv files and i have to do the this for each csv file, read the sheet name and write it in the C column till the end of the rows .i.e 1048576.
Please help me to create this workflow.

Thanks,
Amol Golhar

2

@Amol_Golhar

one thing..csv would not have sheets..if you need to write same value thrn try reading data …add data column to datatable as needed and write back

cheers

3

@Amol_Golhar,

There is sheet name concept in CSV File. It just get displayed like that when we open the file in Excel.

You can use read the csv as text file and those extra rows you needed at the end and write that string back to the CSV.