Free Trial
Web API version
Licensing
Request A Quote
HAVE QUESTIONS OR NEED HELP? SUBMIT THE SUPPORT REQUEST FORM or write email to SUPPORT@BYTESCOUT.COM
The SpreadsheetComponent type exposes the following members.
Methods
Name | Description | |
---|---|---|
Close |
Closes this instance.
| |
CreateObjRef | Creates an object that contains all the relevant information required to generate a proxy used to communicate with a remote object. (Inherited from MarshalByRefObject.) | |
Dispose |
Performs application-defined tasks associated with freeing, releasing, or resetting unmanaged resources.
| |
Dispose(Boolean) |
Clean up any resources being used.
(Overrides ComponentDispose(Boolean).) | |
Equals | Determines whether the specified Object is equal to the current Object. (Inherited from Object.) | |
Finalize |
Releases unmanaged resources and performs other cleanup operations before the
Spreadsheet is reclaimed by garbage collection.
(Overrides ComponentFinalize.) | |
GetAsBytesArray |
Gets the bytes of spreadsheet saved as document with specified type.
| |
GetAsBytesArrayCSV |
Gets the bytes of spreadsheet saved as CSV document.
| |
GetAsBytesArrayHTML |
Gets the bytes of spreadsheet saved as HTML document.
| |
GetAsBytesArrayHTML(Int32) |
Gets the bytes of specified worksheet page saved as HTML document.
| |
GetAsBytesArrayTXT |
Gets the bytes of spreadsheet saved as text document.
| |
GetAsBytesArrayXLS |
Gets the bytes of spreadsheet saved as XLS document.
| |
GetAsBytesArrayXLSX |
Gets the bytes of spreadsheet saved as XLSX document.
| |
GetAsBytesArrayXML |
Gets the bytes of spreadsheet saved as XML document.
| |
GetHashCode | Serves as a hash function for a particular type. (Inherited from Object.) | |
GetLifetimeService | Retrieves the current lifetime service object that controls the lifetime policy for this instance. (Inherited from MarshalByRefObject.) | |
GetService | Returns an object that represents a service provided by the Component or by its Container. (Inherited from Component.) | |
GetType | Gets the type of the current instance. (Inherited from Object.) | |
InitializeLifetimeService | Obtains a lifetime service object to control the lifetime policy for this instance. (Inherited from MarshalByRefObject.) | |
LoadFromFile(String) |
Load data from file.
| |
LoadFromFile(String, CacheType) |
Load data from file.
| |
LoadFromFile(String, CacheType, String) |
Load data from file.
| |
LoadFromFile(String, String, Encoding) |
Load data from file.
| |
LoadFromFile(String, CacheType, String, Encoding) |
Load data from file.
| |
LoadFromFile(String, CacheType, String, Encoding, String) |
Load data from file.
| |
LoadFromStream(Stream) |
Load data from stream.
| |
LoadFromStream(Stream, CacheType) |
Load data from stream.
| |
LoadFromStream(Stream, SpreadsheetFormatType) |
Load data from stream.
| |
LoadFromStream(Stream, SpreadsheetFormatType, CacheType) |
Load data from stream.
| |
LoadFromStream(Stream, SpreadsheetFormatType, String, Encoding) |
Load data from stream.
| |
LoadFromStream(Stream, SpreadsheetFormatType, CacheType, String, Encoding) |
Load data from stream.
| |
MemberwiseClone | Creates a shallow copy of the current Object. (Inherited from Object.) | |
MemberwiseClone(Boolean) | Creates a shallow copy of the current MarshalByRefObject object. (Inherited from MarshalByRefObject.) | |
SaveAs(String) |
Saves data in XLS or XLSX file FileName
| |
SaveAs(String, SpreadsheetFormatType) |
Saves data in XLS or XLSX file FileName
| |
SaveAsCSV(String, Int32) |
Saves data in CSV file with specified name
| |
SaveAsCSV(String, Int32, String) |
Saves data in CSV file with specified name
| |
SaveAsHTML(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.
| |
SaveAsHTML(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.
| |
SaveAsTXT |
Saves data in TXT file with specified name
| |
SaveAsXLS |
Saves data in XLS file with specified name
| |
SaveAsXLSX |
Saves data in XLSX format to a file with specified name
| |
SaveAsXML |
Saves data in XML file with specified name
| |
SaveToStream(Stream) |
Saves data in XLS format to a given stream
| |
SaveToStream(Stream, SpreadsheetFormatType) |
Saves data in XLS or XLSX format to a given stream
| |
SaveToStreamCSV(Stream, Int32) |
Saves data in CSV format to a given stream
| |
SaveToStreamCSV(Stream, Int32, String) |
Saves data in CSV format to a given stream
| |
SaveToStreamHTML(Stream) |
Saves first worksheet of spreadsheet as HTML document to a given stream.
| |
SaveToStreamHTML(Stream, Int32) |
Saves a worksheet of spreadsheet as HTML document to a given stream.
| |
SaveToStreamTXT |
Saves data in TXT format to a given stream
| |
SaveToStreamXLS |
Saves data in XLS format to a given stream
| |
SaveToStreamXLSX |
Saves data in XLSX format to a given stream
| |
SaveToStreamXML |
Saves data in XML format to a given stream
| |
ToString | Returns a String containing the name of the Component, if any. This method should not be overridden. (Inherited from Component.) | |
Worksheet |
Return Worksheet the specified index.
|
See Also