EXAMPLE 3 Append sheet data from a folder of workbooks to a single sheet

To copy the used range of Formulas of "Sheet1" of all the workbooks in the "D:\XLSFiles\" folder, to "Sheet1" (placing the appended data below existing data) of the workbook "D:\XLSFiles\Target.XLS", the following syntax would be used:

ConvertXLS.EXE /S"D:\XLSFiles\*.XLS" /T"D:\Output\Target.XLS" /P101 /1"Sheet1" /2 1 /6"Sheet1" /7TRUE /8below

To place the data to the right of existing data change /8below to /8right

Note it is highly encouraged that you use the Verbose (/V) switch initially to see what the status of your conversion is.

Examples:

EXAMPLE 1: Copy all values from one sheet to another, within same workbook

EXAMPLE 2: Copy specified range of formula from one workbook to another

EXAMPLE 3: Append sheet data from a folder of workbooks to a single sheet

EXAMPLE 4: Example 4 Copy ALL including column widths from one workbook to another

P101 Copy Specified Sheet Data to same or different XLS file