1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26
| if (DateTime.TryParse(cellValue.ToString(), out dateValue))
{
styleIndex = _dateStyleId;
//the ToOADate method addresses how Excel stores Date values...
cell = createValueCell(columnIndex, rowIndex, dateValue.ToOADate().ToString(), styleIndex);
}
else if (int.TryParse(cellValue.ToString(), out intValue))
{
styleIndex = _numberStyleId;
cell = createValueCell(columnIndex, rowIndex, intValue, styleIndex);
}
else if (Double.TryParse(cellValue.ToString(), out doubleValue))
{
styleIndex = _doubleStyleId;
cell = createValueCell(columnIndex, rowIndex, doubleValue, styleIndex);
}
else
{
// //assume the value is string, use the InlineString value type...
InlineString inlineString = new InlineString();
Text t = new Text();
t.Text = cellValue.ToString();
inlineString.Append(t);
cell.Append(inlineString);
} |
Partager