excelhelper.java

日志管理源代码

package com.log.util;

import java.io.OutputStream; 

import com.lzc.util.Tools;

import jxl.Workbook;
import jxl.format.CellFormat;
import jxl.write.Label;
import jxl.write.WritableCellFormat;
import jxl.write.WritableFont;
import jxl.write.WritableSheet;
import jxl.write.WritableWorkbook;

public class ExcelHelper {
	private static final String DEFAULT_SHEET_NAME = "sheet1";

	/**
	 * 
	 * @param dispName
	 * @param attrName
	 * @param data
	 * @param out
	 * @throws Exception
	 * @author Henry
	 * @date 2007-06-06
	 */
	public static void writeToExcel(String[][] data, OutputStream out)
			throws Exception {
		if (null == data) {
			throw new Exception("No Content!");
		}
		WritableWorkbook workbook = Workbook.createWorkbook(out);
		WritableSheet sheet = workbook.createSheet(DEFAULT_SHEET_NAME, 0);
		writesheet(sheet, data);
		workbook.write();
		workbook.close();
	}

	private static void writesheet(WritableSheet sheet, String[][] data)
			throws Exception {

		String[] dispNames = data[0];
		writeHeadName(sheet, dispNames);
		CellFormat arial12format = getCellFormat();
		for (int cols = 0; cols < dispNames.length; cols++) {
			for (int i = 1; i < data.length; i++) {
				sheet.addCell(new Label(cols, i, Tools.getRsString(
						dispNames[cols], data, i, ""), arial12format));
			}
		}
	}

	private static void writeHeadName(WritableSheet sheet, String[] dispNames)
			throws Exception {
		CellFormat arial12format = getHeaderCellFormat();
		for (int i = 0; i < dispNames.length; i++) {
			String dispName = dispNames[i];
			sheet.addCell(new Label(i, 0, dispName, arial12format));

		}
	}

	/**
	 * 
	 * @return
	 * @throws Exception
	 */
	private static CellFormat getHeaderCellFormat() throws Exception {
		WritableFont arial12pt = new WritableFont(WritableFont.ARIAL, 12,
				WritableFont.BOLD);
		WritableCellFormat arial12format = new WritableCellFormat(arial12pt);
		arial12format.setWrap(false);
		return arial12format;
	}

	/**
	 * 
	 * @return
	 * @throws Exception
	 */
	private static CellFormat getCellFormat() throws Exception {
		WritableFont arial12pt = new WritableFont(WritableFont.ARIAL, 12);
		WritableCellFormat arial12format = new WritableCellFormat(arial12pt);
		arial12format.setWrap(false);
		return arial12format;
	}

}