应用jxl框架进行Excel文件解析

1、在项目开发过程中需要将Excel文件导入到数据库中，应用到jxl.jar 进行解析

2、如下

1. package test;
3. import java.io.File;
4. import java.io.IOException;
5. import java.io.UnsupportedEncodingException;
7. import javax.servlet.http.HttpServletResponse;
8. import jxl.Sheet;
9. import jxl.Workbook;
10. import jxl.WorkbookSettings;
11. import jxl.read.biff.BiffException;
12. import jxl.write.Label;
13. import jxl.write.WritableSheet;
14. import jxl.write.WritableWorkbook;
15. import jxl.write.WriteException;
17. public class JxlTest {
18.     public static void main(String[] args) {
19.         (new JxlTest()).excelRead();
20.     }
21.     public void excelRead(){
22.         File file = new File("d:\\cicc825.xls");
23.         try {
24.             WorkbookSettings workbookSettings=new WorkbookSettings();
25.             workbookSettings.setEncoding("ISO-8859-1"); //关键代码，解决中文乱码
26.             Workbook book= Workbook.getWorkbook(file,workbookSettings);
27.             //Workbook book= Workbook.getWorkbook(file);
28.             Sheet sheet=book.getSheet(0); 
29.             int row = sheet.getRows();
30.             int column =sheet.getColumns();
31.             for(int i=0;i<row;i++){
32.                 for(int j=0;j<column;j++){
33.                     System.out.println(sheet.getCell(j, i).getContents());
34.                 }
35.             }
36.         } catch (BiffException e) {
37.             e.printStackTrace();
38.         } catch (IOException e) {
39.             e.printStackTrace();
40.         }
41.     }
42.     
43.     public void excelWrite(HttpServletResponse response) {
44.         long time = System.currentTimeMillis();// 用当前的系统时间作为默认表名
45.         String name = String.valueOf(time);
46.         name ="position";
47.         String pathName = name + ".xls";
48.         try {
49.             pathName = new String(pathName.getBytes(), "ISO-8859-1");
50.         } catch (UnsupportedEncodingException e) {
51.             e.printStackTrace();
52.         }
53.         // 获取弹出保存框的保存路径和表名
54.         response.setContentType("APPLICATION/OCTET-STREAM");
55.         response.setHeader("Content-Disposition", "attachment; filename=\"" + pathName + "\"");
56.         
57.         WritableWorkbook workbook;
58.         WorkbookSettings   workbookSettings=new   WorkbookSettings(); 
59.         workbookSettings.setEncoding("GB2312");
60.         try {
61.             workbook = Workbook.createWorkbook(response.getOutputStream(),workbookSettings);
62.             WritableSheet ws = workbook.createSheet("sheet 1", 0);
63.             ws.setColumnView(0,22);
64.             Label cell = null;
65.             for(int i=0;i<2;i++){
66.                 cell = new Label(0, i+1, "id");
67.                 ws.addCell(cell);
68.                 cell = new Label(1, i+1, "name");
69.                 ws.addCell(cell);
70.                 
71.             }
72.             workbook.write();
73.             workbook.close();   // 一定要关闭, 否则没有保存Excel;
74.         } catch (IOException e) {
75.             e.printStackTrace();
76.         }catch (WriteException e) {
77.             e.printStackTrace();
78.         } 
79.         
80.     }
81.     
83. }

3、解析过程还是比较简单的。