News for hackers. Stuff that matters.

A comment on Microsoft is bringing Python to Excel.

Re:Microsoft is bringing Python to Excel by hyperpl on Tuesday August 22, 2023 @09:24AM (#37222368)
My main dependence on Excel is being able to interact with pivot tables. I also have some VBA macros to help with formatting which I would welcome to be in python - alas it looks like what they're bringing is for the cloud only?

I haven't found any free, open source solutions around this including any for Jupyter notebooks (my preferred medium).

[ Parent | on HN ]
Re:Microsoft is bringing Python to Excel by xcombelle on Tuesday August 22, 2023 @01:49PM (#37226243)
python pandas has pivot tables https://pandas.pydata.org/docs/reference/api/pandas.pivot_ta...

I don't know if it fits your needs

[ Parent | on HN ]
Re:Microsoft is bringing Python to Excel by pasc1878 on Wednesday August 23, 2023 @08:34AM (#37234891)
So you can click and drag the columns around in the pivot table to get a better view?
[ Parent | on HN ]
Re:Microsoft is bringing Python to Excel by reportgunner on Wednesday August 23, 2023 @09:57AM (#37235958)
imho using pandas for pivot tables is like using a cannon to shoot sparrows
[ Parent | on HN ]