API Reference
ExcelColumnFormatPlan
Describes reusable header-based column number formats for worksheet exports.
Inheritance
- Object
- ExcelColumnFormatPlan
Usage
This type appears in these public API surfaces even when no hand-authored example is attached directly to the page.
Returned or exposed by
- Method ExcelColumnFormatPlan.Add
- Method ExcelColumnFormatPlan.AddFormat
- Method ExcelColumnFormatPlan.Currency
- Method ExcelColumnFormatPlan.Currency
- Method ExcelColumnFormatPlan.Currency
- Method ExcelColumnFormatPlan.Currency
- Method ExcelColumnFormatPlan.Date
- Method ExcelColumnFormatPlan.DateTime
- Method ExcelColumnFormatPlan.Integer
- Method ExcelColumnFormatPlan.Number
- Method ExcelColumnFormatPlan.Number
- Method ExcelColumnFormatPlan.Percent
- Method ExcelColumnFormatPlan.Percent
- Method ExcelColumnFormatPlan.Text
Accepted by parameters
Constructors
public ExcelColumnFormatPlan() #Methods
public ExcelColumnFormatPlan Add(String header, ExcelNumberPreset preset, Int32 decimals = 2, CultureInfo culture = null, Boolean includeHeader = false, Boolean autoFit = false) #ExcelColumnFormatPlanAdds a preset number format for a column resolved by header text.
Parameters
- header System.String
- preset OfficeIMO.Excel.ExcelNumberPreset
- decimals System.Int32 = 2
- culture System.Globalization.CultureInfo = null
- includeHeader System.Boolean = false
- autoFit System.Boolean = false
public ExcelColumnFormatPlan AddFormat(String header, String numberFormat, Boolean includeHeader = false, Boolean autoFit = false) #ExcelColumnFormatPlanAdds a custom Excel number format for a column resolved by header text.
Parameters
- header System.String
- numberFormat System.String
- includeHeader System.Boolean = false
- autoFit System.Boolean = false
public ExcelColumnFormatPlan Currency(params String[] headers) #ExcelColumnFormatPlanAdds currency formatting for columns resolved by header text.
Parameters
- headers System.String[]
public ExcelColumnFormatPlan Currency(CultureInfo culture, params String[] headers) #ExcelColumnFormatPlanAdds culture-aware currency formatting for columns resolved by header text.
Parameters
- culture System.Globalization.CultureInfo
- headers System.String[]
public ExcelColumnFormatPlan Currency(Int32 decimals, params String[] headers) #ExcelColumnFormatPlanAdds currency formatting with explicit precision for columns resolved by header text.
Parameters
- decimals System.Int32
- headers System.String[]
public ExcelColumnFormatPlan Currency(Int32 decimals, CultureInfo culture, params String[] headers) #ExcelColumnFormatPlanAdds culture-aware currency formatting with explicit precision for columns resolved by header text.
Parameters
- decimals System.Int32
- culture System.Globalization.CultureInfo
- headers System.String[]
public ExcelColumnFormatPlan Date(params String[] headers) #ExcelColumnFormatPlanAdds date formatting for columns resolved by header text.
Parameters
- headers System.String[]
public ExcelColumnFormatPlan DateTime(params String[] headers) #ExcelColumnFormatPlanAdds date and time formatting for columns resolved by header text.
Parameters
- headers System.String[]
public ExcelColumnFormatPlan Integer(params String[] headers) #ExcelColumnFormatPlanAdds integer formatting for columns resolved by header text.
Parameters
- headers System.String[]
public ExcelColumnFormatPlan Number(params String[] headers) #ExcelColumnFormatPlanAdds decimal number formatting for columns resolved by header text.
Parameters
- headers System.String[]
public ExcelColumnFormatPlan Number(Int32 decimals, params String[] headers) #ExcelColumnFormatPlanAdds decimal number formatting with explicit precision for columns resolved by header text.
Parameters
- decimals System.Int32
- headers System.String[]
public ExcelColumnFormatPlan Percent(params String[] headers) #ExcelColumnFormatPlanAdds percent formatting for columns resolved by header text.
Parameters
- headers System.String[]
public ExcelColumnFormatPlan Percent(Int32 decimals, params String[] headers) #ExcelColumnFormatPlanAdds percent formatting with explicit precision for columns resolved by header text.
Parameters
- decimals System.Int32
- headers System.String[]
public ExcelColumnFormatPlan Text(params String[] headers) #ExcelColumnFormatPlanAdds text formatting for columns resolved by header text.
Parameters
- headers System.String[]
Inherited Methods
public override Boolean Equals(Object obj) #BooleanParameters
- obj Object