private void ExportToExecl() { System.Windows.Forms.SaveFileDialog sfd = new SaveFileDialog(); sfd.DefaultExt = "xls"; sfd.Filter = "Excel文件 (*.xls)|*.xls"; if (sfd.ShowDialog() == DialogResult.OK) { string path = sfd.FileName; string header = "项目#年月#压铸车间合格品数#压铸计数器#压铸车间报废数 压铸,打砂1,打砂2,挫披锋,H面全检#压铸车间内部报废数#压铸车间内部报废率#挫披锋内部报废 压铸,打砂1,打砂2,挫披锋,H面全检外观全检#挫披锋内部报废数#挫披锋内部报废率#压铸车间总的报废数#压铸车间总的内部报废率#CNC产能#机加缺陷报废数 CNC,清洗,测漏,全检#机加车间最终报废数#机加车间最终报废率#压铸车间报废总数 CNC2,全检线#压铸车间最终报废数#压铸车间最终报废率"; DataSet ds = new DataSet(); ds.Tables.Add(dtable.Copy()); NPOIHelper helper = new WorkShopSystem.Utility.NPOIHelper("", "sheet", header, "车间数据统计", ds, "", path, 2); string flag = helper.Export(); if (flag == "ok") { MessageBox.Show("导出数据成功!"); } else { MessageBox.Show(flag); } } }
private void ExportToExecl() { System.Windows.Forms.SaveFileDialog sfd = new SaveFileDialog(); sfd.DefaultExt = "xls"; sfd.Filter = "Excel文件 (*.xls)|*.xls"; if (sfd.ShowDialog() == DialogResult.OK) { string path = sfd.FileName; //string heade = header.TrimEnd('#'); DataSet ds = new DataSet(); ds.Tables.Add(dtable.Copy()); NPOIHelper helper = new WorkShopSystem.Utility.NPOIHelper("", "机加车间", header.TrimEnd('#'), "机加车间数据查询", ds, "", path, 2); string flag = helper.Export(); if (flag == "ok") { MessageBox.Show("导出数据成功!"); } else { MessageBox.Show(flag); } } }