NibaaaExcelEx.Core
1.1.4
dotnet add package NibaaaExcelEx.Core --version 1.1.4
NuGet\Install-Package NibaaaExcelEx.Core -Version 1.1.4
<PackageReference Include="NibaaaExcelEx.Core" Version="1.1.4" />
<PackageVersion Include="NibaaaExcelEx.Core" Version="1.1.4" />
<PackageReference Include="NibaaaExcelEx.Core" />
paket add NibaaaExcelEx.Core --version 1.1.4
#r "nuget: NibaaaExcelEx.Core, 1.1.4"
#:package NibaaaExcelEx.Core@1.1.4
#addin nuget:?package=NibaaaExcelEx.Core&version=1.1.4
#tool nuget:?package=NibaaaExcelEx.Core&version=1.1.4
ver 1.1.X 导出函数名已经更变为ExportToExcel,与ver1.0.0不兼容
//导入excel List<ImportBaseField> Importfields=[ new ImportBaseField(){Title = "姓名", FieldName = "RealName", IsEquals = true, IsRequired = true,MinLenght=2}, new ImportBaseField(){Title = "性别", FieldName = "Sex", IsEquals = false, IsRequired = true, ValueRange=sexList }, new ImportBaseField(){Title = "身份证号", FieldName = "IdCardNo", IsEquals = false} new ImportBaseField(){Title = "联系电话|联系方式", FieldName = "Phone", IsEquals = false, IsRequired = false} ];
string filePath="导入excel文件路径"
var excel = new ExcelEx(filePath);
List<PersonDto> importList = excel.ExcelToList<PersonDto>(Importfields)
//导出excel
List<FieldInfo> fields = [ new FieldInfo(){Title = "序号", FieldName = "ROWNO", Size = 3, Check = true}, new FieldInfo(){Title = "姓名", FieldName = "RealName", Size = 5, Check = true}, new FieldInfo(){Title = "性别", FieldName = "Sex", Size = 5, Check = true}, new FieldInfo(){Title = "身份证号", FieldName = "IdCardNo", Size = 5 , Check = true}, new FieldInfo(){Title = "联系电话|联系方式", FieldName = "Phone", Size = 5 , Check = true} new FieldInfo(){Title = "班级", FieldName = "ClassInfo.Name", Check = true} ]; List<PersonDto> list= (略) //名单列表; ExcelEx excel1 = new("名单", null); excel1.ExportToExcel(list, 0, fields1, null); excel1.Save();
| Product | Versions Compatible and additional computed target framework versions. |
|---|---|
| .NET | net8.0 is compatible. net8.0-android was computed. net8.0-browser was computed. net8.0-ios was computed. net8.0-maccatalyst was computed. net8.0-macos was computed. net8.0-tvos was computed. net8.0-windows was computed. net9.0 was computed. net9.0-android was computed. net9.0-browser was computed. net9.0-ios was computed. net9.0-maccatalyst was computed. net9.0-macos was computed. net9.0-tvos was computed. net9.0-windows was computed. net10.0 was computed. net10.0-android was computed. net10.0-browser was computed. net10.0-ios was computed. net10.0-maccatalyst was computed. net10.0-macos was computed. net10.0-tvos was computed. net10.0-windows was computed. |
-
net8.0
- NPOI (>= 2.7.5)
- System.Text.RegularExpressions (>= 4.3.1)
NuGet packages
This package is not used by any NuGet packages.
GitHub repositories
This package is not used by any popular GitHub repositories.