Python-Scripts-For-Excel-Manipulation

Various python scripts for solving excel related problems

Problem 1

Given a column title as appear in an Excel sheet, return its corresponding column number.

For example:
A -> 1 B -> 2 C -> 3 ... Z -> 26 AA -> 27 AB -> 28 ... AAA -> 703 ...

Problem 2

Given a positive integer, return its corresponding column title as appear in an Excel sheet.

For example:
1 -> A 2 -> B 3 -> C ... 26 -> Z 27 -> AA 28 -> AB ...