This sample demonstrates how to customize spreadsheets using XlsIO.
Excel provides options for working with worksheet manipulations. You can copy a worksheet, move a worksheet from one position to another, rename a worksheet, delete a worksheet, insert a worksheet, and insert tab color. These options provide users with great flexibility to work with worksheets.
- Selecting a worksheet from one workbook and copying it to another workbook with or without worksheet elements
- Sheet renaming
- Sheet activation