Link Search Menu Expand Document

SpreadsheetComponent Class

Spreadsheet component
Inheritance Hierarchy
SystemObject
SystemMarshalByRefObject
System.ComponentModelComponent
Bytescout.SpreadsheetSpreadsheetComponent

Namespace:Bytescout.Spreadsheet
Assembly: Bytescout.Spreadsheet (in Bytescout.Spreadsheet.dll) Version: 4.5.1.2018-master
Syntax
public class SpreadsheetComponent : Component

The SpreadsheetComponent type exposes the following members.

Constructors
NameDescription
Public methodSpreadsheetComponent
Initializes a new instance of the SpreadsheetComponent class.
Public methodSpreadsheetComponent(IContainer)
Initializes a new instance of the SpreadsheetComponent class.
Top
Properties
NameDescription
Public propertyCache
Sets the cache type.
Protected propertyCanRaiseEvents
Gets a value indicating whether the component can raise an event.
(Inherited from Component.)
Public propertyContainer
Gets the IContainer that contains the Component.
(Inherited from Component.)
Protected propertyDesignMode
Gets a value that indicates whether the Component is currently in design mode.
(Inherited from Component.)
Protected propertyEvents
Gets the list of event handlers that are attached to this Component.
(Inherited from Component.)
Public propertyOptions
Gets the options.
Public propertySite
Gets or sets the ISite of the Component.
(Inherited from Component.)
Public propertyUserKey
Gets or sets the key number part of registration information.
Public propertyUserName
Gets or sets the name part of the registration information.
Public propertyWorkbook
Gets or sets the Workbook.
Top
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
Events
NameDescription
Public eventDisposed
Occurs when the component is disposed by a call to the Dispose method.
(Inherited from Component.)
Top
See Also

Reference


Copyright © 2016 - 2021 ByteScout