Excel alternative
What can be a good alternative for Excel that works on Linux? Currently I need to use VBA, Solver, Analysis Toolpak charts. Moreover the alternative should read xls and xlsx files. Doesn't need to be free or open source.
Any recommendations? Thank you.
LibreOffice. FOSS alternative.
Those accountants are using excel like an infrastructure and they are not to be trusted. The only thing excel can do that libreoffice can't do is create a nightmare web of interdependent spreadsheets.
Isn't that more a case of them not knowing how it works or how to make new formulas etc, because they were all written by a guy called Tony who left the company in 2002, and everyone's been just using his templates and copy-and-pasting since?
Give it a try. Only you can judge for your use cases
A bit of an unusual suggestion, but i’ve replaced Excel with Python. I deal with large datasets anyway, so Python was arguably a better fit for what i do.
Packages to check out to see what is possible…
Everything is in text files. Scripts are version controlled in git. Calcs happen super fast. I spend more time transferring data from DBs than waiting for the calcs to finish.
Also, Jupyter Lab is one of the coolest environments for scientific programming. Write documentation and explanations of your work in Markdown while writing the code, and seeing the results. Oh, and it's programming language agnostic, Python is just the default. I use it with R most of the time.
My bro!
These would be the big three alternatives:
https://wiki.openoffice.org/wiki/VBA_interoperability_in_OpenOffice
https://help.collaboraoffice.com/6.4/en-US/text/sbasic/shared/vbasupport.html
https://help.libreoffice.org/latest/lo/text/sbasic/shared/vbasupport.html
Softmaker Office
https://www.softmaker.com/en/
Works in Windows, Mac and Linux