引用类库:using Aspose.Cells;
////// 导出 /// /// /// private void btnExport_Click(object sender, EventArgs e) { DataTable dtr = ds.Tables[0]; Export(dtr, "拣货信息表.xlsx", false); } ////// 导出Excel /// /// /// /// public void Export(DataTable dataTable, string fileName, bool tipOpenfile = false) { if (fileName == null || dataTable == null) return; if (File.Exists(fileName) && (MessageBox.Show("文件已存在,是否覆盖?", "提示", MessageBoxButtons.YesNo) == System.Windows.Forms.DialogResult.No)) return; try { Workbook wb = new Workbook(); Worksheet ws = wb.Worksheets[0]; ws.Name = dataTable.TableName == null ? "Sheet1" : dataTable.TableName; Cells cell = ws.Cells; for (int i = 0; i < dataTable.Columns.Count; i++) { cell[0, i].PutValue(dataTable.Columns[i].ColumnName); for (int j = 0; j