POI 实现excel导入
标签(空格分隔): POI
excel导入时excel导出的逆向过程,使用相同的类和方法来实现,具体的例子为:
package com.excel.poi;
import java.io.File;
import java.io.IOException;
import org.apache.commons.io.FileUtils;
import org.apache.poi.hssf.usermodel.HSSFCell;
import org.apache.poi.hssf.usermodel.HSSFRow;
import org.apache.poi.hssf.usermodel.HSSFSheet;
import org.apache.poi.hssf.usermodel.HSSFWorkbook;
public class PoiReadExcel {
public static void main(String[] args){
File file=new File("e:/poi_test.xls");
try{
//创建excel,读取文件内容
HSSFWorkbook workbook=new HSSFWorkbook(FileUtils.openInputStream(file));
//两种方式读取工作表
//HSSFSheet sheet=workbook.getSheet("sheet0");
//读取默认第一个sheet
HSSFSheet sheet=workbook.getSheetAt(0);
int fisrtRowNum=0;
int lastRowNum=sheet.getLastRowNum();
for(int i=fisrtRowNum;i<=lastRowNum;i++){
HSSFRow row=sheet.getRow(i);
int lastCellNum=row.getLastCellNum();
for(int j=0;j<lastCellNum;j++){
HSSFCell cell=row.getCell(j);
String value=cell.getStringCellValue();
System.out.print(value+" ");
}
System.out.println();
}
}catch(IOException e){
e.printStackTrace();
}
}
}