利用DevExpress将DataTable数据导出到Excel

方法：根据DataTable列名动态创建GridControl，然后利用GridView导出Excel，同时还可以导出其他形式文件。

using DevExpress.XtraGrid.Views.Grid;
using DevExpress.XtraEditors;
using DevExpress.XtraGrid;

/// 
/// 导出Excel/// 
/// public void Export(DataTable datasource){ System.Windows.Forms.SaveFileDialog saveFileDialog = new System.Windows.Forms.SaveFileDialog();saveFileDialog.DefaultExt = "xls";saveFileDialog.Filter = "Excel文件|*.xls";if (saveFileDialog.ShowDialog() == System.Windows.Forms.DialogResult.OK){GridControl grid= new GridControl();;GridView view = new GridView();grid.ViewCollection.Add(view);grid.MainView = view;view.GridControl = grid;foreach (DataColumn dc in datasource.Columns){DevExpress.XtraGrid.Columns.GridColumn gridColumnNumber = view.Columns.AddVisible(dc.ColumnName);gridColumnNumber.FieldName = dc.ColumnName;}grid.DataSource = datasource;this.Controls.Add(grid);//重要grid.ForceInitialize();//重要view.BestFitColumns();view.ExportToXls(saveFileDialog.FileName);}}

关键两行代码必须有，否则view.DataSource为Null

本文来自互联网用户投稿，文章观点仅代表作者本人，不代表本站立场，不承担相关法律责任。如若转载，请注明出处。 如若内容造成侵权/违法违规/事实不符，请点击【内容举报】进行投诉反馈！