@Test
public void poiTest() throws Exception{
//读取一个文件
FileInputStream fs = new FileInputStream(new File("c://名单.xls"));
POIFSFileSystem psfs = new POIFSFileSystem(fs);
HSSFWorkbook wb = new HSSFWorkbook(psfs);
//获取第一张表
HSSFSheet sheet = wb.getSheetAt(0);
//开始遍历表中的行
for(int rowNum = 0; rowNum<sheet.getLastRowNum(); rowNum++){
HSSFRow row = sheet.getRow(rowNum);
if(row==null){
continue;
}
//开始遍历行对应列单元格
for(int cellNum=0; cellNum<row.getLastCellNum(); cellNum++){
HSSFCell cell = row.getCell(cellNum);
if(cell==null){
continue;
}
System.out.print(" "+getValue(cell));
}
System.err.println();
}
}
private String getValue(Cell cell){
if(cell.getCellType()==cell.CELL_TYPE_BOOLEAN){
return String.valueOf(cell.getBooleanCellValue());
}
if(cell.getCellType()==cell.CELL_TYPE_NUMERIC){
return String.valueOf(cell.getNumericCellValue());
}
if(cell.getCellType()==cell.CELL_TYPE_STRING){
return String.valueOf(cell.getStringCellValue());
}
return null;
}
//直接获取文件中的文本
@Test
public void poiTest1() throws Exception{
//读取一个文件
FileInputStream fs = new FileInputStream(new File("c://名单.xls"));
POIFSFileSystem poifs = new POIFSFileSystem(fs);
HSSFWorkbook wb = new HSSFWorkbook(poifs);
ExcelExtractor ex = new ExcelExtractor( wb);
ex.setIncludeSheetNames(false);
System.out.println(ex.getText());
}
简单的读取excel文件
最新推荐文章于 2023-07-03 20:08:58 发布