Adding and Removing Worksheets
You can add or remove worksheets on the Excel 2007+ component, either manually, or by reloading them from an input .xlsx file. To do so, click the 
button next to a worksheet node.
Add/Remove Excel Worksheet selections dialog box
The options applicable to worksheets are as follows.
Show Worksheets by name | This option must be selected if each worksheet in your workbook has a different layout and therefore must appear as a separate item in MapForce.
If all worksheets in your workbook have an identical structure, you can make this option inactive. This way, MapForce will collapse the worksheet items to a single item representing the ordered collection of all worksheets.
If a workbook has multiple worksheets and the Show Worksheets by name option is inactive, then MapForce treats the workbook like a single worksheet. This allows a mapping to process any number of worksheets at once, but requires that all worksheets have the same structure. See Example: Convert Excel Rows to XML Files. |
Insert ( | Inserts a new worksheet before the currently selected one. |
Append ( | Appends a new worksheet. Type a name into the text field to the right of the icon. |
Delete ( | Deletes the currently selected worksheet. |
Get New Sheets From Excel File | Gets into the component the new worksheets found in the input Excel file. This setting is relevant and enabled in source components which have an input Excel file. |
