java利用jxl.jar生成excel文档

java代码：

package com.test.read;

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;

/**
 * 写excel
 * 
 * @author user
 *
 */
public class writeExcel {
	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) {

			ex.printStackTrace();
		}
		// 关闭流
		try {
			wwb.close();
		} catch (WriteException ex) {

			ex.printStackTrace();
		} catch (IOException ex) {

			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) {

			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) {

			e.printStackTrace();
		}
		return format;
	}

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

			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) {

			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) {

			e.printStackTrace();
		}
		return format;
	}

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

结果：