Method Details

• RowIndexToName

  public static String RowIndexToName(int index)

  Gets row name according to row index.

  Parameters:

  index - row index

  Returns:

  the name of row

• RowNameToIndex

  public static int RowNameToIndex(String name)

  Gets row index according to row name.

  Parameters:

  name - row name

  Returns:

  the index of row

• ColumnIndexToName

  public static String ColumnIndexToName(int index)

  Gets column name according to column index.

  Parameters:

  index - column index

  Returns:

  the name of column

• ColumnNameToIndex

  public static int ColumnNameToIndex(String name)

  Gets column index according to column name.

  Parameters:

  name - column name

  Returns:

  the index of column

• CellIndexToName

  public static String CellIndexToName(int row, int column)

  Gets cell name(address) according to its row and column indexes.

  Parameters:

  row - row index

  column - column index

  Returns:

  the address of cell

• CellNameToIndex

  public static int[] CellNameToIndex(String name)

  Gets cell row and column according to its name(address).

  Parameters:

  name - cell name

  Returns:

  a array containing the converted row and column index

• GetRangeBoundary

  public static Rectangle GetRangeBoundary(IRange range)

  Gets the position and size (in pixels) of the specified range.

  Parameters:

  range - The range object

  Returns:

  a rectangle containing the position and size of the range