C++ Examples

C++ Program to Get Excel Column title in Excel Column Number

The Program in C++ Program to Get the Excel column title that corresponds to a given column number is given below:

#include <iostream>
#include <string>

using namespace std;

string getExcelColumnTitle(int columnNumber) {
  string columnTitle = "";
  while (columnNumber > 0) {
    int rem = (columnNumber - 1) % 26;
    columnTitle = char(rem + 'A') + columnTitle;
    columnNumber = (columnNumber - 1) / 26;
  }
  return columnTitle;
}

int main() {
  int columnNumber;
  cout << "Hello Codeauri Family,enter the column number here to find out the excel column title: ";
  cin >> columnNumber;
  cout << "Okay,the excel column title is: " << getExcelColumnTitle(columnNumber) << endl;
  return 0;
}

Output:

Hello Codeauri Family,enter the column number here to find out the excel column title: 45
Okay,the excel column title is: AS

Pro-Tips💡

In this program, the getExcelColumnTitle function converts the given column number to its corresponding Excel column title by using the modulo and integer division operations.

The main function takes the user input for the column number and outputs the corresponding Excel column title by calling the getExcelColumnTitle function.

Learn C-Sharp ↗

C-sharp covers every topic to learn about C-Sharp thoroughly.

Learn C Programming ↗

C-Programming covers every topic to learn about C-Sharp thoroughly.

Learn C++ Programming↗

C++ covers every topic to learn about C-Sharp thoroughly.

Codeauri is Code Learning Hub and Community for every Coder to learn Coding by navigating Structurally from Basic Programming to Front-End Development, Back-End Development to Database, and many more.

Related Posts

C# Program to Find Sum of Rows & Columns of a Matrix

The Program in C# Program to Find Sum of Rows & Columns of a Matrix is given below: Output: Hello Codeauri Family,enter the number of rows and columns…

C# Program to Calculate Determinant of Given Matrix

The Program in C# Program to Calculate Determinant of Given Matrix is given below: Output: Hello Codeauri Family, enter the number of rows and columns of the matrix…

C# Program to Find Sum of right Diagonals of a Matrix

The Program in C# Program to Find Sum of right Diagonals of a Matrix is given below: Output: Hello Codeauri Family, enter the number of rows and columns…

C# Program to Find Transpose of Given Matrix

The Program in C# Program to Find Transpose of Given Matrix is given below: Output: Hello Codeauri Family, enter the number of rows and columns in the matrix:22Enter…

C# Program for Multiplication of two square Matrices

The Program in C# Program for Multiplication of two square Matrices is given below: Output: Hello Codeauri Family, enter the number of rows/columns in the matrices:2Enter the elements…

C# Program to Delete Element at Desired position From Array

The Program in C# Program to Delete Element at Desired position From Array is given below: Output: Hello Codeauri Family, enter the number of elements in the array:4Enter…

Leave a Reply

Your email address will not be published. Required fields are marked *

Your Journey into Code Begins Now: Discover the Wonders of Basic Programming

X