Re:Excel team considering Python as scripting language: aski...
by bdowling on Thursday December 14, 2017 @04:46PM
(#15927403)
So, would this imply numpy and scipy support in Python for Excel? How about support for Excel worksheets within Jupyter notebooks?
[ Parent
| on HN ]
Re:Excel team considering Python as scripting language: aski...
by smortaz on Thursday December 14, 2017 @04:59PM
(#15927537)
That's for the Excel team to decide. My personal hope is that they'll offer as a base:
* Python 3
* Numpy, SciPy, Pandas, Matplotlib, Altair, ...
* Pythonic bindings for Excel APIs (sheets, etc etc)
* VSCode's Python Editor + Debugger built in
* Some sort of conda based env/pkg mgmt
* Right-click, "Open in Jupyter" (data/code)
* <your wish here>
Re:Excel team considering Python as scripting language: aski...
by auxym on Thursday December 14, 2017 @05:23PM
(#15927758)
Transparent access to Excel tables as Pandas Dataframes would be so, so very awesome.
I mean, MS implemented these really nice Tables in excel, but then left us no way to easily query them with something like SQL.
Re:Excel team considering Python as scripting language: aski...
by garyclarke27 on Friday December 15, 2017 @01:57AM
(#15930125)
I agree, SQL in Excel would be awesome, Index Match everywhere is a right pain to maintain - to replicate foreign keys. Its amazing what you can do with Sumifs and Countifs, but SQl is better.
VBA is OK but NO search across modules makes it such a pain just to find your code, I wish VBA had better support for UDFs so that they can appear the same to users, as built in functions with tooltips.
MS have done a really bad job of incorporating Power Pivot, it’s confusing and doesn’t feel like a natural part of Excel. I don’t like Pivot Tables they are too Dynamic and a pain too format.
Re:Excel team considering Python as scripting language: aski...
by govert on Friday December 15, 2017 @05:00AM
(#15930757)
You can add-in IntelliSense for VBA functions using the (free) Excel-DNA IntelliSense extension. See this detailed write-up by Charles Williams: https://fastexcel.wordpress.com/2016/10/07/writing-efficient...
Re:Excel team considering Python as scripting language: aski...
by mistermann on Thursday December 14, 2017 @11:56PM
(#15929741)
Someone posted a link to a really nice 3rd part addin on the reddit thread, on mobile so can't find the link unfortunately but was very well done. Shame on Microsoft for half-assing Excel for the last decade.
Re:Excel team considering Python as scripting language: aski...
by auxym on Friday December 15, 2017 @07:25AM
(#15931285)
Possibly querystorm, in case anyone is looking for it. It did look interesting last time I looked at it, but I've never tried it.
Re:Excel team considering Python as scripting language: aski...
by mistermann on Friday December 15, 2017 @07:36PM
(#15936549)
That was it:
Re:Excel team considering Python as scripting language: aski...
by breatheoften on Thursday December 14, 2017 @11:33PM
(#15929688)
Doesn’t pandas.read_excel provide this?
Re:Excel team considering Python as scripting language: aski...
by dragonwriter on Thursday December 14, 2017 @06:49PM
(#15928499)
Well, there is PowerPivot...
Re:Excel team considering Python as scripting language: aski...
by vvanders on Thursday December 14, 2017 @05:14PM
(#15927676)
Yeah, matplotlib, scipy and numpy are kinda no-brainers there.
Re:Excel team considering Python as scripting language: aski...
by breatheoften on Thursday December 14, 2017 @11:34PM
(#15929691)
Please not matplotlib ... are we really stuck with matplotlib forever ..?
Re:Excel team considering Python as scripting language: aski...
by vvanders on Friday December 15, 2017 @01:36AM
(#15930046)
If you've got better suggestions I'm all ears. I've found it pretty great for debugging and being able to understand data in a rapid manner.
Re:Excel team considering Python as scripting language: aski...
by disgruntledphd2 on Saturday December 16, 2017 @06:19AM
(#15939004)
ggplot2. Simply better in every way. Hell, even base R is better than matplotlib. Full disclosure: I hate matplotlib so very, very much.
Re:Excel team considering Python as scripting language: aski...
by ateesdalejr on Thursday December 14, 2017 @06:03PM
(#15928113)
No, watch them pump out some horribly supported python library .