1 用到库:Excel = Microsoft.office.Interop.Excel
2 导出逻辑注意点:
a,避免弹框:
Application app = new Application();
app.DisplayAlerts = false;
b, 删除指定列
Excel.Range range = (Excel.Range)sheet.column[i];
range.Delete(Excel.XlDeleteShiftDirection.xlShiftUp);
c,导出函数:
SaveAs(csv路径, Excel.XlFileFormat.xlAddIn)