Skip to content

Class ExcelNumberFormatXml

Namespace: OfficeOpenXml.Style.XmlAccess
Assembly: EPPlus.dll

Xml access class for number customFormats

public sealed class ExcelNumberFormatXml : StyleXmlHelper, IExcelNumberFormat

Inheritance

object ← XmlHelper ← StyleXmlHelper ← ExcelNumberFormatXml

Implements

IExcelNumberFormat

Inherited Members

object.Equals(object?, object?)
object.Equals(object?)
object.GetHashCode()
object.GetType()
object.ReferenceEquals(object?, object?)
object.ToString()

Properties

BuildIn

If the number format is build in

public bool BuildIn { get; }

Property Value

bool

Format

The numberformat string

public string Format { get; set; }

Property Value

string

NumFmtId

Id for number format

Build in ID's

0 General 1 0 2 0.00 3 #,##0 4 #,##0.00 9 0% 10 0.00% 11 0.00E+00 12 # ?/? 13 # ??/?? 14 mm-dd-yy 15 d-mmm-yy 16 d-mmm 17 mmm-yy 18 h:mm AM/PM 19 h🇲🇲ss AM/PM 20 h:mm 21 h🇲🇲ss 22 m/d/yy h:mm 37 #,##0;(#,##0) 38 #,##0;[Red] (#,##0) 39 #,##0.00;(#,##0.00) 40 #,##0.00;[Red] (#,##0.00) 45 mm:ss 46 [h]🇲🇲ss 47 mmss.0 48 ##0.0E+0 49 @

public int NumFmtId { get; set; }

Property Value

int