6 ms·
Primarily, it's a lot more convenient. There's no setup involved, you just click and and the data is available through SQL or C#. There's no need to clean the d
by anakic 9y ago
Primarily, it's a lot more convenient. There's no setup involved, you just click and and the data is available through SQL or C#. There's no need to clean the data around the tables, it works on live data (file does not need to be saved), no connection strings to set up or boilerplate code to write.
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.
- foobarchu 9y agoAre 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).
- TuringTest 9y agoIsn't it similar to PowerPivot?
- emodendroket 9y agoI 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.
- chatmasta 9y agoThe 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.
- gnud 9y agoI 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.
- badloginagain 9y agoYou guys, Microsoft just acquires the already built project and our happy dev get his mansion.
- m_mueller 9y agoyeah, but what color though?
- badloginagain 9y agoPlay your cards right and you get any color of your choice