3 ms·

Maybe they read it here: Keep Excel application as is. Excel is OK without Python and VB seems ok, it's BASIC after all. Instead, concentrate on making Excel f

Maybe they read it here: Keep Excel application as is. Excel is OK without Python and VB seems ok, it's BASIC after all. Instead, concentrate on making Excel functions embeddable in server applications, this is area totally neglected so far. Think about server-side spreadsheet handling and calculations, that would allow Excel to drive business logic of systems. And maybe there Python would be useful, but i'd prefer just .Net runtime libraries instead.

odonnellryan 9y ago
The best solution to this, in my experience, has been a data-backend for Excel. No, I'm not talking about connecting via ODBC. Rather, generating Excel documents from a data store: which may possibly be versioned and so on. Excel is not a good place to store data. It is good to work with data. It's really, really good to view data. People love it for that. But when you start to store a lot of data in Excel ...