Click or drag to resize
NanoXLSX

WorksheetReader Class

Class representing a reader for worksheets of XLSX files
Inheritance Hierarchy
SystemObject
  NanoXLSX.LowLevelWorksheetReader

Namespace: NanoXLSX.LowLevel
Assembly: NanoXLSX (in NanoXLSX.dll) Version: 2.6.3+98f265239ae8df4639650ecd7029244cc5e52dfc
Syntax
C#
Copy
public class WorksheetReader

The WorksheetReader type exposes the following members.

Constructors
 NameDescription
Public methodWorksheetReader Constructor with parameters
Top
Properties
 NameDescription
Public propertyAutoFilterRange Gets the auto filter range. If null, no auto filters were defined
Public propertyColumns Gets a list of defined Columns
Public propertyCurrentZoomScale Gets the zoom factor of the current view type
Public propertyData Gets the data of the worksheet as Dictionary of cell address-cell object tuples
Public propertyDefaultColumnWidth Gets the default column width if defined, otherwise null
Public propertyDefaultRowHeight Gets the default row height if defined, otherwise null
Public propertyMergedCells Gets a list of merged cells
Public propertyPaneSplitValue Gets the definition of pane split-related information
Public propertyRows Gets a dictionary of internal Row definitions
Public propertySelectedCells Gets the selected cells (panes are currently not considered)
Public propertyShowGridLines Gets whether grid lines are shown
Public propertyShowRowColHeaders Gets whether column and row headers are shown
Public propertyShowRuler Gets whether rulers are shown in view type: pageLayout
Public propertyStyleAssignment Gets the assignment of resolved styles to cell addresses
Public propertyViewType Gets the sheet view type of the current worksheet
Public propertyWorksheetProtection Gets the applicable worksheet protection values
Public propertyWorksheetProtectionHash Gets the (legacy) password hash of a worksheet if protection values are applied with a password
Public propertyZoomFactors Gets all preserved zoom factors of the worksheet
Top
Methods
 NameDescription
Private methodCollectSelectedCells Resolves the selected cells of a range or a single cell
Private methodConvertDateFromDouble Tries to convert a date (DateTime) from a double
Public methodConvertDoubleToInt Converts a double to an integer without checks
Private methodConvertTimeFromDouble Tries to convert a time (TimeSpan) from a double
Private methodConvertToBool Tries to convert a value to a bool
Private methodConvertToDate Tries to convert a value to a Date (DateTime)
Private methodConvertToDecimal Tries to convert a value to a decimal
Private methodConvertToDouble Tries to convert a value to a double
Private methodConvertToInt Tries to convert a value to an integer
Private methodConvertToString Converts an arbitrary value to string
Private methodConvertToTime Tries to convert a value to a Time (TimeSpan)
Private methodCreateCell Creates a generic cell with optional style information
Public methodEqualsDetermines whether the specified object is equal to the current object.
(Inherited from Object)
Protected methodFinalizeAllows an object to try to free resources and perform other cleanup operations before it is reclaimed by garbage collection.
(Inherited from Object)
Private methodGetAutoFilters Gets the auto filters of the current worksheet
Private methodGetColumns Gets the columns of the current worksheet
Private methodGetDateTimeValue Parses the date (DateTime) or time (TimeSpan) value of a raw cell. If the value is numeric, but out of range of a OAdate, a numeric value will be returned instead. If invalid, the string representation will be returned.
Private methodGetEnforcedColumnValue Converts the cell values of defined rows, based on import options (e.g. everything to string or all values to double)
Private methodGetGloballyEnforcedFlagValues Modifies certain values globally by import options (e.g. empty as string or dates as numbers)
Private methodGetGloballyEnforcedValue Converts the cell values globally, based on import options (e.g. everything to string or all numbers to double)
Public methodGetHashCodeServes as the default hash function.
(Inherited from Object)
Private methodGetMergedCells Gets the merged cells of the current worksheet
Private methodGetNumericValue(String) Parses the numeric value of a raw cell. The order of possible number types are: ulong, long, uint, int, float or double. If nothing applies, null is returned
Private methodGetNumericValue(Object, CellCellType) Tries to parse a numeric value with an appropriate type
Private methodGetSheetFormats Gets the sheet format information of the current worksheet
Private methodGetSheetProtection Gets the sheet protection values of the current worksheets
Private methodGetSheetView Gets the selected cells of the current worksheet
Public methodGetTypeGets the Type of the current instance.
(Inherited from Object)
Private methodManageSheetProtection Manages particular sheet protection values if defined
Protected methodMemberwiseCloneCreates a shallow copy of the current Object.
(Inherited from Object)
Private methodProcessStyles Determine which of the resolved styles are either to define a time or a date. Stores also the styles into a dictionary
Public methodRead Reads the XML file form the passed stream and processes the worksheet data
Private methodReadCell Reads one cell in a worksheet
Private methodResolveCellData Resolves the data of a read cell either automatically or conditionally (import options), transforms it into a cell object and adds it to the data
Private methodResolveSharedString Tries to resolve a shared string from its ID
Private methodResolveType Resolves the final cell type after a possible conversion by import options
Public methodToStringReturns a string that represents the current object.
(Inherited from Object)
Private methodTryConvertDoubleToInt Tries to convert a double to an integer
Private methodTryParseBool Parses the boolean value of a raw cell
Private methodTryParseDate Tris to parse a DateTime instance from a string
Private methodTryParseTime Tris to parse a TimeSpan instance from a string
Top
See Also