Table of Contents

Struct XlsxDocumentCell

Namespace
DocWright.Formats.Xlsx
Assembly
DocWright.Formats.Xlsx.dll

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.