Worksheet

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 GcExcel .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

• Freeze Panes in a Worksheet

• Freeze Trailing Panes in a Worksheet

• Customize Worksheets

• Worksheet Views

• Cell Types

• Quote Prefix

• Tags

• Rich Text