7 ms·
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 overwrit
by submeta 6y ago
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.
- silvershell 6y agoI think XLwings (https://www.xlwings.org https://www.xlwings.org) can do some of that.
- submeta 6y agoThis looks awesome! Thank you.
- sidpatil 6y agoYou might be interested in Pyspread: https://pyspread.gitlab.io/ https://pyspread.gitlab.io/
- iuqiddis 6y agoI've used openpyxl[1] to access excel cells directly while using python [1] https://openpyxl.readthedocs.io/en/stable/ https://openpyxl.readthedocs.io/en/stable/