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
The IWorksheet type exposes the following members.
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