Class RangeAddress


  • public class RangeAddress
    extends Object
    Title: Range Address

    Description: provides connectivity utilities for ranges

    REFERENCE:

    Version:
    1.0
    Author:
    IgOr KaTz && EuGeNe BuMaGiN (Tal Moshaiov) (VistaPortal LDT.)
    • Constructor Detail

      • RangeAddress

        public RangeAddress​(String _url)
        Accepts an external reference from excel.

        i.e. Sheet1!$A$4:$B$9

        Parameters:
        _url -
      • RangeAddress

        public RangeAddress​(int _startCol,
                            int _startRow,
                            int _endCol,
                            int _endRow)
    • Method Detail

      • getAddress

        public String getAddress()
        Returns:
        String note: All absolute references are removed
      • getSheetName

        public String getSheetName()
      • getRange

        public String getRange()
      • isCellOk

        public boolean isCellOk​(String _cell)
      • isSheetNameOk

        public boolean isSheetNameOk()
      • isSheetNameOk

        public static boolean isSheetNameOk​(String _sheetName)
      • getFromCell

        public String getFromCell()
      • getToCell

        public String getToCell()
      • getWidth

        public int getWidth()
      • getHeight

        public int getHeight()
      • setSize

        public void setSize​(int _width,
                            int _height)
      • hasSheetName

        public boolean hasSheetName()
      • hasRange

        public boolean hasRange()
      • hasCell

        public boolean hasCell()
      • getYPosition

        public int getYPosition​(String _subrange)
      • getXPosition

        public int getXPosition​(String _subrange)
      • getDigitPart

        public String getDigitPart​(String _value)
      • getCharPart

        public String getCharPart​(String _value)
      • get26Sys

        public int get26Sys​(String _s)
      • numTo26Sys

        public String numTo26Sys​(int _num)