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...
I mean, MS implemented these really nice Tables in excel, but then left us no way to easily query them with something like SQL.