5 ms·
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 u
by auxym 9y ago
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.
- dragonwriter 9y agoWell, there is PowerPivot...
- breatheoften 9y agoDoesn’t pandas.read_excel provide this?
- mistermann 9y agoSomeone 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.
- auxym 9y agoPossibly querystorm, in case anyone is looking for it. It did look interesting last time I looked at it, but I've never tried it.
- mistermann 9y agoThat was it: https://www.querystorm.com https://www.querystorm.com
- garyclarke27 9y agoI 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.
- govert 9y agoYou 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-vba-udfs-part-15-adding-intellisense-to-your-udfs/ https://fastexcel.wordpress.com/2016/10/07/writing-efficient...