Link Search Menu Expand Document

SpreadsheetComponent Methods

The SpreadsheetComponent type exposes the following members.

Methods
NameDescription
Public methodClose
Closes this instance.
Public methodCreateObjRef
Creates an object that contains all the relevant information required to generate a proxy used to communicate with a remote object.
(Inherited from MarshalByRefObject.)
Public methodDispose
Performs application-defined tasks associated with freeing, releasing, or resetting unmanaged resources.
Protected methodDispose(Boolean)
Clean up any resources being used.
(Overrides ComponentDispose(Boolean).)
Public methodEquals
Determines whether the specified Object is equal to the current Object.
(Inherited from Object.)
Protected methodFinalize
Releases unmanaged resources and performs other cleanup operations before theSpreadsheet is reclaimed by garbage collection.
(Overrides ComponentFinalize.)
Public methodGetAsBytesArray
Gets the bytes of spreadsheet saved as document with specified type.
Public methodGetAsBytesArrayCSV
Gets the bytes of spreadsheet saved as CSV document.
Public methodGetAsBytesArrayHTML
Gets the bytes of spreadsheet saved as HTML document.
Public methodGetAsBytesArrayHTML(Int32)
Gets the bytes of specified worksheet page saved as HTML document.
Public methodGetAsBytesArrayTXT
Gets the bytes of spreadsheet saved as text document.
Public methodGetAsBytesArrayXLS
Gets the bytes of spreadsheet saved as XLS document.
Public methodGetAsBytesArrayXLSX
Gets the bytes of spreadsheet saved as XLSX document.
Public methodGetAsBytesArrayXML
Gets the bytes of spreadsheet saved as XML document.
Public methodGetHashCode
Serves as a hash function for a particular type.
(Inherited from Object.)
Public methodGetLifetimeService
Retrieves the current lifetime service object that controls the lifetime policy for this instance.
(Inherited from MarshalByRefObject.)
Protected methodGetService
Returns an object that represents a service provided by the Component or by its Container.
(Inherited from Component.)
Public methodGetType
Gets the type of the current instance.
(Inherited from Object.)
Public methodInitializeLifetimeService
Obtains a lifetime service object to control the lifetime policy for this instance.
(Inherited from MarshalByRefObject.)
Public methodLoadFromFile(String)
Load data from file.
Public methodLoadFromFile(String, CacheType)
Load data from file.
Public methodLoadFromFile(String, CacheType, String)
Load data from file.
Public methodLoadFromFile(String, String, Encoding)
Load data from file.
Public methodLoadFromFile(String, CacheType, String, Encoding)
Load data from file.
Public methodLoadFromFile(String, CacheType, String, Encoding, String)
Load data from file.
Public methodLoadFromStream(Stream)
Load data from stream.
Public methodLoadFromStream(Stream, CacheType)
Load data from stream.
Public methodLoadFromStream(Stream, SpreadsheetFormatType)
Load data from stream.
Public methodLoadFromStream(Stream, SpreadsheetFormatType, CacheType)
Load data from stream.
Public methodLoadFromStream(Stream, SpreadsheetFormatType, String, Encoding)
Load data from stream.
Public methodLoadFromStream(Stream, SpreadsheetFormatType, CacheType, String, Encoding)
Load data from stream.
Protected methodMemberwiseClone
Creates a shallow copy of the current Object.
(Inherited from Object.)
Protected methodMemberwiseClone(Boolean)
Creates a shallow copy of the current MarshalByRefObject object.
(Inherited from MarshalByRefObject.)
Public methodSaveAs(String)
Saves data in XLS or XLSX file FileName
Public methodSaveAs(String, SpreadsheetFormatType)
Saves data in XLS or XLSX file FileName
Public methodSaveAsCSV(String, Int32)
Saves data in CSV file with specified name
Public methodSaveAsCSV(String, Int32, String)
Saves data in CSV file with specified name
Public methodSaveAsHTML(String)
Saves spreadsheet in a HTML format file. The second and subsequent worksheets of the spreadsheet will be saved in separate files with auto-generated names.
Public methodSaveAsHTML(String, Boolean)
Saves spreadsheet in a HTML format file. The second and subsequent worksheets of the spreadsheet will be saved in separate files with auto-generated names.
Public methodSaveAsTXT
Saves data in TXT file with specified name
Public methodSaveAsXLS
Saves data in XLS file with specified name
Public methodSaveAsXLSX
Saves data in XLSX format to a file with specified name
Public methodSaveAsXML
Saves data in XML file with specified name
Public methodSaveToStream(Stream)
Saves data in XLS format to a given stream
Public methodSaveToStream(Stream, SpreadsheetFormatType)
Saves data in XLS or XLSX format to a given stream
Public methodSaveToStreamCSV(Stream, Int32)
Saves data in CSV format to a given stream
Public methodSaveToStreamCSV(Stream, Int32, String)
Saves data in CSV format to a given stream
Public methodSaveToStreamHTML(Stream)
Saves first worksheet of spreadsheet as HTML document to a given stream.
Public methodSaveToStreamHTML(Stream, Int32)
Saves a worksheet of spreadsheet as HTML document to a given stream.
Public methodSaveToStreamTXT
Saves data in TXT format to a given stream
Public methodSaveToStreamXLS
Saves data in XLS format to a given stream
Public methodSaveToStreamXLSX
Saves data in XLSX format to a given stream
Public methodSaveToStreamXML
Saves data in XML format to a given stream
Public methodToString
Returns a String containing the name of the Component, if any. This method should not be overridden.
(Inherited from Component.)
Public methodWorksheet
Return Worksheet the specified index.
Top
See Also

Reference