Are you ever worried about Microsoft a feature that acts similar in a future version of Excel? It's a problem that has bit others before (Firebug, Growl, tabbed-browsing extensions for IE).
I don't think Microsoft would be able to produce something that was just ready, without having to create a project or click through a wizard first.
Much of this functionality is available already, through ODBC, powershell, c# - but it's cumbersome to use. That's the selling point of this software, it seems to me.
Re:I wandered off and built an IDE
by badloginagain on Friday April 06, 2018 @01:03PM
(#16774907)
You guys, Microsoft just acquires the already built project and our happy dev get his mansion.
yeah, but what color though?
Re:I wandered off and built an IDE
by badloginagain on Friday April 06, 2018 @05:14PM
(#16777515)
Play your cards right and you get any color of your choice
Re:I wandered off and built an IDE
by emodendroket on Friday April 06, 2018 @10:02AM
(#16773266)
I wouldn't be. The energy is in O365 at the moment, isn't it? VBA is the big programming environment at the moment and it's basically VB6 and hasn't been touched in a long time. There's also that JavaScript thing, which I think is still pretty half-baked.
The JavaScript office API looks like a good solution for integrating your UI within the app. It’s still quite limited in terms of heavier capabilities, eg data processing etc. That’s probably because right now MS is focused more on a shared plugin API for all office products than on deep integration of any one specific product.
Re:I wandered off and built an IDE
by TuringTest on Friday April 06, 2018 @09:46AM
(#16773154)
Isn't it similar to PowerPivot?
There's more, e.g. the SQLite engine can interact with Excel and fiddle with formatting, but I think the major thing is convenience. As a dev, most times I just wouldn't bother with the ODBC approach unless I really had to. Convenient C# and SQL though, I'd use them at least 10x more often.