Link Search Menu Expand Document

IWorksheet Interface

Worksheet interface

Namespace:Bytescout.Spreadsheet.COM
Assembly: Bytescout.Spreadsheet (in Bytescout.Spreadsheet.dll) Version: 4.5.1.2018-master
Syntax
public interface IWorksheet

The IWorksheet type exposes the following members.

Properties
NameDescription
Public propertyActive
Gets or sets a value indicating whether this Worksheet is active.
Public propertyBackgroundPicture
Gets or sets the sheet background picture.
Public propertyColumns
Gets the list of columns.
Public propertyDefaultColumnWidth
Gets or sets the default width of the column in 1/256 of the width of the zero character, using default font.
Public propertyHyperlinks
Returns a HyperLinks collection that represents the hyperlinks for the worksheet.
Public propertyIsEmpty
Gets a value indicating whether worksheet is empty.
Public propertyItemString
Gets the Cell with the specified by A1-style reference.
Public propertyItemInt32, Int32
Gets the Cell with the specified row and col.
Public propertyName
Gets or sets Worksheet name
Public propertyNotEmptyColumnMax
Gets the last column contains not empty cell.
Public propertyNotEmptyColumnMin
Gets the first column contains not empty cell.
Public propertyNotEmptyRowMax
Gets the last row contains not empty cell.
Public propertyNotEmptyRowMin
Gets the first row contains not empty cell.
Public propertyPageSetup
Gets or sets the page setup.
Public propertyPictures
Gets the pictures.
Public propertyProtected
Gets a value indicating whether this Worksheet is protected against modification.
Public propertyProtectionOptions
Gets the option flags for sheet protection.
Public propertyRows
Gets the list of rows.
Public propertyUsedRangeColumnMax
Gets the last used column.
Public propertyUsedRangeColumnMin
Gets the first used column.
Public propertyUsedRangeRowMax
Gets the last used row.
Public propertyUsedRangeRowMin
Gets the first used row.
Public propertyViewOptions
Gets the view optionsfor the worksheet.
Public propertyVisible
Gets or sets the visible state of the sheet.
Top
Methods
NameDescription
Public methodCalculate
Calculates the formulas in the Worksheet.
Public methodCell(String)
Return cell the specified by A1-style reference.
Public methodCell(Int32, Int32)
Return cell the specified i and j.
Public methodFind
Finds the specified search string on the worksheet. Specify the search options using SearchOptions property.
Public methodFind(String, Boolean, Boolean, Boolean)
Finds the specified search string on the worksheet.
Public methodFindNext
Finds next occurrence of the search string on the worksheet. You should initialize the search with the Find() method.
Public methodGetAsBytesArrayCSV
Gets the bytes of worksheet saved as CSV document.
Public methodGetAsBytesArrayHTML
Gets the bytes of worksheet saved as HTML document.
Public methodGetAsBytesArrayTXT
Gets the bytes of worksheet saved as text document.
Public methodGetAsBytesArrayXML
Gets the bytes of worksheet saved as XML document.
Public methodProtect(String)
Protects this Worksheet with the password specified.
Public methodProtect(String, EnhancedSheetProtection)
Protects this Worksheet with specified password and options.
Public methodRange(String)
Return cell range the specified by A1-style reference.
Public methodRange(Int32, Int32, Int32, Int32)
Return cell range specified by (row1, col1) - top-left cell and (row2, col1) - bottom-right cell
Public methodSaveAsCSV(Stream)
Saves worksheet in a CSV format file
Public methodSaveAsCSV(String)
Saves worksheet in a CSV format file
Public methodSaveAsCSV(Stream, ConversionOptions)
Saves worksheet in a CSV format file
Public methodSaveAsCSV(Stream, String)
Saves worksheet in a CSV format file
Public methodSaveAsCSV(String, ConversionOptions)
Saves worksheet in a CSV format file.
Public methodSaveAsCSV(String, String)
Saves worksheet in a CSV format file
Public methodSaveAsCSV(Stream, String, String)
Saves worksheet in a CSV format file
Public methodSaveAsCSV(String, String, String)
Saves worksheet in a CSV format file.
Public methodSaveAsCSV(Stream, String, String, Encoding)
Saves worksheet in a CSV format file
Public methodSaveAsCSV(String, String, String, Encoding)
Saves worksheet in a CSV format file.
Public methodSaveAsCSV(Stream, String, String, Encoding, Boolean)
Saves worksheet in a CSV format file
Public methodSaveAsCSV(String, String, String, Encoding, Boolean)
Saves worksheet in a CSV format file.
Public methodSaveAsHTML(Stream)
Saves worksheet in a HTML format file
Public methodSaveAsHTML(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.
Public methodSaveAsHTML(String)
Saves worksheet in a HTML format file
Public methodSaveAsPDF(Stream)
Saves worksheet to PDF file with specified name.
Public methodSaveAsPDF(String)
Saves worksheet to PDF file with specified name.
Public methodSaveAsPDF(Stream, Boolean)
Saves worksheet to PDF file with specified name.
Public methodSaveAsPDF(String, Boolean)
Saves worksheet to PDF file with specified name.
Public methodSaveAsPDF(Stream, Boolean, String)
Saves worksheet to PDF file with specified name.
Public methodSaveAsPDF(String, Boolean, String)
Saves worksheet to PDF file with specified name.
Public methodSaveAsTXT(Stream)
Saves worksheet in a delimiter-separated text file
Public methodSaveAsTXT(String)
Saves worksheet in a delimiter-separated text file format
Public methodSaveAsTXT(Stream, ConversionOptions)
Saves worksheet in a text format.
Public methodSaveAsTXT(Stream, String)
Saves worksheet in a text format
Public methodSaveAsTXT(String, ConversionOptions)
Saves worksheet in a text format.
Public methodSaveAsTXT(String, String)
Saves worksheet in a delimiter-separated text file format
Public methodSaveAsTXT(Stream, String, String)
Saves worksheet in a text format.
Public methodSaveAsTXT(String, String, String)
Saves worksheet in a text format.
Public methodSaveAsTXT(Stream, String, String, Encoding)
Saves worksheet in a text format.
Public methodSaveAsTXT(String, String, String, Encoding)
Saves worksheet in a text format.
Public methodSaveAsTXT(Stream, String, String, Encoding, Boolean)
Saves worksheet in a text format.
Public methodSaveAsTXT(String, String, String, Encoding, Boolean)
Saves worksheet in a text format.
Public methodSaveAsXML(Stream)
Saves worksheet in a XML format file
Public methodSaveAsXML(String)
Saves worksheet in a XML format file
Public methodSaveAsXML(Stream, Encoding)
Saves worksheet in a XML format file
Public methodSaveAsXML(String, Encoding)
Saves worksheet in a XML format file
Public methodUnProtect
UnProtects this Worksheet with the password.
Top
See Also

Reference


Copyright © 2016 - 2021 ByteScout