我如何使用保存对话框保存Excel文件? [英] How I Save The Excel File Using Save Dialog Box?
本文介绍了我如何使用保存对话框保存Excel文件?的处理方法,对大家解决问题具有一定的参考价值,需要的朋友们下面随着小编来一起学习吧!
问题描述
SaveFileDialog saveDlg = new SaveFileDialog();
saveDlg.InitialDirectory = @ C:\;
saveDlg.Filter = Excel文件(* .xls)| * .xls;
saveDlg.FilterIndex = 0 ;
saveDlg.RestoreDirectory = true ;
saveDlg.Title = 将Excel文件导出为;
if (saveDlg.ShowDialog()== DialogResult.OK)
{
尝试
{
string path = saveDlg.FileName;
// xlWorkBook.SaveCopyAs(path);
ExcelLibrary.DataSetHelper.CreateWorkbook ( MyExcelFile.xls,ds);
MessageBox.Show( File is Created);
}
catch (Exception ex)
{
MessageBox.Show(ex 。信息);
}
}
解决方案
请,阅读我对这个问题的评论。
这是正确的使用SaveFileDialog [ ^ ]:
{
string fullpath = saveDlg.FileName;
// xlWorkBook.SaveCopyAs(path);
ExcelLibrary.DataSetHelper.CreateWorkbook (fullpath,ds);
// 文件已创建
}
SaveFileDialog saveDlg = new SaveFileDialog();
saveDlg.InitialDirectory = @"C:\";
saveDlg.Filter = "Excel files (*.xls)|*.xls";
saveDlg.FilterIndex = 0;
saveDlg.RestoreDirectory = true;
saveDlg.Title = "Export Excel File To";
if (saveDlg.ShowDialog() == DialogResult.OK)
{
try
{
string path = saveDlg.FileName;
// xlWorkBook.SaveCopyAs(path);
ExcelLibrary.DataSetHelper.CreateWorkbook("MyExcelFile.xls", ds);
MessageBox.Show("File is Created");
}
catch (Exception ex)
{
MessageBox.Show(ex.Message);
}
}
解决方案
Please, read my comment to the question.
Here is proper usage of SaveFileDialog[^]:
{ string fullpath = saveDlg.FileName; // xlWorkBook.SaveCopyAs(path); ExcelLibrary.DataSetHelper.CreateWorkbook(fullpath, ds); //File has been created }
这篇关于我如何使用保存对话框保存Excel文件?的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持IT屋!
查看全文