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.1-py3-none-any.whl
Algorithm | Hash digest | |
---|---|---|
SHA256 | 507fe9840aabce22e11692cfa0bf21c8c8fd46738fc4cc4d14c6aa6450711d39 |
|
MD5 | c504de16b4574535accc92d3bf3e2eed |
|
BLAKE2b-256 | fe42eb18ea5d0c00c118c8d5b31602424cf20036ebd239bb46dca551d6ead152 |