Click or drag to resize

XLSDocument Class

SIC Open Document Format XLS Document
Inheritance Hierarchy
SystemObject
  SIC.OpenDocumentFormat.XLSXLSDocument

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

The XLSDocument type exposes the following members.

Constructors
  NameDescription
Public methodXLSDocument
Initializes a new instance of the XLSDocument class. Constructor without parameter
Public methodXLSDocument(String, Boolean)
Initializes a new instance of the XLSDocument class. Constructor with parameter
Public methodXLSDocument(String, String, String, String, Boolean)
Initializes a new instance of the XLSDocument class. Constructor with parameter
Top
Properties
  NameDescription
Public propertyMyDocument
SIC Open Document Format XLSDocument property MyDocument
Public propertyMySheet
SIC Open Document Format XLS Document property MySheet
Top
Methods
  NameDescription
Public methodClose
Close the Open Document Format file
Public methodCreate
SIC Open Document Format XLSDocument method Create.

Create empty Excel document

Public methodEquals
Determines whether the specified Object is equal to the current Object.
(Inherited from Object.)
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 methodGetHashCode
Serves as a hash function for a particular type.
(Inherited from Object.)
Public methodGetType
Gets the Type of the current instance.
(Inherited from Object.)
Protected methodMemberwiseClone
Creates a shallow copy of the current Object.
(Inherited from Object.)
Public methodOpen(String, Boolean)
Open a Open Document Format file
Public methodOpen(String, String, String, String, Boolean)
Open a Open Document Format file
Public methodSave
Save Excel Document (file)
Public methodToString
Returns a string that represents the current object.
(Inherited from Object.)
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
Remarks
Exception handling with method throw.

Note: usings DocumentFormat.OpenXml, DocumentFormat.OpenXml.Packaging and DocumentFormat.OpenXml.Spreadsheet:

class with full namespace path not declaration in region Using because class name collide with SIC names

See Also