.NET Core NPOI导出Word,浏览器下载

小颜学开发

于 2024-05-29 16:09:02 发布

阅读量543

点赞数 1

分类专栏： MVC学习笔记文章标签： .netcore word javascript

本文链接：https://blog.csdn.net/aa2012123456/article/details/139298292

版权

后台

 public MemoryStream GetLavPrintMS(InvPrintDTO dto)
        {
            using var ms = new MemoryStream();
            string sqlStr = @"";
            var table = GetDataTable(sqlStr);
            var list = DataTableHelper.DataTableToList<DTO>(table);
            var doc = CreateWordData(list);
            doc.Write(ms);
            byte[] buffer = ms.ToArray();
            return new MemoryStream(buffer);
        }

 private XWPFDocument CreateWordData(List<DTO> list)
        {
            var doc = new XWPFDocument();
            foreach (var item in list)
            {
                var row = doc.CreateParagraph().CreateRun();
                row.SetText(item.BatchNo);
                row.IsBold = true;
                row.FontSize = 12;

                //创建table
                var table = doc.CreateTable(3, 2);