How to change the sheetname of csv while exporting?

posted on September 20th, 2021

Answered

loveena asked on September 20, 2021

Hi
I am exporting the CSV file using method

pivot.exportTo('csv', {
filename:"test"
});

The exported csv file has default "sheet1" name in it. I need to change that sheet name like we are doing in

pivot.exportTo('excel', {
filename:"test", excelSheetName:"test"
});

Please tell me how i can do it.

Thanks

2 answers

Public

Illia Yatsyshyn ⋅ Flexmonster ⋅ September 20, 2021

Hello,

Thank you for posting on our forum.

Please note that CSV is not a native file type for Excel. Unlike XLSX, it does not store any information about the sheet name or other metadata specific to Excel. Excel uses the default sheet name ("Sheet1") to open any CSV file.
Use export to Excel if a specific sheet name is required in your case.

Please contact us if any other questions arise.

Kind regards,
Illia

Public

loveena ⋅ September 20, 2021

Thanks

How to change the sheetname of csv while exporting?

2 answers

Please login or Register to Submit Answer