SpreadsheetGear Namespace : IWorksheet Interface

IWorksheet overview

Public Properties

Cells	Returns an instance of IRange which provides access to cell values, formulas, formatting and other cell properties and methods.
DisplayAutomaticPageBreaks	Gets or sets the property which specifies whether automatic page breaks should be displayed.
HPageBreaks	Returns a reference to the horizontal page break collection for the worksheet.
Hyperlinks	Returns a reference to the hyperlink collection for the worksheet.
Names	Returns the collection of worksheet specific defined names associated with this worksheet.
Outline	Returns an instance of IOutline which provides access to outline options.
PageSetup	Returns an instance of IPageSetup which provides access to page setup uptions.
ProtectContents	Gets or sets the property which specifies whether the contents of a worksheet are protected.
Range	Returns an instance of IRange which provides access to cell values, formulas, formatting and other cell properties and methods.
Shapes	Returns the collection of shapes associated with this worksheet.
StandardWidth	Gets or sets the default column width for this worksheet in units equal to the width of a character in the default font.
TransitionExpEval	Gets or sets the property which specifies whether or not a worksheet should use transitional formula evaluation.
UsedRange	Returns an IRange representing the portion of the worksheet which is in use.
VPageBreaks	Returns a reference to the vertical page break collection for the worksheet.
WindowInfo	Returns an instance of IWorksheetWindowInfo which represents worksheet specific window options.

Public Methods

Protect	Enables protection for this worksheet with the specified password.
Unprotect	Disables protection for the worksheet with the specified password.

See Also

IWorksheet Interface  | SpreadsheetGear Namespace

 

 

---

See our live Excel Reporting, Excel Charting, Excel to DataGrid and Excel Calculation Samples.

Copyright © 2003-2007 SpreadsheetGear LLC. All Rights Reserved.

SpreadsheetGear and Spreadsheet Gear are trademarks of SpreadsheetGear LLC.