Class ExcelNumberFormatXml

Xml access class for number formats

Inheritance
System.Object
XmlHelper
StyleXmlHelper
ExcelNumberFormatXml
Inherited Members
System.Object.Equals(System.Object)
System.Object.Equals(System.Object, System.Object)
System.Object.GetHashCode()
System.Object.GetType()
System.Object.MemberwiseClone()
System.Object.ReferenceEquals(System.Object, System.Object)
System.Object.ToString()
Namespace: OfficeOpenXml.Style.XmlAccess
Assembly: EPPlus.dll
Syntax
public sealed class ExcelNumberFormatXml : StyleXmlHelper

Properties

BuildIn

If the numberformat is build in

Declaration
public bool BuildIn { get; }
Property Value
Type Description
System.Boolean

Format

The numberformat string

Declaration
public string Format { get; set; }
Property Value
Type Description
System.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:mm:ss AM/PM 20 h:mm 21 h:mm:ss 22 m/d/yy h:mm 37 #,##0 ;(#,##0) 38 #,##0 ;Red 39 #,##0.00;(#,##0.00) 40 #,##0.00;Red 45 mm:ss 46 [h]:mm:ss 47 mmss.0 48 ##0.0E+0 49 @

Declaration
public int NumFmtId { get; set; }
Property Value
Type Description
System.Int32