public Cell(object value, string formatString) { _value = value; _format = new CellFormat(CellFormatType.General, formatString); }
public Cell(object value, CellFormat format) { _value = value; _format = format; }
public Cell(object value) { _value = value; _format = CellFormat.General; }
internal int GetXFIndex(CellFormat cellFormat) { string formatString = cellFormat.FormatString; if (NumberFormatXFIndice.ContainsKey(formatString)) { return NumberFormatXFIndice[formatString]; } else { UInt16 formatIndex = CellFormats.GetFormatIndex(formatString); if (formatIndex == UInt16.MaxValue) { formatIndex = MaxNumberFormatIndex++; } FORMAT format = new FORMAT(); format.FormatIndex = formatIndex; format.FormatString = formatString; FormatRecords.Add(format); XF xf = new XF(); xf.Attributes = 252; xf.CellProtection = 0; xf.PatternColorIndex = 64; xf.PatternBackgroundColorIndex = 130; xf.FontIndex = 0; xf.FormatIndex = formatIndex; ExtendedFormats.Add(xf); int numberFormatXFIndex = ExtendedFormats.Count - 1; NumberFormatXFIndice.Add(formatString, numberFormatXFIndex); return numberFormatXFIndex; } }