欢迎您访问程序员文章站本站旨在为大家提供分享程序员计算机编程知识!
您现在的位置是: 首页  >  IT编程

ASP.NET 开源导入导出库Magicodes.IE Docker中使用

程序员文章站 2022-06-11 12:17:12
Magicodes.IE在Docker中使用 更新历史 2019.02.13 【Nuget】版本更新到2.0.2 【导入】修复单列导入的Bug,单元测试“OneColumnImporter_Test”。问题见(https://github.com/dotnetcore/Magicodes.IE/is ......

magicodes.ie在docker中使用

更新历史
2019.02.13
【nuget】版本更新到2.0.2
【导入】修复单列导入的bug,单元测试“onecolumnimporter_test”。问题见(https://github.com/dotnetcore/magicodes.ie/issues/35)。
【导出】修复导出html、pdf、word时,模板在某些情况下编译报错的问题。
【导入】重写空行检查。
2019.02.14
【nuget】版本更新到2.1.0
【导出】pdf导出支持.net 4.6.1,具体见单元测试

说明

本章主要说明使用magicodes.ie,在docker环境中的配置.

要点

  • 通过dto进行excel导出
  • 导出pdf数据
  • docker配置

示例

导出示例:

install-package magicodes.ie.excel
install-package magicodes.ie.pdf
  • 导出excel
    [excelexporter(name = "学生信息", 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);
        }
  • 导出pdf
    [pdfexporter(name = "学生信息")]
    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);
        }

通过上述代码我们创建了一个导出示例,
具体特性属性可以看一下前两篇文章 基础教程之导出excel基础教程之导出pdf收据

dockerfile配置

from ccr.ccs.tencentyun.com/magicodes/aspnetcore-runtime:latest as base
# 安装libgdiplus库,用于excel导出
#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.ttc

workdir /app
expose 80
expose 443

from 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/build

from build as publish
run dotnet publish "magicodes.ie.exporter.csproj" -c release -o /app/publish

from base as final
workdir /app
copy --from= publish /app/publish .
entrypoint ["dotnet", "magicodes.ie.exporter.dll"]
# 安装libgdiplus库,用于excel导出
run apt-get update && apt-get install -y libgdiplus libc6-dev
run ln -s /usr/lib/libgdiplus.so /usr/lib/gdiplus.dll
# 安装fontconfig库,用于pdf导出
run apt-get update && apt-get install -y fontconfig
copy /simsun.ttc /usr/share/fonts/simsun.ttc

注意,以上基础镜像使用:(ccr.ccs.tencentyun.com/magicodes/aspnetcore-runtime:latest) ,该镜像github地址:()。

推荐理由:

  • 加快镜像构建和拉取速度,加速ci\cd构建以及提高开发体验
  • 时区默认设置为东八区,见“env tz=asia/shanghai”
  • 默认安装了libgdiplus等库,以便支持excel导入导出
  • 目前提供了腾讯云的公共镜像和hub.docker的公共镜像,大家可以按需

reference

https://github.com/dotnetcore/magicodes.ie

https://github.com/hueifeng/blogsample/tree/master/src/magicodes.ie.exporter