Excel工具类POIExcelUtil

来源：互联网发布：淘宝非实名认证手机卡编辑：程序博客网时间：2024/06/08 13:34
import java.io.FileInputStream;import java.io.IOException;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.xssf.usermodel.XSSFCell;import org.apache.poi.xssf.usermodel.XSSFRow;import org.apache.poi.xssf.usermodel.XSSFSheet;import org.apache.poi.xssf.usermodel.XSSFWorkbook;public class POIExcelUtil {public static void readXls() throws IOException {InputStream is = new FileInputStream("D:\\excel\\xls_test2.xls");HSSFWorkbook hssfWorkbook = new HSSFWorkbook(is);// 循环工作表Sheetfor (int numSheet = 0; numSheet < hssfWorkbook.getNumberOfSheets(); numSheet++) {HSSFSheet hssfSheet = hssfWorkbook.getSheetAt(numSheet);if (hssfSheet == null) {continue;}// 循环行Rowfor (int rowNum = 0; rowNum <= hssfSheet.getLastRowNum(); rowNum++) {HSSFRow hssfRow = hssfSheet.getRow(rowNum);if (hssfRow == null) {continue;}// 循环列Cellfor (int cellNum = 0; cellNum <= hssfRow.getLastCellNum(); cellNum++) {HSSFCell hssfCell = hssfRow.getCell(cellNum);if (hssfCell == null) {continue;}System.out.print("    " + getValue(hssfCell));}System.out.println();}}}public 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());}}//xlsxpublic static void readXlsx() throws IOException{      String fileName = "D:\\excel\\xlsx_test.xlsx";      XSSFWorkbook xssfWorkbook = new XSSFWorkbook( fileName);            // 循环工作表Sheet      for(int numSheet = 0; numSheet < xssfWorkbook.getNumberOfSheets(); numSheet++){        XSSFSheet xssfSheet = xssfWorkbook.getSheetAt( numSheet);        if(xssfSheet == null){          continue;        }                // 循环行Row         for(int rowNum = 0; rowNum <= xssfSheet.getLastRowNum(); rowNum++ ){          XSSFRow xssfRow = xssfSheet.getRow( rowNum);          if(xssfRow == null){            continue;          }                    // 循环列Cell             for(int cellNum = 0; cellNum <= xssfRow.getLastCellNum(); cellNum++){            XSSFCell xssfCell = xssfRow.getCell( cellNum);            if(xssfCell == null){              continue;            }            System.out.print("   "+getsValue(xssfCell));          }          System.out.println();        }      }    }  public static String getsValue(XSSFCell xssfCell){      if(xssfCell.getCellType() == xssfCell.CELL_TYPE_BOOLEAN){        return String.valueOf( xssfCell.getBooleanCellValue());      }else if(xssfCell.getCellType() == xssfCell.CELL_TYPE_NUMERIC){        return String.valueOf( xssfCell.getNumericCellValue());      }else{        return String.valueOf( xssfCell.getStringCellValue());      }    }  }
0 0