测试 excel导出

wells.liu

2020-07-13 9aba9bbb5682cae407dfb1e52c80f57494ed38d6

 src/Bro.M071.DBManager/ExcelExportHelper.cs

@@ -19,6 +19,13 @@
        public Dictionary<string, Dictionary<string, string>> WorksheetColumns { get; set; }
        public Dictionary<string, DataTable> WorksheetDataTable { get; set; }

        public ExcelExportSet()
        {
            Worksheets = new List<string>();
            WorksheetColumns = new Dictionary<string, Dictionary<string, string>>();
            WorksheetDataTable = new Dictionary<string, DataTable>();
        }

    }

    /// <summary>
@@ -70,6 +77,7 @@
        /// <returns></returns>
        public static byte[] ExportExcel(ExcelExportSet excelExportDto, bool showSrNo = false)
        {
            //ExcelPackage.LicenseContext = LicenseContext.Commercial; 5.0以上版本 需要授权
            byte[] result = null;
            using (ExcelPackage package = new ExcelPackage())
            {
@@ -132,8 +140,8 @@
                        workSheet.InsertRow(1, 1);
                        workSheet.Column(1).Width = 5;
                    }
                    result = package.GetAsByteArray();
                }
                result = package.GetAsByteArray();
            }
            return result;
        }