Info
Version: | 1.0.9 |
Author(s): | HJMinimally.Office |
Last Update: | Wednesday, May 4, 2022 |
.NET Fiddle: | Create the first Fiddle |
NuGet Url: | https://www.nuget.org/packages/HJMinimally.Office |
Install
Install-Package HJMinimally.Office
dotnet add package HJMinimally.Office
paket add HJMinimally.Office
HJMinimally.Office Download (Unzip the "nupkg" after downloading)
Dependencies
- DotNetCore.NPOI(>= 1.2.2)
重新引用DotNetCore.NPOI组件
1.0.9
修改导入excel时,传入rowIndex报错的问题
1.0.5
ExcelImport(Stream fileStream, string strFileName)
增加导入excel时,直接读取数据流,不需要在服务端保存文件到本地;
1.0.6
ExcelImport(Stream fileStream, string strFileName, int rowIndex)
增加导入excel是,直接读取数据流,可以表头为第几行;
1.0.7
增加导出excel方法。
/// <summary>
/// DataTable导出到Excel的MemoryStream Export()
/// </summary>
/// <param name="data">key:数据存放的Sheet;value:数据</param>
/// <param name="excelConfig">导出设置包含文件名、标题、列设置</param>
/// <param name="maxSheet">最大sheet数</param>
MemoryStream ExportMemoryStream(List<ExportMemoryStreamMode> data, ExcelConfig excelConfig, int maxSheet = 10)
1.0.8
优化导出excel接口。
MemoryStream ExportMemoryStream(List<ExportMemoryStreamMode> data, ExcelConfig excelConfig, int maxSheet = 10).