java Aspose.Words实现Word生成表格并下载至本地

我就是我 2023-10-07 03:57 40阅读 0赞

### 一、Maven加入Aspose.Words依赖 ###

<dependency>
        <groupId>com.aspose</groupId>
        <artifactId>aspose-words</artifactId>
        <version>20.2</version>
    </dependency>

### 二、后台生成表格并传输到本地 ###

1、前台编写js，使其可以跳转至Controller

location.href="/wordExport/exportScoreList?username=sa&readFlag=1"

2、创建Controller类和处理方法

@RequestMapping("/wordExport")
    @RestController
    public class WordExportController{
        @Autowired
        private TestRecordService testRecordService;
        
        @GetMapping("/exportScoreList")
        public void exportScoreList(HttpServletResponse response,String username,
                                    String testType,String testName,String readFlag){
            username=username==null?"":username;
            testType=testType==null?"":testType;
            testName=testName==null?"":testName;
            readFlag=readFlag==null?"":readFlag;
    
            List<TestRecordExt> testRecordExtList=testRecordService.getTestRecordExtList("",username,readFlag,testName,testType);
            try {
                String fileName="考试成绩单"+ DateUtil.getCurrentTimeByDay()+".doc";
                response.setHeader("content-type", "application/octet-stream");
                response.setContentType("application/octet-stream;charset=UTF-8");
                response.setHeader("Content-Disposition", "attachment; filename=" + new String(fileName.getBytes("utf-8"),"ISO-8859-1"));
                OutputStream outputStream=response.getOutputStream();
                Document document=new Document();
                DocumentBuilder builder = new DocumentBuilder(document);
                //单元格水平居中对齐
                builder.getCellFormat().setVerticalAlignment(CellVerticalAlignment.CENTER);
                //段落居中对齐
                builder.getParagraphFormat().setAlignment(ParagraphAlignment.CENTER);
                builder.writeln("考试成绩单");
                //段落左对齐
                builder.getParagraphFormat().setAlignment(ParagraphAlignment.LEFT);
                String pickname="";
                if(testRecordExtList!=null&&testRecordExtList.size()>0){
                    pickname=testRecordExtList.get(0).getPickname();
                }
                builder.writeln("姓名："+pickname);
                builder.startTable();
                //表头
                builder.insertCell();
                builder.write("序号");
                builder.insertCell();
                builder.write("考试");
                builder.insertCell();
                builder.write("考试时长");
                builder.insertCell();
                builder.write("成绩");
                builder.insertCell();
                builder.write("排名");
                builder.insertCell();
                builder.write("考试类型");
                builder.endRow();
                //表格内容
                for(int i=0;i<testRecordExtList.size();i++){
                    TestRecordExt testRecordExt=testRecordExtList.get(i);
                    builder.insertCell();
                    builder.write((i+1)+"");
                    builder.insertCell();
                    builder.write(testRecordExt.getTestName());
                    builder.insertCell();
                    int testRecordLength=testRecordExt.getTestRecordLength();
                    String testLengthStr="";
                    int testHour=testRecordLength/3600;
                    if(testHour>0){
                        testLengthStr+=testHour+" 小时";
                    }
                    int testMinutes=testRecordLength%3600/60;
                    if(testMinutes>0){
                        testLengthStr+=testMinutes+" 分钟";
                    }
                    int testSecond=testRecordLength%60;
                    if(testSecond>0){
                        testLengthStr+=testSecond+" 秒";
                    }
                    builder.write(testLengthStr);
                    builder.insertCell();
                    builder.write(testRecordExt.getTestScore()+"分");
                    builder.insertCell();
                    builder.write(testRecordExt.getRankNo()+"");
                    builder.insertCell();
                    builder.write(testRecordExt.getTestTypeName());
                    builder.endRow();
                }
                builder.endTable();
                document.save(outputStream, SaveFormat.DOC);
                outputStream.flush();
                outputStream.close();
            } catch (IOException e) {
                e.printStackTrace();
            }catch (Exception e) {
                e.printStackTrace();
            }
    }

最终效果图

![watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3FxXzM4OTc0NjM4_size_16_color_FFFFFF_t_70][]

### 三、遇到的问题 ###

1、Maven加入aspose.words依赖出现下载不了jar包的情况

解决请参考下面这条博客

[maven不能下载aspose解决方案][maven_aspose]

2、将文件下载到本地时，出现文件名中的中文无法显示

[Java 下载文件，文件名无法显示中文问题解决][Java]

3、Word文档中有水印，而且有三个水印

![20200311191908814.png][]

![watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3FxXzM4OTc0NjM4_size_16_color_FFFFFF_t_70 1][]

![20200311191839785.png][]

4、Maven加上 aspose.words依赖之后，Spring Boot启动需要10分钟。

有哪位仁兄解决了上面这两个问题请务必告诉我

如果大家对使用poi组件实现Word生成表格并下载至本地感兴趣的话，可以去看我的另一篇博客

[java poi实现Word生成表格并下载至本地][java poi_Word]

[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3FxXzM4OTc0NjM4_size_16_color_FFFFFF_t_70]: https://img-blog.csdnimg.cn/20200312184926362.png?x-oss-process=image/watermark,type_ZmFuZ3poZW5naGVpdGk,shadow_10,text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3FxXzM4OTc0NjM4,size_16,color_FFFFFF,t_70
[maven_aspose]: https://blog.csdn.net/qq_38974638/article/details/104752484
[Java]: https://blog.csdn.net/qq_38974638/article/details/104803406
[20200311191908814.png]: https://img-blog.csdnimg.cn/20200311191908814.png
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3FxXzM4OTc0NjM4_size_16_color_FFFFFF_t_70 1]: https://img-blog.csdnimg.cn/20200311191947459.png?x-oss-process=image/watermark,type_ZmFuZ3poZW5naGVpdGk,shadow_10,text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3FxXzM4OTc0NjM4,size_16,color_FFFFFF,t_70
[20200311191839785.png]: https://img-blog.csdnimg.cn/20200311191839785.png
[java poi_Word]: https://blog.csdn.net/qq_38974638/article/details/104826799