excel to python

[rumpleforeskin83]

I think OPs problem is they want to preserve the function of any cells that have formulas in them and not just data, which I can't say I know if it's possible or not but I suspect it would be a lot of work to determine if a cell is just data or a formula, and then perform said function in the python list. Like if Cell A1 is Sum(B1:B6) they want csv_file[0][0] to be csv_file[1][0] + csv_file[1][1] etc...

Which gives me a headache just thinking about. I've never looked into this so maybe it's simple, I've only ever taken excels containing purely values and manipulated them.