Click or drag to resize

XLSDocumentSheet Class

Excel Sheet handling
Inheritance Hierarchy
SystemObject
  SIC.OpenDocumentFormat.XLSXLSDocumentSheet

Namespace:  SIC.OpenDocumentFormat.XLS
Assembly:  SIC.OpenDocumentFormat (in SIC.OpenDocumentFormat.dll) Version: 19.1.23.1 (19.1.23.622)
Syntax
Copy
public class Sheet

The XLSDocumentSheet type exposes the following members.

Constructors
  NameDescription
Public methodXLSDocumentSheet
Initializes a new instance of the Sheet class. Constructor with parameter
Top
Methods
  NameDescription
Public methodAdd
Adds a Excel Sheet object
Public methodEquals
Determines whether the specified Object is equal to the current Object.
(Inherited from Object.)
Public methodExist
Exist Excel Sheet
Protected methodFinalize
Allows an object to try to free resources and perform other cleanup operations before it is reclaimed by garbage collection.
(Inherited from Object.)
Public methodGetCellValue(Cell)
Get Cell Value (by Cell)
Public methodGetCellValue(String, String)
Get Cell Value (by sheet name and cell reference)
Public methodGetDataColumn
Read data on column
Public methodGetHashCode
Serves as a hash function for a particular type.
(Inherited from Object.)
Public methodGetSheetNames
List all sheets in Excel Document
Public methodGetType
Gets the Type of the current instance.
(Inherited from Object.)
Private methodGetWorkSheet
Get work sheet object
Protected methodMemberwiseClone
Creates a shallow copy of the current Object.
(Inherited from Object.)
Public methodSetCellValueString
Set Excel Cell value type string
Public methodToString
Returns a string that represents the current object.
(Inherited from Object.)
Top
Fields
  NameDescription
Public fieldMyXLSDocument
Parent - XLSDocument
Top
Extension Methods
  NameDescription
Public Extension MethodGetObjectToBytes
Convert an object to byte array
(Defined by Extensions.)
Public Extension MethodIsNumber
Check is value a number
(Defined by Convert.)
Public Extension MethodToHTMLDisplay(DataGrid, TempDataDictionary)Overloaded.
Gives HTML code for display. Details see ToHTMLDisplay(Object, String, DataGridDataTypes, String, String, String, String, TempDataDictionary).
(Defined by Extensions.)
Public Extension MethodCode exampleToHTMLDisplay(String, DataGridDataTypes, String, String, String, String, TempDataDictionary)Overloaded.
Gives HTML code for display.
(Defined by Extensions.)
Public Extension MethodToHTMLEditor(DataGrid, TempDataDictionary, String)Overloaded.
Gives HTML code for Input field. Call method ToHTMLEditor(Object, String, DataGridDataTypes, String, String, String, TempDataDictionary, Boolean, String, DataPlacements, String, String)
(Defined by Extensions.)
Public Extension MethodToHTMLEditor(String, DataGridDataTypes, String, String, String, TempDataDictionary, Boolean, String, DataPlacements, String, String)Overloaded.
Gives HTML code for Input field
(Defined by Extensions.)
Public Extension MethodCode exampleToHTMLHidden(String)Overloaded.
Gives HTML code for hidden data
(Defined by Extensions.)
Public Extension MethodToHTMLHidden(DataGrid)Overloaded.
Gives HTML code for hidden data
(Defined by Extensions.)
Public Extension MethodXMLWrite
Gives XML string from data item
(Defined by Helper.)
Top
See Also