←back to thread

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

(citadel5.com)
112 points jpiech | 1 comments | 25 Apr 25 18:17 UTC | HN request time: 0.212s | source

Process large (e.g. 4GB+) data sets in a spreadsheet.

Load GB/32 million-row files in seconds and use them without any crashes using up to about 500GB RAM.

Load/edit in-place/split/merge/clean CSV/text files with up to 32 million rows and 1 million columns.

Use your Python functions as UDF formulas that can return to GS-Calc images and entire CSV files.

Use a set of statistical pivot data functions.

Solver functions virtually without limits for the number of variables.

Create and display all popular chart types with millions of data points instantly.

Suggestions for improvements are welcome (and often implemented quite quickly).

Show context
gpjt ◴[29 Apr 25 00:18 UTC] No.43827498[source]▶
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's hope it's you :-)
replies(1): >>43830434 #
1. jpiech ◴[29 Apr 25 09:43 UTC] No.43830434[source]▶
Thank you. The current integration is described in the online HTML GS-Calc help. Any suggestions would be highly appreciated.