(Showing Draft Content)

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:

• Work with Worksheets

• Range Operations

• Customize Worksheets

• Worksheet Views

• Cell Types

• Quote Prefix

• Tags

• Rich Text

See Also

Sort

Table Sort