用jexcel读写excel的.xls文件的例子

以前自己写过一篇关于制作excel报表的例子，有兴趣的朋友可以去看看：http://www.cnblogs.com/loveJava/archive/2011/11/08/2241115.html。下面我就分享一下别人的代码，希望这两种方法对你能够有所帮助：

有时候我们会需要做excel的报表,下面这个例子详细的给出了读写及定义样式的方法。
(jexcel下载)

package com.test;

import java.io.File;
import java.io.IOException;
import jxl.Cell;
import jxl.Sheet;
import jxl.Workbook;
import jxl.format.Border;
import jxl.format.BorderLineStyle;
import jxl.format.Colour;
import jxl.read.biff.BiffException;
import jxl.write.Label;
import jxl.write.WritableCellFormat;
import jxl.write.WritableFont;
import jxl.write.WritableSheet;
import jxl.write.WritableWorkbook;
import jxl.write.WriteException;
import jxl.write.biff.RowsExceededException;

/**
 * 
 * CopyRight (C) www.blogjava.net/ilovezmh All rights reserved.
 * <p>
 * 
 * WuHan Inpoint Information Technology Development,Inc.
 * <p>
 * 
 * Author zhu
 * <p>
 * 
 * @version 1.0 2007-2-6
 * 
 *          <p>
 *          Base on : JDK1.5
 *          <p>
 * 
 */
public class JexcelSample {

	/**
	 * 写excel文件
	 * 
	 */
	public void writeExc(File filename) {
		WritableWorkbook wwb = null;
		try {
			wwb = Workbook.createWorkbook(filename);
		} catch (Exception e) {
			e.printStackTrace();
		}

		// 创建Excel工作表
		WritableSheet ws = wwb.createSheet("通讯录", 0);// 创建sheet
		try {
			ws.mergeCells(0, 0, 2, 1);// 合并单元格(左列，左行，右列，右行)从第1行第1列到第2行第3列
			Label header = new Label(0, 0, "通讯录(191026班)", getHeader());
			ws.addCell(header);// 写入头
			Label l = new Label(0, 2, "姓名", getTitle());// 第3行
			ws.addCell(l);
			l = new Label(1, 2, "电话", getTitle());
			ws.addCell(l);
			l = new Label(2, 2, "地址", getTitle());
			ws.addCell(l);
			l = new Label(0, 3, "小祝", getNormolCell());// 第4行
			ws.addCell(l);
			l = new Label(1, 3, "1314***0974", getNormolCell());
			ws.addCell(l);
			l = new Label(2, 3, "武汉武昌", getNormolCell());
			ws.addCell(l);
			l = new Label(0, 4, "小施", getNormolCell());// 第5行
			ws.addCell(l);
			l = new Label(1, 4, "1347***5057", getNormolCell());
			ws.addCell(l);
			l = new Label(2, 4, "武汉武昌", getNormolCell());
			ws.addCell(l);
			ws.setColumnView(0, 20);// 设置列宽
			ws.setColumnView(1, 20);
			ws.setColumnView(2, 40);
			ws.setRowView(0, 400);// 设置行高
			ws.setRowView(1, 400);
			ws.setRowView(2, 500);
			ws.setRowView(3, 500);
			ws.setRowView(4, 500);
		} catch (RowsExceededException e1) {
			e1.printStackTrace();
		} catch (WriteException e1) {
			e1.printStackTrace();
		}

		// 输出流
		try {
			wwb.write();
		} catch (IOException ex) {
			// TODO 自动生成 catch 块
			ex.printStackTrace();
		}
		// 关闭流
		try {
			wwb.close();
		} catch (WriteException ex) {
			// TODO 自动生成 catch 块
			ex.printStackTrace();
		} catch (IOException ex) {
			// TODO 自动生成 catch 块
			ex.printStackTrace();
		}
		// outStream.close();
		System.out.println("写入成功！\n");
	}

	public void readExc(File filename) throws BiffException, IOException {
		Workbook wb = Workbook.getWorkbook(filename);
		Sheet s = wb.getSheet(0);// 第1个sheet
		Cell c = null;
		int row = s.getRows();// 总行数
		int col = s.getColumns();// 总列数
		for (int i = 0; i < row; i++) {
			for (int j = 0; j < col; j++) {
				c = s.getCell(j, i);
				System.out.print(c.getContents() + "  ");
			}
			System.out.println();
		}
	}

	/**
	 * 设置头的样式
	 * 
	 * @return
	 */
	public static WritableCellFormat getHeader() {
		WritableFont font = new WritableFont(WritableFont.TIMES, 24,
				WritableFont.BOLD);// 定义字体
		try {
			font.setColour(Colour.BLUE);// 蓝色字体
		} catch (WriteException e1) {
			// TODO 自动生成 catch 块
			e1.printStackTrace();
		}
		WritableCellFormat format = new WritableCellFormat(font);
		try {
			format.setAlignment(jxl.format.Alignment.CENTRE);// 左右居中
			format.setVerticalAlignment(jxl.format.VerticalAlignment.CENTRE);// 上下居中
			format.setBorder(Border.ALL, BorderLineStyle.THIN, Colour.BLACK);// 黑色边框
			format.setBackground(Colour.YELLOW);// 黄色背景
		} catch (WriteException e) {
			// TODO 自动生成 catch 块
			e.printStackTrace();
		}
		return format;
	}

	/**
	 * 设置标题样式
	 * 
	 * @return
	 */
	public static WritableCellFormat getTitle() {
		WritableFont font = new WritableFont(WritableFont.TIMES, 14);
		try {
			font.setColour(Colour.BLUE);// 蓝色字体
		} catch (WriteException e1) {
			// TODO 自动生成 catch 块
			e1.printStackTrace();
		}
		WritableCellFormat format = new WritableCellFormat(font);

		try {
			format.setAlignment(jxl.format.Alignment.CENTRE);
			format.setVerticalAlignment(jxl.format.VerticalAlignment.CENTRE);
			format.setBorder(Border.ALL, BorderLineStyle.THIN, Colour.BLACK);
		} catch (WriteException e) {
			// TODO 自动生成 catch 块
			e.printStackTrace();
		}
		return format;
	}

	/**
	 * 设置其他单元格样式
	 * 
	 * @return
	 */
	public static WritableCellFormat getNormolCell() {// 12号字体,上下左右居中,带黑色边框
		WritableFont font = new WritableFont(WritableFont.TIMES, 12);
		WritableCellFormat format = new WritableCellFormat(font);
		try {
			format.setAlignment(jxl.format.Alignment.CENTRE);
			format.setVerticalAlignment(jxl.format.VerticalAlignment.CENTRE);
			format.setBorder(Border.ALL, BorderLineStyle.THIN, Colour.BLACK);
		} catch (WriteException e) {
			// TODO 自动生成 catch 块
			e.printStackTrace();
		}
		return format;
	}

	public static void main(String[] args) throws IOException, BiffException {
		JexcelSample js = new JexcelSample();
		File f = new File("D:\\address.xls");
		f.createNewFile();
		js.writeExc(f);
		js.readExc(f);
	}
}

生成的excel表格如下：

转载地址：http://www.blogjava.net/ilovezmh/archive/2007/02/06/98270.html