List of usage examples for org.apache.poi.ss.usermodel Workbook createSheet
Sheet createSheet(String sheetname);
From source file:com.sirelab.controller.reportes.ControllerGeneradorReportes.java
public void reporteIntegracionInventario() throws Exception { String rutaArchivo = ""; if (validarNombreReporte()) { rutaArchivo = System.getProperty("user.home") + "/" + nombreReporte + ".xls"; } else {//from w ww. j a va2 s . c om rutaArchivo = System.getProperty("user.home") + "/" + "INTEGRACION_INVENTARIO" + ".xls"; } File archivoXLS = new File(rutaArchivo); if (archivoXLS.exists()) { archivoXLS.delete(); } archivoXLS.createNewFile(); Workbook libro = new HSSFWorkbook(); FileOutputStream archivo = new FileOutputStream(archivoXLS); Sheet hoja = libro.createSheet("INVENTARIO"); List<ComponenteEquipo> componentes = administradorGeneradorReportesBO.consultarComponentesRegistrados(); int tamtotal = 0; if (null != componentes) { tamtotal = componentes.size(); } for (int f = 0; f < tamtotal; f++) { Row fila = hoja.createRow(f); ComponenteEquipo componente = componentes.get(f); for (int c = 0; c < 18; c++) { Cell celda = fila.createCell(c); if (f == 0) { if (c == 0) { celda.setCellValue("CODIGO_COMPONENTE"); } else if (c == 1) { celda.setCellValue("NOMBRE_COMPONENTE"); } else if (c == 2) { celda.setCellValue("DESCRIPCION_COMPONENTE"); } else if (c == 3) { celda.setCellValue("MARCA_COMPONENTE"); } else if (c == 4) { celda.setCellValue("MODELO_COMPONENTE"); } else if (c == 5) { celda.setCellValue("TIPO_COMPONENTE"); } else if (c == 6) { celda.setCellValue("ESTADO_COMPONENTE"); } else if (c == 7) { celda.setCellValue("CODIGO_EQUIPO"); } else if (c == 8) { celda.setCellValue("NOMBRE_EQUIPO"); } else if (c == 9) { celda.setCellValue("MODELO_EQUIPO"); } else if (c == 10) { celda.setCellValue("SERIE_EQUIPO"); } else if (c == 11) { celda.setCellValue("PROVEEDOR_EQUIPO"); } else if (c == 12) { celda.setCellValue("ESTADO_EQUIPO"); } else if (c == 13) { celda.setCellValue("TIPO_ACTIVO_EQUIPO"); } else if (c == 14) { celda.setCellValue("CODIGO_MODULO_LABORATORIO"); } else if (c == 15) { celda.setCellValue("MODULO_LABORATORIO"); } else if (c == 16) { celda.setCellValue("SALA_LABORATORIO"); } else if (c == 17) { celda.setCellValue("LABORATORIO"); } } else { if (c == 0) { celda.setCellValue(componente.getCodigocomponete()); } else if (c == 1) { celda.setCellValue(componente.getNombrecomponente()); } else if (c == 2) { celda.setCellValue(componente.getDescripcioncomponente()); } else if (c == 3) { celda.setCellValue(componente.getMarcacomponente()); } else if (c == 4) { celda.setCellValue(componente.getModelocomponente()); } else if (c == 5) { celda.setCellValue(componente.getTipocomponente().getNombretipo()); } else if (c == 6) { celda.setCellValue(componente.getStrEstado()); } else if (c == 7) { celda.setCellValue(componente.getEquipoelemento().getInventarioequipo()); } else if (c == 8) { celda.setCellValue(componente.getEquipoelemento().getNombreequipo()); } else if (c == 9) { celda.setCellValue(componente.getEquipoelemento().getModeloequipo()); } else if (c == 10) { celda.setCellValue(componente.getEquipoelemento().getSeriequipo()); } else if (c == 11) { celda.setCellValue(componente.getEquipoelemento().getProveedor().getNombreproveedor()); } else if (c == 12) { celda.setCellValue( componente.getEquipoelemento().getEstadoequipo().getNombreestadoequipo()); } else if (c == 13) { celda.setCellValue(componente.getEquipoelemento().getTipoactivo().getNombretipoactivo()); } else if (c == 14) { celda.setCellValue(componente.getEquipoelemento().getModulolaboratorio().getCodigomodulo()); } else if (c == 15) { celda.setCellValue( componente.getEquipoelemento().getModulolaboratorio().getDetallemodulo()); } else if (c == 16) { celda.setCellValue(componente.getEquipoelemento().getModulolaboratorio() .getSalalaboratorio().getNombresala()); } else if (c == 17) { celda.setCellValue(componente.getEquipoelemento().getModulolaboratorio() .getSalalaboratorio().getLaboratorio().getNombrelaboratorio()); } } } } libro.write(archivo); archivo.close(); descargarArchivo(rutaArchivo); }
From source file:com.sirelab.controller.reportes.ControllerGeneradorReportes.java
public void reporteHojaVidaEquipos() throws Exception { String rutaArchivo = ""; if (validarNombreReporte()) { rutaArchivo = System.getProperty("user.home") + "/" + nombreReporte + ".xls"; } else {//w w w .j av a2s . c om rutaArchivo = System.getProperty("user.home") + "/" + "HOJA_VIDA_EQUIPOS" + ".xls"; } File archivoXLS = new File(rutaArchivo); if (archivoXLS.exists()) { archivoXLS.delete(); } archivoXLS.createNewFile(); Workbook libro = new HSSFWorkbook(); FileOutputStream archivo = new FileOutputStream(archivoXLS); Sheet hoja = libro.createSheet("HOJA_VIDA_EQUIPOS"); List<HojaVidaEquipo> hojavidaequipos = administradorGeneradorReportesBO.consultarHojaVidaEquipos(); int tamtotal = 0; if (null != hojavidaequipos) { tamtotal = hojavidaequipos.size(); } for (int f = 0; f < tamtotal; f++) { Row fila = hoja.createRow(f); HojaVidaEquipo hojavida = hojavidaequipos.get(f); for (int c = 0; c < 19; c++) { Cell celda = fila.createCell(c); if (f == 0) { if (c == 0) { celda.setCellValue("FECHA_REGISTRO"); } else if (c == 1) { celda.setCellValue("FECHA_EVENTO"); } else if (c == 2) { celda.setCellValue("FECHA_FIN_EVENTO"); } else if (c == 3) { celda.setCellValue("DETALLE_EVENTO"); } else if (c == 4) { celda.setCellValue("OBSERVACIONES"); } else if (c == 5) { celda.setCellValue("COSTO"); } else if (c == 6) { celda.setCellValue("USUARIO"); } else if (c == 7) { celda.setCellValue("TIPO_EVENTO"); } else if (c == 8) { celda.setCellValue("CODIGO_EQUIPO"); } else if (c == 9) { celda.setCellValue("NOMBRE_EQUIPO"); } else if (c == 10) { celda.setCellValue("MODELO_EQUIPO"); } else if (c == 11) { celda.setCellValue("SERIE_EQUIPO"); } else if (c == 12) { celda.setCellValue("PROVEEDOR_EQUIPO"); } else if (c == 13) { celda.setCellValue("ESTADO_EQUIPO"); } else if (c == 14) { celda.setCellValue("TIPO_ACTIVO_EQUIPO"); } else if (c == 15) { celda.setCellValue("CODIGO_MODULO_LABORATORIO"); } else if (c == 16) { celda.setCellValue("MODULO_LABORATORIO"); } else if (c == 17) { celda.setCellValue("SALA_LABORATORIO"); } else if (c == 18) { celda.setCellValue("LABORATORIO"); } } else { String pattern = "dd/MM/yyyy"; SimpleDateFormat simpleDateFormat = new SimpleDateFormat(pattern); if (c == 0) { String date = simpleDateFormat.format(hojavida.getFecharegistro()); celda.setCellValue(date); } else if (c == 1) { String date = simpleDateFormat.format(hojavida.getFechaevento()); celda.setCellValue(date); } else if (c == 2) { String date = simpleDateFormat.format(hojavida.getFechafinevento()); celda.setCellValue(date); } else if (c == 3) { celda.setCellValue(hojavida.getDetalleevento()); } else if (c == 4) { celda.setCellValue(hojavida.getObservaciones()); } else if (c == 5) { celda.setCellValue(hojavida.getCosto()); } else if (c == 6) { celda.setCellValue(hojavida.getUsuariomodificacion()); } else if (c == 7) { celda.setCellValue(hojavida.getTipoevento().getDetalleevento()); } else if (c == 8) { celda.setCellValue(hojavida.getEquipoelemento().getInventarioequipo()); } else if (c == 9) { celda.setCellValue(hojavida.getEquipoelemento().getNombreequipo()); } else if (c == 10) { celda.setCellValue(hojavida.getEquipoelemento().getModeloequipo()); } else if (c == 11) { celda.setCellValue(hojavida.getEquipoelemento().getSeriequipo()); } else if (c == 12) { celda.setCellValue(hojavida.getEquipoelemento().getProveedor().getNombreproveedor()); } else if (c == 13) { celda.setCellValue(hojavida.getEquipoelemento().getEstadoequipo().getNombreestadoequipo()); } else if (c == 14) { celda.setCellValue(hojavida.getEquipoelemento().getTipoactivo().getNombretipoactivo()); } else if (c == 15) { celda.setCellValue(hojavida.getEquipoelemento().getModulolaboratorio().getCodigomodulo()); } else if (c == 16) { celda.setCellValue(hojavida.getEquipoelemento().getModulolaboratorio().getDetallemodulo()); } else if (c == 17) { celda.setCellValue(hojavida.getEquipoelemento().getModulolaboratorio().getSalalaboratorio() .getNombresala()); } else if (c == 18) { celda.setCellValue(hojavida.getEquipoelemento().getModulolaboratorio().getSalalaboratorio() .getLaboratorio().getNombrelaboratorio()); } } } } libro.write(archivo); archivo.close(); descargarArchivo(rutaArchivo); }
From source file:com.skt.adcas.lte.action.DownLinkByNMSAction.java
public String selectDailyCellTrafficCQIExcelDownload() { this.log.debug("selectDailyCellTrafficCQIExcelDownload Start"); SqlSession session = null;/*from w w w . java 2s . c o m*/ FileOutputStream fileOut = null; try { parseParam(); log.debug(this.MFC_CD); String[] CQINAME = { "0", "1", "2", "3", "4", "5", "6", "7", "8", "9", "10", "11", "12", "13", "14", "15" }; if (MFC_CD.equals("MFC00002")) { CQINAME[0] = "1"; CQINAME[1] = "2"; CQINAME[2] = "3"; CQINAME[3] = "4"; CQINAME[4] = "5"; CQINAME[5] = "6"; CQINAME[6] = "7"; CQINAME[7] = "8"; CQINAME[8] = "9"; CQINAME[9] = "10"; CQINAME[10] = "11"; CQINAME[12] = "12"; CQINAME[13] = "13"; CQINAME[14] = "14"; CQINAME[15] = "15"; } Type type = new TypeToken<Map<String, Object>>() { }.getType(); Gson gson = new Gson(); Map<String, Object> map = gson.fromJson(this.JSONDATA, type); //log.debug("json data : " + this.JSONDATA); Workbook wb = new HSSFWorkbook(); //PDFsheet String sheetName = "CQI PDF"; String safeName = WorkbookUtil.createSafeSheetName(sheetName); Sheet PDFsheet = wb.createSheet(safeName); //CDFsheet sheetName = "CQI CDF"; safeName = WorkbookUtil.createSafeSheetName(sheetName); Sheet CDFsheet = wb.createSheet(safeName); //header ? Row PDFhrow0 = PDFsheet.createRow((short) 0); PDFhrow0.setHeightInPoints(20); PDFhrow0.createCell(0).setCellValue(""); // "YMD" PDFhrow0.createCell(1).setCellValue(""); // "MB_TIME" PDFhrow0.createCell(2).setCellValue("DU"); // "BTS_NM" PDFhrow0.createCell(3).setCellValue("CELL ID"); // "CELL_ID" PDFhrow0.createCell(4).setCellValue("CELL "); // "CELL_NM" PDFhrow0.createCell(5).setCellValue("MCID"); // "MCID" PDFhrow0.createCell(6).setCellValue(""); // "MCID" PDFhrow0.createCell(7).setCellValue("PDF-" + CQINAME[0]); PDFhrow0.createCell(8).setCellValue("PDF-" + CQINAME[1]); PDFhrow0.createCell(9).setCellValue("PDF-" + CQINAME[2]); PDFhrow0.createCell(10).setCellValue("PDF-" + CQINAME[3]); PDFhrow0.createCell(11).setCellValue("PDF-" + CQINAME[4]); PDFhrow0.createCell(12).setCellValue("PDF-" + CQINAME[5]); PDFhrow0.createCell(13).setCellValue("PDF-" + CQINAME[6]); PDFhrow0.createCell(14).setCellValue("PDF-" + CQINAME[7]); PDFhrow0.createCell(15).setCellValue("PDF-" + CQINAME[8]); PDFhrow0.createCell(16).setCellValue("PDF-" + CQINAME[9]); PDFhrow0.createCell(17).setCellValue("PDF-" + CQINAME[10]); PDFhrow0.createCell(18).setCellValue("PDF-" + CQINAME[11]); PDFhrow0.createCell(19).setCellValue("PDF-" + CQINAME[12]); PDFhrow0.createCell(20).setCellValue("PDF-" + CQINAME[13]); PDFhrow0.createCell(21).setCellValue("PDF-" + CQINAME[14]); PDFhrow0.createCell(22).setCellValue("PDF-" + CQINAME[15]); //header ? Row CDFhrow0 = CDFsheet.createRow((short) 0); CDFhrow0.setHeightInPoints(20); CDFhrow0.createCell(0).setCellValue(""); // "YMD" CDFhrow0.createCell(1).setCellValue(""); // "MB_TIME" CDFhrow0.createCell(2).setCellValue("DU"); // "BTS_NM" CDFhrow0.createCell(3).setCellValue("CELL ID"); // "CELL_ID" CDFhrow0.createCell(4).setCellValue("CELL "); // "CELL_NM" CDFhrow0.createCell(5).setCellValue("MCID"); // "MCID" CDFhrow0.createCell(6).setCellValue(""); // "MCID" CDFhrow0.createCell(7).setCellValue("CDF-" + CQINAME[0]); CDFhrow0.createCell(8).setCellValue("CDF-" + CQINAME[1]); CDFhrow0.createCell(9).setCellValue("CDF-" + CQINAME[2]); CDFhrow0.createCell(10).setCellValue("CDF-" + CQINAME[3]); CDFhrow0.createCell(11).setCellValue("CDF-" + CQINAME[4]); CDFhrow0.createCell(12).setCellValue("CDF-" + CQINAME[5]); CDFhrow0.createCell(13).setCellValue("CDF-" + CQINAME[6]); CDFhrow0.createCell(14).setCellValue("CDF-" + CQINAME[7]); CDFhrow0.createCell(15).setCellValue("CDF-" + CQINAME[8]); CDFhrow0.createCell(16).setCellValue("CDF-" + CQINAME[9]); CDFhrow0.createCell(17).setCellValue("CDF-" + CQINAME[10]); CDFhrow0.createCell(18).setCellValue("CDF-" + CQINAME[11]); CDFhrow0.createCell(19).setCellValue("CDF-" + CQINAME[12]); CDFhrow0.createCell(20).setCellValue("CDF-" + CQINAME[13]); CDFhrow0.createCell(21).setCellValue("CDF-" + CQINAME[14]); CDFhrow0.createCell(22).setCellValue("CDF-" + CQINAME[15]); ArrayList list01 = (ArrayList) map.get("rows"); Iterator iterator = (Iterator) list01.iterator(); short i = 1; while (iterator.hasNext()) { StringMap jrow = (StringMap) iterator.next(); // Row PDFrow = PDFsheet.createRow((short) i); Row CDFrow = CDFsheet.createRow((short) i); PDFrow.setHeightInPoints(20); CDFrow.setHeightInPoints(20); PDFrow.createCell(0).setCellValue((String) jrow.get("YMD")); PDFrow.createCell(1).setCellValue((String) jrow.get("MB_TIME")); PDFrow.createCell(2).setCellValue((String) jrow.get("BTS_NM")); PDFrow.createCell(3).setCellValue((String) jrow.get("CELL_ID")); PDFrow.createCell(4).setCellValue((String) jrow.get("CELL_NM")); PDFrow.createCell(5).setCellValue((String) jrow.get("MCID")); PDFrow.createCell(6).setCellValue((String) jrow.get("FREQ_KIND")); CDFrow.createCell(0).setCellValue((String) jrow.get("YMD")); CDFrow.createCell(1).setCellValue((String) jrow.get("MB_TIME")); CDFrow.createCell(2).setCellValue((String) jrow.get("BTS_NM")); CDFrow.createCell(3).setCellValue((String) jrow.get("CELL_ID")); CDFrow.createCell(4).setCellValue((String) jrow.get("CELL_NM")); CDFrow.createCell(5).setCellValue((String) jrow.get("MCID")); CDFrow.createCell(6).setCellValue((String) jrow.get("FREQ_KIND")); PDFrow.createCell(7).setCellValue(Double .parseDouble(jrow.containsKey("CQI_PDF_00") ? jrow.get("CQI_PDF_00").toString() : "0")); PDFrow.createCell(8).setCellValue(Double .parseDouble(jrow.containsKey("CQI_PDF_01") ? jrow.get("CQI_PDF_01").toString() : "0")); PDFrow.createCell(9).setCellValue(Double .parseDouble(jrow.containsKey("CQI_PDF_02") ? jrow.get("CQI_PDF_02").toString() : "0")); PDFrow.createCell(10).setCellValue(Double .parseDouble(jrow.containsKey("CQI_PDF_03") ? jrow.get("CQI_PDF_03").toString() : "0")); PDFrow.createCell(11).setCellValue(Double .parseDouble(jrow.containsKey("CQI_PDF_04") ? jrow.get("CQI_PDF_04").toString() : "0")); PDFrow.createCell(12).setCellValue(Double .parseDouble(jrow.containsKey("CQI_PDF_05") ? jrow.get("CQI_PDF_05").toString() : "0")); PDFrow.createCell(13).setCellValue(Double .parseDouble(jrow.containsKey("CQI_PDF_06") ? jrow.get("CQI_PDF_06").toString() : "0")); PDFrow.createCell(14).setCellValue(Double .parseDouble(jrow.containsKey("CQI_PDF_07") ? jrow.get("CQI_PDF_07").toString() : "0")); PDFrow.createCell(15).setCellValue(Double .parseDouble(jrow.containsKey("CQI_PDF_08") ? jrow.get("CQI_PDF_08").toString() : "0")); PDFrow.createCell(16).setCellValue(Double .parseDouble(jrow.containsKey("CQI_PDF_09") ? jrow.get("CQI_PDF_09").toString() : "0")); PDFrow.createCell(17).setCellValue(Double .parseDouble(jrow.containsKey("CQI_PDF_10") ? jrow.get("CQI_PDF_10").toString() : "0")); PDFrow.createCell(18).setCellValue(Double .parseDouble(jrow.containsKey("CQI_PDF_11") ? jrow.get("CQI_PDF_11").toString() : "0")); PDFrow.createCell(19).setCellValue(Double .parseDouble(jrow.containsKey("CQI_PDF_12") ? jrow.get("CQI_PDF_12").toString() : "0")); PDFrow.createCell(20).setCellValue(Double .parseDouble(jrow.containsKey("CQI_PDF_13") ? jrow.get("CQI_PDF_13").toString() : "0")); PDFrow.createCell(21).setCellValue(Double .parseDouble(jrow.containsKey("CQI_PDF_14") ? jrow.get("CQI_PDF_14").toString() : "0")); PDFrow.createCell(22).setCellValue(Double .parseDouble(jrow.containsKey("CQI_PDF_15") ? jrow.get("CQI_PDF_15").toString() : "0")); CDFrow.createCell(7).setCellValue(Double .parseDouble(jrow.containsKey("CQI_CDF_00") ? jrow.get("CQI_CDF_00").toString() : "0")); CDFrow.createCell(8).setCellValue(Double .parseDouble(jrow.containsKey("CQI_CDF_01") ? jrow.get("CQI_CDF_01").toString() : "0")); CDFrow.createCell(9).setCellValue(Double .parseDouble(jrow.containsKey("CQI_CDF_02") ? jrow.get("CQI_CDF_02").toString() : "0")); CDFrow.createCell(10).setCellValue(Double .parseDouble(jrow.containsKey("CQI_CDF_03") ? jrow.get("CQI_CDF_03").toString() : "0")); CDFrow.createCell(11).setCellValue(Double .parseDouble(jrow.containsKey("CQI_CDF_04") ? jrow.get("CQI_CDF_04").toString() : "0")); CDFrow.createCell(12).setCellValue(Double .parseDouble(jrow.containsKey("CQI_CDF_05") ? jrow.get("CQI_CDF_05").toString() : "0")); CDFrow.createCell(13).setCellValue(Double .parseDouble(jrow.containsKey("CQI_CDF_06") ? jrow.get("CQI_CDF_06").toString() : "0")); CDFrow.createCell(14).setCellValue(Double .parseDouble(jrow.containsKey("CQI_CDF_07") ? jrow.get("CQI_CDF_07").toString() : "0")); CDFrow.createCell(15).setCellValue(Double .parseDouble(jrow.containsKey("CQI_CDF_08") ? jrow.get("CQI_CDF_08").toString() : "0")); CDFrow.createCell(16).setCellValue(Double .parseDouble(jrow.containsKey("CQI_CDF_09") ? jrow.get("CQI_CDF_09").toString() : "0")); CDFrow.createCell(17).setCellValue(Double .parseDouble(jrow.containsKey("CQI_CDF_10") ? jrow.get("CQI_CDF_10").toString() : "0")); CDFrow.createCell(18).setCellValue(Double .parseDouble(jrow.containsKey("CQI_CDF_11") ? jrow.get("CQI_CDF_11").toString() : "0")); CDFrow.createCell(19).setCellValue(Double .parseDouble(jrow.containsKey("CQI_CDF_12") ? jrow.get("CQI_CDF_12").toString() : "0")); CDFrow.createCell(20).setCellValue(Double .parseDouble(jrow.containsKey("CQI_CDF_13") ? jrow.get("CQI_CDF_13").toString() : "0")); CDFrow.createCell(21).setCellValue(Double .parseDouble(jrow.containsKey("CQI_CDF_14") ? jrow.get("CQI_CDF_14").toString() : "0")); CDFrow.createCell(22).setCellValue(Double .parseDouble(jrow.containsKey("CQI_CDF_15") ? jrow.get("CQI_CDF_15").toString() : "0")); i++; } String writeFolderPath = (String) super.properties.get("TEMP_FOLDER_PATH"); String tempFolder = "/" + UUID.randomUUID().toString(); String xlsFileName = "/DownLinkCQI(PDF_CDF).xls"; if (!(new File(writeFolderPath + tempFolder)).mkdir()) { throw new Exception("? ?? ."); } String xlsFileFullPath = writeFolderPath + tempFolder + xlsFileName; fileOut = new FileOutputStream(xlsFileFullPath); wb.write(fileOut); this.msg = "? ? ?"; this.status = "SUCCESS"; this.downloadurl = "download" + tempFolder + xlsFileName; } catch (Exception e) { this.msg = e.getMessage(); this.status = "ERROR"; this.error = true; if (session != null) { session.rollback(); } e.printStackTrace(); } finally { try { if (fileOut != null) fileOut.close(); } catch (IOException e) { e.printStackTrace(); } if (session != null) { session.close(); } } this.log.debug("selectDailyCellTrafficCQIExcelDownload End"); return SUCCESS; }
From source file:com.skt.adcas.lte.action.DownLinkByNMSAction.java
private void makeTrafficSheet(Workbook wb, String safeName, Map map) { //sheet /*from w ww . j a v a2s . c o m*/ Sheet sheet = wb.createSheet(safeName); //header ? Row hrow0 = sheet.createRow((short) 0); hrow0.setHeightInPoints(20); createCell(wb, hrow0, (short) 0, CellStyle.ALIGN_CENTER, CellStyle.VERTICAL_CENTER, ""); createCell(wb, hrow0, (short) 1, CellStyle.ALIGN_CENTER, CellStyle.VERTICAL_CENTER, ""); // "MB_TIME" createCell(wb, hrow0, (short) 2, CellStyle.ALIGN_CENTER, CellStyle.VERTICAL_CENTER, "DU"); // "BTS_NM" createCell(wb, hrow0, (short) 3, CellStyle.ALIGN_CENTER, CellStyle.VERTICAL_CENTER, "CELL ID"); // "CELL_ID" createCell(wb, hrow0, (short) 4, CellStyle.ALIGN_CENTER, CellStyle.VERTICAL_CENTER, "CELL "); // "CELL_NM" createCell(wb, hrow0, (short) 5, CellStyle.ALIGN_CENTER, CellStyle.VERTICAL_CENTER, "MCID"); // "MCID" createCell(wb, hrow0, (short) 6, CellStyle.ALIGN_CENTER, CellStyle.VERTICAL_CENTER, ""); // "FREQ_KIND" createCell(wb, hrow0, (short) 7, CellStyle.ALIGN_CENTER, CellStyle.VERTICAL_CENTER, "MIMO"); // "MIMO_TYPE" createCell(wb, hrow0, (short) 8, CellStyle.ALIGN_CENTER, CellStyle.VERTICAL_CENTER, "(Mbps)"); // "THROUGHPUT" createCell(wb, hrow0, (short) 9, CellStyle.ALIGN_CENTER, CellStyle.VERTICAL_CENTER, "CQI ?"); // "CQI_AVERAGE" createCell(wb, hrow0, (short) 10, CellStyle.ALIGN_CENTER, CellStyle.VERTICAL_CENTER, "CQI0 (%)"); // "RI_RATE" createCell(wb, hrow0, (short) 11, CellStyle.ALIGN_CENTER, CellStyle.VERTICAL_CENTER, "RI2 (%)"); // createCell(wb, hrow0, (short) 12, CellStyle.ALIGN_CENTER, CellStyle.VERTICAL_CENTER, "DL PRB(%)"); // createCell(wb, hrow0, (short) 13, CellStyle.ALIGN_CENTER, CellStyle.VERTICAL_CENTER, "MCS?"); //SS createCell(wb, hrow0, (short) 14, CellStyle.ALIGN_CENTER, CellStyle.VERTICAL_CENTER, "RSSI"); //SS createCell(wb, hrow0, (short) 15, CellStyle.ALIGN_CENTER, CellStyle.VERTICAL_CENTER, "RSSI"); //SS createCell(wb, hrow0, (short) 16, CellStyle.ALIGN_CENTER, CellStyle.VERTICAL_CENTER, "MIMO "); // ELG createCell(wb, hrow0, (short) 17, CellStyle.ALIGN_CENTER, CellStyle.VERTICAL_CENTER, "DL Throughput(kbps)");// ELG createCell(wb, hrow0, (short) 18, CellStyle.ALIGN_CENTER, CellStyle.VERTICAL_CENTER, "License "); // ELG createCell(wb, hrow0, (short) 19, CellStyle.ALIGN_CENTER, CellStyle.VERTICAL_CENTER, "OL MIMO (%)"); //NSN createCell(wb, hrow0, (short) 20, CellStyle.ALIGN_CENTER, CellStyle.VERTICAL_CENTER, "MCS0 (%)"); //NSN createCell(wb, hrow0, (short) 21, CellStyle.ALIGN_CENTER, CellStyle.VERTICAL_CENTER, "RSSI"); //NSN createCell(wb, hrow0, (short) 22, CellStyle.ALIGN_CENTER, CellStyle.VERTICAL_CENTER, "RSSI"); //NSN createCell(wb, hrow0, (short) 23, CellStyle.ALIGN_CENTER, CellStyle.VERTICAL_CENTER, "RSSI"); //NSN createCell(wb, hrow0, (short) 24, CellStyle.ALIGN_CENTER, CellStyle.VERTICAL_CENTER, "RSSI"); //NSN createCell(wb, hrow0, (short) 25, CellStyle.ALIGN_CENTER, CellStyle.VERTICAL_CENTER, "??"); createCell(wb, hrow0, (short) 26, CellStyle.ALIGN_CENTER, CellStyle.VERTICAL_CENTER, "??"); createCell(wb, hrow0, (short) 27, CellStyle.ALIGN_CENTER, CellStyle.VERTICAL_CENTER, "??"); createCell(wb, hrow0, (short) 28, CellStyle.ALIGN_CENTER, CellStyle.VERTICAL_CENTER, "??"); createCell(wb, hrow0, (short) 29, CellStyle.ALIGN_CENTER, CellStyle.VERTICAL_CENTER, "??"); createCell(wb, hrow0, (short) 30, CellStyle.ALIGN_CENTER, CellStyle.VERTICAL_CENTER, "??"); createCell(wb, hrow0, (short) 31, CellStyle.ALIGN_CENTER, CellStyle.VERTICAL_CENTER, "??"); createCell(wb, hrow0, (short) 32, CellStyle.ALIGN_CENTER, CellStyle.VERTICAL_CENTER, "??"); createCell(wb, hrow0, (short) 33, CellStyle.ALIGN_CENTER, CellStyle.VERTICAL_CENTER, "HD Voice"); createCell(wb, hrow0, (short) 34, CellStyle.ALIGN_CENTER, CellStyle.VERTICAL_CENTER, "HD Voice"); createCell(wb, hrow0, (short) 35, CellStyle.ALIGN_CENTER, CellStyle.VERTICAL_CENTER, "HD Voice"); createCell(wb, hrow0, (short) 36, CellStyle.ALIGN_CENTER, CellStyle.VERTICAL_CENTER, "HD Voice"); createCell(wb, hrow0, (short) 37, CellStyle.ALIGN_CENTER, CellStyle.VERTICAL_CENTER, "??"); createCell(wb, hrow0, (short) 38, CellStyle.ALIGN_CENTER, CellStyle.VERTICAL_CENTER, "??"); createCell(wb, hrow0, (short) 39, CellStyle.ALIGN_CENTER, CellStyle.VERTICAL_CENTER, "??"); createCell(wb, hrow0, (short) 40, CellStyle.ALIGN_CENTER, CellStyle.VERTICAL_CENTER, "??"); createCell(wb, hrow0, (short) 41, CellStyle.ALIGN_CENTER, CellStyle.VERTICAL_CENTER, ""); createCell(wb, hrow0, (short) 42, CellStyle.ALIGN_CENTER, CellStyle.VERTICAL_CENTER, ""); Row hrow1 = sheet.createRow((short) 1); hrow1.setHeightInPoints(20); createCell(wb, hrow1, (short) 0, CellStyle.ALIGN_CENTER, CellStyle.VERTICAL_CENTER, ""); createCell(wb, hrow1, (short) 1, CellStyle.ALIGN_CENTER, CellStyle.VERTICAL_CENTER, ""); // "MB_TIME" createCell(wb, hrow1, (short) 2, CellStyle.ALIGN_CENTER, CellStyle.VERTICAL_CENTER, "DU"); // "BTS_NM" createCell(wb, hrow1, (short) 3, CellStyle.ALIGN_CENTER, CellStyle.VERTICAL_CENTER, "CELL ID"); // "CELL_ID" createCell(wb, hrow1, (short) 4, CellStyle.ALIGN_CENTER, CellStyle.VERTICAL_CENTER, "CELL "); // "CELL_NM" createCell(wb, hrow1, (short) 5, CellStyle.ALIGN_CENTER, CellStyle.VERTICAL_CENTER, "MCID"); // "MCID" createCell(wb, hrow1, (short) 6, CellStyle.ALIGN_CENTER, CellStyle.VERTICAL_CENTER, ""); // "FREQ_KIND" createCell(wb, hrow1, (short) 7, CellStyle.ALIGN_CENTER, CellStyle.VERTICAL_CENTER, "MIMO"); // "MIMO_TYPE" createCell(wb, hrow1, (short) 8, CellStyle.ALIGN_CENTER, CellStyle.VERTICAL_CENTER, "(Mbps)"); // "THROUGHPUT" createCell(wb, hrow1, (short) 9, CellStyle.ALIGN_CENTER, CellStyle.VERTICAL_CENTER, "CQI ?"); // "CQI_AVERAGE" createCell(wb, hrow1, (short) 10, CellStyle.ALIGN_CENTER, CellStyle.VERTICAL_CENTER, "CQI0 (%)"); // "RI_RATE" createCell(wb, hrow1, (short) 11, CellStyle.ALIGN_CENTER, CellStyle.VERTICAL_CENTER, "RI2 (%)"); // createCell(wb, hrow1, (short) 12, CellStyle.ALIGN_CENTER, CellStyle.VERTICAL_CENTER, "DL PRB(%)"); // createCell(wb, hrow1, (short) 13, CellStyle.ALIGN_CENTER, CellStyle.VERTICAL_CENTER, "MCS?"); //SS createCell(wb, hrow1, (short) 14, CellStyle.ALIGN_CENTER, CellStyle.VERTICAL_CENTER, ""); //SS createCell(wb, hrow1, (short) 15, CellStyle.ALIGN_CENTER, CellStyle.VERTICAL_CENTER, ""); //SS createCell(wb, hrow1, (short) 16, CellStyle.ALIGN_CENTER, CellStyle.VERTICAL_CENTER, "MIMO "); // ELG createCell(wb, hrow1, (short) 17, CellStyle.ALIGN_CENTER, CellStyle.VERTICAL_CENTER, "DL Throughput(kbps)");// ELG createCell(wb, hrow1, (short) 18, CellStyle.ALIGN_CENTER, CellStyle.VERTICAL_CENTER, "License "); // ELG createCell(wb, hrow1, (short) 19, CellStyle.ALIGN_CENTER, CellStyle.VERTICAL_CENTER, "OL MIMO (%)"); //NSN createCell(wb, hrow1, (short) 20, CellStyle.ALIGN_CENTER, CellStyle.VERTICAL_CENTER, "MCS0 (%)"); //NSN createCell(wb, hrow1, (short) 21, CellStyle.ALIGN_CENTER, CellStyle.VERTICAL_CENTER, "PUCCH"); //NSN createCell(wb, hrow1, (short) 22, CellStyle.ALIGN_CENTER, CellStyle.VERTICAL_CENTER, "PUCCH"); //NSN createCell(wb, hrow1, (short) 23, CellStyle.ALIGN_CENTER, CellStyle.VERTICAL_CENTER, "PUSCH"); //NSN createCell(wb, hrow1, (short) 24, CellStyle.ALIGN_CENTER, CellStyle.VERTICAL_CENTER, "PUSCH"); //NSN createCell(wb, hrow1, (short) 25, CellStyle.ALIGN_CENTER, CellStyle.VERTICAL_CENTER, "(MB)"); createCell(wb, hrow1, (short) 26, CellStyle.ALIGN_CENTER, CellStyle.VERTICAL_CENTER, "PRB(%)"); createCell(wb, hrow1, (short) 27, CellStyle.ALIGN_CENTER, CellStyle.VERTICAL_CENTER, "DPR(%)"); createCell(wb, hrow1, (short) 28, CellStyle.ALIGN_CENTER, CellStyle.VERTICAL_CENTER, "??(Erl)"); createCell(wb, hrow1, (short) 29, CellStyle.ALIGN_CENTER, CellStyle.VERTICAL_CENTER, "?"); createCell(wb, hrow1, (short) 30, CellStyle.ALIGN_CENTER, CellStyle.VERTICAL_CENTER, "?(%)"); createCell(wb, hrow1, (short) 31, CellStyle.ALIGN_CENTER, CellStyle.VERTICAL_CENTER, "CD(%)"); createCell(wb, hrow1, (short) 32, CellStyle.ALIGN_CENTER, CellStyle.VERTICAL_CENTER, "FA(%)"); createCell(wb, hrow1, (short) 33, CellStyle.ALIGN_CENTER, CellStyle.VERTICAL_CENTER, "(MB)"); createCell(wb, hrow1, (short) 34, CellStyle.ALIGN_CENTER, CellStyle.VERTICAL_CENTER, "PRB (%)"); createCell(wb, hrow1, (short) 35, CellStyle.ALIGN_CENTER, CellStyle.VERTICAL_CENTER, "?"); createCell(wb, hrow1, (short) 36, CellStyle.ALIGN_CENTER, CellStyle.VERTICAL_CENTER, "?"); createCell(wb, hrow1, (short) 37, CellStyle.ALIGN_CENTER, CellStyle.VERTICAL_CENTER, " (MB)"); createCell(wb, hrow1, (short) 38, CellStyle.ALIGN_CENTER, CellStyle.VERTICAL_CENTER, "PRB(%)"); createCell(wb, hrow1, (short) 39, CellStyle.ALIGN_CENTER, CellStyle.VERTICAL_CENTER, "?"); createCell(wb, hrow1, (short) 40, CellStyle.ALIGN_CENTER, CellStyle.VERTICAL_CENTER, "?"); createCell(wb, hrow1, (short) 41, CellStyle.ALIGN_CENTER, CellStyle.VERTICAL_CENTER, ""); createCell(wb, hrow1, (short) 42, CellStyle.ALIGN_CENTER, CellStyle.VERTICAL_CENTER, ""); Row hrow2 = sheet.createRow((short) 2); hrow2.setHeightInPoints(20); createCell(wb, hrow2, (short) 0, CellStyle.ALIGN_CENTER, CellStyle.VERTICAL_CENTER, ""); createCell(wb, hrow2, (short) 1, CellStyle.ALIGN_CENTER, CellStyle.VERTICAL_CENTER, ""); // "MB_TIME" createCell(wb, hrow2, (short) 2, CellStyle.ALIGN_CENTER, CellStyle.VERTICAL_CENTER, "DU"); // "BTS_NM" createCell(wb, hrow2, (short) 3, CellStyle.ALIGN_CENTER, CellStyle.VERTICAL_CENTER, "CELL ID"); // "CELL_ID" createCell(wb, hrow2, (short) 4, CellStyle.ALIGN_CENTER, CellStyle.VERTICAL_CENTER, "CELL "); // "CELL_NM" createCell(wb, hrow2, (short) 5, CellStyle.ALIGN_CENTER, CellStyle.VERTICAL_CENTER, "MCID"); // "MCID" createCell(wb, hrow2, (short) 6, CellStyle.ALIGN_CENTER, CellStyle.VERTICAL_CENTER, ""); // "FREQ_KIND" createCell(wb, hrow2, (short) 7, CellStyle.ALIGN_CENTER, CellStyle.VERTICAL_CENTER, "MIMO"); // "MIMO_TYPE" createCell(wb, hrow2, (short) 8, CellStyle.ALIGN_CENTER, CellStyle.VERTICAL_CENTER, "(Mbps)"); // "THROUGHPUT" createCell(wb, hrow2, (short) 9, CellStyle.ALIGN_CENTER, CellStyle.VERTICAL_CENTER, "CQI ?"); // "CQI_AVERAGE" createCell(wb, hrow2, (short) 10, CellStyle.ALIGN_CENTER, CellStyle.VERTICAL_CENTER, "CQI0 (%)"); // "RI_RATE" createCell(wb, hrow2, (short) 11, CellStyle.ALIGN_CENTER, CellStyle.VERTICAL_CENTER, "RI2 (%)"); createCell(wb, hrow2, (short) 12, CellStyle.ALIGN_CENTER, CellStyle.VERTICAL_CENTER, "DL PRB(%)"); createCell(wb, hrow2, (short) 13, CellStyle.ALIGN_CENTER, CellStyle.VERTICAL_CENTER, "MCS?"); //SS createCell(wb, hrow2, (short) 14, CellStyle.ALIGN_CENTER, CellStyle.VERTICAL_CENTER, "RSSI "); //SS createCell(wb, hrow2, (short) 15, CellStyle.ALIGN_CENTER, CellStyle.VERTICAL_CENTER, "RSSI "); //SS createCell(wb, hrow2, (short) 16, CellStyle.ALIGN_CENTER, CellStyle.VERTICAL_CENTER, "MIMO "); // ELG createCell(wb, hrow2, (short) 17, CellStyle.ALIGN_CENTER, CellStyle.VERTICAL_CENTER, "DL Throughput(kbps)");// ELG createCell(wb, hrow2, (short) 18, CellStyle.ALIGN_CENTER, CellStyle.VERTICAL_CENTER, "License "); // ELG createCell(wb, hrow2, (short) 19, CellStyle.ALIGN_CENTER, CellStyle.VERTICAL_CENTER, "OL MIMO (%)"); //NSN createCell(wb, hrow2, (short) 20, CellStyle.ALIGN_CENTER, CellStyle.VERTICAL_CENTER, "MCS0 (%)"); //NSN createCell(wb, hrow2, (short) 21, CellStyle.ALIGN_CENTER, CellStyle.VERTICAL_CENTER, ""); //NSN createCell(wb, hrow2, (short) 22, CellStyle.ALIGN_CENTER, CellStyle.VERTICAL_CENTER, ""); //NSN createCell(wb, hrow2, (short) 23, CellStyle.ALIGN_CENTER, CellStyle.VERTICAL_CENTER, ""); //NSN createCell(wb, hrow2, (short) 24, CellStyle.ALIGN_CENTER, CellStyle.VERTICAL_CENTER, ""); //NSN createCell(wb, hrow2, (short) 25, CellStyle.ALIGN_CENTER, CellStyle.VERTICAL_CENTER, "(MB)"); createCell(wb, hrow2, (short) 26, CellStyle.ALIGN_CENTER, CellStyle.VERTICAL_CENTER, "PRB(%)"); createCell(wb, hrow2, (short) 27, CellStyle.ALIGN_CENTER, CellStyle.VERTICAL_CENTER, "DPR(%)"); createCell(wb, hrow2, (short) 28, CellStyle.ALIGN_CENTER, CellStyle.VERTICAL_CENTER, "??(Erl)"); createCell(wb, hrow2, (short) 29, CellStyle.ALIGN_CENTER, CellStyle.VERTICAL_CENTER, "?"); createCell(wb, hrow2, (short) 30, CellStyle.ALIGN_CENTER, CellStyle.VERTICAL_CENTER, "?(%)"); createCell(wb, hrow2, (short) 31, CellStyle.ALIGN_CENTER, CellStyle.VERTICAL_CENTER, "CD(%)"); createCell(wb, hrow2, (short) 32, CellStyle.ALIGN_CENTER, CellStyle.VERTICAL_CENTER, "FA(%)"); createCell(wb, hrow2, (short) 33, CellStyle.ALIGN_CENTER, CellStyle.VERTICAL_CENTER, "(MB)"); createCell(wb, hrow2, (short) 34, CellStyle.ALIGN_CENTER, CellStyle.VERTICAL_CENTER, "PRB (%)"); createCell(wb, hrow2, (short) 35, CellStyle.ALIGN_CENTER, CellStyle.VERTICAL_CENTER, "?"); createCell(wb, hrow2, (short) 36, CellStyle.ALIGN_CENTER, CellStyle.VERTICAL_CENTER, "?"); createCell(wb, hrow2, (short) 37, CellStyle.ALIGN_CENTER, CellStyle.VERTICAL_CENTER, " (MB)"); createCell(wb, hrow2, (short) 38, CellStyle.ALIGN_CENTER, CellStyle.VERTICAL_CENTER, "PRB(%)"); createCell(wb, hrow2, (short) 39, CellStyle.ALIGN_CENTER, CellStyle.VERTICAL_CENTER, "?"); createCell(wb, hrow2, (short) 40, CellStyle.ALIGN_CENTER, CellStyle.VERTICAL_CENTER, "?"); createCell(wb, hrow2, (short) 41, CellStyle.ALIGN_CENTER, CellStyle.VERTICAL_CENTER, ""); createCell(wb, hrow2, (short) 42, CellStyle.ALIGN_CENTER, CellStyle.VERTICAL_CENTER, ""); sheet.addMergedRegion(new CellRangeAddress(0, 2, 0, 0)); // (""); sheet.addMergedRegion(new CellRangeAddress(0, 2, 1, 1)); // (""); sheet.addMergedRegion(new CellRangeAddress(0, 2, 2, 2)); // ("DU"); sheet.addMergedRegion(new CellRangeAddress(0, 2, 3, 3)); // ("CELL ID"); sheet.addMergedRegion(new CellRangeAddress(0, 2, 4, 4)); // ("CELL "); sheet.addMergedRegion(new CellRangeAddress(0, 2, 5, 5)); // ("MCID"); sheet.addMergedRegion(new CellRangeAddress(0, 2, 6, 6)); // (""); sheet.addMergedRegion(new CellRangeAddress(0, 2, 7, 7)); // ("MIMO "); sheet.addMergedRegion(new CellRangeAddress(0, 2, 8, 8)); // ("(Mbps)"); sheet.addMergedRegion(new CellRangeAddress(0, 2, 9, 9)); // ("CQI ?"); sheet.addMergedRegion(new CellRangeAddress(0, 2, 10, 10)); // ("CQI0 (%)"); sheet.addMergedRegion(new CellRangeAddress(0, 2, 11, 11)); // ("RI2 (%)"); sheet.addMergedRegion(new CellRangeAddress(0, 2, 12, 12)); // ("DL PRB(%)"); sheet.addMergedRegion(new CellRangeAddress(0, 2, 13, 13)); // ("MCS?"); sheet.addMergedRegion(new CellRangeAddress(0, 0, 14, 15)); // ("RSSI"); //ss sheet.addMergedRegion(new CellRangeAddress(1, 2, 14, 14)); // (""); //ss sheet.addMergedRegion(new CellRangeAddress(1, 2, 15, 15)); // (""); //ss sheet.addMergedRegion(new CellRangeAddress(0, 2, 16, 16)); // ("MIMO "); // ELG sheet.addMergedRegion(new CellRangeAddress(0, 2, 17, 17)); // ("DL Throughput(kbps)");// ELG sheet.addMergedRegion(new CellRangeAddress(0, 2, 18, 18)); // ("License "); // ELG sheet.addMergedRegion(new CellRangeAddress(0, 2, 19, 19)); // ("OL MIMO (%)"); //NSN sheet.addMergedRegion(new CellRangeAddress(0, 2, 20, 20)); // ("MCS0 (%)"); //NSN sheet.addMergedRegion(new CellRangeAddress(0, 0, 21, 24)); // RSSI //NSN sheet.addMergedRegion(new CellRangeAddress(1, 1, 21, 22)); // RSSI - PUCCH //NSN ? sheet.addMergedRegion(new CellRangeAddress(1, 1, 23, 24)); // RSSI - PUSCH //NSN ? // 4 sheet.addMergedRegion(new CellRangeAddress(0, 0, 25, 32)); //?? sheet.addMergedRegion(new CellRangeAddress(1, 2, 25, 25)); // ?? - ("(MB)"); sheet.addMergedRegion(new CellRangeAddress(1, 2, 26, 26)); // ?? - ("PRB(%)"); sheet.addMergedRegion(new CellRangeAddress(1, 2, 27, 27)); // ?? - ("DPR(%)"); sheet.addMergedRegion(new CellRangeAddress(1, 2, 28, 28)); // ?? - ("??(Erl)"); sheet.addMergedRegion(new CellRangeAddress(1, 2, 29, 29)); // ?? - ("?"); sheet.addMergedRegion(new CellRangeAddress(1, 2, 30, 30)); // ?? - ("?(%)"); sheet.addMergedRegion(new CellRangeAddress(1, 2, 31, 31)); // ?? - ("CD(%)"); sheet.addMergedRegion(new CellRangeAddress(1, 2, 32, 32)); // ?? - ("FA(%)"); sheet.addMergedRegion(new CellRangeAddress(0, 0, 33, 36)); // HD Voice sheet.addMergedRegion(new CellRangeAddress(1, 2, 33, 33)); // HD Voice - ("(MB)"); sheet.addMergedRegion(new CellRangeAddress(1, 2, 34, 34)); // HD Voice - ("PRB (%)"); sheet.addMergedRegion(new CellRangeAddress(1, 2, 35, 35)); // HD Voice - ("?"); sheet.addMergedRegion(new CellRangeAddress(1, 2, 36, 36)); // HD Voice - ("?"); sheet.addMergedRegion(new CellRangeAddress(0, 0, 37, 40)); //?? sheet.addMergedRegion(new CellRangeAddress(1, 2, 37, 37)); // sheet.addMergedRegion(new CellRangeAddress(1, 2, 38, 38)); // sheet.addMergedRegion(new CellRangeAddress(1, 2, 39, 39)); // sheet.addMergedRegion(new CellRangeAddress(1, 2, 40, 40)); // sheet.addMergedRegion(new CellRangeAddress(0, 0, 41, 42)); // sheet.addMergedRegion(new CellRangeAddress(1, 2, 41, 41)); // sheet.addMergedRegion(new CellRangeAddress(1, 2, 42, 42)); // String _MFC_CD = "MFC00001"; ArrayList list01 = (ArrayList) map.get("rows"); Iterator iterator = (Iterator) list01.iterator(); short i = 3; while (iterator.hasNext()) { StringMap jrow = (StringMap) iterator.next(); if (i == 3) { _MFC_CD = jrow.containsKey("MFC_CD") ? jrow.get("MFC_CD").toString() : "MFC00001"; // hieddn if (_MFC_CD.equals("MFC00001")) { // ? // sheet.setColumnHidden(13,true); // sheet.setColumnHidden(14,true); // sheet.setColumnHidden(15,true); sheet.setColumnHidden(16, true); sheet.setColumnHidden(17, true); sheet.setColumnHidden(18, true); sheet.setColumnHidden(19, true); sheet.setColumnHidden(20, true); sheet.setColumnHidden(21, true); sheet.setColumnHidden(22, true); sheet.setColumnHidden(23, true); sheet.setColumnHidden(24, true); } else if (_MFC_CD.equals("MFC00002")) { sheet.setColumnHidden(13, true); sheet.setColumnHidden(14, true); sheet.setColumnHidden(15, true); // sheet.setColumnHidden(16,true); // sheet.setColumnHidden(17,true); // sheet.setColumnHidden(18,true); sheet.setColumnHidden(19, true); sheet.setColumnHidden(20, true); // sheet.setColumnHidden(21,true); // sheet.setColumnHidden(22,true); // sheet.setColumnHidden(23,true); // sheet.setColumnHidden(24,true); } else if (_MFC_CD.equals("MFC00014")) { sheet.setColumnHidden(13, true); sheet.setColumnHidden(14, true); sheet.setColumnHidden(15, true); sheet.setColumnHidden(16, true); sheet.setColumnHidden(17, true); sheet.setColumnHidden(18, true); // sheet.setColumnHidden(19,true); // sheet.setColumnHidden(20,true); // sheet.setColumnHidden(21,true); // sheet.setColumnHidden(22,true); // sheet.setColumnHidden(23,true); // sheet.setColumnHidden(24,true); } } // Row row = sheet.createRow((short) i); row.setHeightInPoints(20); row.createCell(0).setCellValue((String) jrow.get("YMD")); row.createCell(1).setCellValue((String) jrow.get("MB_TIME")); row.createCell(2).setCellValue((String) jrow.get("BTS_NM")); row.createCell(3).setCellValue((String) jrow.get("CELL_ID")); row.createCell(4).setCellValue((String) jrow.get("CELL_NM")); row.createCell(5).setCellValue((String) jrow.get("MCID")); row.createCell(6).setCellValue((String) jrow.get("FREQ_KIND")); row.createCell(7).setCellValue(jrow.containsKey("MIMO_TYPE") ? jrow.get("MIMO_TYPE").toString() : "-"); // "); // "MIMO_TYPE" //? setCellDoubleIfExistValue(row.createCell(8), jrow, "THROUGHPUT"); // (Mbps)"); // "THROUGHPUT" setCellDoubleIfExistValue(row.createCell(9), jrow, "CQI_AVERAGE"); // CQI ?"); // "CQI_AVERAGE" setCellDoubleIfExistValue(row.createCell(10), jrow, "CQI0_RATE"); // CQI0 (%)"); // "RI_RATE" setCellDoubleIfExistValue(row.createCell(11), jrow, "RI_RATE"); // RI2 (%)"); setCellDoubleIfExistValue(row.createCell(12), jrow, "DL_PRB_RATE"); // DL PRB(%)"); /**/ setCellDoubleIfExistValue(row.createCell(13), jrow, "MCS_AVERAGE"); // MCS?"); //SS setCellDoubleIfExistValue(row.createCell(14), jrow, "RSSI"); // RSSI "); //SS setCellDoubleIfExistValue(row.createCell(15), jrow, "R2_RSSI"); // RSSI "); //SS setCellDoubleIfExistValue(row.createCell(16), jrow, "MIMO_RATE"); // MIMO "); // ELG setCellDoubleIfExistValue(row.createCell(17), jrow, "DL_THROUGHPUT"); // DL Throughput(kbps)"); // ELG setCellDoubleIfExistValue(row.createCell(18), jrow, "LICENSE_FAIL"); // License "); // ELG setCellDoubleIfExistValue(row.createCell(19), jrow, "MIMO_RATE"); // OL MIMO (%)"); //ELG + NSN setCellDoubleIfExistValue(row.createCell(20), jrow, "MCS_AVERAGE"); // MCS0 (%)"); //ELG + NSN setCellDoubleIfExistValue(row.createCell(21), jrow, "PUCCH_AVG"); // RSSI PUCCH "); //ELG + NSN setCellDoubleIfExistValue(row.createCell(22), jrow, "R2_PUCCH_AVG"); // RSSI PUCCH "); //NSN setCellDoubleIfExistValue(row.createCell(23), jrow, "PUSCH_AVG"); // RSSI PUSCH "); //NSN setCellDoubleIfExistValue(row.createCell(24), jrow, "R2_PUSCH_AVG"); // RSSI PUSCH "); //NSN /**/ setCellDoubleIfExistValue(row.createCell(25), jrow, "PDCP_DL_MB"); // ?? (MB)"); setCellDoubleIfExistValue(row.createCell(26), jrow, "PRB_USG_RATE"); // ?? PRB(%)"); setCellDoubleIfExistValue(row.createCell(27), jrow, "DRB_USG_RATE"); // ?? DPR(%)"); setCellDoubleIfExistValue(row.createCell(28), jrow, "CON_TIME"); // ?? ??(Erl)"); setCellDoubleIfExistValue(row.createCell(29), jrow, "TRY_CCNT"); // ?? ?"); setCellDoubleIfExistValue(row.createCell(30), jrow, "CON_RATE"); // ?? ?(%)"); setCellDoubleIfExistValue(row.createCell(31), jrow, "CDC_RATE"); // ?? CD(%)"); setCellDoubleIfExistValue(row.createCell(32), jrow, "DL_FA_USG_RATE"); //?? FA(%) setCellDoubleIfExistValue(row.createCell(33), jrow, "VOICE_DL_MB"); setCellDoubleIfExistValue(row.createCell(34), jrow, "VOICE_DL_PRB"); // HD Voice PRB (%)"); setCellDoubleIfExistValue(row.createCell(35), jrow, "VOICE_TRY_CCNT"); // HD Voice ?"); setCellDoubleIfExistValue(row.createCell(36), jrow, "VOICE_TIME"); // HD Voice ?"); setCellDoubleIfExistValue(row.createCell(37), jrow, "IMAGE_DL_MB"); // ?? (MB)"); setCellDoubleIfExistValue(row.createCell(38), jrow, "IMAGE_DL_PRB"); // ?? PRB(%)"); setCellDoubleIfExistValue(row.createCell(39), jrow, "IMAGE_TRY_CCNT"); // ?? ?"); setCellDoubleIfExistValue(row.createCell(40), jrow, "IMAGE_TIME"); // ?? ?"); row.createCell(41).setCellValue((String) jrow.get("CHNL_TYPE")); // "); setCellDoubleIfExistValue(row.createCell(42), jrow, "CHNL_COUNT"); // "); i++; } }
From source file:com.skt.adcas.lte.action.DownLinkByNMSStatsAction.java
public String selectCellTrafficStatsCQIExcelDownload() { this.log.debug("selectCellTrafficStatsCQIExcelDownload Start"); SqlSession session = null;/*from w w w. j ava 2 s . co m*/ FileOutputStream fileOut = null; try { //parseParam(); Type type = new TypeToken<Map<String, Object>>() { }.getType(); Gson gson = new Gson(); Map<String, Object> map = gson.fromJson(this.JSONDATA, type); log.debug("json data : " + this.JSONDATA); String searchType = this.SEARCHTYPE; log.debug("SEARCHTYPE : " + searchType); Workbook wb = new HSSFWorkbook(); //PDFsheet String sheetName = "CQI PDF"; String safeName = WorkbookUtil.createSafeSheetName(sheetName); Sheet PDFsheet = wb.createSheet(safeName); createCellTrafficStatsCQIExcelSheet(PDFsheet, "PDF", searchType, map); //CDFsheet sheetName = "CQI CDF"; safeName = WorkbookUtil.createSafeSheetName(sheetName); Sheet CDFsheet = wb.createSheet(safeName); createCellTrafficStatsCQIExcelSheet(CDFsheet, "CDF", searchType, map); String writeFolderPath = (String) super.properties.get("TEMP_FOLDER_PATH"); String tempFolder = "/" + UUID.randomUUID().toString(); String xlsFileName = "/DownLinkStatsCQI(PDF_CDF)(NMS).xls"; if (!(new File(writeFolderPath + tempFolder)).mkdir()) { throw new Exception("? ?? ."); } String xlsFileFullPath = writeFolderPath + tempFolder + xlsFileName; fileOut = new FileOutputStream(xlsFileFullPath); wb.write(fileOut); this.msg = "? ? ?"; this.status = "SUCCESS"; this.downloadurl = "download" + tempFolder + xlsFileName; } catch (Exception e) { this.msg = e.getMessage(); this.status = "ERROR"; this.error = true; if (session != null) { session.rollback(); } e.printStackTrace(); } finally { try { if (fileOut != null) fileOut.close(); } catch (IOException e) { e.printStackTrace(); } if (session != null) { session.close(); } } this.log.debug("selectCellTrafficStatsCQIExcelDownload End"); return SUCCESS; }
From source file:com.skt.adcas.lte.action.DownLinkByNMSStatsAction.java
public String selectCellTrafficStatsCompCQIExcelDownload() { this.log.debug("selectCellTrafficStatsCompCQIExcelDownload Start"); SqlSession session = null;// w ww.j a va 2s . co m FileOutputStream fileOut = null; try { //parseParam(); Type type = new TypeToken<Map<String, Object>>() { }.getType(); Gson gson = new Gson(); Map<String, Object> map = gson.fromJson(this.JSONDATA, type); Map<String, Object> mapAfter = gson.fromJson(this.JSONDATA2, type); log.debug("json data : " + this.JSONDATA); log.debug("json2 data : " + this.JSONDATA2); String searchType = this.SEARCHTYPE; log.debug("SEARCHTYPE : " + searchType); Workbook wb = new HSSFWorkbook(); //PDFsheet String sheetName = " CQI PDF"; String safeName = WorkbookUtil.createSafeSheetName(sheetName); Sheet PDFsheet = wb.createSheet(safeName); createCellTrafficStatsCQIExcelSheet(PDFsheet, "PDF", searchType, map); //CDFsheet sheetName = " CQI CDF"; safeName = WorkbookUtil.createSafeSheetName(sheetName); Sheet CDFsheet = wb.createSheet(safeName); createCellTrafficStatsCQIExcelSheet(CDFsheet, "CDF", searchType, map); //PDFsheet sheetName = " CQI PDF"; safeName = WorkbookUtil.createSafeSheetName(sheetName); Sheet PDFsheetAfter = wb.createSheet(safeName); createCellTrafficStatsCQIExcelSheet(PDFsheetAfter, "PDF", searchType, mapAfter); //CDFsheet sheetName = " CQI CDF"; safeName = WorkbookUtil.createSafeSheetName(sheetName); Sheet CDFsheetAfter = wb.createSheet(safeName); createCellTrafficStatsCQIExcelSheet(CDFsheetAfter, "CDF", searchType, mapAfter); String writeFolderPath = (String) super.properties.get("TEMP_FOLDER_PATH"); String tempFolder = "/" + UUID.randomUUID().toString(); String xlsFileName = "/DownLinkStatsCompCQI(PDF_CDF)(NMS).xls"; if (!(new File(writeFolderPath + tempFolder)).mkdir()) { throw new Exception("? ?? ."); } String xlsFileFullPath = writeFolderPath + tempFolder + xlsFileName; fileOut = new FileOutputStream(xlsFileFullPath); wb.write(fileOut); this.msg = "? ? ?"; this.status = "SUCCESS"; this.downloadurl = "download" + tempFolder + xlsFileName; } catch (Exception e) { this.msg = e.getMessage(); this.status = "ERROR"; this.error = true; if (session != null) { session.rollback(); } e.printStackTrace(); } finally { try { if (fileOut != null) fileOut.close(); } catch (IOException e) { e.printStackTrace(); } if (session != null) { session.close(); } } this.log.debug("selectCellTrafficStatsCompCQIExcelDownload End"); return SUCCESS; }
From source file:com.skt.adcas.lte.action.DownLinkByNMSStatsAction.java
public String selectCellTrafficStatsExcelDownload() { this.log.debug("selectCellTrafficStatsExcelDownload Start"); SqlSession session = null;/*from ww w . j a va 2 s.c o m*/ FileOutputStream fileOut = null; try { //parseParam(); Type type = new TypeToken<Map<String, Object>>() { }.getType(); Gson gson = new Gson(); Map<String, Object> map = gson.fromJson(this.JSONDATA, type); log.debug("json data : " + this.JSONDATA); String searchType = this.SEARCHTYPE; Workbook wb = new HSSFWorkbook(); //CreationHelper createHelper = wb.getCreationHelper(); String sheetName = "data"; String safeName = WorkbookUtil.createSafeSheetName(sheetName); //sheet Sheet sheet = wb.createSheet(safeName); createCellTrafficStatsExcelSheet(sheet, searchType, map); log.debug("selectCellTrafficStatsExcelDownload : file start"); String writeFolderPath = (String) super.properties.get("TEMP_FOLDER_PATH"); String tempFolder = "/" + UUID.randomUUID().toString(); String xlsFileName = "/DownLinkStatsData(NMS).xls"; if (!(new File(writeFolderPath + tempFolder)).mkdir()) { throw new Exception("? ?? ."); } String xlsFileFullPath = writeFolderPath + tempFolder + xlsFileName; fileOut = new FileOutputStream(xlsFileFullPath); wb.write(fileOut); log.debug("selectCellTrafficStatsExcelDownload : file end"); this.msg = "? ? ?"; this.status = "SUCCESS"; this.downloadurl = "download" + tempFolder + xlsFileName; } catch (Exception e) { this.msg = e.getMessage(); this.status = "ERROR"; this.error = true; if (session != null) { session.rollback(); } e.printStackTrace(); } finally { try { if (fileOut != null) fileOut.close(); } catch (IOException e) { e.printStackTrace(); } if (session != null) { session.close(); } } this.log.debug("selectCellTrafficStatsExcelDownload End"); return SUCCESS; }
From source file:com.skt.adcas.lte.action.DownLinkByNMSStatsAction.java
public String selectCellTrafficStatsCompExcelDownload() { this.log.debug("selectCellTrafficStatsCompExcelDownload Start"); SqlSession session = null;/*from ww w. j a v a 2 s .c o m*/ FileOutputStream fileOut = null; try { //parseParam(); Type type = new TypeToken<Map<String, Object>>() { }.getType(); Gson gson = new Gson(); Map<String, Object> map = gson.fromJson(this.JSONDATA, type); Map<String, Object> mapAfter = gson.fromJson(this.JSONDATA2, type); log.debug("json data : " + this.JSONDATA); log.debug("json2 data : " + this.JSONDATA2); String searchType = this.SEARCHTYPE; Workbook wb = new HSSFWorkbook(); //CreationHelper createHelper = wb.getCreationHelper(); //sheet String sheetName = ""; String safeName = WorkbookUtil.createSafeSheetName(sheetName); Sheet sheet = wb.createSheet(safeName); // Sheet ? createCellTrafficStatsExcelSheet(sheet, searchType, map); //After sheet sheetName = ""; safeName = WorkbookUtil.createSafeSheetName(sheetName); Sheet sheetAfter = wb.createSheet(safeName); // Sheet ? createCellTrafficStatsExcelSheet(sheetAfter, searchType, mapAfter); log.debug("selectCellTrafficStatsExcelDownload : file start"); String writeFolderPath = (String) super.properties.get("TEMP_FOLDER_PATH"); String tempFolder = "/" + UUID.randomUUID().toString(); String xlsFileName = "/DownLinkStatsCompData(NMS).xls"; if (!(new File(writeFolderPath + tempFolder)).mkdir()) { throw new Exception("? ?? ."); } String xlsFileFullPath = writeFolderPath + tempFolder + xlsFileName; fileOut = new FileOutputStream(xlsFileFullPath); wb.write(fileOut); log.debug("selectCellTrafficStatsExcelDownload : file end"); this.msg = "? ? ?"; this.status = "SUCCESS"; this.downloadurl = "download" + tempFolder + xlsFileName; } catch (Exception e) { this.msg = e.getMessage(); this.status = "ERROR"; this.error = true; if (session != null) { session.rollback(); } e.printStackTrace(); } finally { try { if (fileOut != null) fileOut.close(); } catch (IOException e) { e.printStackTrace(); } if (session != null) { session.close(); } } this.log.debug("selectCellTrafficStatsCompExcelDownload End"); return SUCCESS; }
From source file:com.skt.adcas.lte.action.DownLinkByNMSStatsAction.java
public String selectCellTrafficStatsHistogramExcelDownload() { this.log.debug("selectCellTrafficStatsHistogramExcelDownload Start"); SqlSession session = null;/* w w w . jav a2 s . c o m*/ FileOutputStream fileOut = null; try { //parseParam(); Type type = new TypeToken<Map<String, Object>>() { }.getType(); Gson gson = new Gson(); Map<String, Object> map = gson.fromJson(this.JSONDATA, type); log.debug("json data : " + this.JSONDATA); Workbook wb = new HSSFWorkbook(); //CreationHelper createHelper = wb.getCreationHelper(); String sheetName = this.FROMYMD + "~" + this.TOYMD; String safeName = WorkbookUtil.createSafeSheetName(sheetName); //sheet Sheet sheet = wb.createSheet(safeName); //header ? Row hrow0 = sheet.createRow((short) 0); hrow0.setHeightInPoints(20); hrow0.createCell(0).setCellValue("MBPS"); hrow0.createCell(1).setCellValue("COUNT"); hrow0.createCell(2).setCellValue("??"); hrow0.createCell(3).setCellValue("CDF"); StringMap categoryVal = (StringMap) map.get("categoryVal"); StringMap rVal = (StringMap) map.get("rVal"); StringMap rate = (StringMap) map.get("rate"); StringMap cdf = (StringMap) map.get("cdf"); short i = 1; for (int j = 0; j < 10; j++) { // Row row = sheet.createRow((short) i); row.setHeightInPoints(20); row.createCell(0).setCellValue(Double.parseDouble(categoryVal.get(String.valueOf(j)).toString())); row.createCell(1).setCellValue(Double.parseDouble(rVal.get(String.valueOf(j)).toString())); row.createCell(2).setCellValue(Double.parseDouble(rate.get(String.valueOf(j)).toString())); row.createCell(3).setCellValue(Double.parseDouble(cdf.get(String.valueOf(j)).toString())); i++; } log.debug("selectCellTrafficStatsHistogramExcelDownload : file start"); String writeFolderPath = (String) super.properties.get("TEMP_FOLDER_PATH"); String tempFolder = "/" + UUID.randomUUID().toString(); String xlsFileName = "/DownLinkStatsHistogram(NMS).xls"; if (!(new File(writeFolderPath + tempFolder)).mkdir()) { throw new Exception("? ?? ."); } String xlsFileFullPath = writeFolderPath + tempFolder + xlsFileName; fileOut = new FileOutputStream(xlsFileFullPath); wb.write(fileOut); log.debug("selectCellTrafficStatsHistogramExcelDownload : file end"); this.msg = "? ? ?"; this.status = "SUCCESS"; this.downloadurl = "download" + tempFolder + xlsFileName; } catch (Exception e) { this.msg = e.getMessage(); this.status = "ERROR"; this.error = true; if (session != null) { session.rollback(); } e.printStackTrace(); } finally { try { if (fileOut != null) fileOut.close(); } catch (IOException e) { e.printStackTrace(); } if (session != null) { session.close(); } } this.log.debug("selectCellTrafficStatsHistogramExcelDownload End"); return SUCCESS; }
From source file:com.skt.adcas.lte.action.DownLinkByNMSStatsAction.java
public String selectCellTrafficStatsThrpCompGraphExcelDownload() { this.log.debug("selectCellTrafficStatsThrpCompGraphExcelDownload Start"); SqlSession session = null;// ww w . j a v a2 s. c om FileOutputStream fileOut = null; try { //parseParam(); Type type = new TypeToken<Map<String, Object>>() { }.getType(); Gson gson = new Gson(); Map<String, Object> map = gson.fromJson(this.JSONDATA, type); log.debug("json data : " + this.JSONDATA); Workbook wb = new HSSFWorkbook(); //CreationHelper createHelper = wb.getCreationHelper(); String sheetName = " ?"; String safeName = WorkbookUtil.createSafeSheetName(sheetName); //sheet Sheet sheet = wb.createSheet(safeName); //header ? Row hrow0 = sheet.createRow((short) 0); hrow0.setHeightInPoints(20); hrow0.createCell(0).setCellValue(""); hrow0.createCell(1).setCellValue("(" + this.FROMYMD + ")"); hrow0.createCell(2).setCellValue("(" + this.TOYMD + ")"); StringMap categories = (StringMap) map.get("categories"); StringMap beforeSeries = (StringMap) map.get("beforeSeries"); StringMap afterSeries = (StringMap) map.get("afterSeries"); short i = 1; for (int j = 0; j < categories.size(); j++) { // Row row = sheet.createRow((short) i); row.setHeightInPoints(20); row.createCell(0) .setCellValue(categories.get(String.valueOf(j)).toString().replaceAll("<br>", " : ")); row.createCell(1).setCellValue(Double.parseDouble(beforeSeries.get(String.valueOf(j)).toString())); row.createCell(2).setCellValue(Double.parseDouble(afterSeries.get(String.valueOf(j)).toString())); i++; } log.debug("selectCellTrafficStatsThrpCompGraphExcelDownload : file start"); String writeFolderPath = (String) super.properties.get("TEMP_FOLDER_PATH"); String tempFolder = "/" + UUID.randomUUID().toString(); String xlsFileName = "/DownLinkStatsThrpCompGraph(NMS).xls"; if (!(new File(writeFolderPath + tempFolder)).mkdir()) { throw new Exception("? ?? ."); } String xlsFileFullPath = writeFolderPath + tempFolder + xlsFileName; fileOut = new FileOutputStream(xlsFileFullPath); wb.write(fileOut); log.debug("selectCellTrafficStatsThrpCompGraphExcelDownload : file end"); this.msg = "? ? ?"; this.status = "SUCCESS"; this.downloadurl = "download" + tempFolder + xlsFileName; } catch (Exception e) { this.msg = e.getMessage(); this.status = "ERROR"; this.error = true; if (session != null) { session.rollback(); } e.printStackTrace(); } finally { try { if (fileOut != null) fileOut.close(); } catch (IOException e) { e.printStackTrace(); } if (session != null) { session.close(); } } this.log.debug("selectCellTrafficStatsThrpCompGraphExcelDownload End"); return SUCCESS; }