Easypoi word模板批量导出

「爱情、让人受尽委屈。」 2022-05-16 13:22 711阅读 0赞

版本介绍：

spring boot1.5.6

mysql

easypoi 3.2.0

1、需求：

用户在勾选“全选”的时候，点击批量导出时，会根据勾选的单位名称依次导出在一张表中。

![3375][]

![3390][]

2、根据样式制作一个模板

![3399][]

![3403][]

3、想要使用easypoi框架做excel/word 要导出以下依赖

![3422][]

4、如果要导出excel的话，就在实体上面添加@Excel注解（name="xxx",heigth="20"）,里面还可以 添加excel的各个样式（详情可以去看easypoi API自定义）。word的话，是不需要添加注解的！

![3415][]

5、Controller层的结构：

![3448][]

Controller（service）

![3426][]

controller：

@RestController

@RequestMapping("/wordController")

@SuppressWarnings("all")

public class PropertyCostBillWordController \{

@Autowired

private PropertyCostBillExcelService propertyCostBillExcelService;

@Autowired

private AirSecondaryOrderService airSecondaryOrderService;

@RequestMapping("/getPropertyCostBillWord")

public String getPropertyCostBillWord(HttpServletRequest request, HttpServletResponse response) \{

//1，通过id list 获取 实体对象列表

BCSLoginInfo loginInfo = BCSContext.getLoginInfo();

if (loginInfo == null) \{

System.out.println("loginInfo is null");

return null;

String prcbIds = null;

if (!StringUtils.isEmpty(request.getParameter("prcbIds"))) \{

prcbIds = request.getParameter("prcbIds");

//文件下载请求头、字节码、类型

response.setHeader("content-type", "application/octet-stream");

response.setContentType("application/octet-stream");

response.setCharacterEncoding("UTF-8");

//总表map

List<PropertyCostBill> propertyCostBillList = propertyCostBillExcelService.getPropertyCostBillList(prcbIds);

List<XWPFDocument> xwpfDocuments = new ArrayList<>();

try \{

for (PropertyCostBill propertyCostBill : propertyCostBillList) \{

DecimalFormat df = new DecimalFormat("\#0.00");

double totalMoney = 0.00;

if (propertyCostBill != null) \{

totalMoney = propertyCostBill.getDueAmount().doubleValue();

String totalMoneyCapital = CapitalUtil.moneyToChinese(totalMoney);

Map<String, Object> map = new HashMap<>();

map.put("customerName", propertyCostBill.getCustomerNameStr());

map.put("dueAmount", propertyCostBill.getDueAmountStr());

map.put("unitPrice", propertyCostBill.getUnitPrice());

map.put("totalArea", propertyCostBill.getTotalArea());

map.put("type", propertyCostBill.getTypeStr());

map.put("billBucket", propertyCostBill.getBillBucket());

map.put("totalMoney", df.format(totalMoney));

map.put("totalMoneyCapital", totalMoneyCapital);

//从resources中导出word模板

XWPFDocument doc = WordExportUtil.exportWord07("word/property.docx", map);

xwpfDocuments.add(doc);

if (xwpfDocuments.size()>0) \{

XWPFDocument xwpfDocument = xwpfDocuments.get(0);

for (int i = 0; i < xwpfDocuments.size(); i++) \{

//每次的追加为了避免样式和格式混乱 加上分页符

//当是只有一条数据的时候 直接输出

if (i == 0) \{

xwpfDocument = xwpfDocuments.get(0);

continue;

\} else \{

//当存在多条时候

xwpfDocument = mergeWord(xwpfDocument, xwpfDocuments.get(i));

String name = "物管费缴费详情.docx";

// 指定下载的文件名

response.setHeader("Content-Disposition", "attachment;filename=" + new String(name.getBytes("utf-8"), "ISO8859-1"));

ServletOutputStream outputStream = response.getOutputStream();

xwpfDocument.write(outputStream);

outputStream.close();

\} catch (UnsupportedEncodingException e) \{

e.printStackTrace();

\} catch (Exception e) \{

e.printStackTrace();

return CAjaxResult.toJson(200, null, null);

//word模板，两个对象进行追加

public XWPFDocument mergeWord(XWPFDocument document, XWPFDocument doucDocument2) throws Exception \{

XWPFDocument src1Document = document;

XWPFParagraph p = src1Document.createParagraph();

//设置分页符

p.setPageBreak(true);

CTBody src1Body = src1Document.getDocument().getBody();

XWPFDocument src2Document = doucDocument2;

CTBody src2Body = src2Document.getDocument().getBody();

XWPFParagraph p2 = src2Document.createParagraph();

XmlOptions optionsOuter = new XmlOptions();

optionsOuter.setSaveOuter();

String appendString = src2Body.xmlText(optionsOuter);

String srcString = src1Body.xmlText();

String prefix = srcString.substring(0, srcString.indexOf(">") + 1);

String mainPart = srcString.substring(srcString.indexOf(">") + 1, srcString.lastIndexOf("<"));

String sufix = srcString.substring(srcString.lastIndexOf("<"));

String addPart = appendString.substring(appendString.indexOf(">") + 1, appendString.lastIndexOf("<"));

CTBody makeBody = CTBody.Factory.parse(prefix + mainPart + addPart + sufix);

src1Body.set(makeBody);

return src1Document;

6、Service层的结构：

![3452][]

6-1、Service（controller）

通过Controller层的service方法中的call，来调用service层的方法

HttpResponse resp = ServAPIUtil.call("billExcel","GetPropertyCostBillExcelList", params);

通过注解@CAPI写service层的业务逻辑：

根据 如：通过String prcbIds="a4796bb7-9530a,a4796bb7-9530a,a4796bb7-9530a"多个prcbIds查询mybatis的要返回的值。

![3460][]

6-2、Service（service）

![3480][]

6-3、ServiceImpl

![3483][]

6-4、通过mapper来接口，到Dao层查询所需字段

![3490][]

6-5、resources-Mapper

![3495][]

6-6、mapper的sql语句查询

![3498][]

![3501][]

后端基本可以了，但是还是有些问题

前端：

添加批量导出、全选的按钮。第三个红色长方形里面是用vue绑定的id、value、v-model

![3505][]

圈中表示：prcbIds为一个数组

![3514][]

通过ajax文件下载给后台拿到prcbIds数据。

如：String prcbIds="a4796bb7-9530a,a4796bb7-9530a,a4796bb7-9530a"

![3518][]

复选框的设置：

![3526][]

[3375]: /images/20220516/fe3efe30e3354069a7bbdac025ed549c.png
[3390]: /images/20220516/c7258ba6d6994f8f99aa35fa2b5af76c.png
[3399]: /images/20220516/61696245ed4649da816701cf5b8c16e5.png
[3403]: /images/20220516/fb13e9591ec84ac092859850a22c7283.png
[3422]: /images/20220516/b2ca93aa27d14649ac6148b042b38e27.png
[3415]: /images/20220516/1ff678cc908e4a6e89e86c899c796794.png
[3448]: /images/20220516/ef1d6a07041346f2ac32be7e9eb62d45.png
[3426]: /images/20220516/355e8253ad4144c09d513d8ce6d58fcc.png
[3452]: /images/20220516/94ce9116ce104ab99448bcd3b6dd176d.png
[3460]: /images/20220516/0d7983666a924662b10aaacbeac39544.png
[3480]: /images/20220516/4c7aca5216f54c8a8147ee0bbc88537a.png
[3483]: /images/20220516/7506f76ab5454c779c682dbc32090707.png
[3490]: /images/20220516/cb7184229d094510a4bcf076476e9db2.png
[3495]: /images/20220516/de8f8eaa02d04503b2153d3461e477a9.png
[3498]: /images/20220516/7c4e003c9af14e7bbb7b6750011ee35f.png
[3501]: /images/20220516/8bcf5a3f126049489c6c591e74921c3c.png
[3505]: /images/20220516/a76a3d61f48040128c45388e89c381f5.png
[3514]: /images/20220516/19db9bf9ca5e4596acae4978c8d58fe4.png
[3518]: /images/20220516/0d620ce5e0104ad1849da08d7a2d299d.png
[3526]: /images/20220516/0091c65ad38f4d5896018dfb5cf38cdb.png