JAVA使用POI读取EXCEL文件的简单model

 

[java] view plain copy

print ?

1. package poi;  
2. import java.io.FileInputStream;  
3. import java.io.IOException;  
4. import java.io.InputStream;  
5. import java.util.Iterator;  
6. import org.apache.poi.hssf.usermodel.HSSFCell;  
7. import org.apache.poi.hssf.usermodel.HSSFWorkbook;  
8. import org.apache.poi.ss.usermodel.Cell;  
9. import org.apache.poi.ss.usermodel.Row;  
10. import org.apache.poi.ss.usermodel.Sheet;  
11. import org.apache.poi.ss.usermodel.Workbook;  
12. import org.apache.poi.xssf.usermodel.XSSFWorkbook;  
13.    
14. public class ReadExcel001 {  
15.     public static void main(String[] args) {  
16.         readXml(“D:/test.xlsx”);  
17.         System.out.println("-------------");  
18.         readXml(“d:/test2.xls”);  
19.     }  
20.     public static void readXml(String fileName){  
21.         boolean isE2007 = false;    //判断是否是excel2007格式  
22.         if(fileName.endsWith(“xlsx”))  
23.             isE2007 = true;  
24.         try {  
25.             InputStream input = new FileInputStream(fileName);  //建立输入流  
26.             Workbook wb  = null;  
27.             //根据文件格式(2003或者2007)来初始化  
28.             if(isE2007)  
29.                 wb = new XSSFWorkbook(input);  
30.             else  
31.                 wb = new HSSFWorkbook(input);  
32.             Sheet sheet = wb.getSheetAt(0);     //获得第一个表单  
33.             Iterator<Row> rows = sheet.rowIterator(); //获得第一个表单的迭代器  
34.             while (rows.hasNext()) {  
35.                 Row row = rows.next();  //获得行数据  
36.                 System.out.println(“Row #” + row.getRowNum());  //获得行号从0开始  
37.                 Iterator<Cell> cells = row.cellIterator();    //获得第一行的迭代器  
38.                 while (cells.hasNext()) {  
39.                     Cell cell = cells.next();  
40.                     System.out.println(“Cell #” + cell.getColumnIndex());  
41.                     switch (cell.getCellType()) {   //根据cell中的类型来输出数据  
42.                     case HSSFCell.CELL_TYPE_NUMERIC:  
43.                         System.out.println(cell.getNumericCellValue());  
44.                         break;  
45.                     case HSSFCell.CELL_TYPE_STRING:  
46.                         System.out.println(cell.getStringCellValue());  
47.                         break;  
48.                     case HSSFCell.CELL_TYPE_BOOLEAN:  
49.                         System.out.println(cell.getBooleanCellValue());  
50.                         break;  
51.                     case HSSFCell.CELL_TYPE_FORMULA:  
52.                         System.out.println(cell.getCellFormula());  
53.                         break;  
54.                     default:  
55.                         System.out.println(“unsuported sell type”);  
56.                     break;  
57.                     }  
58.                 }  
59.             }  
60.         } catch (IOException ex) {  
61.             ex.printStackTrace();  
62.         }  
63.     }  
64. }  

package poi;

import java.io.FileInputStream;

import java.io.IOException;

import java.io.InputStream;

import java.util.Iterator;

import org.apache.poi.hssf.usermodel.HSSFCell;

import org.apache.poi.hssf.usermodel.HSSFWorkbook;

import org.apache.poi.ss.usermodel.Cell;

import org.apache.poi.ss.usermodel.Row;

import org.apache.poi.ss.usermodel.Sheet;

import org.apache.poi.ss.usermodel.Workbook;

import org.apache.poi.xssf.usermodel.XSSFWorkbook;

public class ReadExcel001 {
public static void main(String[] args) {
readXml(“D:/test.xlsx”);
System.out.println("-------------");
readXml(“d:/test2.xls”);
}
public static void readXml(String fileName){
boolean isE2007 = false; //判断是否是excel2007格式
if(fileName.endsWith(“xlsx”))
isE2007 = true;
try {
InputStream input = new FileInputStream(fileName); //建立输入流
Workbook wb = null;
//根据文件格式(2003或者2007)来初始化
if(isE2007)
wb = new XSSFWorkbook(input);
else
wb = new HSSFWorkbook(input);
Sheet sheet = wb.getSheetAt(0); //获得第一个表单
Iterator<Row> rows = sheet.rowIterator(); //获得第一个表单的迭代器
while (rows.hasNext()) {
Row row = rows.next(); //获得行数据
System.out.println(“Row #” + row.getRowNum()); //获得行号从0开始
Iterator<Cell> cells = row.cellIterator(); //获得第一行的迭代器
while (cells.hasNext()) {
Cell cell = cells.next();
System.out.println(“Cell #” + cell.getColumnIndex());
switch (cell.getCellType()) { //根据cell中的类型来输出数据
case HSSFCell.CELL_TYPE_NUMERIC:
System.out.println(cell.getNumericCellValue());
break;
case HSSFCell.CELL_TYPE_STRING:
System.out.println(cell.getStringCellValue());
break;
case HSSFCell.CELL_TYPE_BOOLEAN:
System.out.println(cell.getBooleanCellValue());
break;
case HSSFCell.CELL_TYPE_FORMULA:
System.out.println(cell.getCellFormula());
break;
default:
System.out.println(“unsuported sell type”);
break;
}
}
}
} catch (IOException ex) {
ex.printStackTrace();
}
}
}