jxl读取excel文件

try {TemplateHandler course = new TemplateHandler("src/com/excel/insert.sql");String file = "C:\\Users\\Administrator\\Desktop\\test.xls";Workbook book = Workbook.getWorkbook(new File(file));Sheet[] sheets = book.getSheets();Cell[] cells = null;String name = null;String id = null;String sex = null;for (Sheet s : sheets) {for (int i = 1; i < s.getRows(); i++) {cells = s.getRow(i);id = cells[0].getContents().trim();name = cells[2].getContents().trim();sex = cells[4].getContents().trim();course.put("id", id);course.put("name", name);course.put("sex", sex);course.print(System.out);// System.out.println(id+"  "+name+"  "+sex);System.out.println();}}book.close();} catch (Exception e) {// System.out.println(e);}

<dependency><groupId>jexcelapi</groupId><artifactId>jxl</artifactId><version>2.6</version></dependency>