110,534
社区成员
发帖
与我相关
我的任务
分享
foreach (Worksheet sheet in workbook.Worksheets)
{
foreach (CellRange cell in sheet.Range)
{
if (cell.HasFormula)
{
double value = cell.FormulaNumberValue;
cell.Clear(ExcelClearOptions.ClearAll);
cell.NumberValue = value;
}
}
}