Click or drag to resize
Sheet Class
Sheet class represents a worksheet defined in Excel.
Inheritance Hierarchy
SystemObject
  Aceoffix.ExcelWriterSheet

Namespace: Aceoffix.ExcelWriter
Assembly: Aceoffix (in Aceoffix.dll) Version: 5.0.0.1
Syntax
public class Sheet

The Sheet type exposes the following members.

Methods
  NameDescription
Public methodCode exampleOpenCell
Opens the specified cell and returns a Cell object.
Public methodOpenCellByDefinedName
Opens the cell with specified name that defined in Excel and returns a Cell object.
Public methodCode exampleOpenCellRC
Opens the specified cell and returns a Cell object.
Public methodCode exampleOpenTable(String)
Opens the specified range of the cells and returns a Table object.
Public methodOpenTable(String, Boolean)
Opens the specified range of cells and returns a Table object.
Public methodOpenTableByDefinedName(String, Int32, Int32)
Opens the table with the specified name defined in Excel and returns a table object.
Public methodOpenTableByDefinedName(String, Int32, Int32, Boolean)
Opens the table with specified name that defined in Excel and returns a table object.
Top
Properties
  NameDescription
Public propertyAllowAdjustRC
Sets a value that indicates whether users are allowed to adjust rows and column manually when the worksheet is read-only.
Public propertyAutoFit
Sets a value that indicate whether the AutoFit feature will be used in the cells of the worksheet.
Public propertyName
Gets the name of the Sheet.
Public propertyReadOnly
Sets a value that indicates whether the worksheet is read-only.
Top
Remarks

Sheet class represents the worksheet defined in Excel. You can only call the OpenSheet(String) method to get the Sheet object.

See Also