Link Search Menu Expand Document

Worksheet Class

Worksheet class
Inheritance Hierarchy
SystemObject
Bytescout.SpreadsheetWorksheet

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

The Worksheet type exposes the following members.

Constructors
NameDescription
Public methodWorksheet
Initializes a new instance of the Worksheet class.
Top
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 propertyCharts
Gets the charts.
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 propertyHPageBreaks
Gets the H page breaks.
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 options for the worksheet.
Public propertyVisible
Gets or sets the visible state of the sheet.
Public propertyVPageBreaks
Gets the V page breaks.
Top
Methods
NameDescription
Public methodAutoFitRows
AutoFit of rows height.
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 methodEquals
Determines whether the specified Object is equal to the current Object.
(Inherited from Object.)
Protected methodFinalize
Allows an object to try to free resources and perform other cleanup operations before it is reclaimed by garbage collection.
(Inherited from Object.)
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 methodGetHashCode
Serves as a hash function for a particular type.
(Inherited from Object.)
Public methodGetType
Gets the type of the current instance.
(Inherited from Object.)
Protected methodMemberwiseClone
Creates a shallow copy of the current Object.
(Inherited from Object.)
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 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
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.
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 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 methodToString
Returns a string that represents the current object.
(Inherited from Object.)
Public methodUnProtect
UnProtects this Worksheet with the password.
Top
See Also

Reference


Copyright © 2016 - 2021 ByteScout