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 }

 

posted @ 2015-04-27 15:13  韩不懂  阅读(241)  评论(0编辑  收藏  举报