private void btnExport_Click(object sender, EventArgs e) { if (this.GridView != null) { NPOIExcelHelper.Export(GridView, true); } }
/// <summary> /// 导出数据 /// </summary> protected virtual void ExportData() { try { if (GridView == null) { return; } SaveFileDialog dig = new SaveFileDialog(); dig.Filter = "Excel文档|*.xls;*.xlsx|所有文件(*.*)|*.*"; dig.InitialDirectory = Environment.GetFolderPath(Environment.SpecialFolder.Desktop); if (dig.ShowDialog() == DialogResult.OK) { string path = dig.FileName; NPOIExcelHelper.Export(GridView, path, true); MessageBox.Show("导出成功"); } } catch (Exception) { MessageBox.Show("保存到电子表格时出现错误!"); } }