java导出word

王大锤4391

已于 2024-02-27 15:35:14 修改

阅读量244

点赞数 1

分类专栏： java 文章标签： java word c#

于 2023-08-30 09:14:42 首次发布

本文链接：https://blog.csdn.net/weixin_41037490/article/details/132575312

版权

java 专栏收录该内容

12 篇文章 0 订阅

订阅专栏

1.使用easyWord

2.模版 .doc文件

3.maven依赖

<dependency>
    <groupId>com.sushengren</groupId>
    <artifactId>easyword</artifactId>
    <version>1.1.3</version>
</dependency>

package com.test.domain.word;


import com.sushengren.easyword.annotation.WordProperty;
import jdk.nashorn.internal.objects.annotations.Getter;
import lombok.AllArgsConstructor;
import lombok.Builder;
import lombok.Data;
import lombok.NoArgsConstructor;

/***
 * 导出word
 */
@Data
@Builder
@NoArgsConstructor
@AllArgsConstructor
public class Wxdj {

    @WordProperty("wxdjcode")
    private String wxdjcode;

    @WordProperty("deptName")
    private String deptName;

    @WordProperty("policeName")
    private String policeName;

    @WordProperty("ctAjmc")
    private String ctAjmc;

    @WordProperty("policePhone")
    private String policePhone;

    @WordProperty("createdate")
    private String createdate;

}

@ExcelIgnore   隐藏不展示实体类的字段

5.给模版赋值

/***8
     * 下载通知书 模版信息
     * @param ctId
     */
    @Override
    public void downloadNotice(String ctId, HttpServletRequest request, HttpServletResponse response) throws IOException {
        String path = this.getClass().getResource("/").getPath();
        String rootPath = path.substring(1, path.length());
        //TODO 后续将模版文件写在  sys_config 表中
        String filePath = rootPath.replace("ruoyi-admin/target/classes/", "business/src/main/resources/stencil/wxdj.doc");
        File file = new File(filePath);

        DateFormat df = new SimpleDateFormat("yyyy-MM-dd HH:mm:ss");
        TbNbgzWxdj nbgzWxdj = tbNbgzWxdjMapper.selectTbNbgzWxdjByCtId(ctId);
        //外协单位-组织信息
        TbNbgzWxdjdata dept = new TbNbgzWxdjdata();
        dept.setCtIdP(ctId);
        dept.setCtFunNo(FunNoConstants.NBGZ_WXDJWXDW_DEPT);
        dept.setCtFunNop(FunNoConstants.NBGZ_WXDJ);
        List<TbNbgzWxdjdata> deptList = tbNbgzWxdjwdataMapper.selectTbNbgzWxdjwdataList(dept);
        List<String> deptNames = deptList.stream().map(TbNbgzWxdjdata::getCtDeptName).collect(Collectors.toList());
        String deptName = String.join(",", deptNames);


        //外协单位人员名称信息
        List<TbNbgzWxdjdata> newPoliceList = new ArrayList<>();
        for (int i = 0; i < deptList.size(); i++) {
            TbNbgzWxdjdata tbNbgzWxdjdata = deptList.get(i);
            //外协单位-人员信息
            TbNbgzWxdjdata police = new TbNbgzWxdjdata();
            police.setCtFunNop(FunNoConstants.NBGZ_WXDJ);
            police.setCtFunNo(FunNoConstants.NBGZ_WXDJWXDW_POLICE);
            police.setCtIdP(deptList.get(i).getCtId());
            List<TbNbgzWxdjdata> policeList = tbNbgzWxdjwdataMapper.selectTbNbgzWxdjwdataList(police);
            if (policeList.size() > 0) {
                tbNbgzWxdjdata.setWxdwPoliceList(policeList);
            }
            newPoliceList.add(tbNbgzWxdjdata);
        }
        nbgzWxdj.setWxdwList(newPoliceList);

        List<TbNbgzWxdjdata> wxdwPoliceList = newPoliceList.get(0).getWxdwPoliceList();
        List<String> policeLists = wxdwPoliceList.stream().map(TbNbgzWxdjdata::getCtQqmjName).collect(Collectors.toList());

        String policeName = String.join(",", policeLists);
        //外协单位人员电话信息
        List<String> policePhoneLists = newPoliceList.stream().map(TbNbgzWxdjdata::getCtQqmjPhone).collect(Collectors.toList());
        String policePhone = String.join(",", policePhoneLists);


        for (int i = 0; i < deptList.size(); i++) {
            TbNbgzWxdjdata tbNbgzWxdjdata = deptList.get(i);
            //外协单位-人员信息
            TbNbgzWxdjdata police = new TbNbgzWxdjdata();
            police.setCtFunNop(FunNoConstants.NBGZ_WXDJ);
            police.setCtFunNo(FunNoConstants.NBGZ_WXDJWXDW_POLICE);
            police.setCtIdP(deptList.get(i).getCtId());
            List<TbNbgzWxdjdata> policeList = tbNbgzWxdjwdataMapper.selectTbNbgzWxdjwdataList(police);
            if (policeList.size() > 0) {
                tbNbgzWxdjdata.setWxdwPoliceList(policeList);
                newPoliceList.addAll(policeList);
            }
        }

        Wxdj wxdj = Wxdj.builder()
                .wxdjcode(ctId)
                .deptName(deptName)
                .policeName(policeName)
                .ctAjmc(nbgzWxdj.getCtAjmc())
                .policePhone(policePhone)
                .createdate(df.format(nbgzWxdj.getDtCreateDate()))
                .build();

        EasyWord.of(file).doWrite(wxdj).toOutputStream(response.getOutputStream());

    }