Menu
I'm looking to create a .csv file that can be opened in Excel that displays 2 tabs. However, the catch is that the script that I write has to be in a batch file (command prompt). I've seen a few ways to do this online, but they're all JAVA programs. I'm not sure about doing this in command prompt
Is this even possible?
425
CSV files are plain text files. Not spreadsheet files. Therefore, you can not have multiple sheets in a single CSV file.
To open a comma-delimited (CSV) file properly, use Excel's Data Import from Text feature to open the import wizard and set all columns as text.
Asking excel to save a multiple-sheet workbook as CSV got me this error message:
So, no, not possible.
54
If you love us? You can donate to us via Paypal or buy me a coffee so we can maintain and grow! Thank you!
Donate Us With
