JXL读取Excel文件内容
1 package poi; 2 3 import java.io.File; 4 import jxl.Cell; 5 import jxl.Sheet; 6 import jxl.Workbook; 7 8 9 public class JxlReadExcel { 10 11 public static void main(String[] args) { 12 try { 13 //获取工作薄 14 Workbook workbook=Workbook.getWorkbook(new File("e:/jxl.xls")); 15 //获取sheet 16 Sheet sheet = workbook.getSheet("sheet1"); 17 for (int i = 0; i < sheet.getRows(); i++) { 18 for (int j = 0; j < sheet.getColumns(); j++) { 19 //获取单元格 20 Cell cell = sheet.getCell(j, i); 21 //获取单元格内容 22 System.out.print(cell.getContents()+" "); 23 } 24 System.out.println(); 25 } 26 //关闭工作薄 27 workbook.close(); 28 } catch (Exception e) { 29 30 e.printStackTrace(); 31 } 32 33 } 34 35 }