TE
科技回声
首页24小时热榜最新最佳问答展示工作
GitHubTwitter
首页

科技回声

基于 Next.js 构建的科技新闻平台,提供全球科技新闻和讨论内容。

GitHubTwitter

首页

首页最新最佳问答展示工作

资源链接

HackerNews API原版 HackerNewsNext.js

© 2025 科技回声. 版权所有。

Show HN: GS-Calc – A modern spreadsheet with Python integration

112 点作者 jpiech20 天前
Process large (e.g. 4GB+) data sets in a spreadsheet.<p>Load GB&#x2F;32 million-row files in seconds and use them without any crashes using up to about 500GB RAM.<p>Load&#x2F;edit in-place&#x2F;split&#x2F;merge&#x2F;clean CSV&#x2F;text files with up to 32 million rows and 1 million columns.<p>Use your Python functions as UDF formulas that can return to GS-Calc images and entire CSV files.<p>Use a set of statistical pivot data functions.<p>Solver functions virtually without limits for the number of variables.<p>Create and display all popular chart types with millions of data points instantly.<p>Suggestions for improvements are welcome (and often implemented quite quickly).

8 条评论

tianqi20 天前
It is an interesting tool. I&#x27;ve been struggling with Office Excel&#x27;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&#x27;t open the whole in Excel. This really doesn&#x27;t seem like a modern work.<p>&quot;a slow, old pc with 8GB RAM&quot;<p>By the way, this struck me like a humour of era. Oh god it has 8GB RAM. Cheers! To the good old days.
评论 #43800204 未加载
评论 #43801703 未加载
sunray220 天前
So I&#x27;ll take a layman&#x27;s view here since I&#x27;ve only cursory experience of the big data tasks that this software seems to made for. Or maybe the pitch is still different and it went over my head.<p>It loads quick, and works with large data. Crucially, you can view and edit visually, not only programmatically.<p>Assuming those already working with such data have Excel and Python tools etc., the pitch here is that the $39 license fee saves time or effort. So, is it that the user can spot and correct errors that you couldn&#x27;t otherwise do with either Excel or with other big data tools? And&#x2F;or otherwise do the necessary data manipulations?<p>I came across the phrase &#x27;eyes like a shithouse rat&#x27; recently, to describe the people doing final checks at a printing press. I think there&#x27;s probably plenty of people out there who would pay $39 for eyes like a shithouse rat.<p>Also the website makes me nostalgic :)
评论 #43810391 未加载
conductr20 天前
It all sounds very compelling , great work! But I have to ask, what’s the catch? This almost seems like it’s ready to fully replace Excel but I’ve seen many things die in that pursuit. What will Excel users miss by switching?<p>I’m don’t do a ton to big data stuff, but sometimes despite Excels stated row and column support- I find it effectively melts down if even 100K&#x2F;100 of data and forget adding formulas.
评论 #43799319 未加载
评论 #43799327 未加载
gpjt17 天前
As co-founder of Resolver Systems -- we tried but ultimately failed to take on Excel with a Python-enabled equivalent back in 2007 -- and current employee at Anaconda (providing Python in Excel) I really do hope you get this one to work. Excel is a mess, Python is better, and someone surely will eventually be able to fix the former with the latter. Let&#x27;s hope it&#x27;s you :-)
评论 #43830434 未加载
akdor115420 天前
Looks very cool, but Windows only?
评论 #43801745 未加载
nemoniac20 天前
LibreOffice has Python integration.<p><a href="https:&#x2F;&#x2F;help.libreoffice.org&#x2F;latest&#x2F;en-US&#x2F;text&#x2F;sbasic&#x2F;python&#x2F;python_programming.html" rel="nofollow">https:&#x2F;&#x2F;help.libreoffice.org&#x2F;latest&#x2F;en-US&#x2F;text&#x2F;sbasic&#x2F;python...</a>
badmonster19 天前
are there any plans to add real-time collaboration features, like Google Sheets or Excel Online
评论 #43808040 未加载
Yiling-J20 天前
<a href="https:&#x2F;&#x2F;rowzero.io&#x2F;" rel="nofollow">https:&#x2F;&#x2F;rowzero.io&#x2F;</a> 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.
评论 #43801014 未加载