Excel Never Dies

Re:Excel Never Dies by submeta on Monday March 08, 2021 @05:10PM (#26392346)

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.

[ Parent | on HN ]

Re:Excel Never Dies by sidpatil on Monday March 08, 2021 @08:32PM (#26394246)

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

[ Parent | on HN ]

Re:Excel Never Dies by iuqiddis on Tuesday March 09, 2021 @02:32AM (#26396347)

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

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

[ Parent | on HN ]

Re:Excel Never Dies by silvershell on Monday March 08, 2021 @07:55PM (#26393863)

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

[ Parent | on HN ]

Re:Excel Never Dies by submeta on Tuesday March 09, 2021 @08:57AM (#26398761)

This looks awesome! Thank you.

[ Parent | on HN ]