public void ImproExcel(DataGridView selectDgv) { SaveFileDialog sdfExport = new SaveFileDialog(); sdfExport.Filter = "Excel 97-2003文件|*.xls|Excel 2007文件|*.xlsx"; // sdfExport.ShowDialog(); if (sdfExport.ShowDialog() != DialogResult.OK) { return; } String filename = sdfExport.FileName; String tableName = ""; NPOIExcelCompletedToMes NPOIexcel = new NPOIExcelCompletedToMes(); DataTable tabl = new DataTable(); tabl = GetDgvToTable(this.selectDgv); tableName = "dataGridView1"; NPOIexcel.ExcelWrite(filename, tabl, tableName); //excelhelper写出 if (MessageBox.Show("导出成功,文件保存在" + filename.ToString() + ",是否打开此文件?", "提示", MessageBoxButtons.YesNo) == DialogResult.Yes) { if (File.Exists(filename)) //文件是否存在 { Process.Start(filename); //执行打开导出的文件 } else { MessageBox.Show("文件不存在!", "提示"); return; } } }
public void ImproExcel() { String tableName = this.cbSearchType.SelectedItem.ToString() + "-" + this.dtpStarDate.Value.ToString("yyyy-MM-dd") + "-" + this.dtpStopDate.Value.ToString("yyyy-MM-dd") + ".xlsx"; SaveFileDialog sdfExport = new SaveFileDialog(); sdfExport.Filter = "Excel 2007文件|*.xlsx|Excel 97-2003文件|*.xls"; sdfExport.FileName = tableName; // sdfExport.ShowDialog(); if (sdfExport.ShowDialog() != DialogResult.OK) { return; } String filename = sdfExport.FileName; NPOIExcelCompletedToMes NPOIexcel = new NPOIExcelCompletedToMes(); DataTable tabl = new DataTable(); tabl = GetDgvToTable(this.dgvCFoutPut); // tableName = "dgvOutgoingTable"; NPOIexcel.ExcelWrite(filename, tabl, tableName);//excelhelper写出 if (MessageBox.Show("导出成功,文件保存在" + filename.ToString() + ",是否打开此文件?", "提示", MessageBoxButtons.YesNo) == DialogResult.Yes) { if (File.Exists(filename)) //文件是否存在 { Process.Start(filename); //执行打开导出的文件 } else { MessageBox.Show("文件不存在!", "提示"); } } }