摘要:匯出Excel檔案時, 讓user 選檔名
private void button1_Click(object sender, EventArgs e)
{
SaveFileDialog dlg = new SaveFileDialog();
dlg.FileName = "~temp1.xlsx";
dlg.Filter = "Excel files (*.xls;*.xlsx)|*.xls;*.xlsx|All files (*.*)|*.* ";
if (dlg.ShowDialog(null) == System.Windows.Forms.DialogResult.OK)
{
System.IO.File.Delete(dlg.FileName);
string template = System.IO.File.Exists(dlg.FileName) ? dlg.FileName : "";
excelDataGridView1.ExportToExcel(dlg.FileName, null, true);
}
Close();
}