I hear good things about spreadsheet functionality in org-mode.

I use Orgmode. A lot. It's my primary organisation method, as the General Manager for a small 3 person sub-company, as well as my household organisation.

I've always, unwittingly, organised myself via two systems:

  1. Lists
  2. Matrices 

I love the tables in Orgmode [0]. They are intuitive, simple, and just beautifully done.

That said, the spreadsheet functionality is a different beast altogether. Even though it's the same interface as the tables, it adds an exponential layer of complexity, and separation from how most people view a spreadsheet. It's powerful, but a bit daunting, and I don't see many journalists being able to grok it.

[0] https://www.youtube.com/watch?v=JHKrTsiz4JU&index=25&list=PL...

I just discovered that you can actually use Org's Tables as R data frames, and all sorts of other R actions from within Org. [0]

So that's quite amazing.

[0] http://ehneilsen.net/notebook/orgExamples/org-examples.html#...

I'd love a little spreadsheet widget for Jupyter that was only for data entry (i.e., a formula-less spreadsheet) and produced a Pandas dataframe.

You can do this with xlwings![0] Would highly recommend.

——

[0] https://www.xlwings.org

I don't believe that's what the poster meant, which you're replying to. xlwings is a python library used to connect to excel files and e.g. change their contents programmatically. I don't think you can use it (out of the box anyway) to display and change data 'as-a-spreadsheet' in a jupyter notebook [e.g. by showing an iframe].

Yeah, unsure about what the parent may have intended. I use it as a data IO for stuff that I want to manipulate in Python somewhat-interactively, by having an Excel sheet open on the side as I work in Python.

Jupyter lab has a spreadsheet editor. I haven't actually used it so I'm not sure if you can calculate with it, but I'd be mildly surprised if you could.