/// <summary>
/// 值填入excel
/// </summary>
/// <param name="cell"></param>
/// <param name="style"></param>
/// <param name="value"></param>
private void PutExcelValue(Cell cell, Style style, string value)
{
if ((cell.Type == CellValueType.IsNumeric || cell.NumberCategoryType == NumberCategoryType.Number || cell.NumberCategoryType == NumberCategoryType.Scientific || cell.NumberCategoryType == NumberCategoryType.General || cell.NumberCategoryType == NumberCategoryType.Fraction) && AsposeHelper.TryGetDecimal(value))
{
cell.PutValue(Convert.ToDecimal(value));
}
else if ((style.IsDateTime || cell.Type == CellValueType.IsDateTime || cell.NumberCategoryType == NumberCategoryType.Date) && AsposeHelper.TryGetDateTime(value))
{
cell.PutValue(Convert.ToDateTime(value));
}
else if (cell.Type == CellValueType.IsBool && AsposeHelper.TryGetbool(value))
{
cell.PutValue(Convert.ToBoolean(value));
}
else if (cell.Type == CellValueType.IsNull || cell.Type == CellValueType.IsString)
{
cell.PutValue(value);
}
else
{
cell.PutValue(value);
}
}
