遍歷一個工作簿

package com.java.poi;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;import java.io.FileInputStream; import java.io.InputStream;/*** 遍歷一個工作簿* @author nidegui* @create 2019-06-17 9:46*/ public class Test5 {public static void main(String[] args) throws Exception {InputStream is=new FileInputStream("E:\\2.xls");POIFSFileSystem fs=new POIFSFileSystem(is); //接受一個輸入流HSSFWorkbook wb=new HSSFWorkbook(fs);//創建了一個工作簿HSSFSheet hssfSheet=wb.getSheetAt(0); //獲取第一個sheet頁if(hssfSheet==null){return;}//遍歷行rowfor (int rownum=0;rownum<=hssfSheet.getLastRowNum();rownum++){HSSFRow sheetRow = hssfSheet.getRow(rownum);if(sheetRow==null){continue;}//遍歷列cellfor (int cellnum=0;cellnum<=sheetRow.getLastCellNum();cellnum++){HSSFCell cell = sheetRow.getCell(cellnum);if(cell==null){continue;}System.out.print( " "+getValue(cell));}System.out.println();}}/*** 靜態* @param hssfCell* @return*/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());}} }

　　

?

轉載于:https://www.cnblogs.com/nidegui/p/11038627.html

總結

以上是生活随笔為你收集整理的java操作Excel的poi 遍历一个工作簿的全部內容，希望文章能夠幫你解決所遇到的問題。

如果覺得生活随笔網站內容還不錯，歡迎將生活随笔推薦給好友。