@ C#读写Excel及保存文件到不同的文件夹中
用C#读写Excel后,保存到不同的文件夹中
先读写Excel使用workbook和worksheet类
Application app = new Application();
//打开结果表
Workbook wbook = app.Workbooks.Open("D:\\20181211-jurong.xlsx", Type.Missing, Type.Missing, Type.Missing, Type.Missing, Type.Missing, Type.Missing, Type.Missing, Type.Missing, Type.Missing, Type.Missing, Type.Missing, Type.Missing, Type.Missing, Type.Missing);
Worksheet wsheet = wbook.Worksheets[1];
//打开合并企业表
Workbook wbook_hebing = app.Workbooks.Open("D:\\hebingbiao.xlsx", Type.Missing, Type.Missing, Type.Missing, Type.Missing, Type.Missing, Type.Missing, Type.Missing, Type.Missing, Type.Missing, Type.Missing, Type.Missing, Type.Missing, Type.Missing, Type.Missing);
Worksheet wsheet_hebing = wbook_hebing.Worksheets[1];
//先打开模板
Workbook wbook_tiji