我试图读取Excel文件到Java代码
文件作为分组行缩进我试图生成嵌套的工作休息结构分组行例如1.1.1
我用的是apache POi 3.7
这是密码

public class ExcelReaderforHierarchy {
    
     public static boolean importExcel() throws Exception {
         boolean ret= false;
            try {
                String a_fileName = "E:\\groupedRow.xls";
                FileInputStream w_In = new FileInputStream(a_fileName);
                // Load the workbook
                HSSFWorkbook workbook = new HSSFWorkbook(w_In);

                // Get the first sheet in the workbook
                Sheet sheet = workbook.getSheetAt(0);

                generateWBSCodes(sheet);

                ret = true;

                // Close the workbook and file input stream
              //  workbook.close();
              //  file.close();
            } catch (IOException e) {
                e.printStackTrace();
                return false;
            }
            return ret;
        }
      private static void generateWBSCodes(Sheet sheet) {
            int currentLevel = 0;
            int groupIndex = 1;

            // Iterate over the rows in the sheet
            for (Row row : sheet) {
                // Check if the row is grouped
                if (isGroupedRow(row)) {
                    currentLevel++;
                    groupIndex = 1;
                }

                // Generate and print the WBS code
                String wbsCode = generateWBSCode(currentLevel, groupIndex);
                System.out.println("Row: " + row.getRowNum() + ", WBS Code: " + wbsCode);

                // Increment group index for the next row
                groupIndex++;
            }
        }

        private static boolean isGroupedRow(Row row) {
            Cell cell = row.getCell(0);
            try {
                 System.out.println("cellval -" + cell.getStringCellValue());
            } catch (Exception e) {
                e.printStackTrace();
            }
           
          
                HSSFCellStyle cellStyle = (HSSFCellStyle) cell.getCellStyle();
                if (cellStyle != null) {
                    short indentLevel = cellStyle.getIndention();
                    System.out.println("indentLevel -" + cellStyle.getIndention()); // THIS always returns 0
                    return indentLevel > 0;
                }
          
            return false;
        }

        private static String generateWBSCode(int level, int index) {
            StringBuilder wbsCodeBuilder = new StringBuilder();
            for (int i = 0; i < level; i++) {
                if (i > 0) {
                    wbsCodeBuilder.append(".");
                }
                wbsCodeBuilder.append(index);
            }
            return wbsCodeBuilder.toString();
        }
    }

问题是cellStyle.getIndention();总是返回0
因此，我无法检测它是否是分组行
我也没有得到任何错误…