使用jxl组件读取excel

先下好jxl，导入jar包。以下代码是为了读取从第三行起的数据并存入到数据库中的测试代码（前两行是标题行）。存着供参考……

1.                 try {
2.                         Class.forName("com.mysql.jdbc.Driver");
3.                        
4.                         Connection conn = DriverManager.getConnection("jdbc:mysql://localhost:3306/db","root","");
5.                        
6.                         String sql1 = "insert into student_info(CREATEDT,FULLNAME,BIRTHDAY,GENDER,MAJOR,REGION,INSTITUTION,MOBILEPHONE,QQNUMBER,EMAIL,FEE,ENTERFOREXTRA) value (?,?,?,?,?,?,?,?,?,?,?,?)";
7.                         PreparedStatement ps1 = conn.prepareStatement(sql1);
8.                        
9.                         Workbook workbook = Workbook.getWorkbook(new File("d://EXCEL文件.xls"));
10.                        
11.                         Sheet sheet = workbook.getSheet(0);
12.                         int columns = sheet.getColumns();
13.                         int rows = sheet.getRows();
14.                        
15.                         for(int i=3;i<rows;i++){
16.                                 ps1.setString(1,sheet.getCell(1,i).getContents());            //CREATEDT    报名日期
17.                                 ps1.setString(2,sheet.getCell(2,i).getContents());            //FULLNAME    姓名
18.                                 ps1.setString(3,sheet.getCell(3,i).getContents());            //BIRTHDAY    出生日期
19.                                 ps1.setString(4, sheet.getCell(4,i).getContents());          //GENDER     性别
20.                                 ps1.setString(5, sheet.getCell(5,i).getContents());          //MAJOR            专业
21.                                 //      所在公司 6//
22.                                 //      所属岗位 7//
23.                                 //      学历         8//        
24.                                 ps1.setString(6, sheet.getCell(9,i).getContents());          //REGION     所属地区
25.                                 ps1.setString(7, sheet.getCell(10,i).getContents());    //INSTITUTION       所属院校
26.                                 //      何时毕业 11 //
27.                                 ps1.setString(8, sheet.getCell(12,i).getContents());    //MOBILEPHONE       电话
28.                                 ps1.setString(9, sheet.getCell(13,i).getContents());    //QQNUMBER    QQ
29.                                 ps1.setString(10, sheet.getCell(14,i).getContents());   //EMAIL        邮箱
30.                                 //      套餐名称 15
31.                                 String fee = sheet.getCell(16,i).getContents();
32.                                 if(fee!=""&&!"已退款".equals(fee)){        //FEE          收费情况
33.                                         ps1.setInt(11, Integer.parseInt(sheet.getCell(16,i).getContents()));
34.                                 }else{
35.                                         ps1.setInt(11,0);
36.                                 }
37.                                 ps1.setString(12, sheet.getCell(17,i).getContents());   //ENTERFOREXTRA    备注
38.                                
39.                                 ps1.execute();
40.                         }
41.                        
42.                         ps1.close();
43.                         workbook.close();
44.                         conn.close();
45.                 } catch (BiffException e) {
46.                         e.printStackTrace();
47.                 } catch (IOException e) {
48.                         e.printStackTrace();
49.                 } catch (ClassNotFoundException e) {
50.                         e.printStackTrace();
51.                 } catch (SQLException e) {
52.                         e.printStackTrace();
53.                 }

其中 sheet.getCell(列,行).getContens()就可以获得相应单元格的内容。