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>