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.