# Worksheet

Use DsExcel Java to work with worksheets, apply operations on range, freeze panes in a worksheet, customize worksheets, apply rich text, and more.

## 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](/document-solutions/java-excel-api/api/online/com/grapecity/documents/excel/IWorksheets.html) interface stores the collection of all the sheets in the workbook and the [IWorksheet](/document-solutions/java-excel-api/api/online/com/grapecity/documents/excel/IWorksheet.html) 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](/document-solutions/java-excel-api/docs/online/Features/ManageWorksheet/WorkWithSheets)
* [Range Operations](/document-solutions/java-excel-api/docs/online/Features/ManageWorksheet/RangeOperations)
* [Customize Worksheets](/document-solutions/java-excel-api/docs/online/Features/ManageWorksheet/CustomizeWorksheets)
* [Worksheet Views](/document-solutions/java-excel-api/docs/online/Features/ManageWorksheet/WorkwithWorksheetViews)
* [Cell Types](/document-solutions/java-excel-api/docs/online/Features/ManageWorksheet/work_with_cell_types)
* [Quote Prefix](/document-solutions/java-excel-api/docs/online/Features/ManageWorksheet/work-with-quote-prefix)
* [Tags](/document-solutions/java-excel-api/docs/online/Features/ManageWorksheet/use_tags)
* [Rich Text](/document-solutions/java-excel-api/docs/online/Features/ManageWorksheet/SetRichTextinaCell)
* [Date and Time Format for a Culture](/document-solutions/java-excel-api/docs/online/Features/ManageWorksheet/Date-time-format-for-culture)

## See Also

[Sort](/document-solutions/java-excel-api/docs/online/Features/AllowSort)
[Table Sort](/document-solutions/java-excel-api/docs/online/Features/UseTable/ApplyTableSort)