Simplecel

Offline Excel-like app with no formula conversion, but with image/markdown/HTML support.

Features

Custom renderers beyond https://docs.handsontable.com/5.0.0/demo-custom-renderers.html -- 'markdownRenderer', 'imageRenderer'. -- Can render images with URL's alone. No need for <img src="" />.
Always good word wrap support and auto-row-height due to Handsontable.
Absolutely no formula conversion. Things like =1+2, OCT2, 11-14 will never get converted.
Max column width can be specified (default: 200).

Installation

pip install simplecel
pip install pyexcel-xlsx  # Or any other packages defined in pyexcel GitHub

For what you need to install other than simplecel, please see https://github.com/pyexcel/pyexcel#available-plugins

Usage

$ simplecel --help
Usage: simplecel [OPTIONS] FILENAME

Options:
  --config TEXT     Please input the path to CONFIG yaml, as defined in pyhandsontable.
  --host TEXT
  --port INTEGER
  --debug
  --help          Show this message and exit.
$ simplecel example.xlsx

In this case, example.config.yaml is also auto-loaded, although you can specify *.config.yaml directly in --config. If the file doesn't exist, it will be auto-generated on Save.

Example of `example.config.yaml`

simplecel:
  _default: {allowInsertCol: false, hasHeader: true, renderers: markdownRenderer}
  hanzi:
    allowInsertCol: false
    colHeaders: true
    colWidths: [67, 197, 200, 71, 90, 106, 66, 60, 59, 200]
    contextMenu: true
    dropdownMenu: true
    filters: true
    hasHeader: true
    manualColumnResize: true
    manualRowResize: true
    maxColWidth: 200
    renderers: markdownRenderer
    rowHeaders: true

One-stop settings for all tables are defined in _default.

Note that the defaultConfig in the Javascript are

let defaultConfig = {
  rowHeaders: true,
  colHeaders: true,
  manualRowResize: true,
  manualColumnResize: true,
  // fixedRowsTop: 1,
  filters: true,
  dropdownMenu: true,
  contextMenu: true,
  maxColWidth: 200,
  hasHeader: false,
  // renderers: 'markdownRenderer',
  allowInsertCol: true
};

renderers can also accept something like

{
    1: "markdownRenderer",
    2: "markdownRenderer"
}

Some other acceptable configs are defined in https://docs.handsontable.com/5.0.0/Options.html

Plan

Wrap this app in PyQt / PyFlaDesk for GUI end-users (maybe later, as PyFlaDesk of now is still buggy).

Screenshots

Metadata

Release files for simplecel 0.2.10.7

For a detailed explanation of source distributions (sdists) and built distributions (wheels), please see the package formats documentation.

Source distribution (sdist)

Source distribution for simplecel 0.2.10.7
File	Size	Uploaded
simplecel-0.2.10.7.tar.gz	72.1 kB	Aug 10, 2018	Details

Built distribution (wheel)

Table of built distributions (wheels) for simplecel 0.2.10.7
File	Interpreter	ABI	Platform	Reset
simplecel-0.2.10.7-py3-none-any.whl 221.0 kB Aug 10, 2018	Python 3	none	any	Details

Total release size: 293.1 kB

Release files / simplecel-0.2.10.7.tar.gz

Download URL	simplecel-0.2.10.7.tar.gz
Size	72.1 kB
Tags	Source
SHA-256 checksum How to use checksums	`f48258b48a6b07ed4f53485f09b0b67e86fc9efae839fe453eb317816cb46254`
BLAKE2b-256 checksum How to use checksums	`f88831b47e59ed7e102f69a7677bda0ed589511150990e6764777a17da2ac976`
Upload date	Aug 10, 2018
Uploaded using Trusted Publishing? What is trusted publishing?	No
Uploaded via	`poetry/0.11.3 CPython/3.7.0 Darwin/17.7.0`

Release files / simplecel-0.2.10.7-py3-none-any.whl

Download URL	simplecel-0.2.10.7-py3-none-any.whl
Size	221.0 kB
Tags	Python 3
SHA-256 checksum How to use checksums	`b718c5293aeafe40e36e92b373d3ce3bf47f84209e2c1ed697888fe2855d328a`
BLAKE2b-256 checksum How to use checksums	`7a8f580b39a63f8321f63a02da04a68a69caa2582dadc3337bac18f7ed54955c`
Upload date	Aug 10, 2018
Uploaded using Trusted Publishing? What is trusted publishing?	No
Uploaded via	`poetry/0.11.3 CPython/3.7.0 Darwin/17.7.0`