基本操作--Excel--找对应内容在Excel中的行下标和列下标

[java]代码库

	例如第3行第2列的内容是("你好")

那么 getRowNumberByNameXlsx(sheet,"你好")的返回值就是 2
       getColumnNumberByNameXlsx(sheet,"你好") 的返回值是1


//根据名称,获取所在单元格的行下标
	public static int getRowNumberByNameXlsx(XSSFSheet sheet, String itemName) {
		int result=-1;
		for (int rowNumber = 0; rowNumber < sheet.getLastRowNum(); rowNumber++) {
			XSSFRow row = sheet.getRow(rowNumber); // 获取第x行对象
			int rowLength = row.getLastCellNum();// 获取第x行的列数
			for (int columnNumber = 0; columnNumber < rowLength; columnNumber++) {
				XSSFCell cell = row.getCell(columnNumber);
				if (null != cell&& cell.getCellType() == XSSFCell.CELL_TYPE_STRING) {
					if (cell.getStringCellValue().equals(itemName)) {
                         result=rowNumber;
						break;
					}
				}
			}
		}
		return result;
	}
	
	//根据名称,获取所在单元格的行下标
	public static int getRowNumberByNameXls(HSSFSheet sheet, String itemName) {
		int result=-1;
		for (int rowNumber = 0; rowNumber < sheet.getLastRowNum(); rowNumber++) {
			HSSFRow row = sheet.getRow(rowNumber); // 获取第x行对象
			int rowLength = row.getLastCellNum();// 获取第x行的列数
			for (int columnNumber = 0; columnNumber < rowLength; columnNumber++) {
				HSSFCell cell = row.getCell(columnNumber);
				if (null != cell&& cell.getCellType() == XSSFCell.CELL_TYPE_STRING) {
					if (cell.getStringCellValue().equals(itemName)) {
                         result=rowNumber;
						break;
					}
				}
			}
		}
		return result;
	}
	
	//根据名称,获取所在单元格的列下标
	public static int getColumnNumberByNameXlsx(XSSFSheet sheet, String itemName) {
		int result=-1;
		for (int rowNumber = 0; rowNumber < sheet.getLastRowNum(); rowNumber++) {
			XSSFRow row = sheet.getRow(rowNumber); // 获取第x行对象
			int rowLength = row.getLastCellNum();// 获取第x行的列数
			for (int columnNumber = 0; columnNumber < rowLength; columnNumber++) {
				XSSFCell cell = row.getCell(columnNumber);
				if (null != cell&& cell.getCellType() == XSSFCell.CELL_TYPE_STRING) {
					if (cell.getStringCellValue().equals(itemName)) {
                         result=columnNumber;
						break;
					}
				}
			}
		}
		return result;
	}
	
	//根据名称,获取所在单元格的列下标
	public static int getColumnNumberByNameXls(HSSFSheet sheet, String itemName) {
		int result=-1;
		for (int rowNumber = 0; rowNumber < sheet.getLastRowNum(); rowNumber++) {
			HSSFRow row = sheet.getRow(rowNumber); // 获取第x行对象
			int rowLength = row.getLastCellNum();// 获取第x行的列数
			for (int columnNumber = 0; columnNumber < rowLength; columnNumber++) {
				HSSFCell cell = row.getCell(columnNumber);
				if (null != cell&& cell.getCellType() == XSSFCell.CELL_TYPE_STRING) {
					if (cell.getStringCellValue().equals(itemName)) {
                         result=columnNumber;
						break;
					}
				}
			}
		}
		return result;
	}