Struct XlsxDocumentCell
One cell of an opened workbook, as it was read.
public readonly struct XlsxDocumentCell
- Inherited Members
Remarks
A value, not a handle: it does not change when the workbook does. A cell the sheet does not store reads as blank, with no formula and the default style.
Properties
- Column
Gets the one-based column.
- Formula
Gets the formula without its leading
=, or null when the cell has none.
- IsDate
Gets whether the cell holds a date or a time: a number whose format displays it as one, or a value stored as a date.
- NumberFormat
Gets the number format code the value is displayed through, or null for the general format. One of Excel's built-in formats is given as its code.
- Reference
Gets the reference of the cell, such as
B4; empty for a default value.
- Row
Gets the one-based row.
- Style
Gets how the cell looks, as nearly as XlsxCellStyle can say it.
- Value
Gets the value. For a formula cell this is the result the file carries from the last time an application calculated it; DocWright does not calculate.
Methods
- ToDateTime()
Converts the cell's number to the date and time it stands for, in the workbook's date system.