CSV file -Renaming sheet name

Help
1

Hi,

My requirement is copying excel data to CSV file and the CSV file name should be xxxx.csv and the sheet name should be yyyy .How do i implement this?

I used excel application scope to generate the datatable from excel and passed that variable to WriteCSV/AppendCSV to create csv file.In there i can able to mention the file name as xxxx.csv using filepath property .But where to give the sheet name ?By default it takes the file name as sheet name

Please suggest me the solution .Struggling for long time

Regards,
Sathiswaran.P

2

There is no concept of sheet names in a csv file. A csv file is simply a text file that is tabular data with separators, there’s no such thing as a sheet in CSV, only after it’s imported to Excel does it get a sheets name.

3 Likes
3

yes @bobpeers i understood .thanks for ur reply

regards,
Sathiswaran.P

4

This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.