使用jxl工具包生成Excel以及读取Excel的方法

package com.yqcf.util;

import java.io.File;
import java.io.InputStream;
import java.io.FileInputStream;
import java.io.IOException;
import java.util.List;
import java.util.ArrayList;
import jxl.Workbook;
import jxl.Sheet;
import jxl.Cell;
import jxl.CellType;
import jxl.write.Label;
import jxl.write.Number;
import jxl.format.Alignment;
import jxl.format.Border;
import jxl.format.BorderLineStyle;
import jxl.format.VerticalAlignment;
import jxl.write.WritableCellFormat;
import jxl.write.WritableSheet;
import jxl.write.WritableWorkbook;
import jxl.write.WritableFont;
import jxl.write.WriteException;
import jxl.read.biff.BiffException;

public class Excel {
 /**
  * @param dirPath:文件要保存的目录
  * @param fileName:文件要保存的文件名
  * @param sheetTitle:报表名称
  * @param title:报表的题目
  * @param columnTitle:列名集合（类型为List）
  * @param text:正文数据（类型为两级嵌套List）
  *            return boolean
  */
 public boolean writeExcel(String dirPath, String fileName,
   String sheetTitle, String title, List columnTitle, List text) {
  // ************判断参数是否合理**********************//
  if (dirPath == null || "".equals(dirPath) || fileName == null
    || "".equals(fileName)) {
   System.out.println("建立excel文件失败：路径或文件名为空");
   return false;
  }
  File filePath = new File(dirPath);
  {
   if (!filePath.exists()) {
    // 如果文件要保存的目录不存在则产生该目录
    if (!filePath.mkdir()) {
     System.out.println("建立excel文件失败：无法建立该目录");
     return false;
    }
   }
  }
  // 在该目录下产生要保存的文件名
  String excelPath = dirPath + "/" + fileName + ".xls";
  File excelFile = new File(excelPath);
  // 以下开始输出到EXCEL
  WritableWorkbook workBook = null;
  WritableSheet sheet = null;
  try {
   // *******************判断文件是否存在，否则产生该文件**********//
   if (!excelFile.exists()) {
    if (!excelFile.createNewFile()) {
     System.out.println("建立excel文件失败：建立excel文件发生异常");
     return false;
    }
   }
   // ************创建工作簿*************//
   workBook = Workbook.createWorkbook(excelFile);
   // ************创建工作表*************//
   if ("".equals(sheetTitle) || sheetTitle == null) {
    sheet = workBook.createSheet("Sheet1", 0);
   } else {
    sheet = workBook.createSheet(sheetTitle, 0);
   }
   // **************设置单元格字体***************//
   WritableFont headFont = new WritableFont(WritableFont.ARIAL, 14);
   WritableFont normalFont = new WritableFont(WritableFont.ARIAL, 12);
   // **************以下设置几种格式的单元格*************//
   // 用于表头
   WritableCellFormat wcf_head = new WritableCellFormat(headFont);
   wcf_head.setBorder(Border.ALL, BorderLineStyle.THIN); // 线条
   wcf_head.setVerticalAlignment(VerticalAlignment.CENTRE); // 文字垂直对齐
   wcf_head.setAlignment(Alignment.CENTRE); // 文字水平对齐
   wcf_head.setWrap(false); // 文字是否换行

   // 用于正文居中
   WritableCellFormat wcf_center = new WritableCellFormat(normalFont);
   wcf_center.setBorder(Border.ALL, BorderLineStyle.THIN); // 线条
   wcf_center.setVerticalAlignment(VerticalAlignment.CENTRE); // 文字垂直对齐
   wcf_center.setAlignment(Alignment.CENTRE); // 文字水平对齐
   wcf_center.setWrap(false); // 文字是否换行

   // **************单元格格式设置完成*******************//

   // *****************以下是报表的内容**********************//
   // **************合并单元格设置excel的题目*************//
   int x = 0;
   if ("".equals(title) || title == null) {
    title = "";
    x = 0;
   } else {
    if (columnTitle != null && columnTitle.size() > 0) {
     sheet.mergeCells(0, 0, columnTitle.size() - 1, 0);
     sheet.addCell(new Label(0, 0, title, wcf_head));
     x = 1;
    } else if (text != null && text.size() > 0
      && ((List) text.get(0)).size() > 0) {
     sheet.addCell(new Label(0, ((List) text.get(0)).size() - 1,
       title, wcf_head));
     x = 1;
    } else {
     sheet.addCell(new Label(0, 0, title, wcf_head));
     x = 1;
    }
   }
   // *********************设置excel的字段名******************//
   if (columnTitle != null && columnTitle.size() > 0) {
    for (int i = 0; i < columnTitle.size(); i++) {
     sheet.addCell(new Label(i, x, String.valueOf(columnTitle
       .get(i)), wcf_center));
    }
    x = x + 1;
   }

   // ****************写入正文数据**********************//
   if (text != null && text.size() > 0) {
    for (int i = 0; i < text.size(); i++) {
     List content = (List) text.get(i);
     if (content != null && content.size() > 0) {
      for (int j = 0; j < content.size(); j++) {
       String data = String.valueOf(content.get(j));
       // ***************判断数据类型并添加数据**********//
       if (content.get(j) instanceof String) {
        sheet.addCell(new Label(j, x + i, data,
          wcf_center));
       } else if (content.get(j) instanceof Integer) {
        Number numberLabel = new Number(j, x + i,
          Integer.parseInt(data), wcf_center);
        sheet.addCell(numberLabel);
       } else if (content.get(j) instanceof Float) {
        Number numberLabel = new Number(j, x + i, Float
          .parseFloat(data), wcf_center);
        sheet.addCell(numberLabel);
       } else if (content.get(j) instanceof Double) {
        Number numberLabel = new Number(j, x + i,
          Double.parseDouble(data), wcf_center);
        sheet.addCell(numberLabel);
       } else if (content.get(j) instanceof Long) {
        Number numberLabel = new Number(j, x + i, Long
          .parseLong(data), wcf_center);
        sheet.addCell(numberLabel);
       } else if (content.get(j) instanceof Short) {
        Number numberLabel = new Number(j, x + i, Short
          .parseShort(data), wcf_center);
        sheet.addCell(numberLabel);
       } else if (content.get(j) instanceof Boolean) {
        sheet.addCell(new Label(j, x + i, data,
          wcf_center));
       } else if (content.get(j) instanceof Byte) {
        sheet.addCell(new Label(j, x + i, data,
          wcf_center));
       } else {
        try {
         Number numberLabel = new Number(j, x + i,
           Double.parseDouble(data),
           wcf_center);
         sheet.addCell(numberLabel);
        } catch (NumberFormatException ex) {
         sheet.addCell(new Label(j, x + i, data,
           wcf_center));
        }
       }
       sheet.setColumnView(j, data.length() + 10);
      }
     }
    }
   }
   // ************以上所写的内容都是写在缓存中的，下一句将缓存的内容写到文件中*********//
   workBook.write();
   return true;
  } catch (WriteException e) {
   System.out.println("建立excel文件失败：" + e.getMessage());
   return false;
  } catch (IOException e) {
   System.out.println("建立excel文件失败：" + e.getMessage());
   return false;
  } finally {
   // ***********关闭文件**************//
   try {
    if (workBook != null) {
     workBook.close();
    }
   } catch (WriteException ex) {
    System.out.println(ex.getMessage());
   } catch (IOException ex) {
    System.out.println(ex.getMessage());
   }
  }
 }

 /**
  * @param excelFileName:excel文件的具体路径+文件名
  *            return List(类型为两级嵌套List)
  */
 public List readExcel(String excelFileName) {
  // *****************判断参数是否合理****************//
  if (excelFileName == null || "".equals(excelFileName)) {
   System.out.println("读取excel文件失败：路径或文件名为空");
   return null;
  }
  File file = new File(excelFileName);
  if (!file.exists()) {
   System.out.println("读取excel文件失败：路径或文件名不存在");
   return null;
  }
  List data = new ArrayList();
  InputStream input = null;
  Workbook workBook = null;
  try {
   // ****************产生文件流读取excel文件*************//
   input = new FileInputStream(file);
   workBook = Workbook.getWorkbook(input);
   Sheet sheet = workBook.getSheet(0);
   int columns = sheet.getColumns();
   int rows = sheet.getRows();
   for (int i = 0; i < rows; i++) {
    List row = new ArrayList();
    for (int j = 0; j < columns; j++) {
     Cell cell = sheet.getCell(j, i);
     String cellValue = cell.getContents();
     // **************判断字段的数据类型***************//
     if (cell.getType() == CellType.NUMBER) {
      try {
       Integer intCell = Integer.valueOf(cellValue);
       row.add(intCell);
      } catch (NumberFormatException ex) {
       Double doubleCell = Double.valueOf(cellValue);
       row.add(doubleCell);
      }
     } else {
      row.add(cellValue);
     }
    }
    data.add(row);
   }
   return data;
  } catch (BiffException e) {
   System.out.println("读取excel文件失败：" + e.getMessage());
   return null;
  } catch (IOException e) {
   System.out.println("读取excel文件失败：" + e.getMessage());
   return null;
  } finally {
   // ***********关闭流和工作簿**************//
   if (workBook != null) {
    workBook.close();
   }
   try {
    if (input != null) {
     input.close();
    }
   } catch (IOException ex) {
    System.out.println(ex.getMessage());
   }
  }
 }

}