C Exercises: Get the column number that corresponds to a column title as appear in an Excel sheet
C Programming Mathematics: Exercise-9 with Solution
Write a C program to get the column number (integer value) that corresponds to a column title as appear in an Excel sheet.
For example:
A -> 1
B -> 2
C -> 3
...
Z -> 26
AA -> 27
AB -> 28
...
Example:
Input:
col_title1[ ] ="C"
col_title2[ ] ="AC"
col_title3[ ] ="ZY"
Output:
Corresponding number: 3
Corresponding number: 29
Corresponding number: 701
Pictorial Presentation:
Sample Solution:
C Code:
#include <stdio.h>
int excel_title_to_Number(char* s) {
int k = 0;
while (s && *s) {
k = k * 26 + (*s) - 'A' + 1;
s ++;
}
return k;
}
int main(void)
{
char col_title1[ ] ="C";
printf("\nExcel column title: = %s", col_title1);
printf("\nCorresponding number: %d ",excel_title_to_Number(col_title1));
char col_title2[ ] ="AC";
printf("\n\nExcel column title: = %s", col_title2);
printf("\nCorresponding number: %d ",excel_title_to_Number(col_title2));
char col_title3[ ] ="ZY";
printf("\n\nExcel column title: = %s", col_title3);
printf("\nCorresponding number: %d ",excel_title_to_Number(col_title3));
return 0;
}
Sample Output:
Excel column title: = C Corresponding number: 3 Excel column title: = AC Corresponding number: 29 Excel column title: = ZY Corresponding number: 701
Flowchart:
C Programming Code Editor:
Improve this sample solution and post your code through Disqus.
Previous: Write a C program to get the Excel column title that corresponds to a given column number.
Next: Write a C program to find the number of trailing zeroes in a given factorial.
What is the difficulty level of this exercise?
Test your Programming skills with w3resource's quiz.
C Programming: Tips of the Day
Static variable inside of a function in C
The scope of variable is where the variable name can be seen. Here, x is visible only inside function foo().
The lifetime of a variable is the period over which it exists. If x were defined without the keyword static, the lifetime would be from the entry into foo() to the return from foo(); so it would be re-initialized to 5 on every call.
The keyword static acts to extend the lifetime of a variable to the lifetime of the programme; e.g. initialization occurs once and once only and then the variable retains its value - whatever it has come to be - over all future calls to foo().
Ref : https://bit.ly/3fOq7XP
- New Content published on w3resource:
- HTML-CSS Practical: Exercises, Practice, Solution
- Java Regular Expression: Exercises, Practice, Solution
- Scala Programming Exercises, Practice, Solution
- Python Itertools exercises
- Python Numpy exercises
- Python GeoPy Package exercises
- Python Pandas exercises
- Python nltk exercises
- Python BeautifulSoup exercises
- Form Template
- Composer - PHP Package Manager
- PHPUnit - PHP Testing
- Laravel - PHP Framework
- Angular - JavaScript Framework
- Vue - JavaScript Framework
- Jest - JavaScript Testing Framework