poi解析xls和xlsx

- 日理万妓 2022-08-09 00:39 240阅读 0赞

package cn.mrcast.action;  
  
  
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;  
  
//解析xls和xlsx主方法，读取所有行所有列的内容  
public class ReserXLS \{  
  
   public static void main(String\[\] args) throws IOException \{  
//    readXls();  
    readXlsx();  
  \}  
  
  
  private static void readXls() throws IOException\{  
    InputStream is = new FileInputStream( "D:\\\\test1.xls");  
    HSSFWorkbook hssfWorkbook = new HSSFWorkbook( is);   
      
    // 循环工作表Sheet  
    for(int numSheet = 0; numSheet < hssfWorkbook.getNumberOfSheets(); numSheet++)\{  
      HSSFSheet hssfSheet = hssfWorkbook.getSheetAt( numSheet);  
      if(hssfSheet == null)\{  
        continue;  
      \}  
        
      // 循环行Row   
      for(int rowNum = 0; rowNum <= hssfSheet.getLastRowNum(); rowNum++)\{  
        HSSFRow hssfRow = hssfSheet.getRow( rowNum);  
        if(hssfRow == null)\{  
          continue;  
        \}  
          
        // 循环列Cell    
        for(int cellNum = 0; cellNum <= hssfRow.getLastCellNum(); cellNum++)\{  
          HSSFCell hssfCell = hssfRow.getCell( cellNum);  
          if(hssfCell == null)\{  
            continue;  
          \}  
            
          System.out.print("    " + getValue( hssfCell));  
        \}  
        System.out.println();  
      \}  
    \}  
  \}  
    
  @SuppressWarnings("static-access")  
  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());  
    \}  
  \}  
    
  
  
  private static void readXlsx() throws IOException\{  
    String fileName = "D:\\\\test2-1.xlsx";  
    XSSFWorkbook xssfWorkbook = new XSSFWorkbook( fileName);  
      
    // 循环工作表Sheet  
    for(int numSheet = 0; numSheet < xssfWorkbook.getNumberOfSheets(); numSheet++)\{  
    System.out.println("\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*");  
      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("   "+getValue(xssfCell));  
        \}  
        System.out.println();  
      \}  
    \}  
  \}  
    
  @SuppressWarnings("static-access")  
  private static String getValue(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());  
    \}  
  \}  
    
\}