/// <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); } }