ExcelKit 1.0.20
dotnet add package ExcelKit --version 1.0.20
NuGet\Install-Package ExcelKit -Version 1.0.20
<PackageReference Include="ExcelKit" Version="1.0.20" />
paket add ExcelKit --version 1.0.20
#r "nuget: ExcelKit, 1.0.20"
// Install ExcelKit as a Cake Addin #addin nuget:?package=ExcelKit&version=1.0.20 // Install ExcelKit as a Cake Tool #tool nuget:?package=ExcelKit&version=1.0.20
Excel百万级(几百万亦可)数据导出与读取(仅针对xlsx文件)
excel million level data export and read (only for xlsx files)
1.极低的内存占用,方便易用的方法,让Excel导出和读取更简单
2.支持.Net Core,Docker,Win下皆可使用
3.单文件多Sheet导出,多Sheet可导出几百万数据
5.导出数据超过单Sheet最大量时,多余数据会自动拆分新的Sheet,新Sheet继续沿用之前的样式
6.可定义类读取和导出,亦可使用字典动态读取和导出
7.字段可为基础类型,枚举,对象(对象需自己实现Converter)等
8.可指定列的填充色,字体颜色,列宽,列顺序,筛选,表头冻结等
9.项目开源地址为:https://github.com/AdvanceOpen/ExcelKit.git
10.更多功能与使用方式,请点击下方链接查看示例ExcelKit.Sample
changes
1.优化Converter定义,使用更自由;调整内置BoolConverter,使用更方便
2.增加方便易用的LiteDataHelper类,适合数据量不大的时候使用
3.IsIgore全部忽略,增加IsOnlyIgnoreRead IsOnlyIgnoreWrite
4.优化调整;去掉LiteDataHelper导出文件名多了后缀的问题
5.解决EnumConverter存在的Bug;优化Converter内部调用;增加注释
6.LiteDataHelper增加安全的Sheet名称获取和检测
7.LiteDataHelper中增加读取单行数据
8.调整追加的数据行数为内部实现,不再采用组件的PhysicalNumberOfRows
Product | Versions Compatible and additional computed target framework versions. |
---|---|
.NET | net5.0 was computed. net5.0-windows was computed. net6.0 was computed. net6.0-android was computed. net6.0-ios was computed. net6.0-maccatalyst was computed. net6.0-macos was computed. net6.0-tvos was computed. net6.0-windows was computed. net7.0 was computed. net7.0-android was computed. net7.0-ios was computed. net7.0-maccatalyst was computed. net7.0-macos was computed. net7.0-tvos was computed. net7.0-windows was computed. net8.0 was computed. 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. |
.NET Core | netcoreapp3.0 was computed. netcoreapp3.1 was computed. |
.NET Standard | netstandard2.1 is compatible. |
MonoAndroid | monoandroid was computed. |
MonoMac | monomac was computed. |
MonoTouch | monotouch was computed. |
Tizen | tizen60 was computed. |
Xamarin.iOS | xamarinios was computed. |
Xamarin.Mac | xamarinmac was computed. |
Xamarin.TVOS | xamarintvos was computed. |
Xamarin.WatchOS | xamarinwatchos was computed. |
-
.NETStandard 2.1
- DocumentFormat.OpenXml (>= 2.10.1)
- NPOI (>= 2.5.6)
NuGet packages
This package is not used by any NuGet packages.
GitHub repositories
This package is not used by any popular GitHub repositories.
Excel百万级数据导出&读取(仅针对xlsx文件)