基本操作--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;
    }
用户注册

用户登录

发表随想

该用户最新代码

编程随想

[java]代码库

网友评论 (发表评论)

发表评论：

评论须知：

扫码下载

输入口令后可复制整站源码
