1 @Override
 2 public void buildOutputStream() throws FileProducerException {
 3 // 处理传入的JSON数据
 4 sheets = this.jsonData.getJSONArray(this.SHEETS);
 5 Iterator<Object> sheetIter = sheets.iterator();
 6 if (sheets.isEmpty()) {
 7 this.responseData.setErrcode(1001);
 8 this.responseData.setSuccess(false);
 9 this.responseData.setErrmsg("无数据可生成");
10 throw new FileProducerException();
11 }
12 wb = new XSSFWorkbook();
13 // 建立全局格式
14 JSONArray userStyles = this.jsonData.getJSONArray(this.USERSTYLES);
15 this.initUserStyles(userStyles);
16 this.initDefaultHeadStyle();
17  
18 XSSFSheet ws;
19 JSONObject sheet;
20 JSONArray sheetData;
21 JSONArray sheetTitle;
22 JSONArray sheetHead;
23 JSONArray sheetFoot;
24 JSONArray sheetImgs;
25  
26 String sheetName;
27 int sheetIndex = 0;
28 while (sheetIter.hasNext()) {
29 sheet = (JSONObject) sheetIter.next();
30 // 获取sheet名称
31 sheetName = sheet.getString(this.SHEET_NAME);
32 ws = wb.createSheet();
33 if (StringUtils.isNotBlank(sheetName)) {
34 wb.setSheetName(sheetIndex, sheetName);
35 }
36 int sheetRowIndex = 0;
37 sheetTitle = sheet.getJSONArray(this.SHEET_TITLE);
38 this.setMergeCells(ws, sheet.getJSONArray(this.SHEET_TITLE_MERGE),
39 sheetRowIndex);
40 sheetRowIndex = this.createRandom(ws, sheetTitle, sheetRowIndex);
41  
42 sheetHead = sheet.getJSONArray(this.SHEET_HEAD);
43 sheetRowIndex = this.createHeadColumn(ws, sheetHead, sheetRowIndex);
44  
45 this.setMergeCells(ws, sheet.getJSONArray(this.SHEET_DATA_MERGE),
46 sheetRowIndex);
47 sheetData = sheet.getJSONArray(this.SHEET_DATA);
48 sheetRowIndex = this.createData(ws, sheetData, sheetRowIndex);
49  
50 sheetFoot = sheet.getJSONArray(this.SHEET_FOOT);
51 this.setMergeCells(ws, sheet.getJSONArray(this.SHEET_FOOT_MERGE),
52 sheetRowIndex);
53 sheetRowIndex = this.createRandom(ws, sheetFoot, sheetRowIndex);
54  
55 sheetImgs = sheet.getJSONArray(this.SHEET_IMG);
56  
57 this.setSheetImages(ws, sheetImgs);
58 }
59  
60 // 返回输出流
61 try {
62 ByteArrayOutputStream os = new ByteArrayOutputStream();
63 wb.write(os);
64 this.outStreams.add(os);
65 } catch (IOException e) {
66 throw new FileProducerException(e.getMessage(), e.getCause());
67 }
68 }

  1 private int createHeadColumn(XSSFSheet ws, JSONArray sheetHead,
  2 int sheetRowIndex) {
  3 if (sheetHead == null)
  4 return sheetRowIndex;
  5 Iterator<Object> headIter = sheetHead.iterator();
  6 JSONObject curHead = null;
  7 int colIndex = 0;
  8 Object colStyle = null;
  9 int colSize = sheetHead.size();
 10 headTypes = new String[colSize];
 11 headCellStyleKeys = new String[colSize];
 12 int[] headColLevel = new int[colSize];
 13 String colName = null;
 14 String[] colNameAry = null;
 15 int maxLevel = 0;
 16 int colLevel = 0;
 17 XSSFCell headCell = null;
 18 ArrayList<ArrayList<String>> headValueList = new ArrayList<ArrayList<String>>();
 19 while (headIter.hasNext()) {
 20 curHead = (JSONObject) headIter.next();
 21 // 处理默认样式
 22 if (curHead.containsKey(this.COLUMN_STYLE)) {
 23 colStyle = curHead.get(this.COLUMN_STYLE);
 24 if (colStyle instanceof JSONObject) {
 25 headCellStyleKeys[colIndex] = this.COLUMNSTYLE_PREV
 26 + colIndex;
 27 this.userStyles.put(headCellStyleKeys[colIndex],
 28 this.createCellStyle((JSONObject) colStyle));
 29 } else if (this.userStyles.containsKey(colStyle)) {
 30 headCellStyleKeys[colIndex] = (String) colStyle;
 31 }
 32 }
 33 // 处理默认列宽
 34 if (curHead.containsKey(this.COLUMN_WIDTH)) {
 35 ws.setDefaultColumnWidth(pixToExcelWdith(curHead
 36 .getIntValue(this.COLUMN_WIDTH)));
 37 }
 38 // 保存列样式
 39 if (curHead.containsKey(this.COLUMN_TYPE)) {
 40 headTypes[colIndex] = curHead.getString(this.COLUMN_TYPE);
 41 } else {
 42 headTypes[colIndex] = this.CELLTYPESTRING;
 43 }
 44 // 处理多表头
 45 colName = curHead.getString(this.COLUMN_NAME);
 46 colNameAry = colName.split("\\|");
 47 colLevel = colNameAry.length;
 48 headColLevel[colIndex] = colLevel;
 49 if (colLevel > maxLevel) {
 50 maxLevel = colLevel;
 51 }
 52 for (int i = 0; i < colLevel; i++) {
 53 if (headValueList.size() <= i) {
 54 headValueList.add(new ArrayList<String>());
 55 }
 56 headValueList.get(i).add(colIndex, colNameAry[i]);
 57 XSSFRow row = ws.getRow(sheetRowIndex + i);
 58 if (row == null) {
 59 row = ws.createRow(sheetRowIndex + i);
 60 }
 61 headCell = row.createCell(colIndex);
 62 headCell.setCellValue(colNameAry[i]);
 63 headCell.setCellStyle(this.userStyles.get(this.HEADSTYLE_KEY));
 64 }
 65 colIndex++;
 66 }
 67  
 68 // 横向合并
 69 Iterator<ArrayList<String>> a = headValueList.iterator();
 70 JSONArray headMerge = new JSONArray();
 71 String prev = "";
 72 String curent = null;
 73 int lRowIndex = 0;
 74 int startCol = 0;
 75 int mergeCol = 0;
 76 ArrayList<String> columnInfo = null;
 77 while (a.hasNext()) {
 78 startCol = 0;
 79 mergeCol = 0;
 80 prev = "";
 81 columnInfo = a.next();
 82 // 第三列才能知道，第一列和第二列是否合并
 83 columnInfo.add("");
 84 Iterator<String> b = columnInfo.iterator();
 85 XSSFCell lastRowCell = null;
 86 while (b.hasNext()) {
 87 curent = b.next();
 88 if (lRowIndex > 0) {
 89 lastRowCell = ws.getRow(sheetRowIndex + lRowIndex - 1)
 90 .getCell(startCol);
 91 }
 92 if (prev.equalsIgnoreCase(curent) && lRowIndex == 0) {
 93 ws.getRow(sheetRowIndex + lRowIndex).getCell(startCol)
 94 .setCellType(Cell.CELL_TYPE_BLANK);
 95 mergeCol++;
 96 } else if (prev.equalsIgnoreCase(curent)
 97 && lRowIndex > 0
 98 && StringUtils
 99 .isBlank(lastRowCell.getStringCellValue())) {
100 ws.getRow(sheetRowIndex + lRowIndex).getCell(startCol)
101 .setCellType(Cell.CELL_TYPE_BLANK);
102 mergeCol++;
103 } else {
104 if (mergeCol > 0 && startCol > 0) {
105 headMerge.add(String.format("%d,%d,%d,%d", lRowIndex,
106 lRowIndex, startCol - mergeCol - 1,
107 startCol - 1));
108 mergeCol = 0;
109 }
110 }
111 startCol++;
112 prev = curent;
113 }
114 lRowIndex++;
115 }
116 for (int i = 0; i < colSize; i++) {
117 if (headColLevel[i] < maxLevel) { // 存在列合并
118 headMerge.add(String.format("%d,%d,%d,%d", headColLevel[i] - 1,
119 maxLevel - 1, i, i));
120 for (int r = headColLevel[i]; r < maxLevel; r++) {
121 ws.getRow(sheetRowIndex + r)
122 .createCell(i)
123 .setCellStyle(
124 this.userStyles.get(this.HEADSTYLE_KEY));
125 }
126 }
127 }
128  
129 this.setMergeCells(ws, headMerge, sheetRowIndex);
130 return sheetRowIndex + maxLevel;
131 }