private void btn_export_Click(object sender, EventArgs e) { string path = ""; bool overWrite = true; if (dataGridView1.Rows.Count == 0) { return; } comn = new Common.Common(); saveFileDialog1.Filter = "Excel File|*.xls"; saveFileDialog1.Title = "数据导出"; //this.saveFileDialog1.FileName = txtKhmc.Text.Trim() + "印刷清单"; if (saveFileDialog1.ShowDialog() != DialogResult.Cancel) { path = saveFileDialog1.FileName; DataGridViewExport.ExportToExcel(dataGridView1, path, "s", overWrite); } DialogResult result = MessageBox.Show("是否打开Excel文件?", "提示", MessageBoxButtons.YesNo, MessageBoxIcon.Question); if (result == DialogResult.No) { return; } if (DataGridViewExport.IsExistsExcel()) { DataGridViewExport.OpenExcel(path); } }
private void bt_print_Click(object sender, EventArgs e) { //RdlcPrintNew rdlcprint = new RdlcPrintNew(); //rdlcprint.Run(reportView.LocalReport, "单据打印", false, "A4"); //DataGridViewExport.DataGridviewShowToExcel(dgv_tjxm,false); string path = ""; bool overWrite = true; if (dgv_tjxm.Rows.Count == 0) { return; } Common.Common comn = new Common.Common(); saveFileDialog1.Filter = "Excel File|*.xls"; saveFileDialog1.Title = "数据导出"; if (saveFileDialog1.ShowDialog() != DialogResult.Cancel) { path = saveFileDialog1.FileName; DataGridViewExport.ExportToExcel(dgv_tjxm, path, "s", overWrite); } DialogResult result = MessageBox.Show("是否打开Excel文件?", "提示", MessageBoxButtons.YesNo, MessageBoxIcon.Question); if (result == DialogResult.No) { return; } if (DataGridViewExport.IsExistsExcel()) { DataGridViewExport.OpenExcel(path); } }