Offline Excel-like app with no formula conversion, but with image/markdown/HTML support.
Project description
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
_default: {hasHeader: true, renderers: markdownRenderer}
hanzi:
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
sentences:
colHeaders: true
colWidths: [200, 200, 200, 200, 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
{
rowHeaders: true,
colHeaders: true,
manualRowResize: true,
manualColumnResize: true,
filters: true,
dropdownMenu: true,
contextMenu: true,
maxColWidth: 200,
hasHeader: false
}
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
Project details
Release history Release notifications | RSS feed
Download files
Download the file for your platform. If you're not sure which to choose, learn more about installing packages.
Source Distribution
Built Distribution
Hashes for simplecel-0.2.2.3-py3-none-any.whl
Algorithm | Hash digest | |
---|---|---|
SHA256 | 9a8e9d0e2ad910626848bf3268b71eb11b2b3596e108dff6f954ec4cfed43a28 |
|
MD5 | edf52e97f664bdb648a2a61180f791ae |
|
BLAKE2b-256 | b8dd4f32c9f9a9058bf40c9ece9fc5301cae9516e0db067613f13f0598694892 |