QueryStorm
Productivity
spreadsheet plugin
SHOW HN2017
How HN took it
4 positive, 3 neutral or asking, 2 mixed, 2 critical, out of 11 comments about the project. Thread score +0.10.
Pricing: 1 for, 0 againstExecution: 0 for, 1 againstIdea: 0 for, 1 againstDocs: 1 for, 0 against
The thread, comment by comment
Each row is a top-level comment and its replies, in HN's order. Select a cell to open that comment on HN.
positive neutral or mixed critical about another commenter or something else the maker
What HN said
What people liked
Documentation and intro videos are well received
From 2 comments
I really loved the introduction videos you posted. Great showing of different features in your product - wishing you the best with this project
cbcoutinho on HNCongrats! This is fantastic. Now can you do the same with Python please? :) But seriously, great work, including the docs/videos.
smortaz on HN
Seen as a big improvement over VBA
From 1 comment
I have two thoughts. 1. This is a huge improvement over VBA. 2. This is going to make creating unmaintainable mission critical Excel macro based monstrosities even easier. So a…
wmil on HN
Excel is a good platform for developer tools
From 1 comment
QueryStorm: optimizing the way we abuse Excel!:) Well, jokes aside, C# and .NET are a better tool, so at least its easier to make a good solution in Excel. I think Excel is an…
anakic on HN
Objections
Could encourage unmaintainable mission-critical Excel monstrosities
From 1 comment
I have two thoughts. 1. This is a huge improvement over VBA. 2. This is going to make creating unmaintainable mission critical Excel macro based monstrosities even easier. So a…
wmil on HN
No clear way to test in a commercial environment without paying
From 1 comment
It is insane to me that Microsoft hasn't already provided this. I get that you can't replace VBA entirely, or phase it out, without breaking a Lot of Things, and putting a lot of…
runin2k1 on HN
Requests
Python support
From 1 comment
Congrats! This is fantastic. Now can you do the same with Python please? :) But seriously, great work, including the docs/videos.
smortaz on HN
F# support
From 1 comment
How about an F# port of this? Aside from it being a very handy language for ETL type tasks, I suspect your average excel power user who otherwise does not program could more…
jackfoxy on HN
OAuth 2 login support for protected data sources
From 1 comment
It looks quite amazing. Is there any way to provide som sort of log in form, if data is provided by a protected source? Of course, the user could just enter credentials in cells,…
lowkeyokay on HN
Questions
How to test the plugin in a commercial environment
From 1 comment
It is insane to me that Microsoft hasn't already provided this. I get that you can't replace VBA entirely, or phase it out, without breaking a Lot of Things, and putting a lot of…
runin2k1 on HN
Whether it works with VBA-era Excel versions and interoperability
From 1 comment
The problem is interoperability with older versions of Excel when that new one is released too...
my123 on HN
Alternatives named
VBA
From 2 comments
It's been a long, long time since I've tried to do anything with VBA. How far out of date is the implementation of it that is built into Excel? Like .NET 1.1?
megaman22 on HNUnless something has changed recently, VBA in Excel and other Office applications isn't .NET at all. It's basically just VB6. When you go to edit VBA inside Excel, you get a VB6…
rpeden on HN
Power Query / SQL-linked datatables in Excel
From 1 comment
You actually can do it, it's just hidden and sort of a pain in the ass. You can insert a SQL-linked datatable that can pull parameters from your spreadsheet, if the cell changes…
act_right on HN
Office web add-ins and DAX/M
From 1 comment
> "Their are ways to develop Office add-ins using .NET, but they aren't built in the way VBA and its IDE are." It's also worth noting that you can build custom tools in Office…
ZenoArrow on HN