blob: 24ddaa66b9ba9e99c38534b2d24c45a6e7663cb3 (
plain)
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
|
#!/usr/bin/env python
# -*- coding: utf-8 -*-
def number_to_excel_column(num: int) -> str:
column = ""
while num > 0:
num -= 1
column = chr((num % 26) + ord("A")) + column
num //= 26
return column
def excel_column_to_number(column: str) -> int:
num = 0
for char in column:
num = num * 26 + (ord(char) - ord("A") + 1)
return num
if __name__ == "__main__":
input_number = 28
print(f"Input Number: {input_number}")
output_column = number_to_excel_column(input_number)
print(f"Output: {output_column}")
input_column = "AD"
print(f"Input Column Name: {input_column}")
output_number = excel_column_to_number(input_column)
print(f"Output: {output_number}")
|
