Java tutorial
package org.activityinfo.server.endpoint.export; /* * #%L * ActivityInfo Server * %% * Copyright (C) 2009 - 2013 UNICEF * %% * This program is free software: you can redistribute it and/or modify * it under the terms of the GNU General Public License as * published by the Free Software Foundation, either version 3 of the * License, or (at your option) any later version. * * This program is distributed in the hope that it will be useful, * but WITHOUT ANY WARRANTY; without even the implied warranty of * MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the * GNU General Public License for more details. * * You should have received a copy of the GNU General Public * License along with this program. If not, see * <http://www.gnu.org/licenses/gpl-3.0.html>. * #L% */ import org.apache.poi.hssf.usermodel.HSSFWorkbook; import org.apache.poi.ss.usermodel.*; import java.util.Date; import java.util.HashMap; public abstract class Exporter { public final HSSFWorkbook book; public final CreationHelper creationHelper; public HashMap<String, Integer> sheetNames; private CellStyle dateStyle; private CellStyle coordStyle; private CellStyle indicatorValueStyle; private CellStyle headerStyle; private CellStyle headerStyleCenter; private CellStyle headerStyleRight; public Exporter() { book = new HSSFWorkbook(); creationHelper = book.getCreationHelper(); sheetNames = new HashMap<String, Integer>(); } public HSSFWorkbook getBook() { return book; } protected void declareStyles() { dateStyle = book.createCellStyle(); dateStyle.setDataFormat(creationHelper.createDataFormat().getFormat("m/d/yy")); coordStyle = book.createCellStyle(); coordStyle.setDataFormat(creationHelper.createDataFormat().getFormat("0.000000")); indicatorValueStyle = book.createCellStyle(); indicatorValueStyle.setDataFormat(creationHelper.createDataFormat().getFormat("#,##0")); Font headerFont = book.createFont(); headerFont.setBoldweight(Font.BOLDWEIGHT_BOLD); Font smallFont = book.createFont(); smallFont.setFontHeightInPoints((short) 8); headerStyle = book.createCellStyle(); headerStyle.setFont(headerFont); headerStyleCenter = book.createCellStyle(); headerStyleCenter.setFont(headerFont); headerStyleCenter.setAlignment(CellStyle.ALIGN_CENTER); headerStyleRight = book.createCellStyle(); headerStyleRight.setFont(headerFont); headerStyleRight.setAlignment(CellStyle.ALIGN_RIGHT); } protected Cell createHeaderCell(Row headerRow, int columnIndex, String text, CellStyle style) { Cell cell = headerRow.createCell(columnIndex); cell.setCellValue(creationHelper.createRichTextString(text)); cell.setCellStyle(style); return cell; } protected Cell createHeaderCell(Row headerRow, int columnIndex, String text) { return createHeaderCell(headerRow, columnIndex, text, CellStyle.ALIGN_LEFT); } protected Cell createHeaderCell(Row headerRow, int columnIndex, String text, int align) { Cell cell = headerRow.createCell(columnIndex); cell.setCellValue(creationHelper.createRichTextString(text)); switch (align) { case CellStyle.ALIGN_LEFT: cell.setCellStyle(headerStyle); break; case CellStyle.ALIGN_CENTER: cell.setCellStyle(headerStyleCenter); break; case CellStyle.ALIGN_RIGHT: cell.setCellStyle(headerStyleRight); break; } return cell; } protected Cell createCell(Row row, int columnIndex, String text) { Cell cell = row.createCell(columnIndex); cell.setCellValue(creationHelper.createRichTextString(text)); return cell; } protected Cell createCell(Row row, int columnIndex, String text, CellStyle style) { Cell cell = createCell(row, columnIndex, text); cell.setCellStyle(style); return cell; } protected void createCell(Row row, int columnIndex, Date date) { Cell cell = row.createCell(columnIndex); cell.setCellValue(date); cell.setCellStyle(dateStyle); } }