Add a sheet to an Excel file created with Notepad?
Posted on 2016-08-04
Sounds crazy, but a colleague told me one can make a spreadsheet from text data by using tab delineation instead of comma (CSV). I have a circumstance it which it would be better to produce a tab separated file instead of CSV and then just rename it ".XLS". I tried it, and it works just fine!
However, I need to have more than one sheet in the Excel file. Is there a command that I can put into the text file to cause the data that follows it to be on a new sheet?