通过jxl.jar来对Excel数据表进行访问读取,(下载地址)
读取Excel文件:
private static void readExcel() {
try {
File file = new File("e://data//data.xls");
Workbook workbook = Workbook.getWorkbook(file);
Sheet sheet = workbook.getSheet(0);//获取第一张表的数据
int colCounts = sheet.getColumns();
for (int i = 1; i < colCounts; i++) {
Cell cells = sheet.getCell(0, i);//获取第1行,第i列的值
String levelId = cells.getContents();
System.out.println(levelId);
}
// Cell[] cells = sheet.getColumn(0);//获取指定列的单元格的值
// for (Cell ids : cells) {
// String levelId = ids.getContents();
// System.out.println(levelId);
// }
} catch (BiffException e) {
e.printStackTrace();
} catch (IOException e) {
e.printStackTrace();
}
}