Manage Worksheet

Spread.Services Documentation
Manage Worksheet
Collapse All Expand All

Spread.Services Documentation > Developer's Guide > Customize User Interaction > Manage 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 Spread.Services, 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
- Work with Shape And Picture
- Customize Worksheets

See Also
Allow Sort
Apply Table Sort

Copyright © GrapeCity, inc. All rights reserved.