JAVA读取xls文件和xlsx文件

系统管理员 2022-08-22 13:16 219阅读 0赞

\#\#\#所需jar包：

由于在csdn上下载需要50积分（积分是csdn固定规则确定的，无法修改）所以提供百度网盘下载地址：  
[https://pan.baidu.com/s/1r01c8zv44FQND91o8VmsLg][https_pan.baidu.com_s_1r01c8zv44FQND91o8VmsLg]

--------------------

\#\#\#xls和xlsx文件：office excel2007以后版本为xlsx,以前的版本为xls

--------------------

\#\#\#读取xlsx文件：

InputStream is = new FileInputStream(file);
    		XSSFWorkbook xssfWorkbook = new XSSFWorkbook(is);
    		// 获取每一个工作薄
    		for (int numSheet = 0; numSheet < xssfWorkbook.getNumberOfSheets(); numSheet++) {
    			XSSFSheet xssfSheet = xssfWorkbook.getSheetAt(numSheet);
    			if (xssfSheet == null) {
    				continue;
    			}
    			// 获取当前工作薄的每一行
    			for (int rowNum = 0; rowNum <= xssfSheet.getLastRowNum(); rowNum++) {
    				XSSFRow xssfRow = xssfSheet.getRow(rowNum);
    				if (xssfRow != null) {
    					XSSFCell one = xssfRow.getCell(0);
    					//读取第一列数据
    					XSSFCell two = xssfRow.getCell(1);
    					//读取第二列数据
    					XSSFCell three = xssfRow.getCell(2);
    					//读取第三列数据
    					//需要转换数据的话直接调用getValue获取字符串
    				}
    			}
    		}
    		//转换数据格式
    	private String getValue(XSSFCell xssfRow) {
    
    		if (xssfRow.getCellType() == xssfRow.CELL_TYPE_BOOLEAN) {
    			return String.valueOf(xssfRow.getBooleanCellValue());
    		} else if (xssfRow.getCellType() == xssfRow.CELL_TYPE_NUMERIC) {
    			return String.valueOf(xssfRow.getNumericCellValue());
    		} else {
    			return String.valueOf(xssfRow.getStringCellValue());
    		}
    	}

--------------------

\#\#\#读取xls文件：

InputStream is = new FileInputStream(file);
    		HSSFWorkbook hssfWorkbook = new HSSFWorkbook(is);
    		// 获取每一个工作薄
    		for (int numSheet = 0; numSheet < hssfWorkbook.getNumberOfSheets(); numSheet++) {
    			HSSFSheet hssfSheet = hssfWorkbook.getSheetAt(numSheet);
    			if (hssfSheet == null) {
    				continue;
    			}
    			// 获取当前工作薄的每一行
    			for (int rowNum = 0; rowNum <= hssfSheet.getLastRowNum(); rowNum++) {
    				HSSFRow hssfRow = hssfSheet.getRow(rowNum);
    				if (hssfRow != null) {
    					HSSFCell one = hssfRow.getCell(0);
    					//读取第一列数据
    					HSSFCell two = hssfRow.getCell(1);
    					//读取第二列数据
    					HSSFCell three = hssfRow.getCell(2);
    					//读取第三列数据
    					//需要转换数据的话直接调用getValue获取字符串
    				}
    			}
    		}
    		// 转换数据格式
    	private 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());
    		}
    	}

--------------------

\#\#\#注意上述代码需要excel中有列名·

[https_pan.baidu.com_s_1r01c8zv44FQND91o8VmsLg]: https://pan.baidu.com/s/1r01c8zv44FQND91o8VmsLg