• DEV-gridview导出Excel


                    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);
                    }
    

      

  • 相关阅读:
    第九周
    第八周
    第七周
    代码复审核查表
    对软件开发的理解
    第六周
    网站流量分析架构及实现
    hive的sql语句
    精简客户端搭建Oracle数据库
    idaa搭建maven发布tomcat
  • 原文地址:https://www.cnblogs.com/lhlong/p/4992299.html
Copyright © 2020-2023  润新知