Manage Worksheets of Microsoft Excel files.
Adding Worksheets to a New Excel File
To create a new Excel file programmatically:
- Create an object of the Workbook class.
- Call the Add method of the WorksheetCollection class. An empty worksheet is added to the Excel file automatically. It can be referenced by passing the sheet index of the new worksheet to the Worksheets collection.
- Obtain a worksheet reference.
- Perform work on the worksheets.
- Save the new Excel file with new worksheets by calling the Workbook class' Save method.
Adding Worksheets to a Designer Spreadsheet
The process of adding worksheets to a designer spreadsheet is the same as that of adding a new worksheet, except that the Excel file already exists so should be opened before worksheets are added. A designer spreadsheet can be opened by the Workbook class.
Accessing Worksheets using Sheet Name
Access any worksheet by specifying its name or index.
Removing Worksheets using Sheet Name
Removing Worksheets using Sheet Index
Removing worksheets by name works well when the name of the worksheet is known. If you don’t know the worksheet’s name, use an overloaded version of the RemoveAt method that takes the sheet index of the worksheet instead of its sheet name.
Activating Sheets and Making an Active Cell in the Worksheet
Sometimes, you need a specific worksheet to be active and displayed when a user opens a Microsoft Excel file in Excel. Similarly, you might want to activate a specific cell and set the scrollbars to show the active cell. Aspose.Cells is capable of doing all these tasks.
An active sheet is a sheet you’re working on: the active sheet’s name on the tab is bold by default.
An active cell is a selected cell, the cell into which data is entered when you begin typing. Only one cell is active at a time. The active cell is highlighted by a heavy border.
Activating Sheets and Making a Cell Active
Aspose.Cells provides specific API calls for activating a sheet and a cell. For Example, the Aspose.Cells.WorksheetCollection.ActiveSheetIndex property is useful for setting the active sheet in a workbook. Similarly, Aspose.Cells.Worksheet.ActiveCell property is used to set and get an active cell in the worksheet.
To make sure that the horizontal or vertical scrollbars are at the row and column index position you want to show specific data, use the Aspose.Cells.Worksheet.FirstVisibleRow and Aspose.Cells.Worksheet.FirstVisibleColumn properties.
The following example shows how to activate a worksheet and make an active cell in it. In the generated output, the scrollbars will be scrolled to make the 2nd row and 2nd column as their first visible row and column.
- Copying and Moving Worksheets
- Count number of cells in the Worksheet
- Cut and Paste Cells
- Detect Hyperlink Type
- Display Features
- Find if the Worksheet is Dialog Sheet
- Get Cell Validation in ODS Files
- Get Hyperlinks in Range
- Get Range with External Links
- Get worksheet unique id
- Managing Page Breaks
- Page Setup Features
- Print multiple copies of a worksheet
- Security Features
- Update Days Preserving History of Revision Logs in Shared Workbook
- Utilize Sheet.SheetId property of OpenXml using Aspose.Cells
- Worksheet Views
- Add Signature line to the worksheet