Get Free Trial

How to change the sheetname of csv while exporting?

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 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

Please login or Register to Submit Answer