Document Solutions for Excel, Java Edition | Document Solutions
Features / Worksheet
In This Topic
    In This Topic

    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:

    See Also