(Showing Draft Content)

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:

• Work with Worksheets

• Range Operations

• Customize Worksheets

• Worksheet Views

• Cell Types

• Quote Prefix

• Tags

• Rich Text

• Date and Time Format for a Culture

See Also

Sort

Table Sort