Please enable JavaScript to view this site.

A-Shell Consolidated Reference

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.