GridControl导出到Excel代码,Asp.Net代码库,德仔网

代码语言

代码分类

【Asp.Net】 GridControl导出到Excel

作者:Sarah / 发布于2015/3/24/ 988


	SaveFileDialog fileDialog = new SaveFileDialog();
	fileDialog.Title = "导出Excel";
	fileDialog.Filter = "Excel文件(*.xls)|*.xls";
	DialogResult dialogResult = fileDialog.ShowDialog(this);
	if (dialogResult == DialogResult.OK)
	{
	DevExpress.XtraPrinting.XlsExportOptions options = new DevExpress.XtraPrinting.XlsExportOptions();
	gridControl1.ExportToXls(fileDialog.FileName);
	DevExpress.XtraEditors.XtraMessageBox.Show("保存成功！", "提示", MessageBoxButtons.OK, MessageBoxIcon.Information);
	}

	

	public override void ImportExcel()
	 {
	 if (XtraMessageBox.Show("确定要将本页面数据导入到Excel内?") == DialogResult.OK)
	 {
	 try
	 {
	 if (this.DataSourceTable == null || this.DataSourceTable.Rows.Count == 0)
	 {
	 XtraMessageBox.Show("没有数据要导出！");
	 return;
	 }
	 this.SaveFileDialog.Filter = "Excel文件(*.xls)|*.xls";
	 if (this.SaveFileDialog.ShowDialog(this) == DialogResult.OK)
	 {
	 BaseFormFactory.ProcessFactory.Show(this, "数据导出开始");
	 ExportTo(new DevExpress.XtraExport.ExportXlsProvider(this.SaveFileDialog.FileName));
	 }

	 }
	 catch (Exception vErr)
	 {
	 XtraMessageBox.Show("导出数据失败!错误源:" + vErr.Message);
	 }
	 finally
	 {
	 BaseFormFactory.ProcessFactory.Close();
	 XtraMessageBox.Show("导出成功!", "提示", MessageBoxButtons.OK, MessageBoxIcon.Information);
	 }
	 }
	 }
	 private void ExportTo(DevExpress.XtraExport.IExportProvider provider)
	 {
	 DevExpress.XtraGrid.Export.BaseExportLink link = this.gridData.gridView2.CreateExportLink(provider);
	 (link as DevExpress.XtraGrid.Export.GridViewExportLink).ExpandAll = false;
	 link.ExportTo(true);
	 provider.Dispose();
	 }

试试其它关键字

　l导出到Excel　

同语言下

可能有用的

Sarah贡献的其它代码(10)