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