Info
| Version: | 2.0.13 |
| Author(s): | Labbor |
| Last Update: | Wednesday, February 16, 2022 |
| .NET Fiddle: | Create the first Fiddle |
| Project Url: | https://github.com/shaiyu/NPOIHelper |
| NuGet Url: | https://www.nuget.org/packages/NPOIHelper |
Install
Install-Package NPOIHelper
dotnet add package NPOIHelper
paket add NPOIHelper
NPOIHelper Download (Unzip the "nupkg" after downloading)
Dependencies
.NETFramework 4.5
- Microsoft.CSharp(>= 4.7.0)
- NPOI(>= 2.5.1)
- Microsoft.CSharp(>= 4.7.0)
- NPOI(>= 2.5.1)
var helper = NPOIHelperBuild.GetHelper();
helper.Add("sheet1", data);
return File(helper.ToArray(), helper.ContentType, helper.FullName);
快速读取Excel
//读取到List
NPOIHelperBuild.ReadExcel<ImportUser>("TestImportExcel/test1.xlsx");
//读取到DataTable
NPOIHelperBuild.ReadExcel("TestImportExcel/test1.xlsx");.