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);
}
}
}
