POI的简单用例

小咪咪 2022-08-07 01:45 240阅读 0赞

/**
    需求：读取Excel中的内容
    实现步骤：
    1、构建对象XSSFWorkbook，创建工作对象
    2、获取工作表sheet的个数 XSSFSheet sheet = XSSFWorkbook.getNumberOfSheets()
    3、获取页的行数XSSFRow row = xSheet.getLastRowNum()
    4、获取cell个数XSSFCell cell = getLastCellNum()
    5、根据类型获取值：
    xCell.getCellType() == XSSFCell.CELL_TYPE_BOOLEAN
    获取值：xCell.getBooleanCellValue()
    xCell.getCellType() == XSSFCell.CELL_TYPE_NUMERIC
    获取值：xCell.getNumericCellValue()
    字符串：
    xCell.getStringCellValue()
    */
    
    import java.io.FileInputStream;
    import java.io.FileNotFoundException;
    import java.io.IOException;
    import java.io.InputStream;
    import java.util.ArrayList;
    import java.util.List;
    import java.lang.Exception;
    import java.lang.Object;
    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;
    
    class ExcelReaderDemo
    {
    	public static void main(String[] args) 
    	{
    		ExcelReader excel = new ExcelReader("C:\\Users\\dengshiwei\\Desktop\\1.xlsx");
    		excel.readExcelData();
    	}
    }
    
    class ExcelReader
    {
    	private String path;
    	public ExcelReader(String path)
    	{
    		this.path = path;
    	}
    
    	public void readExcelData()
    	{
    		XSSFWorkbook xwb = null;
    		try
    		{
    			xwb = new XSSFWorkbook(path);
    			for(int iSheet=0;iSheet<xwb.getNumberOfSheets();iSheet++)
    			{
    				XSSFSheet xSheet = xwb.getSheetAt(iSheet);
    				if (xSheet == null)
    				{
    					continue;
    				}
    				for(int iRow=0;iRow<=xSheet.getLastRowNum();iRow++)
    				{
    					XSSFRow xRow = xSheet.getRow(iRow); 
    					if (xRow == null) 
    					{  
                            continue;  
                        }  
    					for (int iCell = 0; iCell <= xRow.getLastCellNum(); iCell++)
    					{
    						XSSFCell xCell = xRow.getCell(iCell);
    						if (xCell == null || "".equals(xCell))
    							System.out.println();
    						else if (xCell.getCellType() == XSSFCell.CELL_TYPE_BOOLEAN)
                                System.out.println(xCell.getBooleanCellValue());  
                            else if (xCell.getCellType() == XSSFCell.CELL_TYPE_NUMERIC)
                                System.out.println(xCell.getNumericCellValue());  
                            else 
                                System.out.println(xCell.getStringCellValue()); 
    					}
    				}
    			}
    		}
    		catch (Exception ex)
    		{
    			ex.printStackTrace();
    		}
    	}
    }

![Center][]

注意：

1、导入的包：

![Center 1][]

常见帮助文档连接：

http://poi.apache.org/apidocs/org/apache/poi/xssf/usermodel/XSSFWorkbook.html

帮助文档：

http://www.yiibai.com/apache\_poi/apache\_poi\_core\_classes.html

[Center]: /images/20220805/d225f354d655435f8fcdad3883b49752.png
[Center 1]: /images/20220805/c3a777d4bc974a759204dac200e8bfbe.png