Excel读入 JXL

以下是通过JXL把Excel读入到List 的程序

/**
 * jxl 的Excel阅读器.
 * @author sakyone
 */
public class JxlExcelReader {

	/**
	 * @return 返回String[] 的列表
	 */
	public List readExcel(InputStream in) {
		List lt = new ArrayList();
		Workbook wb = null;
		try {
			wb = Workbook.getWorkbook(in);
			Sheet[] sheets = wb.getSheets(); //获取工作
			for (int i = 0; i < sheets.length; i++) {
				Sheet sheet = sheets[i];
				System.err.println("----------sheet"+i+"共有"+sheet.getRows()+"行------------");
				for (int j = 0; j < sheet.getRows(); j++) {
					
					Cell[] cells = sheet.getRow(j); //读取一行
					if (cells != null && cells.length > 0) { //这一行有内容才添加
//						System.err.println("-----------共有"+cells.length+"列------------");
						String[] dataCells = new String[cells.length];
						for (int k = 0; k < cells.length; k++) {
							dataCells[k] = "" + cells[k].getContents(); //读内容
						}//column
						lt.add(dataCells);
					}
				}//one sheet
			}//xls file
		} catch (BiffException e) {
			e.printStackTrace();
		} catch (IOException e) {
			e.printStackTrace();
		} finally {
			if (wb != null) {
				wb.close();
			}
		}

		return lt;
	}