Is there a way to name the CSV sheet exporting by the Data Export widget?

[mariaSutton]

Hi, 

I am trying to explicitly name the sheet that is exported when using the Data Export widget in a mashup. Currently the filename is copied to the sheet name, however the sheet name can only hold 31 characters and the file name will always be longer. 

[CharlesJi · Accepted solution]

Hi @mariaSutton, 

The Data Export widget simply exports a CSV (Comma-separated values) file, which are just lines of data with commas separated.

If you open a CSV file in Excel, it takes the filename to 'name' its sheet automatically (just for the visualization, no changes made to the file itself).

You'll have to save it as some sort of Excel file in order to rename the Excel sheet name explicitly. Note that by doing so, your file extension will be changed (e.g., from .csv -> .xlsx), and technically, the file will no longer be a CSV file anymore.