Write each query output to new csv sheets
Hello, I am able to fetch the query results and save to new CSV file using jscript. But I need to save the query results to a new sheet each time in the same CSV File. This is th...
Forum Discussion
HKosova
Alumni
AlumniOK, let me put it differently. CSV files have only 1 sheet. They can't have multiple sheets.
If you create a multi-sheet workbook in Excel and then try to save it as a CSV file, you'll see a warning like this:
---------------------------------------------------------------------------
The selected file type does not support workbooks that contain multiple sheets.
* To save only the active sheet, click OK.
* To save all sheets, save them individually using a different file name for each, or choose a file type that supports multiple sheets.
---------------------------------------------------------------------------
If you need a multi-sheet data file, use the Excel file format - XLS or XLSX. Here's an example of how to write to Excel files:
Write data to MS Excel
If you create a multi-sheet workbook in Excel and then try to save it as a CSV file, you'll see a warning like this:
---------------------------------------------------------------------------
The selected file type does not support workbooks that contain multiple sheets.
* To save only the active sheet, click OK.
* To save all sheets, save them individually using a different file name for each, or choose a file type that supports multiple sheets.
---------------------------------------------------------------------------
If you need a multi-sheet data file, use the Excel file format - XLS or XLSX. Here's an example of how to write to Excel files:
Write data to MS Excel