CSV2XL Examples
AddSheet
Assume these two files:
File1.csv:
//XL,AddSheet,dstbook=test.xls,sheetname=test sheet1
Name,Age,Sex,...
<data>
File2.csv:
//XL,AddSheet,srcbook=test.xls,dstbook=test.xls,sheetname=test sheet2
Account#,Address,Amount...
<data>
Execution:
.PRINT CSV2XL=FILE1.CSV ! creates TEST.XLS with sheet named "test sheet1"
.PRINT CSV2XL=FILE2.CSV ! loads TEST.XLS, adds new sheet "test sheet2", saves it as TEST.XLS
The specified new sheet will be appended to the end of the workbook, and the existing file will be overwritten.
