Link.DtoMapper.ClosedXml
0.0.1-alpha7
dotnet add package Link.DtoMapper.ClosedXml --version 0.0.1-alpha7
NuGet\Install-Package Link.DtoMapper.ClosedXml -Version 0.0.1-alpha7
<PackageReference Include="Link.DtoMapper.ClosedXml" Version="0.0.1-alpha7" />
paket add Link.DtoMapper.ClosedXml --version 0.0.1-alpha7
#r "nuget: Link.DtoMapper.ClosedXml, 0.0.1-alpha7"
// Install Link.DtoMapper.ClosedXml as a Cake Addin #addin nuget:?package=Link.DtoMapper.ClosedXml&version=0.0.1-alpha7&prerelease // Install Link.DtoMapper.ClosedXml as a Cake Tool #tool nuget:?package=Link.DtoMapper.ClosedXml&version=0.0.1-alpha7&prerelease
Link.DtoMapper.ClosedXml
This is a utility based on the ClosedXml package. It has the following main functions:
- Maps Excel column names automatically to the field names of a custom DTO object or the ColumnName defined by ColumnNameAttribute.
- Reads Excel, and automatically imports the content into the specified List<T> of DTOs.
- Creates Excel, and automatically imports the content of the specified List<T> of DTOs into Excel.
NuGet
https://www.nuget.org/packages/Link.DtoMapper.ClosedXml/
γ.NET CLIγ
dotnet add package Link.DtoMapper.ClosedXml
Repository
The git repository is located at: https://github.com/ctliu5/Link.DtoMapper.ClosedXml
Usage
Given the capabilities of this library, you might use it like so:
// Read data from Excel.
List<Excel_DTO> ExcelList2 = ReadXlsx.FailFast.Mapping<Excel_DTO>(ExcelPath, Sheet1Name);
// Export DTO data into ClosedXml Excel type XLWorkbook.
XLWorkbook workbook = new XLWorkbook();
IXLWorksheet worksheet = workbook.AddWorksheet();
WriteXlsx.FailSafe.Mapping(excels, ref worksheet);
string ExportPath = Path.Combine(Environment.GetFolderPath( Environment.SpecialFolder.Desktop), "Excel_Export.xlsx");
workbook.SaveAs(ExportPath);
Disclaimer
This package is for learning and experimentation purposes, and it is not recommended for use in production environments.
License
This project is licensed under the MIT License - see the LICENSE.md file for details.
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 | netcoreapp2.0 was computed. netcoreapp2.1 was computed. netcoreapp2.2 was computed. netcoreapp3.0 was computed. netcoreapp3.1 was computed. |
.NET Standard | netstandard2.0 is compatible. netstandard2.1 was computed. |
.NET Framework | net461 is compatible. net462 is compatible. net463 was computed. net47 is compatible. net471 is compatible. net472 is compatible. net48 is compatible. net481 is compatible. |
MonoAndroid | monoandroid was computed. |
MonoMac | monomac was computed. |
MonoTouch | monotouch was computed. |
Tizen | tizen40 was computed. tizen60 was computed. |
Xamarin.iOS | xamarinios was computed. |
Xamarin.Mac | xamarinmac was computed. |
Xamarin.TVOS | xamarintvos was computed. |
Xamarin.WatchOS | xamarinwatchos was computed. |
-
.NETFramework 4.6.1
- ClosedXML (>= 0.97.0)
-
.NETFramework 4.6.2
- ClosedXML (>= 0.97.0)
-
.NETFramework 4.7
- ClosedXML (>= 0.97.0)
-
.NETFramework 4.7.1
- ClosedXML (>= 0.97.0)
-
.NETFramework 4.7.2
- ClosedXML (>= 0.97.0)
-
.NETFramework 4.8
- ClosedXML (>= 0.97.0)
-
.NETFramework 4.8.1
- ClosedXML (>= 0.97.0)
-
.NETStandard 2.0
- ClosedXML (>= 0.97.0)
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 |
---|---|---|
0.0.1-alpha7 | 163 | 12/7/2023 |
In its initial version, only the preliminary function of reading Excel has been completed so far.