https://rowzero.io/ can handle 1 billion+ rows and offers native Python support. Also compatible with Excel and Google Sheets. However it’s a cloud based solution, and the private hosting option is only available to Enterprise users.
Show HN: GS-Calc – A modern spreadsheet with Python integration
11–20 of 24 posts
Re: Show HN: GS-Calc – A modern spreadsheet with Python integration
#12Looks very cool, but Windows only?
Re: Show HN: GS-Calc – A modern spreadsheet with Python integration
#13https://rowzero.io/ can handle 1 billion+ rows and offers native Python support. Also compatible with Excel and Google Sheets. However it’s a cloud based solution, and the private hosting option is only available to Enterprise users.
[deleted]
Re: Show HN: GS-Calc – A modern spreadsheet with Python integration
#14It is an interesting tool. I've been struggling with Office Excel's inability to open large files. I always work with csv in python, and if a client must review the data in Excel, I take a random sample to generate a smaller file, then explain to the client that we can't open the whole in Excel. This really doesn't seem like a modern work. "a slow, old pc with 8GB RAM" By the way, this struck me like a humour of era.…
Fully agree, I have found that above 300k rows Excel struggles even on a good laptop. Not even mentioning the Python integration into MS Excel that is so unbearably slow that it is much better performing the calculations outside of Excel first.
I am sold on the website looks and license model!
Re: Show HN: GS-Calc – A modern spreadsheet with Python integration
#15Looks very cool, but Windows only?
Thanks. Yes, that was put off a bit too long, but there are plans to come up with the multiplatform version this year.
Re: Show HN: GS-Calc – A modern spreadsheet with Python integration
#16It is an interesting tool. I've been struggling with Office Excel's inability to open large files. I always work with csv in python, and if a client must review the data in Excel, I take a random sample to generate a smaller file, then explain to the client that we can't open the whole in Excel. This really doesn't seem like a modern work. "a slow, old pc with 8GB RAM" By the way, this struck me like a humour of era.…
Fully agree, I have found that above 300k rows Excel struggles even on a good laptop. Not even mentioning the Python integration into MS Excel that is so unbearably slow that it is much better performing the calculations outside of Excel first. I am sold on the website looks and license model!
These days I use DuckDB to read massive excel files. DuckDB now ships with a nice local UI and it also works beautifully with Datagrip, my preferred database IDE. With SQL, it just becomes a matter of applying old grease to do whatever analysis I want.
Re: Show HN: GS-Calc – A modern spreadsheet with Python integration
#17LibreOffice has Python integration.
https://help.libreoffice.org/latest/en-US/text/sbasic/python...
Re: Show HN: GS-Calc – A modern spreadsheet with Python integration
#18are there any plans to add real-time collaboration features, like Google Sheets or Excel Online
Re: Show HN: GS-Calc – A modern spreadsheet with Python integration
#19are there any plans to add real-time collaboration features, like Google Sheets or Excel Online
This is a potentially interesting feature - it probably could be relatively easily extended to the shared environment in GS-Calc as there are already separate passwords to protect files, the sheet/view structures and cell ranges and optional sha256 checksums for all the data categories, but there no plans as such. At the moment you can just use two script commands to release the opened file, periodically check whether it's modified, report it and automatically reload the file.
Re: Show HN: GS-Calc – A modern spreadsheet with Python integration
#20Earlier quoted context omitted.
> What will Excel users miss by switching? The ability to use legacy spreadsheets and macros. Let's be real, Excel self perpetuates by at once being awful but also the thing everyone used to use thus must still use. Lots of spreadsheet apps better than Excel have come and gone over the years...
MS Office Macros are too easy for untrained users (that think of themselves as power users) to create, and once they grow big enough, it's very hard to port them to other applications. They're the monkey paw of spreadsheets.
I wonder if anyones gonna eventually just create a wrapper API to just a vm that runs some stock excel open to a spreadsheet...