Dust.ExcelMapper
1.0.0
dotnet add package Dust.ExcelMapper --version 1.0.0
NuGet\Install-Package Dust.ExcelMapper -Version 1.0.0
This command is intended to be used within the Package Manager Console in Visual Studio, as it uses the NuGet module's version of Install-Package.
<PackageReference Include="Dust.ExcelMapper" Version="1.0.0" />
For projects that support PackageReference, copy this XML node into the project file to reference the package.
paket add Dust.ExcelMapper --version 1.0.0
The NuGet Team does not provide support for this client. Please contact its maintainers for support.
#r "nuget: Dust.ExcelMapper, 1.0.0"
#r directive can be used in F# Interactive and Polyglot Notebooks. Copy this into the interactive tool or source code of the script to reference the package.
// Install Dust.ExcelMapper as a Cake Addin
#addin nuget:?package=Dust.ExcelMapper&version=1.0.0
// Install Dust.ExcelMapper as a Cake Tool
#tool nuget:?package=Dust.ExcelMapper&version=1.0.0
The NuGet Team does not provide support for this client. Please contact its maintainers for support.
ExcelMapper
Excel 操作封装 导入、导出
例,如下
using ExcelMapper;
using ExcelMapper.Attributes;
// 导出
var stream = await ExportConfig<object>.GenDefaultConfig(new List<object>
{
new
{
Name = "张三",
Sex = 0,
Birthday = DateTime.Now
},
new
{
Name = "李四",
Sex = 1,
Birthday = DateTime.Now
}
})
.Add("名称", "Name", 30)
.Add("性别", "Sex", 40)
.Add("生日", "Birthday", 50)
.Handler("性别", t => ((dynamic)t).Sex == 1 ? "女" : "男")
.Handler("生日", t => ((dynamic)t).Birthday.ToString("yyyy-MM-dd HH:mm:ss"))
.ExportAsync();
await using var sw = File.Create("D:\\monitor\\test.xlsx");
await stream.CopyToAsync(sw);
// 导入
var result = await ReadConfig<Demo>.ExcelToEntityAsync(stream);
public class Demo
{
[Excel(ExcelField = "名称")]
public string Name { get; set; }
[Excel(ExcelField = "性别", ReadConverterExp = "0=男,1=女", Separator = ",")]
public int Sex { get; set; }
[Excel(ExcelField = "生日")]
public DateTime? Birthday { get; set; }
}
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. |
Compatible target framework(s)
Included target framework(s) (in package)
Learn more about Target Frameworks and .NET Standard.
-
.NETStandard 2.1
- AutoMapper (>= 12.0.1)
- EPPlusFree (>= 4.5.3.8)
NuGet packages
This package is not used by any NuGet packages.
GitHub repositories
This package is not used by any popular GitHub repositories.
Version | Downloads | Last updated |
---|---|---|
1.0.0 | 143 | 5/17/2023 |