IWorksheet Interface
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
Worksheet interface
Namespace:Bytescout.Spreadsheet.COMAssembly: Bytescout.Spreadsheet (in Bytescout.Spreadsheet.dll) Version: 4.7.0.2045-master
Syntax
The IWorksheet type exposes the following members.
Properties
| Name | Description | |
|---|---|---|
 | Active | Gets or sets a value indicating whether this Worksheet is active. |
| BackgroundPicture | Gets or sets the sheet background picture. |
| 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. |
| 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 optionsfor the worksheet. |
| Visible | Gets or sets the visible state of the sheet. |
Methods
| Name | Description | |
|---|---|---|
 | 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. |
| 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. |
| 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 specified by (row1, col1) - top-left cell and (row2, col1) - bottom-right cell |
| 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 format |
| 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 delimiter-separated 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 |
| UnProtect | UnProtects this Worksheet with the password. |
See Also