Follow these steps to add a single sheet to an Excel workbook:
1. Select the special process “[104] (*.XLS) Add a new sheet to workbook at a specified location” from the Special Process drop down list. The file format is automatically set as *.XLS.
2. Next select the input and output files. If input and output files specify the same location the page will be created in the input file. If input and output files are different, a new workbook will be created for the output that contains all the pages of the input plus the newly created sheet.
3. Click the Click here for Add Sheet Details button.
a. Specify a sheet name and location.
b. Note that you may create a new blank sheet to replace an existing one if the check box ‘If sheet already exists, delete it and add a new empty one’ is selected.
4. Optionally click the Add button to add the task to the Conversion Task list. You may add multiple tasks to the Conversion Task list before initiating the conversion process by repeating Steps 1 - 3 as necessary.
5. Click the Convert button to execute the process.
Additional Details
This special process can add new worksheets to one or many workbooks.
Name of Sheet To Add is the name of the sheet to add. Not required.
Overwrite If Output Exists: If Output Sheet already exists, it will be overwritten by Input Sheet if this option is checked. If Output Sheet already exists nothing will be done if this parameter is not selected.
Sheet Before is only used when adding the worksheet to the same workbook (Input File = Output File). Added sheet will be placed before this sheet (Name or #).
Sheet After This is only used when adding the worksheet to the same workbook (Input File = Output File). Added sheet will be placed after this sheet (Name or #).
Note: When Input File is the same as the Output File the positioning info (Sheet Before or Sheet After) is used. Otherwise positioning info is ignored and a new Workbook file will be created, and saved as the Output File.