Class RangeAddress

java.lang.Object
loci.poi.hssf.util.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 Details

    • 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 Details

    • 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)
    • replaceString

      public String replaceString(String _source, String _oldPattern, String _newPattern)
    • removeString

      public String removeString(String _source, String _match)