convert to title

SanjarH · SanjarH · commit 33992a66f886 · 2023-03-12T12:03:59.000+01:00
LeetCode
diff --git a/excel_convert.py b/excel_convert.py
@@ -0,0 +1,24 @@
+# Learn Python together
+"""Given an integer columnNumber, return its corresponding 
+column title as it appears in an Excel sheet."""
+# Solution
+def convert_to_title(colNum):
+    result = ""
+    while colNum > 0:
+        # getting a zero-based index
+        colNum -= 1
+        # using divmod function to get quotient and remainder 
+        quotient, remainder = divmod(colNum, 26)
+        # converting the remainder to a character using the 
+        # ASCII code and addin the result
+        result = chr(remainder + 65) + result
+        # setting index of the next wrap to colNum
+        colNum = quotient
+    return result
+
+# check            
+print(convert_to_title(2))  
+print(convert_to_title(26))           
+print(convert_to_title(-1))
+print(convert_to_title(101))
+print(convert_to_title(450))
diff --git a/fib_numbers.py b/fib_numbers.py
@@ -37,3 +37,4 @@ def fibonacci2(n):
 print(fibonacci2(12)) # Output -> 144
 print(fibonacci2(-11)) # Output -> 0
 print(fibonacci2(6)) # Output -> 8
+
