List of usage examples for org.apache.poi.hssf.usermodel HSSFCell ENCODING_UTF_16
short ENCODING_UTF_16
To view the source code for org.apache.poi.hssf.usermodel HSSFCell ENCODING_UTF_16.
Click Source Link
From source file:com.aimluck.eip.modules.screens.ExtTimecardSummaryXlsExportScreen.java
License:Open Source License
private void setupTimecardSheet(RunData rundata, Context context, HSSFWorkbook wb) throws Exception { ExtTimecardSummaryListSelectData listData = new ExtTimecardSummaryListSelectData(); listData.init(this, rundata, context); listData.setRowsNum(1000);// w ww. j a va2s . c o m listData.doViewList(this, rundata, context); listData.setuserList(target_group_name); String sheet_name = ""; // ? String[] headers = { "???", "", "", "", "", "", "", "", "", "", "?", "", "", "", "", "???", "" }; // 01 short[] cell_enc_types = { HSSFCell.ENCODING_UTF_16, HSSFCell.CELL_TYPE_NUMERIC, HSSFCell.CELL_TYPE_NUMERIC, HSSFCell.ENCODING_UTF_16, HSSFCell.CELL_TYPE_NUMERIC, HSSFCell.CELL_TYPE_NUMERIC, HSSFCell.CELL_TYPE_NUMERIC, HSSFCell.CELL_TYPE_NUMERIC, HSSFCell.CELL_TYPE_NUMERIC, HSSFCell.CELL_TYPE_NUMERIC, HSSFCell.CELL_TYPE_NUMERIC, HSSFCell.CELL_TYPE_NUMERIC, HSSFCell.CELL_TYPE_NUMERIC, HSSFCell.CELL_TYPE_NUMERIC, HSSFCell.CELL_TYPE_NUMERIC, HSSFCell.CELL_TYPE_NUMERIC, HSSFCell.CELL_TYPE_NUMERIC }; HSSFSheet sheet = createHSSFSheet(wb, sheet_name, headers, cell_enc_types); int rowcount = 0; // ? HSSFCellStyle style_col = wb.createCellStyle(); style_col.setVerticalAlignment(HSSFCellStyle.VERTICAL_CENTER); style_col.setAlignment(HSSFCellStyle.ALIGN_JUSTIFY); ExtTimecardSummaryResultData tclistrd = null; List<ExtTimecardSummaryResultData> daykeys = listData.getGroupExtTimecards(); int daykeysize = daykeys.size(); for (int i = 0; i < daykeysize; i++) { tclistrd = daykeys.get(i); String user_name = tclistrd.getUserName();// ??? String year = view_month.substring(0, 4); // String month = view_month.substring(5); // String service_form = tclistrd.getSystemName();// String work_day = tclistrd.getWorkDay().getValueAsString(); // String work_hour = tclistrd.getWorkHour().getValueAsString();// String overtime_day = tclistrd.getOvertimeDay().getValueAsString();// String overtime_hour = tclistrd.getOvertimeHour().getValueAsString();// String off_day = tclistrd.getOffDay().getValueAsString();// String off_hour = tclistrd.getOffHour().getValueAsString();// String late_coming_day = tclistrd.getLateComingDay().getValueAsString();// ? String early_leaving_day = tclistrd.getEarlyLeavingDay().getValueAsString();// String absent_day = tclistrd.getAbsentDay().getValueAsString();// String paid_holiday = tclistrd.getPaidHoliday().getValueAsString();// String compensatory_holiday = tclistrd.getCompensatoryHoliday().getValueAsString();// String other_day = tclistrd.getOtherDay().getValueAsString();// ??? String noinput = tclistrd.getNoInput().getValueAsString();// String[] rows = { user_name, year, month, service_form, work_day, work_hour, overtime_day, overtime_hour, off_day, off_hour, late_coming_day, early_leaving_day, absent_day, paid_holiday, compensatory_holiday, other_day, noinput }; rowcount = rowcount + 1; addRow(sheet.createRow(rowcount), cell_enc_types, rows); } // int uid = ALEipUtils.getUserId(rundata); ALEventlogFactoryService.getInstance().getEventlogHandler().logXlsScreen(uid, "", ALEventlogConstants.PORTLET_TYPE_EXTTIMECARD); }
From source file:com.aimluck.eip.modules.screens.ExtTimecardXlsExportScreen.java
License:Open Source License
private void setupTimecardSheet(RunData rundata, Context context, HSSFWorkbook wb) throws Exception { ExtTimecardSelectData listData = new ExtTimecardSelectData(); listData.initField();//from w w w.j a v a 2 s. c om listData.setRowsNum(1000); listData.doViewList(this, rundata, context); String sheet_name = ""; // ? String[] headers = { "???", "", "", "", "", "", "", "", "", "", "", "", "?", "", "", "", "", "???", "??", "", "", "", "", "", "", "", "", "", "" }; // 01 short[] cell_enc_types = { HSSFCell.ENCODING_UTF_16, HSSFCell.ENCODING_UTF_16, HSSFCell.ENCODING_UTF_16, HSSFCell.ENCODING_UTF_16, HSSFCell.ENCODING_UTF_16, HSSFCell.ENCODING_UTF_16, HSSFCell.CELL_TYPE_NUMERIC, HSSFCell.CELL_TYPE_NUMERIC, HSSFCell.CELL_TYPE_NUMERIC, HSSFCell.CELL_TYPE_NUMERIC, HSSFCell.CELL_TYPE_NUMERIC, HSSFCell.CELL_TYPE_NUMERIC, HSSFCell.CELL_TYPE_NUMERIC, HSSFCell.CELL_TYPE_NUMERIC, HSSFCell.CELL_TYPE_NUMERIC, HSSFCell.CELL_TYPE_NUMERIC, HSSFCell.CELL_TYPE_NUMERIC, HSSFCell.CELL_TYPE_NUMERIC, HSSFCell.ENCODING_UTF_16, HSSFCell.ENCODING_UTF_16, HSSFCell.ENCODING_UTF_16, HSSFCell.ENCODING_UTF_16, HSSFCell.ENCODING_UTF_16, HSSFCell.ENCODING_UTF_16, HSSFCell.ENCODING_UTF_16, HSSFCell.ENCODING_UTF_16, HSSFCell.ENCODING_UTF_16, HSSFCell.ENCODING_UTF_16, HSSFCell.ENCODING_UTF_16 }; HSSFSheet sheet = createHSSFSheet(wb, sheet_name, headers, cell_enc_types); int rowcount = 0; // ? HSSFCellStyle style_col = wb.createCellStyle(); style_col.setVerticalAlignment(HSSFCellStyle.VERTICAL_CENTER); style_col.setAlignment(HSSFCellStyle.ALIGN_JUSTIFY); String user_name = ALEipUtils.getUserFullName(Integer.parseInt(listData.getTargetUserId()));// ??? String system_name = ExtTimecardUtils .getEipTExtTimecardSystemByUserId(Integer.parseInt(listData.getTargetUserId())).getSystemName(); ExtTimecardListResultData tclistrd = null; List<ExtTimecardListResultData> daykeys = listData.getDateListKeys(); int daykeysize = daykeys.size(); for (int i = 0; i < daykeysize; i++) { tclistrd = daykeys.get(i); String date = "";// String day = ""; // String service_form = system_name; // String clock_in_time = "";// String clock_out_time = "";// String work_day = "0"; // 0 or 1 String work_hour = "0";// String overtime_day = "0";// String overtime_hour = "0";// String off_day = "0";// String off_hour = "0";// String late_coming_day = "0";// ? String early_leaving_day = "0";// String absent_day = "0";// String paid_holiday = "0";// String compensatory_holiday = "0";// String other_day = "0";// ??? String remark = "";// ?? String[] out_going = new String[EipTExtTimecard.OUTGOING_COMEBACK_PER_DAY];// String[] come_back = new String[EipTExtTimecard.OUTGOING_COMEBACK_PER_DAY];// if (tclistrd.getRd() == null) { // ExtTimecardResultData rd = tclistrd.getRd(); date = tclistrd.getDateStr("yyyy/MM/dd"); day = tclistrd.getDateStr("EE"); } else { ExtTimecardResultData rd = tclistrd.getRd(); // ExtTimecardSummaryResultData srd = tclistrd.get date = tclistrd.getDateStr("yyyy/MM/dd"); day = tclistrd.getDateStr("EE"); String type = rd.getType().toString(); if (!rd.getIsNullClockInTime()) { clock_in_time = rd.getClockInTime("HH:mm"); clock_out_time = rd.getClockOutTime("HH:mm"); if (tclistrd.getWorkHour() > 0.0) { work_day = "1"; work_hour = Float.toString(tclistrd.getWorkHour()); } else { work_hour = "0"; } if (tclistrd.getOvertimeHourWithoutRestHour() > 0.0) { overtime_day = "1"; overtime_hour = Float.toString(tclistrd.getOvertimeHourWithoutRestHour()); } else { overtime_hour = "0"; } if (tclistrd.getOffHour() > 0.0) { off_day = "1"; off_hour = Float.toString(tclistrd.getOffHour()); } else { off_hour = "0"; } } if (rd.getRefixFlag().getValue() == "1") { remark = rd.getReason().getValue(); if (rd.getReasonFlg() && rd.getRemarksFlg()) { remark += "?"; } } if (rd.getRemarksFlg()) { remark += rd.getRemarks().getValue(); } late_coming_day = tclistrd.isLateComing() ? "1" : "0"; early_leaving_day = tclistrd.isEarlyLeaving() ? "1" : "0"; absent_day = type.equals(EipTExtTimecard.TYPE_ABSENT) ? "1" : "0"; paid_holiday = type.equals(EipTExtTimecard.TYPE_HOLIDAY) ? "1" : "0"; compensatory_holiday = type.equals(EipTExtTimecard.TYPE_COMPENSATORY) ? "1" : "0"; other_day = type.equals(EipTExtTimecard.TYPE_ETC) ? "1" : "0"; List<Map<String, String>> list = tclistrd.getOutgoingComeback_xls(); for (int j = 0; j < EipTExtTimecard.OUTGOING_COMEBACK_PER_DAY; j++) { Map<String, String> map = list.get(j); out_going[j] = map.get("outgoing"); come_back[j] = map.get("comeback"); } } String[] rows = { user_name, date, day, service_form, clock_in_time, clock_out_time, work_day, work_hour, overtime_day, overtime_hour, off_day, off_hour, late_coming_day, early_leaving_day, absent_day, paid_holiday, compensatory_holiday, other_day, remark, out_going[0], come_back[0], out_going[1], come_back[1], out_going[2], come_back[2], out_going[3], come_back[3], out_going[4], come_back[4] }; rowcount = rowcount + 1; addRow(sheet.createRow(rowcount), cell_enc_types, rows); } /* * rowcount = rowcount + 1; String NOTHING = null; String work_day = * "=SUM(G2:G" + rowcount + ")"; String work_hour = "=SUM(H2:H" + rowcount + * ")"; String overtime_day = "=SUM(I2:I" + rowcount + ")"; String * overtime_hour = "=SUM(J2:J" + rowcount + ")"; String off_day = * "=SUM(K2:K" + rowcount + ")"; String off_hour = "=SUM(L2:L" + rowcount + * ")"; String late_coming_day = "=SUM(M2:M" + rowcount + ")"; String * early_leaving_day = "=SUM(N2:N" + rowcount + ")"; String absent_day = * "=SUM(O2:O" + rowcount + ")"; String paid_holiday = "=SUM(P2:P" + * rowcount + ")"; String compensatory_holiday = "=SUM(Q2:Q" + rowcount + * ")"; String other_day = "=SUM(R2:R" + rowcount + ")"; String[] rows = { * NOTHING, NOTHING, NOTHING, NOTHING, NOTHING, NOTHING, work_day, * work_hour, overtime_day, overtime_hour, off_day, off_hour, * late_coming_day, early_leaving_day, absent_day, paid_holiday, * compensatory_holiday, other_day, }; * * addFooter(sheet.createRow(rowcount), cell_enc_types, rows); */ // int uid = ALEipUtils.getUserId(rundata); ALEventlogFactoryService.getInstance().getEventlogHandler().logXlsScreen(uid, "", ALEventlogConstants.PORTLET_TYPE_EXTTIMECARD); }
From source file:com.aimluck.eip.modules.screens.TimecardXlsExportScreen.java
License:Open Source License
private void setupTimecardSheet(RunData rundata, Context context, HSSFWorkbook wb) throws Exception { TimecardSelectData listData = new TimecardSelectData(); listData.initField();/*from w w w . ja v a 2 s. c om*/ listData.setRowsNum(1000); listData.doViewList(this, rundata, context); String sheet_name = ""; // ? String[] headers = { "", "?", "", "", "?" }; // 01 short[] cell_enc_types = { HSSFCell.ENCODING_UTF_16, HSSFCell.CELL_TYPE_NUMERIC, HSSFCell.ENCODING_UTF_16, HSSFCell.ENCODING_UTF_16, HSSFCell.ENCODING_UTF_16 }; HSSFSheet sheet = createHSSFSheet(wb, sheet_name, headers, cell_enc_types); int rowcount = 0; // ? HSSFCellStyle style_col = wb.createCellStyle(); style_col.setVerticalAlignment(HSSFCellStyle.VERTICAL_CENTER); style_col.setAlignment(HSSFCellStyle.ALIGN_JUSTIFY); TimecardListResultData tclistrd = null; List<String> daykeys = listData.getDateListKeys(); int daykeysize = daykeys.size(); for (int i = 0; i < daykeysize; i++) { tclistrd = listData.getDateListValue(daykeys.get(i)); List<TimecardResultData> viewlist = tclistrd.getViewList(); int viewlistsize = viewlist.size(); for (int j = 0; j < viewlistsize; j++) { TimecardResultData rd = viewlist.get(j); String workStr = null; if ("0".equals(rd.getWorkFlag().toString())) { workStr = ""; } else { workStr = ""; } String[] rows = { tclistrd.getDateStr(), tclistrd.getSummayTimes(), workStr, rd.getWorkDateStr(), rd.getReason().toString() }; rowcount = rowcount + 1; addRow(sheet.createRow(rowcount), cell_enc_types, rows); } sheet.addMergedRegion(new Region(rowcount - viewlistsize + 1, (short) 0, rowcount, (short) 0)); HSSFRow row = sheet.getRow(rowcount - viewlistsize + 1); HSSFCell cell1 = row.getCell((short) 0); cell1.setCellStyle(style_col); sheet.addMergedRegion(new Region(rowcount - viewlistsize + 1, (short) 1, rowcount, (short) 1)); HSSFCell cell2 = row.getCell((short) 1); cell2.setCellStyle(style_col); } int uid = ALEipUtils.getUserId(rundata); ALEventlogFactoryService.getInstance().getEventlogHandler().logXlsScreen(uid, "", ALEventlogConstants.PORTLET_TYPE_TIMECARD_XLS_SCREEN); }
From source file:com.develog.utils.report.engine.export.JRXlsExporter.java
License:Open Source License
/** * *///www. j a va 2 s. c o m protected void exportLine(JRPrintLine line, JRExporterGridCell gridCell, int x, int y) { if (gridCell.colSpan > 1 || gridCell.rowSpan > 1) { sheet.addMergedRegion( new Region(y, (short) x, (y + gridCell.rowSpan - 1), (short) (x + gridCell.colSpan - 1))); } short forecolor = getNearestColor(line.getForecolor()).getIndex(); HSSFFont cellFont = getLoadedFont(getDefaultFont(), forecolor); HSSFCellStyle cellStyle = getLoadedCellStyle(HSSFCellStyle.SOLID_FOREGROUND, forecolor, HSSFCellStyle.ALIGN_LEFT, HSSFCellStyle.VERTICAL_TOP, (short) 0, cellFont); cell = row.createCell((short) x); cell.setEncoding(HSSFCell.ENCODING_UTF_16); cell.setCellValue(""); cell.setCellStyle(cellStyle); }
From source file:com.develog.utils.report.engine.export.JRXlsExporter.java
License:Open Source License
/** * *//*from w w w.j a v a 2 s. c om*/ protected void exportRectangle(JRPrintElement element, JRExporterGridCell gridCell, int x, int y) { if (gridCell.colSpan > 1 || gridCell.rowSpan > 1) { sheet.addMergedRegion( new Region(y, (short) x, (y + gridCell.rowSpan - 1), (short) (x + gridCell.colSpan - 1))); } short forecolor = getNearestColor(element.getForecolor()).getIndex(); short mode = backgroundMode; short backcolor = whiteIndex; if (element.getMode() == JRElement.MODE_OPAQUE) { mode = HSSFCellStyle.SOLID_FOREGROUND; backcolor = getNearestColor(element.getBackcolor()).getIndex(); } HSSFFont cellFont = getLoadedFont(getDefaultFont(), forecolor); HSSFCellStyle cellStyle = getLoadedCellStyle(mode, backcolor, HSSFCellStyle.ALIGN_LEFT, HSSFCellStyle.VERTICAL_TOP, (short) 0, cellFont); cell = row.createCell((short) x); cell.setEncoding(HSSFCell.ENCODING_UTF_16); cell.setCellValue(""); cell.setCellStyle(cellStyle); }
From source file:com.develog.utils.report.engine.export.JRXlsExporter.java
License:Open Source License
/** * *//*w w w. ja v a 2s . c o m*/ protected void exportText(JRPrintText textElement, JRExporterGridCell gridCell, int x, int y) { if (gridCell.colSpan > 1 || gridCell.rowSpan > 1) { sheet.addMergedRegion( new Region(y, (short) x, (y + gridCell.rowSpan - 1), (short) (x + gridCell.colSpan - 1))); } JRStyledText styledText = getStyledText(textElement); if (styledText == null) { return; } JRFont font = textElement.getFont(); if (font == null) { font = getDefaultFont(); } short forecolor = getNearestColor(textElement.getForecolor()).getIndex(); HSSFFont cellFont = getLoadedFont(font, forecolor); short horizontalAlignment = HSSFCellStyle.ALIGN_LEFT; short verticalAlignment = HSSFCellStyle.ALIGN_LEFT; short rotation = 0; switch (textElement.getRotation()) { case JRTextElement.ROTATION_LEFT: { rotation = 90; switch (textElement.getTextAlignment()) { case JRAlignment.HORIZONTAL_ALIGN_LEFT: { verticalAlignment = HSSFCellStyle.VERTICAL_BOTTOM; break; } case JRAlignment.HORIZONTAL_ALIGN_CENTER: { verticalAlignment = HSSFCellStyle.VERTICAL_CENTER; break; } case JRAlignment.HORIZONTAL_ALIGN_RIGHT: { verticalAlignment = HSSFCellStyle.VERTICAL_TOP; break; } case JRAlignment.HORIZONTAL_ALIGN_JUSTIFIED: { verticalAlignment = HSSFCellStyle.VERTICAL_JUSTIFY; break; } default: { verticalAlignment = HSSFCellStyle.VERTICAL_BOTTOM; } } switch (textElement.getVerticalAlignment()) { case JRTextElement.VERTICAL_ALIGN_TOP: { horizontalAlignment = HSSFCellStyle.ALIGN_LEFT; break; } case JRTextElement.VERTICAL_ALIGN_MIDDLE: { horizontalAlignment = HSSFCellStyle.ALIGN_CENTER; break; } case JRTextElement.VERTICAL_ALIGN_BOTTOM: { horizontalAlignment = HSSFCellStyle.ALIGN_RIGHT; break; } default: { horizontalAlignment = HSSFCellStyle.ALIGN_LEFT; } } break; } case JRTextElement.ROTATION_RIGHT: { rotation = -90; switch (textElement.getTextAlignment()) { case JRAlignment.HORIZONTAL_ALIGN_LEFT: { verticalAlignment = HSSFCellStyle.VERTICAL_TOP; break; } case JRAlignment.HORIZONTAL_ALIGN_CENTER: { verticalAlignment = HSSFCellStyle.VERTICAL_CENTER; break; } case JRAlignment.HORIZONTAL_ALIGN_RIGHT: { verticalAlignment = HSSFCellStyle.VERTICAL_BOTTOM; break; } case JRAlignment.HORIZONTAL_ALIGN_JUSTIFIED: { verticalAlignment = HSSFCellStyle.VERTICAL_JUSTIFY; break; } default: { verticalAlignment = HSSFCellStyle.VERTICAL_TOP; } } switch (textElement.getVerticalAlignment()) { case JRTextElement.VERTICAL_ALIGN_TOP: { horizontalAlignment = HSSFCellStyle.ALIGN_RIGHT; break; } case JRTextElement.VERTICAL_ALIGN_MIDDLE: { horizontalAlignment = HSSFCellStyle.ALIGN_CENTER; break; } case JRTextElement.VERTICAL_ALIGN_BOTTOM: { horizontalAlignment = HSSFCellStyle.ALIGN_LEFT; break; } default: { horizontalAlignment = HSSFCellStyle.ALIGN_RIGHT; } } break; } case JRTextElement.ROTATION_NONE: default: { rotation = 0; switch (textElement.getTextAlignment()) { case JRAlignment.HORIZONTAL_ALIGN_LEFT: { horizontalAlignment = HSSFCellStyle.ALIGN_LEFT; break; } case JRAlignment.HORIZONTAL_ALIGN_CENTER: { horizontalAlignment = HSSFCellStyle.ALIGN_CENTER; break; } case JRAlignment.HORIZONTAL_ALIGN_RIGHT: { horizontalAlignment = HSSFCellStyle.ALIGN_RIGHT; break; } case JRAlignment.HORIZONTAL_ALIGN_JUSTIFIED: { horizontalAlignment = HSSFCellStyle.ALIGN_JUSTIFY; break; } default: { horizontalAlignment = HSSFCellStyle.ALIGN_LEFT; } } switch (textElement.getVerticalAlignment()) { case JRTextElement.VERTICAL_ALIGN_TOP: { verticalAlignment = HSSFCellStyle.VERTICAL_TOP; break; } case JRTextElement.VERTICAL_ALIGN_MIDDLE: { verticalAlignment = HSSFCellStyle.VERTICAL_CENTER; break; } case JRTextElement.VERTICAL_ALIGN_BOTTOM: { verticalAlignment = HSSFCellStyle.VERTICAL_BOTTOM; break; } default: { verticalAlignment = HSSFCellStyle.VERTICAL_TOP; } } } } short mode = backgroundMode; short backcolor = whiteIndex; if (textElement.getMode() == JRElement.MODE_OPAQUE) { mode = HSSFCellStyle.SOLID_FOREGROUND; backcolor = getNearestColor(textElement.getBackcolor()).getIndex(); } HSSFCellStyle cellStyle = getLoadedCellStyle(mode, backcolor, horizontalAlignment, verticalAlignment, rotation, cellFont); cell = row.createCell((short) x); cell.setEncoding(HSSFCell.ENCODING_UTF_16); if (isAutoDetectCellType) { try { cell.setCellValue(Double.parseDouble(styledText.getText())); } catch (NumberFormatException e) { cell.setCellValue(styledText.getText()); } } else { cell.setCellValue(styledText.getText()); } cell.setCellStyle(cellStyle); }
From source file:gr.abiss.calipso.util.ExcelUtils.java
License:Open Source License
private void setText(int row, int col, String text) { HSSFCell cell = getCell(row, col);/*from www .ja v a2 s . c o m*/ cell.setCellType(HSSFCell.CELL_TYPE_STRING); cell.setEncoding(HSSFCell.ENCODING_UTF_16); cell.setCellValue(text); }
From source file:gr.abiss.calipso.util.ExcelUtils.java
License:Open Source License
private void setHeader(int row, int col, String text) { HSSFCell cell = getCell(row, col);//from ww w. ja va 2 s .c o m cell.setCellStyle(csBold); cell.setCellType(HSSFCell.CELL_TYPE_STRING); cell.setEncoding(HSSFCell.ENCODING_UTF_16); cell.setCellValue(text); }
From source file:include.excel_export.XlsWriter.java
License:Open Source License
/** * write//from www. ja v a 2 s. co m **/ public void writeContent(Collection columns, HSSFSheet sheet, String table) throws Exception { int i = 1; Object[] names = new Object[columns.size()]; columns.toArray(names);//columns? String SQL; info.setTable(table); if (sql == null) { SQL = "select * from " + table; } else { SQL = "select * from " + table + " " + sql; } ResultSet rs = db.executeQuery(SQL); try { while (rs.next()) { HSSFRow row = sheet.createRow((short) i); for (int j = 0; j < columns.size(); j++) { HSSFCell topcell = row.createCell((short) j); String column = (String) names[j]; topcell.setEncoding(HSSFCell.ENCODING_UTF_16);// switch (getType(column)) { //double case HSSFCell.CELL_TYPE_NUMERIC: topcell.setCellType(HSSFCell.CELL_TYPE_NUMERIC); topcell.setCellStyle(doubleCellStyle); topcell.setCellValue(rs.getDouble(column)); break; // case HSSFCell.CELL_TYPE_STRING: topcell.setCellType(HSSFCell.CELL_TYPE_STRING); topcell.setCellValue(rs.getString(column)); break; //INT case 200: topcell.setCellType(HSSFCell.CELL_TYPE_NUMERIC); topcell.setCellStyle(intCellStyle); topcell.setCellValue(rs.getInt(column)); break; // case 300: topcell.setCellType(HSSFCell.CELL_TYPE_STRING); topcell.setCellStyle(dateCellStyle); topcell.setCellValue(rs.getString(column)); break; default: topcell.setCellType(HSSFCell.CELL_TYPE_STRING); topcell.setCellValue(rs.getString(column)); break; } // end of switch () topcell = null; column = null; } i++; row = null; } } catch (SQLException e) { e.printStackTrace(); } }
From source file:include.excel_export.XlsWriter.java
License:Open Source License
/** * write/* w w w. ja v a 2 s. c om*/ **/ public void writeTitle(Collection columns, HSSFSheet sheet) { Object[] names = new Object[columns.size()]; columns.toArray(names); HSSFRow row = sheet.createRow((short) 0); for (int i = 0; i < columns.size(); i++) { HSSFCell cell = row.createCell((short) i); String column = (String) names[i]; cell.setEncoding(HSSFCell.ENCODING_UTF_16); cell.setCellType(HSSFCell.CELL_TYPE_STRING); cell.setCellValue(column); cell = null; column = null; } row = null; names = null; }