Microsoft.Office.Interop.Excel.Application app =
new Microsoft.Office.Interop.Excel.Application();
app.Visible = true;
Workbooks wbs = app.Workbooks;
_Workbook wb = wbs.Open("C:\\test.xlsx");
Sheets shs = wb.Worksheets;
sheet = shs.get_Item(1);
sheet.UsedRange.Value = sheet.UsedRange.Value;//公式变数值
wb.Save();
app.Quit();
using Microsoft.Office.Core;
using Microsoft.Office.Interop.Excel;