Logo

pyspread

Python power for your tables
About
Pyspread is a non-traditional spreadsheet application that is based on and written in the programming language Python.

The goal of pyspread is to be the most pythonic spreadsheet.

Pyspread expects Python expressions in its grid cells, which makes a spreadsheet specific language obsolete. Each cell returns a Python object that can be accessed from other cells. These objects can represent anything including lists or matrices.

Pyspread is free software. It is released under the GPL v3.

Pyspread main window
Features
  • CSV import and export
  • Chart creation dialog based on matplotlib
  • Python objects as cell results
  • Python macros
  • GPG based save file signatures for preventing foreign code execution
  • Access to all Python modules from within cells. These modules allow for example matrix operations via numpy or fixed point decimal numbers for business calculations via decimal.

Pyspread screenshot

news
September 2014: Pyspread 0.3.3 is out. Get it here.


Bugfix release:
  • Initaial GPG key selection now works when using wxPython 3.x
July 2014: Pyspread 0.3.2 is out. Get it here.


Bugfix release:
  • Saving files that exist now succeeds in Windows
  • Result text is now wrapped to cell extent
  • Brasilian Portugese translations updated
July 2014: Pyspread 0.3.1 is out. Get it here.


Bugfix release:
  • Removes a warning
  • Updated German and Ukrainian translations
July 2014: Pyspread 0.3.0 is out. Get it here.

New features:
  • wxPython 3.x support
  • Entryline text completion (use <Tab>)
  • EntryLine tooltip now displays docstrings for methods and builtins (use <Tab>)
  • nn function added to remove None from result array
  • Uncompressed pysu save file format
  • Writing xls files (still experimental)
  • Cell locking
  • Cell sorting
  • Frozen cells can now be updated periodically (>=100 ms/update)
  • Reference to a selection can now be copied the the clipboard with <Ctrl> + R
  • <Home> now moves the active cell to the first column of the actual row
  • <Shift> + <Space> now selects the current row
  • <Ctrl> + <Space> now selects the current column
  • Fingerprint in gpg key choice dialog
  • Tooltips for toolbar icons
March 2014: Andreas Noteng has provided a deb package for installing pyspread 0.2.6 on Debian Linux. The package can also be found in the Debian testing repository.


February 2014: Dimitris Zlatanidis has provided a SlackBuild for installing pyspread on Slackware Linux 14.1.


February 2014: Pyspread 0.2.7 is out. Get it here. This is a bug fix release for the chart dialog on Windows systems.


February 2014: Pyspread 0.2.6 is out. Get it here.


New features:
  • Reading support for Excel® xls files (requires dependency xlrd)
  • Code execution timeout, i. e. buggy code such as infinite loops does not lock up pyspread any more. Note: The timeout does not work for long running C operations
  • Macro dialog now provides an error message field
  • Contour plots and Sankey charts added to chart dialog
  • Chart dialog further improved
  • Example macro for in cell LaTeX equations added

Pyspread screenshot

Requirements
Pyspread is designed for Linux and other GTK platforms. Windows® is supported starting with version 0.2.4.


Dependencies

Optional dependencies
  • python-gnupg (>=0.3.0, for opening own files without approval)
  • xlrd (>=0.9.2, for loading Excel® files)
  • xlwt (>=0.9.2, for saving Excel files, pyspread >=v0.3.0 required)
  • jedi (>=0.8.0, for tab completion and context help in the entry line, pyspread >=v0.3.0 required)
  • basemap (>=1.0.7, for the weather example pys file)

Pyspread screenshot
contact
For user questions or feedback please post to the pyspread-users mailing list by sending an e-mail to pyspread-users@gna.org. You can here subscribe to the list.

For contributions, patches, development discussions and ideas please post to the pyspread-dev mailing list by sending an e-mail to pyspread-dev@gna.org. You can here subscribe to the list.


Copyright Martin Manns
Contact mmanns < at > gmx < dot > net
Last changed: 06. September 2014

Valid HTML 4.01 Transitional