A worksheet refers to 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 (representing numeric characters like 1,2,3 etc.) and columns (representing alphabetical letters like A,B,C etc.). For instance, in a worksheet, B3 represents the cell in column B and row 3.
In DsExcel Java, the IWorksheets interface stores the collection of all the sheets in the workbook and the IWorksheet interface represents a particular worksheet.
You can use the methods of the IWorksheets interface and IWorksheet interface to execute important tasks in a spreadsheet including insertion of a new worksheet in the workbook, deletion of a worksheet from the collection, assigning an active sheet, executing range operations and so much more.
Managing a worksheet involves the following tasks:
