Python Forum
python spreadsheet app (visual-numpy)
Thread Rating:
  • 0 Vote(s) - 0 Average
  • 1
  • 2
  • 3
  • 4
  • 5
python spreadsheet app (visual-numpy)
#1
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.
Gribouillis likes this post

Attached Files

Thumbnail(s)
   
Reply
#2
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.
rome92 likes this post
Reply
#3
(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! Cool
Reply


Possibly Related Threads…
Thread Author Replies Views Last Post
  100% free Python Node Editor (visual Python nodes) KennedyRichard 0 6,348 Apr-05-2022, 02:58 PM
Last Post: KennedyRichard
  Visual Python Programming flows Joost 0 2,648 Jun-06-2021, 06:51 AM
Last Post: Joost
  Spreadsheet to dictionary Gribouillis 1 28,098 Jan-16-2019, 11:22 AM
Last Post: Gribouillis

Forum Jump:

User Panel Messages

Announcements
Announcement #1 8/1/2020
Announcement #2 8/2/2020
Announcement #3 8/6/2020