Python Forum

spreadsheet app (visual-numpy)
This is a full working spreadsheet app written in python under the Qt framework (PySide6), instead of excel like formulas the app evaluates python expressions (cell references in formula are internally changed to comply with python syntax) that return either numpy arrays up to two dimensions or numeric objects (i.e. int, float,complex,etc). The workflow is very much like excel in the sense that it uses alphanumeric coordinates to refer to cell values with slight differences (e.g. [A2:C7] for rectangular selections), a notable difference though is that just a single "formula" can calculate an array of values so no individual formula is needed to calculate every single value of the same operation. Use of explicit numpy functions is available through the prefix np.

Right now it supports basic formating and the capability of importing and exporting CSV files. Additional features are being developed but priority will always be stability of current iteration. If you want to contribute be sure to check the contribute section on github.

There are no tests, so making any sorts of changes is risky (nothing to tell you if you've broken anything when you've made a change). Also, make use of a requirements.txt file to declare the dependencies. I didn't look at much of the code.

(Oct-23-2021, 07:46 AM)ndc85430 Wrote: [ -> ]There are no tests, so making any sorts of changes is risky (nothing to tell you if you've broken anything when you've made a change). Also, make use of a requirements.txt file to declare the dependencies. I didn't look at much of the code.

I'll be working on the tests but it may take some time and yeah should probably add the requirements.txt file. Thanks!