convert Excel Cell Address To Int Array - Java Native OS

Java examples for Native OS:Excel

  1. HOME
  2. Java
  3. Native OS
  4. Excel

Description

convert Excel Cell Address To Int Array

Demo Code


//package com.java2s;

public class Main {
    public static int[] convertCellAddressToIntArray(String cellAddress) {
        int[] address = new int[2];

        String col = cellAddress.replaceAll("[0-9]", "");
        int row = Integer.valueOf(cellAddress.replaceAll("[a-zA-Z]", ""));

        address[0] = letter2Int(col);/*from w  w w .  jav a2 s  . co  m*/
        address[1] = (row == 0) ? row : row - 1;

        return address;
    }

    private static int letter2Int(String col) {
        String columnName = col.toUpperCase();
        int value = 0;
        for (int i = 0; i < columnName.length(); i++) {
            int delta = (columnName.charAt(i)) - 64;
            value = value * 26 + delta;
        }

        return value - 1;
    }
}

Related Tutorials