Please enable JavaScript to view this site.

ASQL Reference

Navigation: » No topics above this level «

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.