Hacker Newsnew | past | comments | ask | show | jobs | submitlogin

Is there a way to manipulate Excel cells from within Python/Pandas? Last time I checked I had a hard time to write to an existing Excel file (= prevent overwriting it).

Would love to do the complex calculations in Python instead of using VBA.



You might be interested in Pyspread: https://pyspread.gitlab.io/


I've used openpyxl[1] to access excel cells directly while using python

[1] https://openpyxl.readthedocs.io/en/stable/


I think XLwings (https://www.xlwings.org) can do some of that.


This looks awesome! Thank you.




Guidelines | FAQ | Lists | API | Security | Legal | Apply to YC | Contact

Search: