poi读取excel文件

/**
* poi生成excel文件
*/
public void wriExcel(){
String[] name={"id","name","sex"};
//创建excel工作薄
HSSFWorkbook workbook=new HSSFWorkbook();
//创建一个工作表的sheet
HSSFSheet sheet=workbook.createSheet();
//创建第一行
HSSFRow row=sheet.createRow(0);
HSSFCell cell=null;
for(int i=0;i<name.length;i++){
cell=row.createCell(i);
cell.setCellValue(name[i]);
}
//追加数据
for(int i=1;i<5;i++){
HSSFRow row1=sheet.createRow(i);
HSSFCell cell2=row1.createCell(0);
cell2.setCellValue(""+i);
cell2=row1.createCell(1);
cell2.setCellValue("wo");
cell2=row1.createCell(2);
cell2.setCellValue("男");
}
//创建一个文件
File file=new File("e:/poi_test.xls");
try {
FileOutputStream stream=FileUtils.openOutputStream(file);
workbook.write(stream);
stream.close();
} catch (Exception e) {
e.printStackTrace();
}
}
/**
* poi解析excel
*/
public void readExcel(){
//需要解析的文件
File file=new File("e:/poi_test.xls");
try {
//创建excel读取文件内容
HSSFWorkbook workbook=new HSSFWorkbook(FileUtils.openInputStream(file));
//创建sheet
HSSFSheet sheet=workbook.getSheetAt(0);
int row=0;
int lastRow=sheet.getLastRowNum();
for(int i=row;i<lastRow;i++){
HSSFRow rowss=sheet.getRow(i);
int lastcell=rowss.getLastCellNum();
for(int j=0;j<lastcell;j++){
HSSFCell cell=rowss.getCell(j);
String value=cell.getStringCellValue();
System.out.print(value+" ");
}
System.out.println();
}
} catch (Exception e) {
e.printStackTrace();
}
}