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
Worksheet class
Inheritance Hierarchy
Bytescout.SpreadsheetWorksheet
Namespace: Bytescout.Spreadsheet
Assembly: Bytescout.Spreadsheet (in Bytescout.Spreadsheet.dll) Version: 4.7.1.2054-master
Syntax
The Worksheet type exposes the following members.
Constructors
| Name | Description | |
|---|---|---|
 | Worksheet |
Initializes a new instance of the Worksheet class.
|
Properties
| Name | Description | |
|---|---|---|
 | Active |
Gets or sets a value indicating whether this Worksheet is active.
|
| BackgroundPicture |
Gets or sets the sheet background picture.
|
| Charts |
Gets the charts.
|
| Columns |
Gets the list of columns.
|
| DefaultColumnWidth |
Gets or sets the default width of the column in 1/256 of the width of the zero character, using default font.
|
| HPageBreaks |
Gets the H page breaks.
|
| Hyperlinks |
Returns a HyperLinks collection that represents the hyperlinks for the worksheet.
|
| IsEmpty |
Gets a value indicating whether worksheet is empty.
|
| ItemString |
Gets the Cell with the specified by A1-style reference.
|
| ItemInt32, Int32 |
Gets the Cell with the specified row and col.
|
| Name |
Gets or sets Worksheet name
|
| NotEmptyColumnMax |
Gets the last column contains not empty cell.
|
| NotEmptyColumnMin |
Gets the first column contains not empty cell.
|
| NotEmptyRowMax |
Gets the last row contains not empty cell.
|
| NotEmptyRowMin |
Gets the first row contains not empty cell.
|
| PageSetup |
Gets or sets the page setup.
|
| Pictures |
Gets the pictures.
|
| Protected |
Gets a value indicating whether this Worksheet is protected against modification.
|
| ProtectionOptions |
Gets the option flags for sheet protection.
|
| Rows |
Gets the list of rows.
|
| UsedRangeColumnMax |
Gets the last used column.
|
| UsedRangeColumnMin |
Gets the first used column.
|
| UsedRangeRowMax |
Gets the last used row.
|
| UsedRangeRowMin |
Gets the first used row.
|
| ViewOptions |
Gets the view options for the worksheet.
|
| Visible |
Gets or sets the visible state of the sheet.
|
| VPageBreaks |
Gets the V page breaks.
|
Methods
| Name | Description | |
|---|---|---|
| AutoFitRows |
AutoFit of rows height.
|
| Calculate |
Calculates the formulas in the Worksheet.
|
| Cell(String) |
Return cell the specified by A1-style reference.
|
| Cell(Int32, Int32) |
Return cell the specified i and j.
|
| Equals | Determines whether the specified Object is equal to the current Object. (Inherited from Object.) |
 | Finalize | Allows an object to try to free resources and perform other cleanup operations before it is reclaimed by garbage collection. (Inherited from Object.) |
| Find |
Finds the specified search string on the worksheet. Specify the search
options using SearchOptions property.
|
| Find(String, Boolean, Boolean, Boolean) |
Finds the specified search string on the worksheet.
|
| FindNext |
Finds next occurrence of the search string on the worksheet. You should
initialize the search with the Find() method.
|
| GetAsBytesArrayCSV |
Gets the bytes of worksheet saved as CSV document.
|
| GetAsBytesArrayHTML |
Gets the bytes of worksheet saved as HTML document.
|
| GetAsBytesArrayTXT |
Gets the bytes of worksheet saved as text document.
|
| GetAsBytesArrayXML |
Gets the bytes of worksheet saved as XML document.
|
| GetHashCode | Serves as a hash function for a particular type. (Inherited from Object.) |
| GetType | Gets the type of the current instance. (Inherited from Object.) |
| MemberwiseClone | Creates a shallow copy of the current Object. (Inherited from Object.) |
| Protect(String) |
Protects this Worksheet with the password specified.
|
| Protect(String, EnhancedSheetProtection) |
Protects this Worksheet with specified password and options.
|
| Range(String) |
Return cell range the specified by A1-style reference.
|
| Range(Int32, Int32, Int32, Int32) |
Return cell range from the specified cell at (row1, col1) as upper-left cell and cell at (row2, col1) are the lower-right cell for this rectangle based range selection
|
| SaveAsCSV(Stream) |
Saves worksheet in a CSV format file.
|
| SaveAsCSV(String) |
Saves worksheet in a CSV format file.
|
| SaveAsCSV(Stream, ConversionOptions) |
Saves worksheet in a CSV format file
|
| SaveAsCSV(Stream, String) |
Saves worksheet in a CSV format file.
|
| SaveAsCSV(String, ConversionOptions) |
Saves worksheet in a CSV format file.
|
| SaveAsCSV(String, String) |
Saves worksheet in a CSV format file.
|
| SaveAsCSV(Stream, String, String) |
Saves worksheet in a CSV format file.
|
| SaveAsCSV(String, String, String) |
Saves worksheet in a CSV format file.
|
| SaveAsCSV(Stream, String, String, Encoding) |
Saves worksheet in a CSV format file.
|
| SaveAsCSV(String, String, String, Encoding) |
Saves worksheet in a CSV format file.
|
| SaveAsCSV(Stream, String, String, Encoding, Boolean) |
Saves worksheet in a CSV format file.
|
| SaveAsCSV(String, String, String, Encoding, Boolean) |
Saves worksheet in a CSV format file.
|
| SaveAsHTML(Stream) |
Saves worksheet in a HTML format file.
|
| SaveAsHTML(StreamWriter) |
Saves worksheet in a HTML format file. Use this overload to specify the encoding for output HTML file.
Create StreamWriter instance with required encoding in constructor parameters.
|
| SaveAsHTML(String) |
Saves worksheet in a HTML format file.
|
| SaveAsPDF(Stream) |
Saves worksheet to PDF file with specified name.
|
| SaveAsPDF(String) |
Saves worksheet to PDF file with specified name.
|
| SaveAsPDF(Stream, Boolean) |
Saves worksheet to PDF file with specified name.
|
| SaveAsPDF(String, Boolean) |
Saves worksheet to PDF file with specified name.
|
| SaveAsPDF(Stream, Boolean, String) |
Saves worksheet to PDF file with specified name.
|
| SaveAsPDF(String, Boolean, String) |
Saves worksheet to PDF file with specified name.
|
| SaveAsTXT(Stream) |
Saves worksheet in a delimiter-separated text file.
|
| SaveAsTXT(String) |
Saves worksheet in a delimiter-separated text file.
|
| SaveAsTXT(Stream, ConversionOptions) |
Saves worksheet in a text format.
|
| SaveAsTXT(Stream, String) |
Saves worksheet in a text format.
|
| SaveAsTXT(String, ConversionOptions) |
Saves worksheet in a text format.
|
| SaveAsTXT(String, String) |
Saves worksheet in a text file format.
|
| SaveAsTXT(Stream, String, String) |
Saves worksheet in a text format.
|
| SaveAsTXT(String, String, String) |
Saves worksheet in a text format.
|
| SaveAsTXT(Stream, String, String, Encoding) |
Saves worksheet in a text format.
|
| SaveAsTXT(String, String, String, Encoding) |
Saves worksheet in a text format.
|
| SaveAsTXT(Stream, String, String, Encoding, Boolean) |
Saves worksheet in a text format.
|
| SaveAsTXT(String, String, String, Encoding, Boolean) |
Saves worksheet in a text format.
|
| SaveAsXML(Stream) |
Saves worksheet in a XML format file
|
| SaveAsXML(String) |
Saves worksheet in a XML format file
|
| SaveAsXML(Stream, Encoding) |
Saves worksheet in a XML format file
|
| SaveAsXML(String, Encoding) |
Saves worksheet in a XML format file
|
| ToString | Returns a string that represents the current object. (Inherited from Object.) |
| UnProtect |
UnProtects this Worksheet with the password.
|
See Also