DEV-gridview导出Excel

最新推荐文章于 2023-04-11 14:25:53 发布

weixin_30556161

最新推荐文章于 2023-04-11 14:25:53 发布

阅读量143

点赞数

原文链接：http://www.cnblogs.com/lhlong/p/4992299.html

版权

                SaveFileDialog saveFile = new SaveFileDialog();
                saveFile.Title = "请选择文件存放路径";
                saveFile.Filter = "Excel文档(*.xls)|*.xls|Excel文档(*.xlsx)|*.xlsx";
                saveFile.FileName = "AX"+DateTime.Now.ToString("yyyyMMddHhmmss");
                if (saveFile.ShowDialog() == DialogResult.OK)
                {
                    DevExpress.XtraPrinting.XlsExportOptions options = new DevExpress.XtraPrinting.XlsExportOptions();
                    options.TextExportMode = DevExpress.XtraPrinting.TextExportMode.Text;
                    options.SheetName = "";
                    gridView1.OptionsPrint.AutoWidth = false;
                    gridView1.OptionsPrint.AllowCancelPrintExport = false;
                    gridView1.AppearancePrint.Row.Font = new System.Drawing.Font("宋体", 9);
                    gridView1.ExportToXls(saveFile.FileName, options);
                }

转载于:https://www.cnblogs.com/lhlong/p/4992299.html