Please enable JavaScript to view this site.

A-Shell Reference

Navigation: Development Topics > Spreadsheet Interface > CSV2XL > Other CSV2XL Topics

CSV2XL Examples

Scroll Prev Top Next More

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.