SpreadsheetComponent Class
Free Trial Web API version Licensing Request A Quote
HAVE QUESTIONS OR NEED HELP?SUBMIT THE SUPPORT REQUEST FORM or write email toSUPPORT@BYTESCOUT.COM
Spreadsheet component
Inheritance Hierarchy
SystemMarshalByRefObject
System.ComponentModelComponent
Bytescout.SpreadsheetSpreadsheetComponent
Namespace:Bytescout.Spreadsheet
Assembly: Bytescout.Spreadsheet (in Bytescout.Spreadsheet.dll) Version: 4.7.0.2045-master
Syntax
The SpreadsheetComponent type exposes the following members.
Constructors
| Name | Description | |
|---|---|---|
 | SpreadsheetComponent | Initializes a new instance of the SpreadsheetComponent class. |
| SpreadsheetComponent(IContainer) | Initializes a new instance of the SpreadsheetComponent class. |
Properties
| Name | Description | |
|---|---|---|
 | Cache | Sets the cache type. |
 | CanRaiseEvents | Gets a value indicating whether the component can raise an event. (Inherited from Component.) |
| Container | Gets the IContainer that contains the Component. (Inherited from Component.) |
| DesignMode | Gets a value that indicates whether the Component is currently in design mode. (Inherited from Component.) |
| Events | Gets the list of event handlers that are attached to this Component. (Inherited from Component.) |
| Options | Gets the options. |
| Site | Gets or sets the ISite of the Component. (Inherited from Component.) |
| UserKey | Gets or sets the key number part of registration information. |
| UserName | Gets or sets the name part of the registration information. |
| Workbook | Gets or sets the Workbook. |
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 theSpreadsheet 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. |
Events
| Name | Description | |
|---|---|---|
 | Disposed | Occurs when the component is disposed by a call to the Dispose method. (Inherited from Component.) |
See Also