A worksheet is a matrix of cells where you can enter and display data, analyse information, write formulas, perform calculations and review results. The cells in a worksheet are defined by rows (represented by numeric characters like 1,2,3) and columns ((represented by alphabetical letters like A,B,C etc.). For instance, in a worksheet, C6 represents the cell in column C and row 6.
In DsExcel .NET, you can use the methods of IWorksheets to execute different tasks in a spreadsheet including insertion of a new worksheet in the workbook, deletion of a worksheet from the collection, assigning an active sheet, and so much more.
Managing a worksheet involves the following tasks: