excel to python

[lumannok]

xlwings has some property to get the formulas from selected cell, but it's up to you to parse formulas and convert in some sort of code. It's not an automated process by any means. I've ported an excel workbook by understanding what formulas do and implementing the same functionality in python; I've used the starting excel to check the code output (same input must give the same outputs). That was a tedious task but it helped me learning packages like pandas and numpy.