Java: Find the Excel column name

Last update on December 21 2024 09:59:39 (UTC/GMT +8 hours)

Excel Column from Number

Write a Java program to find the Excel column name that corresponds to a given column number (integer value).

Sample Solution:

Java Code:

import java.util.*;
import java.lang.Character;

class solution {
  public static String Column(int n) {
    String str_column = "";

    while (n > 0) {
      int col_val = (n - 1) % 26;
      str_column = (char)(col_val + 'A') + str_column;
      n = (n - 1) / 26;
    }

    return str_column;
  }
  public static void main(String[] args) {
    Scanner scan = new Scanner(System.in);
    System.out.print("Input the number: ");
    int n = scan.nextInt();

    System.out.println("Excel Column: " + Column(n));
  }
}

Sample Output:

Input the number:  5
Excel Column: E

Flowchart:

Java Code Editor:

Contribute your code and comments through Disqus.

Previous: Multiply two numbers using bitwise operators.
Next: Find the angle between the hour and minute hands.