Write a C++ program to get the column number (integer value) that corresponds to a column title as appear in an Excel shee
- برمجة سي بلس بلس
- برمجة
- 2021-05-13
- MarwaMohammed
الأجوبة
#include <iostream>
using namespace std;
int excel_title_to_Number(string s) {
int number = 0;
for (const auto& c : s) {
number *= 26;
number += c - 'A' + 1;
}
return number;
}
int main(void)
{
string col_title1 ="C";
cout << "\nExcel column title = " << col_title1 << ", Corresponding number = " << excel_title_to_Number(col_title1) << endl;
col_title1 ="AD";
cout << "\nExcel column title = " << col_title1 << ", Corresponding number = " << excel_title_to_Number(col_title1) << endl;
col_title1 ="WX";
cout << "\nExcel column title = " << col_title1 << ", Corresponding number = " << excel_title_to_Number(col_title1) << endl;
return 0;
}أسئلة مشابهة
القوائم الدراسية التي ينتمي لها السؤال