更新歷史
2019.02.13
【Nuget】版本更新到2.0.2
【導(dǎo)入】修復(fù)單列導(dǎo)入的Bug，單元測試“OneColumnImporter_Test”。問題見（https://github.com/dotnetcore/Magicodes.IE/issues/35）。
【導(dǎo)出】修復(fù)導(dǎo)出HTML、Pdf、Word時(shí)，模板在某些情況下編譯報(bào)錯(cuò)的問題。
【導(dǎo)入】重寫空行檢查。
2019.02.14
【Nuget】版本更新到2.1.0
【導(dǎo)出】PDF導(dǎo)出支持.NET 4.6.1，具體見單元測試

說明

本章主要說明使用Magicodes.IE，在Docker環(huán)境中的配置.

要點(diǎn)

• 通過Dto進(jìn)行Excel導(dǎo)出

• 導(dǎo)出PDF數(shù)據(jù)

• Docker配置

示例

導(dǎo)出示例：

Install-Package Magicodes.IE.Excel Install-Package Magicodes.IE.Pdf

• 導(dǎo)出Excel

[ExcelExporter(Name = "學(xué)生信息", TableStyle = "Light10", AutoFitAllColumn = true,MaxRowNumberOnASheet = 2)]public class StudentExcel{/// <summary>/// 姓名/// </summary>[ExporterHeader(DisplayName = "姓名")]public string Name { get; set; }/// <summary>/// 年齡/// </summary>[ExporterHeader(DisplayName = "年齡")]public int Age { get; set; }/// <summary>/// 備注/// </summary>public string Remarks { get; set; }/// <summary>/// 出生日期/// </summary>[ExporterHeader(DisplayName = "出生日期", Format = "yyyy-mm-DD")]public DateTime Birthday { get; set; }} public async Task<IActionResult> ExporterExcel() {IExporter exporter = new ExcelExporter();var result = await exporter.Export(Path.Combine("wwwroot","test.xlsx"), new List<StudentExcel>(){new StudentExcel{Name = "MR.A",Age = 18,Remarks = "我叫MR.A,今年18歲",Birthday=DateTime.Now},new StudentExcel{Name = "MR.B",Age = 19,Remarks = "我叫MR.B,今年19歲",Birthday=DateTime.Now},new StudentExcel{Name = "MR.C",Age = 20,Remarks = "我叫MR.C,今年20歲",Birthday=DateTime.Now}});return File("test.xlsx", "application/ms-excel", result.FileName);}

• 導(dǎo)出PDF

[PdfExporter(Name = "學(xué)生信息")]public class StudentPdf{/// <summary>/// 姓名/// </summary>[ExporterHeader(DisplayName = "姓名")]public string Name { get; set; }/// <summary>/// 年齡/// </summary>[ExporterHeader(DisplayName = "年齡")]public int Age { get; set; }/// <summary>/// 備注/// </summary>public string Remarks { get; set; }/// <summary>/// 出生日期/// </summary>[ExporterHeader(DisplayName = "出生日期", Format = "yyyy-mm-DD")]public DateTime Birthday { get; set; }}public async Task<IActionResult> ExporterPdf() {var exporter = new PdfExporter();var result = await exporter.ExportListByTemplate(Path.Combine("wwwroot", "test.pdf"), new List<StudentPdf>(){new StudentPdf{Name = "MR.A",Age = 18,Remarks = "我叫MR.A,今年18歲",Birthday=DateTime.Now},new StudentPdf{Name = "MR.B",Age = 19,Remarks = "我叫MR.B,今年19歲",Birthday=DateTime.Now},new StudentPdf{Name = "MR.C",Age = 20,Remarks = "我叫MR.C,今年20歲",Birthday=DateTime.Now}});return File("test.pdf", "application/pdf", result.FileName);}

通過上述代碼我們創(chuàng)建了一個(gè)導(dǎo)出示例，
具體特性屬性可以看一下前兩篇文章?基礎(chǔ)教程之導(dǎo)出Excel?、基礎(chǔ)教程之導(dǎo)出Pdf收據(jù)

Dockerfile配置

FROM ccr.ccs.tencentyun.com/magicodes/aspnetcore-runtime:latest AS base # 安裝libgdiplus庫，用于Excel導(dǎo)出 #RUN apt-get update && apt-get install -y libgdiplus libc6-dev #RUN ln -s /usr/lib/libgdiplus.so /usr/lib/gdiplus.dll#RUN apt-get update && apt-get install -y fontconfig WORKDIR /src RUN ls COPY /src/Magicodes.IE.Exporter/simsun.ttc /usr/share/fonts/simsun.ttcWORKDIR /app EXPOSE 80 EXPOSE 443FROM mcr.microsoft.com/dotnet/core/sdk:latest AS build WORKDIR /src COPY ["Magicodes.IE.Exporter.csproj", "src/Magicodes.IE.Exporter/"] RUN dotnet restore "src/Magicodes.IE.Exporter/Magicodes.IE.Exporter.csproj" COPY . . WORKDIR "src/Magicodes.IE.Exporter" RUN dotnet build "Magicodes.IE.Exporter.csproj" -c Release -o /app/buildFROM build AS publish RUN dotnet publish "Magicodes.IE.Exporter.csproj" -c Release -o /app/publishFROM base AS final WORKDIR /app COPY --from= publish /app/publish . ENTRYPOINT ["dotnet", "Magicodes.IE.Exporter.dll"]# 安裝libgdiplus庫，用于Excel導(dǎo)出 RUN apt-get update && apt-get install -y libgdiplus libc6-dev RUN ln -s /usr/lib/libgdiplus.so /usr/lib/gdiplus.dll# 安裝fontconfig庫，用于Pdf導(dǎo)出 RUN apt-get update && apt-get install -y fontconfig COPY /simsun.ttc /usr/share/fonts/simsun.ttc

注意，以上基礎(chǔ)鏡像使用：(ccr.ccs.tencentyun.com/magicodes/aspnetcore-runtime:latest) ,該鏡像GitHub地址：(https://github.com/xin-lai/aspnetcore-docker)。

推薦理由：

• 加快鏡像構(gòu)建和拉取速度，加速CI\CD構(gòu)建以及提高開發(fā)體驗(yàn)

• 時(shí)區(qū)默認(rèn)設(shè)置為東八區(qū)，見“ENV TZ=Asia/Shanghai”

• 默認(rèn)安裝了libgdiplus等庫，以便支持Excel導(dǎo)入導(dǎo)出

• 目前提供了騰訊云的公共鏡像和hub.docker的公共鏡像，大家可以按需

Reference

https://github.com/dotnetcore/Magicodes.IE

https://github.com/hueifeng/BlogSample/tree/master/src/Magicodes.IE.Exporter

總結(jié)

以上是生活随笔為你收集整理的ASP.NET 开源导入导出库Magicodes.IE Docker中使用的全部內(nèi)容，希望文章能夠幫你解決所遇到的問題。

如果覺得生活随笔網(wǎng)站內(nèi)容還不錯(cuò)，歡迎將生活随笔推薦給好友。