# CSV2XL Examples

> [HTML Version](csv2xlexamples.htm)

**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.xlsx,dstbook=test.xlsx,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.XLSX, adds new sheet "test sheet2", saves it as TEST.XLSX

The specified new sheet will be appended to the end of the workbook, and the existing file will be overwritten.