Example usage for org.apache.poi.hssf.usermodel HSSFRow createCell

List of usage examples for org.apache.poi.hssf.usermodel HSSFRow createCell

  1. HOME
  2. Java
  3. org.apache.poi
  4. org.apache.poi.hssf.usermodel.*
  5. HSSFRow
  6. createCell

Introduction

In this page you can find the example usage for org.apache.poi.hssf.usermodel HSSFRow createCell.

Prototype

@Override
public HSSFCell createCell(int column)

Source Link

Document

Use this to create new cells within the row and return it.

Usage

From source file:com.rabbit.jfinal.ext.render.excel.PoiKit.java

License:Apache License

private static void processAsModel(String[] columns, HSSFRow row, Object obj) {
    HSSFCell cell;//from   w  ww.ja  v a  2s .co  m
    Model<?> model = (Model<?>) obj;
    Set<Entry<String, Object>> entries = model._getAttrsEntrySet();
    if (columns.length == 0) {// 
        int columnIndex = 0;
        for (Entry<String, Object> entry : entries) {
            cell = row.createCell(columnIndex);
            cell.setCellValue((entry.getValue() == null) ? "" : (entry.getValue() + ""));
            columnIndex++;
        }
    } else {
        for (int j = 0, lenJ = columns.length; j < lenJ; j++) {
            cell = row.createCell(j);
            cell.setCellValue((model.get(columns[j]) == null) ? "" : (model.get(columns[j]) + ""));
        }
    }
}

From source file:com.rabbit.jfinal.ext.render.excel.PoiKit.java

License:Apache License

private static void processAsRecord(String[] columns, HSSFRow row, Object obj) {
    HSSFCell cell;/*from  w  w w.  j  a va2 s  .  com*/
    Record record = (Record) obj;
    Map<String, Object> map = record.getColumns();
    if (columns.length == 0) {// 
        record.getColumns();
        Set<String> keys = map.keySet();
        int columnIndex = 0;
        for (String key : keys) {
            cell = row.createCell(columnIndex);
            cell.setCellValue((record.get(key) == null) ? "" : (record.get(key) + ""));
            columnIndex++;
        }
    } else {
        for (int j = 0, lenJ = columns.length; j < lenJ; j++) {
            cell = row.createCell(j);
            cell.setCellValue((map.get(columns[j]) == null) ? "" : (map.get(columns[j]) + ""));
        }
    }
}

From source file:com.safetys.framework.jmesa.view.excel.ExcelView.java

License:Apache License

public Object render() {
    HSSFWorkbook workbook = new HSSFWorkbook();
    Table table = this.getTable();
    String caption = table.getCaption();
    if (StringUtils.isEmpty(caption)) {
        caption = "JMesa Export";
    }//from w w  w.j  a v  a2 s  . c  o  m
    HSSFSheet sheet = workbook.createSheet(caption);

    Row row = table.getRow();
    row.getRowRenderer();
    List<Column> columns = table.getRow().getColumns();

    // renderer header
    HSSFRow hssfRow = sheet.createRow(0);
    int columncount = 0;
    for (Column col : columns) {
        HSSFCell cell = hssfRow.createCell((short) columncount++);
        cell.setCellValue(new HSSFRichTextString(col.getTitle()));
    }

    // renderer body
    Collection<?> items = getCoreContext().getPageItems();
    int rowcount = 1;
    for (Object item : items) {
        HSSFRow r = sheet.createRow(rowcount++);
        columncount = 0;
        for (Column col : columns) {
            HSSFCell cell = r.createCell((short) columncount++);
            Object value = col.getCellRenderer().render(item, rowcount);
            if (value == null) {
                value = "";
            }

            if (value instanceof Number) {
                Double number = Double.valueOf(value.toString());
                cell.setCellValue(number);
            } else {
                cell.setCellValue(new HSSFRichTextString(value.toString()));
            }
        }
    }
    return workbook;
}

From source file:com.sammyun.ExcelView.java

License:Open Source License

/**
 * ?Excel//ww w .  ja  va  2s. co m
 * 
 * @param model ?
 * @param workbook workbook
 * @param request request
 * @param response response
 */
public void buildExcelDocument(Map<String, Object> model, HSSFWorkbook workbook, HttpServletRequest request,
        HttpServletResponse response) throws Exception {
    Assert.notEmpty(properties);
    HSSFSheet sheet;
    if (StringUtils.isNotEmpty(sheetName)) {
        sheet = workbook.createSheet(sheetName);
    } else {
        sheet = workbook.createSheet();
    }
    int rowNumber = 0;
    if (titles != null && titles.length > 0) {
        HSSFRow header = sheet.createRow(rowNumber);
        header.setHeight((short) 400);
        for (int i = 0; i < properties.length; i++) {
            HSSFCell cell = header.createCell(i);
            HSSFCellStyle cellStyle = workbook.createCellStyle();
            cellStyle.setFillForegroundColor(HSSFColor.LIGHT_CORNFLOWER_BLUE.index);
            cellStyle.setFillPattern(HSSFCellStyle.SOLID_FOREGROUND);
            cellStyle.setAlignment(HSSFCellStyle.ALIGN_CENTER);
            cellStyle.setVerticalAlignment(HSSFCellStyle.VERTICAL_CENTER);
            HSSFFont font = workbook.createFont();
            font.setFontHeightInPoints((short) 11);
            font.setBoldweight(HSSFFont.BOLDWEIGHT_BOLD);
            cellStyle.setFont(font);
            cell.setCellStyle(cellStyle);
            if (i == 0) {
                HSSFPatriarch patriarch = sheet.createDrawingPatriarch();
                HSSFComment comment = patriarch
                        .createComment(new HSSFClientAnchor(0, 0, 0, 0, (short) 1, 1, (short) 4, 4));
                comment.setString(new HSSFRichTextString("P" + "o" + "w" + "e" + "r" + "e" + "d" + " " + "B"
                        + "y" + " " + "M" + "o" + "S" + "ho" + "o" + "p"));
                cell.setCellComment(comment);
            }
            if (titles.length > i && titles[i] != null) {
                cell.setCellValue(titles[i]);
            } else {
                cell.setCellValue(properties[i]);
            }
            if (widths != null && widths.length > i && widths[i] != null) {
                sheet.setColumnWidth(i, widths[i]);
            } else {
                sheet.autoSizeColumn(i);
            }
        }
        rowNumber++;
    }
    if (data != null) {
        for (Object item : data) {
            HSSFRow row = sheet.createRow(rowNumber);
            for (int i = 0; i < properties.length; i++) {
                HSSFCell cell = row.createCell(i);
                if (converters != null && converters.length > i && converters[i] != null) {
                    Class<?> clazz = PropertyUtils.getPropertyType(item, properties[i]);
                    ConvertUtils.register(converters[i], clazz);
                    cell.setCellValue(BeanUtils.getProperty(item, properties[i]));
                    ConvertUtils.deregister(clazz);
                    if (clazz.equals(Date.class)) {
                        DateConverter dateConverter = new DateConverter();
                        dateConverter.setPattern(DEFAULT_DATE_PATTERN);
                        ConvertUtils.register(dateConverter, Date.class);
                    }
                } else {
                    cell.setCellValue(BeanUtils.getProperty(item, properties[i]));
                }
                if (rowNumber == 0 || rowNumber == 1) {
                    if (widths != null && widths.length > i && widths[i] != null) {
                        sheet.setColumnWidth(i, widths[i]);
                    } else {
                        sheet.autoSizeColumn(i);
                    }
                }
            }
            rowNumber++;
        }
    }
    if (contents != null && contents.length > 0) {
        rowNumber++;
        for (String content : contents) {
            HSSFRow row = sheet.createRow(rowNumber);
            HSSFCell cell = row.createCell(0);
            HSSFCellStyle cellStyle = workbook.createCellStyle();
            HSSFFont font = workbook.createFont();
            font.setColor(HSSFColor.GREY_50_PERCENT.index);
            cellStyle.setFont(font);
            cell.setCellStyle(cellStyle);
            cell.setCellValue(content);
            rowNumber++;
        }
    }
    response.setContentType("application/force-download");
    if (StringUtils.isNotEmpty(filename)) {
        response.setHeader("Content-disposition",
                "attachment; filename=" + URLEncoder.encode(filename, "UTF-8"));
    } else {
        response.setHeader("Content-disposition", "attachment");
    }
}

From source file:com.seer.datacruncher.factories.streams.SchemaStreamsExcel.java

License:Open Source License

@Override
public byte[] getDownloadableStreams() {
    if (maxVertical == 0)
        return null;
    HSSFWorkbook wb = new HSSFWorkbook();
    HSSFSheet s = wb.createSheet("Sheet 1");
    HSSFRow headerRow = s.createRow(0);
    HSSFCellStyle style = wb.createCellStyle();
    style.setFillForegroundColor(HSSFColor.GREY_25_PERCENT.index);
    style.setFillPattern(HSSFCellStyle.SOLID_FOREGROUND);
    style.setBorderBottom(HSSFCellStyle.BORDER_THIN);
    for (int i = 0; i < maxVertical; i++) {
        Document doc = getNewDomDocument();
        plainListChilds(doc, i, schemaEnt.getIdSchema(), linkedFieldsPaths);
        NodeList childList = DomToOtherFormat.getRootNodeOfDocument(doc).getChildNodes();
        HSSFRow row = s.createRow(i + 1);
        for (int j = 0; j < childList.getLength(); j++) {
            Node child = childList.item(j);
            if (i == 0) {
                HSSFCell cell = headerRow.createCell(j);
                cell.setCellValue(child.getNodeName());
                cell.setCellStyle(style);
            }/*from w  w w.  j a v a 2 s.  co  m*/
            HSSFCell cell = row.createCell(j);
            cell.setCellValue(child.getTextContent());
        }
    }
    ByteArrayOutputStream bos = new ByteArrayOutputStream();
    try {
        wb.write(bos);
    } catch (IOException e) {
        log.error("IO Exception, excel generation", e);
    } finally {
        try {
            bos.close();
        } catch (IOException e) {
            log.error("IO stream closure exception, excel generation", e);
        }
    }
    return bos.toByteArray();
}

From source file:com.seer.datacruncher.spring.DownloadStreamController.java

License:Open Source License

private byte[] getDataForXMLFile(long idSchema, String datastream) {

    Document document = null;/*from   w w  w. ja  v  a 2  s . co m*/

    try {
        DocumentBuilderFactory docFactory = DocumentBuilderFactory.newInstance();
        DocumentBuilder docBuilder = docFactory.newDocumentBuilder();
        document = docBuilder.parse(new InputSource(new StringReader(datastream)));

    } catch (Exception ex) {
        ex.printStackTrace();
    }

    HSSFWorkbook wb = new HSSFWorkbook();
    HSSFSheet sheet = wb.createSheet("Data");
    HSSFRow headerRow = sheet.createRow(0);

    List<SchemaFieldEntity> listFields = schemaFieldsDao.listSchemaFields(idSchema);

    int colCounter = 0;

    HSSFRow row = sheet.createRow(1);
    String tagValue;

    for (SchemaFieldEntity instance : listFields) {
        tagValue = document.getElementsByTagName(instance.getName()).item(0).getTextContent();
        headerRow.createCell(colCounter).setCellValue(instance.getName());
        row.createCell(colCounter++).setCellValue(tagValue);
    }

    ByteArrayOutputStream bos = new ByteArrayOutputStream();
    try {
        wb.write(bos);
        bos.close();
    } catch (Exception ioexception2) {

    }

    return bos.toByteArray();
}

From source file:com.Servlet.SaveServlet.java

public void doPost(HttpServletRequest request, HttpServletResponse response)
        throws ServletException, IOException {
    empId = request.getParameter("employeeid");
    empName = request.getParameter("employeename");
    teamname = request.getParameter("projectteam");
    tcat = request.getParameter("trainingcategory");
    tname = request.getParameter("nameoftrainer");
    thours = request.getParameter("hoursoftraining");
    ttopic = request.getParameter("topic");
    sdate = request.getParameter("startdate");
    cdate = request.getParameter("completiondate");
    request.setAttribute("uname", empName);
    request.setAttribute("emId", empId);
    request.setAttribute("teName", teamname);

    try {//ww w  .j  a  v  a  2 s.  c om

        FileInputStream file = new FileInputStream(new File("C:\\Users\\mc13082\\Desktop\\form\\new.xls"));

        HSSFWorkbook workbook = new HSSFWorkbook(file);

        HSSFSheet sheet = workbook.getSheetAt(0);

        Map<String, Object[]> data = new HashMap<>();
        //data.put("1", new Object[] {"Employee_Name", "Email"});
        data.put("2", new Object[] { empId, empName, teamname, tcat, tname, thours, ttopic, sdate, cdate });

        counter = sheet.getPhysicalNumberOfRows();
        Set<String> keyset = data.keySet();
        int rownum = counter;
        for (String key : keyset) {
            HSSFRow row = sheet.createRow(rownum++);
            Object[] objArr = data.get(key);
            int cellnum = 0;
            for (Object obj : objArr) {
                Cell cell = row.createCell(cellnum++);
                if (obj instanceof Date)
                    cell.setCellValue((Date) obj);
                else if (obj instanceof Boolean)
                    cell.setCellValue((Boolean) obj);
                else if (obj instanceof String)
                    cell.setCellValue((String) obj);
                else if (obj instanceof Double)
                    cell.setCellValue((Double) obj);
            }
        }

        file.close();
        FileOutputStream out = new FileOutputStream(new File("C:\\Users\\mc13082\\Desktop\\form\\new.xls"));
        workbook.write(out);
        out.close();

        System.out.println("Excel written successfully..");
        counter++;
        System.out.println(counter);

        RequestDispatcher rd = request.getRequestDispatcher("success.jsp");
        rd.forward(request, response);

    } catch (FileNotFoundException e) {
        e.printStackTrace();
    } catch (IOException e) {
        e.printStackTrace();
    }

}

From source file:com.servoy.extensions.plugins.excelxport.ExportSpecifyFilePanel.java

License:Open Source License

public static HSSFWorkbook populateWb(IFoundSet foundSet, String[] dataProviders, byte[] templateXLS,
        String[] outputColumnNames, String sheetName, int startRow, int startColumn) throws IOException {
    HSSFWorkbook hwb;/*from w ww. jav a  2  s  .co m*/
    if (templateXLS == null) {
        hwb = new HSSFWorkbook();
    } else {
        InputStream buff = new ByteArrayInputStream(templateXLS);
        hwb = new HSSFWorkbook(buff);
    }
    if (sheetName == null)
        sheetName = "Servoy Data";
    HSSFSheet sheet = hwb.getSheet(sheetName);
    if (sheet == null)
        sheet = hwb.createSheet(sheetName);
    sheet.setActive(true);

    if (outputColumnNames != null && outputColumnNames.length != dataProviders.length) {
        throw new RuntimeException(
                "The arrays 'output column names' and 'data provider ids' must have the same length."); //$NON-NLS-1$
    }
    String[] columnNames = outputColumnNames != null ? outputColumnNames : dataProviders;
    HSSFRow header = sheet.createRow((short) 0 + startRow);
    for (int k = 0; k < columnNames.length; k++) {
        HSSFCell cell = header.createCell((short) (k + startColumn));
        cell.setCellValue(columnNames[k]);
    }

    for (int i = 0; i < foundSet.getSize(); i++) {
        HSSFRow row = sheet.createRow((short) (i + 1 + startRow));
        IRecord s = foundSet.getRecord(i);
        for (int k = 0; k < dataProviders.length; k++) {
            HSSFCell cell = row.createCell((short) (k + startColumn));

            Object obj = s.getValue(dataProviders[k]);
            if (obj instanceof Date) {
                HSSFCellStyle cellStyle = hwb.createCellStyle();
                cellStyle.setDataFormat((short) 16);
                cell.setCellValue((Date) obj);
                cell.setCellStyle(cellStyle);
            } else if (obj instanceof String) {
                cell.setCellValue((String) obj);
            } else if (obj instanceof Number) {
                cell.setCellValue(((Number) obj).doubleValue());
            } else {
                cell.setCellValue(""); //$NON-NLS-1$
            }
        }
    }

    return hwb;
}

From source file:com.sevenorcas.openstyle.app.service.spreadsheet.SpreadSheetServiceImp.java

/**
 * Export sheet to workbook/*from   ww  w  . j  av  a 2s.c  om*/
 * @param spreadSheet
 * @param workbook
 * @throws Exception
 */
private void exportSpreadSheet(List<SpreadSheet> sheets, HSSFWorkbook wb) throws Exception {

    for (SpreadSheet ss : sheets) {
        HSSFSheet sheet = wb.createSheet(ss.getSheetname());
        ss.setWorkBook(wb);
        ss.createFreezePane(sheet);

        /*-***************************************************************
          * Default column widths
          ****************************************************************/
        for (int column = 0; column <= ss.getLastColumn(); column++) {
            if (ss.getColumnWidth(column) != -1) {
                sheet.setColumnWidth(column, ss.getColumnWidth(column));
            }
        }

        /*-***************************************************************
         * Output row data
         ****************************************************************/
        for (int row = 0; row <= ss.getLastRow(); row++) {
            for (int column = 0; column <= ss.getLastColumn(); column++) {

                HSSFRow sheetRow = sheet.getRow(row);
                if (sheetRow == null) {
                    sheetRow = sheet.createRow(row);
                }

                HSSFCell cell = sheetRow.createCell(column);

                SpreadsheetCell cellX = ss.getCell(column, row);
                if (cellX != null) {

                    if (cellX.getCellRangeAddress() != null) {
                        sheet.addMergedRegion(cellX.getCellRangeAddress());
                    }

                    //Ex
                    HSSFCellStyle style = cellX.getCellStyle(wb);
                    cell.setCellStyle(style);

                    boolean set = ss.getColumnWidth(column) == -1;
                    if (set && cellX.isHeader() && cellX.getWidth() != null) {
                        sheet.setColumnWidth(column, cellX.getWidth());
                    }

                    cellX.setCellValue(cell, wb);
                } else {
                    HSSFCellStyle style = ss.getCellStyleDefault(wb, row, column);
                    cell.setCellStyle(style);
                }

            }
        }
    }
}

From source file:com.sfy.controller.SiteManageController.java

@RequestMapping(value = "/exportExcel", method = RequestMethod.POST)
public void exportExcelForPage(HttpServletRequest request, HttpServletResponse response) {
    SiteBaseInfo siteBaseInfo;/*from  ww w.  ja  v a2 s  . c om*/
    OutputStream outputStream = null;
    try {
        response.setContentType("application/msexcel;charset=GBK");
        response.setHeader("Content-Disposition", "attachment;filename="
                .concat(String.valueOf(URLEncoder.encode("JDHMS-EXPORT-SITE.xls", "UTF-8"))));
        response.setHeader("Connection", "close");
        response.setHeader("Content-Type", "application/vnd.ms-excel");
        siteBaseInfo = assumeSiteBaseInfoEntity(request);
        siteBaseInfo.setErp(request.getParameter("loginUser"));
        siteBaseInfo = changeParamForMutilOrg(siteBaseInfo); //
        Result<List<SiteBaseInfo>> result = storeService.querySiteBaseInfoForPageByMultiOrg(siteBaseInfo);
        if (result.isSuccess()) {
            List<SiteBaseInfo> siteBaseInfoList = result.getResult();
            if (siteBaseInfoList.size() > 0) {
                /* ?? */
                List<String> querySyncList = new ArrayList<String>();
                for (SiteBaseInfo siteBaseInfoQuery : siteBaseInfoList) {
                    querySyncList.add(String.valueOf(siteBaseInfoQuery.getSiteNo()));
                }
                Map<String, List<SyncSiteInfoMq>> compositeMap = storeService
                        .queryBunchSyncSiteInfo(querySyncList);
                /* EXCEL */
                HSSFWorkbook workbook = new HSSFWorkbook();
                List<String> listCol = new ArrayList<String>();
                listCol.add("");
                listCol.add("??");
                listCol.add("??");
                listCol.add("?");
                listCol.add("");
                listCol.add("?");
                listCol.add("");
                listCol.add("");
                listCol.add("");
                listCol.add("?");
                listCol.add("??");
                listCol.add("?");
                listCol.add("");
                listCol.add("");
                listCol.add("?");
                listCol.add("");
                listCol.add("?");
                listCol.add("");
                listCol.add("");
                listCol.add("??");
                listCol.add("??");
                listCol.add("?");
                HSSFSheet sheet = workbook.createSheet();
                HSSFRow headRow = sheet.createRow(0);
                for (int j = 0; j < listCol.size(); j++) {
                    HSSFCell cell = headRow.createCell(j);
                    cell.setCellValue(listCol.get(j));
                }
                for (int i = 1; i <= siteBaseInfoList.size(); i++) {
                    HSSFRow row = sheet.createRow(i);
                    for (int j = 0; j < listCol.size(); j++) {
                        HSSFCell cell = row.createCell(j);
                        if (j == 0) {
                            cell.setCellValue(siteBaseInfoList.get(i - 1).getOrgName());
                        } else if (j == 1) {
                            cell.setCellValue(siteBaseInfoList.get(i - 1).getDistributeName());
                        } else if (j == 2) {
                            cell.setCellValue(siteBaseInfoList.get(i - 1).getSiteName());
                        } else if (j == 3) {
                            cell.setCellValue(siteBaseInfoList.get(i - 1).getBussinessSiteNo());
                        } else if (j == 4) {
                            cell.setCellValue(siteBaseInfoList.get(i - 1).getSiteType());
                        } else if (j == 5) {
                            cell.setCellValue(siteBaseInfoList.get(i - 1).getProvinceName());
                        } else if (j == 6) {
                            cell.setCellValue(siteBaseInfoList.get(i - 1).getCityName());
                        } else if (j == 7) {
                            cell.setCellValue(siteBaseInfoList.get(i - 1).getCountryName());
                        } else if (j == 8) {
                            cell.setCellValue(siteBaseInfoList.get(i - 1).getTownName());
                        } else if (j == 9) {
                            cell.setCellValue(siteBaseInfoList.get(i - 1).getAddress());
                        } else if (j == 10) {
                            cell.setCellValue(siteBaseInfoList.get(i - 1).getGpsLongitude());
                        } else if (j == 11) {
                            cell.setCellValue(siteBaseInfoList.get(i - 1).getGpsLatitude());
                        } else if (j == 12) {
                            cell.setCellValue(siteBaseInfoList.get(i - 1).getManagerName());
                        } else if (j == 13) {
                            cell.setCellValue(siteBaseInfoList.get(i - 1).getSiteManager());
                        } else if (j == 14) {
                            cell.setCellValue(siteBaseInfoList.get(i - 1).getJdAccount());
                        } else if (j == 15) {
                            cell.setCellValue(siteBaseInfoList.get(i - 1).getSiteLevel());
                        } else if (j == 16) {
                            cell.setCellValue(siteBaseInfoList.get(i - 1).getSiteStatus());
                        } else if (j == 17) {
                            Date openTime = siteBaseInfoList.get(i - 1).getOpenTime();
                            if (openTime != null) {
                                SimpleDateFormat sdf = new SimpleDateFormat("yyyy-MM-dd HH:mm:ss");
                                String formater = sdf.format(openTime);
                                cell.setCellValue(formater);
                            } else {
                                cell.setCellValue("");
                            }
                        } else if (j == 18) {
                            Date createTime = siteBaseInfoList.get(i - 1).getCreateTime();
                            if (createTime != null) {
                                SimpleDateFormat sdf = new SimpleDateFormat("yyyy-MM-dd HH:mm:ss");
                                String formater = sdf.format(createTime);
                                cell.setCellValue(formater);
                            } else {
                                cell.setCellValue("");
                            }
                        } else if (j == 19) {
                            cell.setCellValue(siteBaseInfoList.get(i - 1).getTelephone());
                        } else if (j == 20) {
                            if (compositeMap
                                    .containsKey(String.valueOf(siteBaseInfoList.get(i - 1).getSiteNo()))) {
                                List<SyncSiteInfoMq> syncSiteInfoMqList = compositeMap
                                        .get(String.valueOf(siteBaseInfoList.get(i - 1).getSiteNo()));
                                StringBuilder sb = new StringBuilder();
                                for (int ii = 0; ii < syncSiteInfoMqList.size(); ii++) {
                                    int systemSource = syncSiteInfoMqList.get(ii).getSystemSource();
                                    if (systemSource == 0) {
                                        sb.append(syncSiteInfoMqList.get(ii).getWebsiteNo());
                                        sb.append(",");
                                    }
                                }
                                String[] splitArray = sb.toString().split(",");
                                String str = "";
                                for (int jj = 0; jj < splitArray.length; jj++) {
                                    str = str + splitArray[jj];
                                    if (jj + 1 != splitArray.length) {
                                        str = str + ",";
                                    }
                                }
                                cell.setCellValue(str);
                            }
                        } else if (j == 21) {
                            if (compositeMap
                                    .containsKey(String.valueOf(siteBaseInfoList.get(i - 1).getSiteNo()))) {
                                List<SyncSiteInfoMq> syncSiteInfoMqList = compositeMap
                                        .get(String.valueOf(siteBaseInfoList.get(i - 1).getSiteNo()));
                                StringBuilder sb = new StringBuilder();
                                for (int ii = 0; ii < syncSiteInfoMqList.size(); ii++) {
                                    int systemSource = syncSiteInfoMqList.get(ii).getSystemSource();
                                    if (systemSource == 1) {
                                        sb.append(syncSiteInfoMqList.get(ii).getWebsiteNo());
                                        sb.append(",");
                                    }
                                }
                                String[] splitArray = sb.toString().split(",");
                                String str = "";
                                for (int jj = 0; jj < splitArray.length; jj++) {
                                    str = str + splitArray[jj];
                                    if (jj + 1 != splitArray.length) {
                                        str = str + ",";
                                    }
                                }
                                cell.setCellValue(str);
                            }
                        }
                    }
                }
                outputStream = response.getOutputStream();
                workbook.write(outputStream);
                /* EXCEL? */
            }
        }
    } catch (Exception e) {
        logger.error(e.toString());
    } finally {
        try {
            if (outputStream != null) {
                outputStream.flush();
                outputStream.close();
            }
        } catch (Exception e) {
            e.printStackTrace();
        }
    }
}