From 9aba9bbb5682cae407dfb1e52c80f57494ed38d6 Mon Sep 17 00:00:00 2001
From: wells.liu <wells.liu@broconcentric.com>
Date: 星期一, 13 七月 2020 14:12:57 +0800
Subject: [PATCH] 测试 excel导出
---
src/Bro.M071.DBManager/ExcelExportHelper.cs | 10 +++++++++-
1 files changed, 9 insertions(+), 1 deletions(-)
diff --git a/src/Bro.M071.DBManager/ExcelExportHelper.cs b/src/Bro.M071.DBManager/ExcelExportHelper.cs
index 0ea0c16..17cadb7 100644
--- a/src/Bro.M071.DBManager/ExcelExportHelper.cs
+++ b/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;
}
--
Gitblit v1.8.0