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
Spreadsheet component
Inheritance Hierarchy
SystemMarshalByRefObject
System.ComponentModelComponent
Bytescout.SpreadsheetSpreadsheetComponent
Namespace: Bytescout.Spreadsheet
Assembly: Bytescout.Spreadsheet (in Bytescout.Spreadsheet.dll) Version: 4.7.1.2054-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 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.
|
Events
| Name | Description | |
|---|---|---|
 | Disposed | Occurs when the component is disposed by a call to the Dispose method. (Inherited from Component.) |
See Also