将数据导出Excel
SaveFileDialog sfd = new SaveFileDialog();
sfd.Title = "保存";
sfd.Filter = "Excel文件(*.xls)|*.xls|Excel文件(*.xlsx)|*.xlsx";
string path = System.IO.Directory.GetCurrentDirectory();
if (sfd.ShowDialog() == DialogResult.OK)
{
string sFilePath = sfd.FileName;
ExportFiles ef = new ExportFiles();
try
{
ef.DataTabletoExcel(DevComponents.DotNetBar.Controls.DataGridViewX, sFilePath);//绑定数据的控件
}
catch
{
}
MessageBox.Show("导出成功");
System.IO.Directory.SetCurrentDirectory(path);
}