Enum ExcelWorksheetTransUnitProperty

    • Method Detail

      • values

        public static ExcelWorksheetTransUnitProperty[] values()
        Returns an array containing the constants of this enum type, in the order they are declared. This method may be used to iterate over the constants as follows:
        for (ExcelWorksheetTransUnitProperty c : ExcelWorksheetTransUnitProperty.values())
            System.out.println(c);
        
        Returns:
        an array containing the constants of this enum type, in the order they are declared
      • valueOf

        public static ExcelWorksheetTransUnitProperty valueOf​(String name)
        Returns the enum constant of this type with the specified name. The string must match exactly an identifier used to declare an enum constant in this type. (Extraneous whitespace characters are not permitted.)
        Parameters:
        name - the name of the enum constant to be returned.
        Returns:
        the enum constant with the specified name
        Throws:
        IllegalArgumentException - if this enum type has no constant with the specified name
        NullPointerException - if the argument is null
      • getKeyName

        public String getKeyName()
      • getColumnIndexFromCellRef

        public static String getColumnIndexFromCellRef​(String cellReference)
        Returns the Column Index part from the Cell Reference. 'A1' -> A 'Z1' -> Z
        Parameters:
        cellReference - a cell reference.
        Returns:
        the column reference.
      • getRowNumberFromCellRef

        public static Integer getRowNumberFromCellRef​(String cellReference)
        Returns the Row Number part from the Cell Reference. 'A1' -> 1 'B1' -> 2
        Parameters:
        cellReference - a cell reference.
        Returns:
        the column reference.
      • getColumnIndexFromColumnRef

        public static int getColumnIndexFromColumnRef​(String columnReference)
        Converts a column reference from ALPHA-26 number format to 0-based base 10. 'A' -> 0 'Z' -> 25
        Returns:
        zero based column index