/**
* 查询 Word 报表
*
* @param
* @return
*/
@RequestMapping(value = "/wordQuery")
public BaseResponse wordQuery() throws Exception {
//报表地址
String modelDir = ExcelDir + "gwydjb.doc";
//输出地址
String importDir = ImportDir + "gwydjb.doc";
//结果集
List<Map<String, Object>> mapData =
reportMapper.selectGwydjbData();
Map<String, Object> map = mapData.get(0);
Document doc = new Document(modelDir);
DocumentBuilder builder = new DocumentBuilder(doc);
//doc 文档添加域名
//1.插入--文档部件--域
//2.域名:邮件合并
//3.域代码:MERGEFIELD "A0101"
//人员姓名
builder.moveToMergeField("A0101");
builder.write(map.get("a0101").toString());
Table table = (Table) doc.getChild(NodeType.TABLE, 0, true); //第
1 个表格
//定义合并的开始列
Cell cellStart = null;
//定义合并的结束列
Cell cellEnd = null;
//全日制学历学位
if(!map.get("a6170").toString().equals("") &&
map.get("a6171").toString().equals("")){
builder.moveToMergeField("A6171");
builder.moveToMergeField("A6170");
builder.getCellFormat().setVerticalMerge(CellMerge.FIRST);
builder.getParagraphFormat().setAlignment(ParagraphAlignment.LEFT);//
水平居左
builder.getCellFormat().setVerticalMerge(CellMerge.PREVIOUS);
评论0
最新资源