java²Ù×÷excelÎļþ

Õâ¸öÊÇ×Ô¼º¹ýȥΪÁË·½±ã²Ù×÷excelÊý¾Ý,дµÄÒ»¸ö¹¤¾ßÀà,ûÓÐÓÅ»¯¹ý,ºÇºÇ
ÉÏÃæµÄÊǹ¤¾ßÀà,ÏÂÃæÌáÓ÷¨,д·¨ºÜ±¿,µ«ÓÃ×Å»¹ºÜ·½±ã
package com.dtb.utils;
import java.io.FileInputStream;
import java.io.FileNotFoundException;
import java.io.FileOutputStream;
import java.io.IOException;
import java.util.ArrayList;
import java.util.List;
import jxl.Cell;
import jxl.Sheet;
import jxl.Workbook;
import jxl.read.biff.BiffException;
import jxl.write.Label;
import jxl.write.WritableSheet;
import jxl.write.WritableWorkbook;
import jxl.write.WriteException;
import jxl.write.biff.RowsExceededException;
/**
* JAVA ²Ù×÷ excel ÖÐµÄ .xlsÎļþ¸ñʽ
* @author dtb
*
*/
public class ExcelUtil {

/** ¹¤×÷±í*/
private Workbook rwb;

/** д²Ù×÷±í*/
private WritableWorkbook wwb;

public ExcelUtil(){}

/**
* ¹¹Ô캯Êý
* @param fileName - ÎļþÃû
*/
public ExcelUtil(String fileName) {
try {
rwb = Workbook.getWorkbook(new FileInputStream(fileName));
} catch (BiffException e) {
e.printStackTrace();
} catch (FileNotFoundException e) {
e.printStackTrace();
} catch (IOException e) {
e.printStackTrace();
}
}

/**
* ¾²Ì¬¹¤³§·½·¨,·µ»Ø¶Á²Ù×÷µÄExcelUtil¶ÔÏó
* @param fileName - ÎļþÃû
* @return this
*/
public static ExcelUtil getReadExcelUtil(String fileName) {
ExcelUtil eu = new ExcelUtil();
try {
eu.rwb = Workbook.getWorkbook(new FileInputStream(fileName));
} catch (BiffException e) {
e.printStackTrace();
} catch (FileNotFoundException e) {
e.printStackTrace();
} catch (IOException e) {
e.printStackTrace();
}
return eu;
}

/**
* ¾²Ì¬¹¤³§·½·¨,·µ»Øд²Ù×÷µÄExcelUtil¶ÔÏó
* @param fileName - ÎļþÃû
* @return this
*/
public static ExcelUtil getWriteExcelUtil(String fileName) {
ExcelUtil eu = new ExcelUtil();
try {
eu.wwb = Workbook.createWorkbook(new FileOutputStream(fileName));
} catch (FileNotFoundException e) {
e.printStackTrace();
} cat