Java读取Excel文件

package com.jadlsoft.utils;


import java.io.File;
import java.io.InputStream;
import java.util.ArrayList;
import java.util.HashMap;
import java.util.List;
import java.util.Map;


import jxl.Cell;
import jxl.Sheet;
import jxl.Workbook;
import jxl.WorkbookSettings;


public class ReadExcelUtils {



/**
* @author WangQing 2014-2-21 上午10:50:06
* @function:将本地磁盘Excel表格数据读到内存中，封装成list
* @param fileUrl Excel文件地址
* @return
* @throws Exception
*/
public static List getLoclExcelContents(String fileUrl) throws Exception{
WorkbookSettings ws = new WorkbookSettings();
ws.setCellValidationDisabled(true);
Workbook book = Workbook.getWorkbook(new File(fileUrl),ws);
Sheet sheet = null;
//获取sheet有以下两种方式
sheet = book.getSheet(0);
List list = new ArrayList();
Cell[] cellTitle=sheet.getRow(0);
for(int i=1; i<sheet.getRows(); i++){
Cell[] cell=sheet.getRow(i);
Map map = new HashMap();
for(int j=0;j<cell.length;j++){
map.put(cellTitle[j].getContents(), cell[j].getContents());

}
list.add(map);
}
return list;

}

/**
* @author WangQing 2014-2-21 上午10:50:06
* @function:将远程获取的Excel表格文件流数据读到内存中，封装成list
* @param fileUrl Excel文件地址
* @return
* @throws Exception
*/
public static List getRemoteExcelContents(InputStream inputStream) throws Exception{
WorkbookSettings ws = new WorkbookSettings();
ws.setCellValidationDisabled(true);
Workbook book = Workbook.getWorkbook(inputStream,ws);
Sheet sheet = null;
//获取sheet有以下两种方式
sheet = book.getSheet(0);
List list = new ArrayList();
Cell[] cellTitle=sheet.getRow(0);
for(int i=1; i<sheet.getRows(); i++){
Cell[] cell=sheet.getRow(i);
Map map = new HashMap();
for(int j=0;j<cell.length;j++){
map.put(cellTitle[j].getContents(), cell[j].getContents());

}
list.add(map);
}
return list;

}

}