导出.txt / .pdf / .xls
生活随笔
收集整理的這篇文章主要介紹了
导出.txt / .pdf / .xls
小編覺(jué)得挺不錯(cuò)的,現(xiàn)在分享給大家,幫大家做個(gè)參考.
public static string TxtFilter = "文本文件(.txt)|*.txt";public static string PDFFilter = "PDF文件(.pdf)|*pdf";public static string XLSFilter = "Excel文件(.xls)|*.xls";public void ExportGrid(GridControl grid, string ext, string Filter,string title){using (SaveFileDialog saveFileDialog1 = new SaveFileDialog()){saveFileDialog1.FileName = "";saveFileDialog1.Filter = Filter;saveFileDialog1.FileName = title;saveFileDialog1.OverwritePrompt = false; //已存在文件是否覆蓋提示if (saveFileDialog1.ShowDialog() != DialogResult.OK)return;//已存在文件是否覆蓋提示while (System.IO.File.Exists(saveFileDialog1.FileName) &&DevExpress.XtraEditors.XtraMessageBox.Show("該文件名已存在,是否覆蓋?","提示", MessageBoxButtons.YesNo, MessageBoxIcon.Question) != DialogResult.Yes){if (saveFileDialog1.ShowDialog() != DialogResult.OK)return;}if (saveFileDialog1.FileName != ""){try{System.IO.FileStream fs =(System.IO.FileStream)saveFileDialog1.OpenFile();if (ext == "txt"){grid.ExportToText(fs);}else if (ext == "pdf"){grid.ExportToPdf(fs);}else if (ext == "xls"){XlsExportOptions options = new XlsExportOptions();options.TextExportMode = TextExportMode.Text;grid.ExportToXls(fs, options);}//this.gcISSUESUBs.ExportToText(fs);
fs.Close();//DevExpress.XtraEditors.XtraMessageBox.Show("數(shù)據(jù)導(dǎo)出成功!", "提示");
}catch (Exception ex){if (ex.Message.Contains("正由另一進(jìn)程使用")){DevExpress.XtraEditors.XtraMessageBox.Show("數(shù)據(jù)導(dǎo)出失敗!文件正由另一個(gè)程序占用!", "提示");}elseDevExpress.XtraEditors.XtraMessageBox.Show("數(shù)據(jù)導(dǎo)出失敗!數(shù)據(jù)量過(guò)大,請(qǐng)分別統(tǒng)計(jì)再導(dǎo)出!", "提示");}}}}
?
轉(zhuǎn)載于:https://www.cnblogs.com/mapstar/p/10818090.html
總結(jié)
以上是生活随笔為你收集整理的导出.txt / .pdf / .xls的全部?jī)?nèi)容,希望文章能夠幫你解決所遇到的問(wèn)題。
- 上一篇: 刚出道的黑客搞瘫美国输油管道!他们还边搞
- 下一篇: 京东到家程序员删库跑路 ! 讲一讲 My