使用DevExpress可以实现将界面的GridControl的内容直接导出到excel文件,一般实现方法如下所示:
public void export(GridControl gridControl1)
{
SaveFileDialog saveFileDialog1 = new SaveFileDialog();
saveFileDialog1.FileName = "";
saveFileDialog1.Filter = "Excel文件(.xls)|*.xls";
string strtype = "Excel文件名";
saveFileDialog1.FileName = strtype + DateTime.Now.ToString("yyyyMMddhhmmss");
saveFileDialog1.OverwritePrompt = false; //已存在文件是否覆盖提示
if (saveFileDialog1.ShowDialog() != DialogResult.OK)
return;
//已存在文件是否覆盖提示
while (System.IO.File.Exists(saveFileDialog1.FileName) &&
DevExpress.XtraEditors.XtraMessageBox.Show("该文件名已存在,