DevExpress 自带的导出EXCEL xls xlsx

最新推荐文章于 2024-01-20 09:59:57 发布

zmlsh

最新推荐文章于 2024-01-20 09:59:57 发布

阅读量6.5k

点赞数 2

分类专栏： ASP.NET c#

本文链接：https://blog.csdn.net/zmlsh/article/details/80119361

版权

c# 同时被 2 个专栏收录

8 篇文章 0 订阅

订阅专栏

ASP.NET

4 篇文章 0 订阅

订阅专栏

SaveFileDialog saveFileDialog = new SaveFileDialog();
                saveFileDialog.Title = "导出Excel";
                saveFileDialog.Filter = "Excel文件(*.xls)|*.xls|Excel文件(*.xlsx)|*.xlsx";
                DialogResult dialogResult = saveFileDialog.ShowDialog(this);
                if (dialogResult == DialogResult.OK)
                {
                    string filter = saveFileDialog.FileName.Substring(saveFileDialog.FileName.LastIndexOf(".") + 1);
                    if (filter == "xls")
                    {
                        XlsExportOptions options = new XlsExportOptions();
                        options.TextExportMode = TextExportMode.Value;
                        options.ExportMode = XlsExportMode.SingleFile;
                        gcLocal.ExportToXls(saveFileDialog.FileName, options);
                    }
                    else
                    {
                        XlsxExportOptions options = new XlsxExportOptions();
                        options.TextExportMode = TextExportMode.Value;
                        options.ExportMode = XlsxExportMode.SingleFile;
                        gcLocal.ExportToXlsx(saveFileDialog.FileName, options);
                    }
                    //MessageBox.Show("导出成功！", "提示", MessageBoxButtons.OK, MessageBoxIcon.Information);
                    ExcelHelper excelBuilder = new ExcelHelper(saveFileDialog.FileName);
                    excelBuilder.DeleteColumns(1, 1);
                    excelBuilder.SaveFile();
                    if (MessageBox.Show("保存成功，是否打开文件？", "提示", MessageBoxButtons.YesNo, MessageBoxIcon.Information) == DialogResult.Yes)
                    {
                        System.Diagnostics.Process.Start(saveFileDialog.FileName);
                    }
                }