Add/Create Sheets in CSV

Hi everyone,

Using excel application scope is it possible to add/create a sheets in CSV file.

I am using Write Range Activity inside Excel application scope to create a sheet called : Sheet1.

But the data is overwritten on the existing sheet.

is there anyway around to achieve to create a sheet in the CSV file, please help me out.

WRE

Thanks a lot for you kind advice in advance.

Regards
Vishnu

CSV can only have 1 sheet as they are not excel files (more like a text file)
Save it as XLSX

Hi @TimK,

I found the solution to add the sheets into CSV now.
Read from A.CSV
Use Excel Application Scope to create a new B.CSV file and and use Write Range activity to create any number of sheets within that B.CSV file.

Regards
Vishnu

1 Like