【web开发】☆★之利用POI操作Excel表格系列教程【6】遍历工作簙行和列取值
package com.xiaoye.demo;import java.io.FileInputStream;import java.io.InputStream;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;import org.apache.poi.poifs.filesystem.POIFSFileSystem;/*** 遍历工作薄的行和列取值* @author 小夜的传说* -2-21 上午11:07:41*/public class ThrRowCell {public static void main(String[] args) throws Exception {InputStream in=new FileInputStream("d://测试文件.xls");POIFSFileSystem fs=new POIFSFileSystem(in);HSSFWorkbook wb=new HSSFWorkbook(fs);HSSFSheet hssfSheet=wb.getSheetAt(0);//获取第一个Sheet页if(hssfSheet==null){return;}//先要遍历行for(int rowNum=0;rowNum<=hssfSheet.getLastRowNum();rowNum++){HSSFRow h***ow=hssfSheet.getRow(rowNum);if(h***ow==null){continue;}for(int cellNum=0;cellNum<=h***ow.getLastCellNum();cellNum++){HSSFCell hssfCell=h***ow.getCell(cellNum);if(hssfCell==null){continue;}System.out.print("--"+getValue(hssfCell));}System.out.println();}}private static String getValue(HSSFCell hssfCell){if(hssfCell.getCellType()==HSSFCell.CELL_TYPE_BOOLEAN){return String.valueOf(hssfCell.getBooleanCellValue());}else if(hssfCell.getCellType()==HSSFCell.CELL_TYPE_NUMERIC){return String.valueOf(hssfCell.getNumericCellValue());}else{return String.valueOf(hssfCell.getStringCellValue());}}}
获取的Excel表格的样式图示:
控制台效果图:
因为Excel数据库传进来的值千变万化,所以我封装了getValue()方法,当然里面的方法肯定不止这么多,你需要什么样就写什么样的吧!