package com.cxl; import jxl.Cell; import jxl.Sheet; import jxl.Workbook; import java.io.File; //读取excel public class JxlReadExcel { public static void main(String[] args) { try { //创建workbook并指定文件所在路径 Workbook workbook = Workbook.getWorkbook(new File("f://jxl_test.xls")); //获取第一个工作表sheet页 Sheet sheet = workbook.getSheet(0); //获取数据 for (int i = 0; i < sheet.getRows(); i++) { for (int j = 0; j < sheet.getColumns(); j++) { Cell cell = sheet.getCell(j, i); System.out.print(cell.getContents() + " "); } System.out.println(); } workbook.close(); } catch (Exception e) { e.printStackTrace(); } } }
效果: