读取xls文件
实现代码:
/**
* jxl.Workbook 读取xls文件
* 注意: 此方法不支持xlsx文件,可以将xlsx文件先另存为xls
* @param file
* @throws BiffException
* @throws IOException
*/
private static void xlsReader(File file) throws BiffException, IOException{
//1、创建workbook
Workbook workBook = Workbook.getWorkbook(file);
//2、获取工作表中的第一页(sheet1)
Sheet sheet1 = workBook.getSheet(0);
//3、获取sheet1中的数据
System.out.println("sheet1有" + sheet1.getRows() + "行数据");
System.out.println("sheet1有" + sheet1.getColumns() + "列数据");
for(int i = 0; i < sheet1.getRows(); i++) {
for (int j = 0; j < sheet1.getColumns(); j++) {
Cell cell = sheet1.getCell(j, i);
System.out.print(cell.getContents() + "|");
}
System.out.println();
}
//关闭资源
workBook.close();
return;
}
验证:
public static void main(String[] args) {
File eFile = new File("D:/Users/1.xls");
try {
xlsReader(eFile);
} catch (BiffException e) {
// TODO Auto-generated catch block
e.printStackTrace();
} catch (IOException e) {
// TODO Auto-generated catch block
e.printStackTrace();
}
}