News for hackers. Stuff that matters.
Re:Excel never dies (2021) by rr888 on Thursday August 04, 2022 @06:10PM (#32348952)
Wow great, I used to customize Excel a lot for financial companies. VBA was good enough until about 20 years ago. VSTO was never as good because you need admin rights to install it. ExcelDNA was much better. I gave up 10 years ago so dont know what is going on now tbh.

Right now I use Python and Pandas, mostly doing the same stuff but with more rows and a worse experience. If you could find an easy way to combine Python and Excel it would be awesome. Like embedding Python instead of VBA? Would need sandboxing.

Re:Excel never dies (2021) by bhewes on Thursday August 04, 2022 @07:31PM (#32349628)
We use Xlwings. Xlwings pro allows for embedded python. We use xltrails to version control our excel files with embedded python and/or VBA.