213
this post was submitted on 05 Sep 2023
213 points (100.0% liked)
Technology
37699 readers
247 users here now
A nice place to discuss rumors, happenings, innovations, and challenges in the technology sphere. We also welcome discussions on the intersections of technology and society. If it’s technological news or discussion of technology, it probably belongs here.
Remember the overriding ethos on Beehaw: Be(e) Nice. Each user you encounter here is a person, and should be treated with kindness (even if they’re wrong, or use a Linux distro you don’t like). Personal attacks will not be tolerated.
Subcommunities on Beehaw:
This community's icon was made by Aaron Schneider, under the CC-BY-NC-SA 4.0 license.
founded 2 years ago
MODERATORS
you are viewing a single comment's thread
view the rest of the comments
view the rest of the comments
As a user of advanced excel features like Power Query and even its plethora of built in functions, LibreOffice Calc just doesn't hold up at all. It lacks all beyond the most basic table features
That is the thing. I would not do anything advanced in a spread sheet. Just not productive. I would use Python.
As an example, I made a spreadsheet that queried WoW's auction house API and showed me items, their crafting components, prices and profits from crafting, that was then easily interactable and extendable in the GUI. Doing the same thing in python would have been great up until the point where I want to display the information... getting python to output a proper front end GUI is definitely a more time consuming exercise than using Excel's built in functionality
Keep in mind Python can interact with spreadsheet formats. So it is very possible to input your data in a spreadsheet , load that data into Python, then dump it into a spreadsheet. Easiest is CSV but I have done direct too.
What approach depends. If you know a spreadsheet really well, then taking it quite a ways makes a lot of sense. On the other hand when one gets to the point of writing more then 100 lines of VBA and especially into the 500 range, it may be time to use another approach. Same when execution times are very long or data very large. Working with large VBA code bases is kind of nutty but people often get too deep into the I have a hammer so every problem looks like a nail thinking. I have had to work with code like that myself.