API Reference
ExcelCell
Lightweight object model wrapper for a single worksheet cell.
Inheritance
- Object
- ExcelCell
Usage
Explore 39 API references to this type
This type appears in these public API surfaces even when no hand-authored example is attached directly to the page.
Returned or exposed by 39
- Method ExcelCell.Clear
- Method ExcelCell.Currency
- Method ExcelCell.Date
- Method ExcelCell.DateTime
- Method ExcelCell.DurationHours
- Method ExcelCell.Error
- Method ExcelCell.HeaderStyle
- Method ExcelCell.Integer
- Method ExcelCell.MutedText
- Method ExcelCell.Number
- Method ExcelCell.Percent
- Method ExcelCell.SetBaseline
- Method ExcelCell.SetBold
- Method ExcelCell.SetBorder
- Method ExcelCell.SetDiagonalBorder
- Method ExcelCell.SetFillColor
- Method ExcelCell.SetFontColor
- Method ExcelCell.SetFontName
- Method ExcelCell.SetFontSize
- Method ExcelCell.SetFormula
- Method ExcelCell.SetGradientFill
- Method ExcelCell.SetItalic
- Method ExcelCell.SetNumberFormat
- Method ExcelCell.SetRichText
- Method ExcelCell.SetShrinkToFit
- Method ExcelCell.SetStrikethrough
- Method ExcelCell.SetSubscript
- Method ExcelCell.SetSuperscript
- Method ExcelCell.SetTextRotation
- Method ExcelCell.SetUnderline
- Method ExcelCell.SetValue
- Method ExcelCell.SetVerticalTextAlignment
- Method ExcelCell.Success
- Method ExcelCell.Text
- Method ExcelCell.Time
- Method ExcelCell.TransformTextCase
- Method ExcelCell.Warning
- Property ExcelRange.FirstCell
- Method ExcelSheet.CellAt
Methods
public ExcelCell Clear(ExcelClearOptions options = All) #ExcelCellClears selected cell data and metadata.
Parameters
- options OfficeIMO.Excel.ExcelClearOptions = All
public ExcelCell Currency(Int32 decimals = 2, CultureInfo? culture = null) #ExcelCellApplies a currency number format.
Parameters
- decimals System.Int32 = 2
- culture System.Globalization.CultureInfo? = null
public ExcelCell Date(String pattern = "yyyy-mm-dd") #ExcelCellApplies a date number format.
Parameters
- pattern System.String = "yyyy-mm-dd"
public ExcelCell DateTime(String pattern = "yyyy-mm-dd hh:mm:ss") #ExcelCellApplies a date/time number format.
Parameters
- pattern System.String = "yyyy-mm-dd hh:mm:ss"
public String GetFormattedText(IFormatProvider? provider = null) #StringGets formatted display text for the cell value.
Parameters
- provider System.IFormatProvider? = null
public IReadOnlyList<ExcelRichTextRun> GetRichText() #IReadOnlyList<ExcelRichTextRun>Gets rich inline text runs from the cell.
public ExcelCellStyleSnapshot GetStyle() #ExcelCellStyleSnapshotGets a read-only snapshot of the cell's visual style.
public T? GetValue<T>() #T?Gets the cell value converted to the requested type.
Type Parameters
- T
public ExcelCell Integer() #ExcelCellApplies a whole-number format with thousands separators.
public ExcelCell Number(Int32 decimals = 2) #ExcelCellApplies a decimal number format.
Parameters
- decimals System.Int32 = 2
public ExcelCell Percent(Int32 decimals = 0) #ExcelCellApplies a percent number format.
Parameters
- decimals System.Int32 = 0
public ExcelCell SetBold(Boolean bold = true) #ExcelCellSets or clears bold font style.
Parameters
- bold System.Boolean = true
public ExcelCell SetBorder(ExcelBorderStyle style, String? hexColor = null) #ExcelCellApplies a border style to the cell.
Parameters
- style OfficeIMO.Excel.ExcelBorderStyle
- hexColor System.String? = null
public ExcelCell SetBorder(ExcelCellBorders borders, ExcelBorderStyle style, String? hexColor = null) #ExcelCellSets selected border edges while preserving other edges and cell styles.
Parameters
- borders OfficeIMO.Excel.ExcelCellBorders
- style OfficeIMO.Excel.ExcelBorderStyle
- hexColor System.String? = null
public ExcelCell SetDiagonalBorder(ExcelBorderStyle style, String? hexColor = null, Boolean diagonalUp = true, Boolean diagonalDown = true) #ExcelCellApplies diagonal borders to the cell.
Parameters
- style OfficeIMO.Excel.ExcelBorderStyle
- hexColor System.String? = null
- diagonalUp System.Boolean = true
- diagonalDown System.Boolean = true
public ExcelCell SetFillColor(String hexColor) #ExcelCellSets the fill color using a hex color value.
Parameters
- hexColor System.String
public ExcelCell SetFontColor(String hexColor) #ExcelCellSets the font color using a hex color value.
Parameters
- hexColor System.String
public ExcelCell SetFontName(String fontName) #ExcelCellSets the font family name.
Parameters
- fontName System.String
public ExcelCell SetFontSize(Double fontSize) #ExcelCellSets the font size in points.
Parameters
- fontSize System.Double
public ExcelCell SetFormula(String formula) #ExcelCellSets the cell formula.
Parameters
- formula System.String
public ExcelCell SetGradientFill(String fromHexColor, String toHexColor, Double degree = 0) #ExcelCellSets a two-color linear gradient fill using hex color values.
Parameters
- fromHexColor System.String
- toHexColor System.String
- degree System.Double = 0
public ExcelCell SetItalic(Boolean italic = true) #ExcelCellSets or clears italic font style.
Parameters
- italic System.Boolean = true
public ExcelCell SetNumberFormat(String numberFormat) #ExcelCellApplies a number format to the cell.
Parameters
- numberFormat System.String
public ExcelCell SetRichText(params ExcelRichTextRun[] runs) #ExcelCellReplaces the cell contents with rich inline text runs.
Parameters
- runs OfficeIMO.Excel.ExcelRichTextRun[]
public ExcelCell SetShrinkToFit(Boolean shrinkToFit = true) #ExcelCellSets or clears shrink-to-fit text alignment.
Parameters
- shrinkToFit System.Boolean = true
public ExcelCell SetStrikethrough(Boolean strikethrough = true) #ExcelCellSets or clears strikethrough font style.
Parameters
- strikethrough System.Boolean = true
public ExcelCell SetTextRotation(Int32 rotation) #ExcelCellSets Excel text rotation. Use 0-90 for upward rotation, 91-180 for downward rotation, or 255 for stacked vertical text.
Parameters
- rotation System.Int32
public ExcelCell SetUnderline(Boolean underline = true) #ExcelCellSets or clears underline font style.
Parameters
- underline System.Boolean = true
public ExcelCell SetUnderline(ExcelUnderlineStyle underlineStyle) #ExcelCellSets the native Excel underline style.
Parameters
- underlineStyle OfficeIMO.Excel.ExcelUnderlineStyle
public ExcelCell SetValue(Object? value) #ExcelCellSets the cell value.
Parameters
- value System.Object?
public ExcelCell SetVerticalTextAlignment(ExcelVerticalTextAlignment alignment) #ExcelCellSets the native Excel baseline, superscript, or subscript alignment.
Parameters
- alignment OfficeIMO.Excel.ExcelVerticalTextAlignment
public ExcelCell TransformTextCase(OfficeTextCase textCase, CultureInfo? culture = null) #ExcelCellChanges stored text casing while preserving cell or rich-run formatting. Formulas and non-text values are left unchanged.
Parameters
- textCase OfficeIMO.Drawing.OfficeTextCase
- culture System.Globalization.CultureInfo? = null
public Boolean TryGetValue<T>(out T? value) #BooleanTries to get the cell value converted to the requested type.
Type Parameters
- T
Parameters
- value T?
Inherited Methods
public virtual Boolean Equals(Object? obj) #BooleanParameters
- obj Object?