POI导入Excel数据

 

Excel:

java代码:

 public void readExcel() throws IOException{  
	        FileInputStream inputStream = new FileInputStream(new File("C:/Users/Administrator/Desktop/aaa.xls"));  
	        //读取工作簿  
	        HSSFWorkbook workBook = new HSSFWorkbook(inputStream); 
	        int numberOfSheets = workBook.getNumberOfSheets();
	        System.err.println("工作薄数量:"+numberOfSheets);
	        //读取工作表  
	        HSSFSheet sheet = workBook.getSheetAt(0);  
	        	        
	        //获取有效的行数:
	        int rowcount = sheet.getLastRowNum();  
	        System.err.println("效的行数:"+rowcount);
	        //获取有效的列数(第一行为标题)
	        short lastCellNum = sheet.getRow(1).getLastCellNum(); 
	        System.err.println("效的列数:"+lastCellNum);
	        //获取数据
	        for (int i = 0; i < rowcount; i++) {
	        	 //读取行  
		        HSSFRow row = sheet.getRow(i);  
				for (int j = 0; j <lastCellNum; j++) {
					//读取单元格  
			        HSSFCell cell = row.getCell(j);  
			        String value = cell.getStringCellValue();  
			        System.out.print(value+" ");  
				}
				  System.out.println();
			}
	        inputStream.close();  
	        workBook.close();//最后记得关闭工作簿  
	    }  

执行结果:

 

https://www.cnblogs.com/huajiezh/p/5467821.html