# odsexport
odsexport is a Python-native library to create ODS (Open Document Spreadsheet)
documents. In other words, it lets you script creating "Excel" sheets from
within Python. The focus is on providing a feature-rich document creation
abstraction: all kinds of cell formatting options (data and style formatting)
are supported, column and row formatting is supported (width/height/visibility)
and conditional formatting is implemented as well. odsexport is intended to
make it easy to use ODS documents as a data sink while creating documents that
are mutable (i.e., recalculate their cells according to formulas). An example
of what documents it can produce is given in the `example` directory along with
the source code that produced it.
## Cell formatting
When handing cells or cell ranges from odsexport, there are three format
characters that are understood:
- `a`: Create an absolute reference, i.e., include the sheet name. Needs to
be used when referencing cells between different sheets.
- `c`: Pin the column. I.e., instead of `G4`, it will produce `$G4`.
- `r`: Pin the row. I.e., instead of `G4`, it will produce `G$4`.
All of these can be combined, here is an example of a sheet "Sheet" with cell
`G4`:
- `a`: Sheet.G4
- `c`: $G4
- `r`: G$4
- `cr`: $G$4
- `acr`: Sheet.$G$4
## Rant
Personally, I hate Excel or LibreOffice with a burning passion. That such an
ugly, stinking turd of software is used by millions of people around the globe
already seems odd. It is pretty much guaranteed that somewhere the salaries of
people depend on this utterly shitty, piss-poor quality application. Worse yet,
possibly some engineer is making structural computations using Excel, where
lives may depend on the accuracy of the results. The thought alone makes me
want to cry out in pain. Software so stupid, broken and obnoxious that
computations may not only not work on the exact same software with a different
locale setting, nooooo, even worse: it may silently ignore the locale errors
and produce wrong results. Don't believe me? Try counting values using
`COUNTIF()` with a condition that counts values greater than/less than a
fractional value and observe what happens when the locale setting (e.g., `4.1`
vs. `4,1`) is different than the number you enter. It really is *that* dumb.
Excel/LibreOffice Calc is an utter disgrace. And yet, just like thousands of
people before me, I need to cope with it. To me, that compromise is having
actual good data quality in a safe haven and only exporting to Excel when
needed.
## License
GNU GPL-3.
Raw data
{
"_id": null,
"home_page": "https://github.com/johndoe31415/odsexport",
"name": "odsexport",
"maintainer": null,
"docs_url": null,
"requires_python": null,
"maintainer_email": null,
"keywords": "python, ods, excel, spreadsheet",
"author": "Johannes Bauer",
"author_email": "joe@johannes-bauer.com",
"download_url": "https://files.pythonhosted.org/packages/d7/18/4d8b7478f611916d50a08ae8fdbd634341883b2701d38a0259623452e9b4/odsexport-0.0.1.tar.gz",
"platform": null,
"description": "# odsexport\nodsexport is a Python-native library to create ODS (Open Document Spreadsheet)\ndocuments. In other words, it lets you script creating \"Excel\" sheets from\nwithin Python. The focus is on providing a feature-rich document creation\nabstraction: all kinds of cell formatting options (data and style formatting)\nare supported, column and row formatting is supported (width/height/visibility)\nand conditional formatting is implemented as well. odsexport is intended to\nmake it easy to use ODS documents as a data sink while creating documents that\nare mutable (i.e., recalculate their cells according to formulas). An example\nof what documents it can produce is given in the `example` directory along with\nthe source code that produced it.\n\n## Cell formatting\nWhen handing cells or cell ranges from odsexport, there are three format\ncharacters that are understood:\n\n - `a`: Create an absolute reference, i.e., include the sheet name. Needs to\n be used when referencing cells between different sheets.\n - `c`: Pin the column. I.e., instead of `G4`, it will produce `$G4`.\n - `r`: Pin the row. I.e., instead of `G4`, it will produce `G$4`.\n\nAll of these can be combined, here is an example of a sheet \"Sheet\" with cell\n`G4`:\n\n - `a`: Sheet.G4\n - `c`: $G4\n - `r`: G$4\n - `cr`: $G$4\n - `acr`: Sheet.$G$4\n\n\n## Rant\nPersonally, I hate Excel or LibreOffice with a burning passion. That such an\nugly, stinking turd of software is used by millions of people around the globe\nalready seems odd. It is pretty much guaranteed that somewhere the salaries of\npeople depend on this utterly shitty, piss-poor quality application. Worse yet,\npossibly some engineer is making structural computations using Excel, where\nlives may depend on the accuracy of the results. The thought alone makes me\nwant to cry out in pain. Software so stupid, broken and obnoxious that\ncomputations may not only not work on the exact same software with a different\nlocale setting, nooooo, even worse: it may silently ignore the locale errors\nand produce wrong results. Don't believe me? Try counting values using\n`COUNTIF()` with a condition that counts values greater than/less than a\nfractional value and observe what happens when the locale setting (e.g., `4.1`\nvs. `4,1`) is different than the number you enter. It really is *that* dumb.\n\nExcel/LibreOffice Calc is an utter disgrace. And yet, just like thousands of\npeople before me, I need to cope with it. To me, that compromise is having\nactual good data quality in a safe haven and only exporting to Excel when\nneeded.\n\n## License\nGNU GPL-3.\n",
"bugtrack_url": null,
"license": "gpl-3.0",
"summary": "Python-native ODS writer library",
"version": "0.0.1",
"project_urls": {
"Download": "https://github.com/johndoe31415/odsexport/archive/0.0.1.tar.gz",
"Homepage": "https://github.com/johndoe31415/odsexport"
},
"split_keywords": [
"python",
" ods",
" excel",
" spreadsheet"
],
"urls": [
{
"comment_text": "",
"digests": {
"blake2b_256": "d7184d8b7478f611916d50a08ae8fdbd634341883b2701d38a0259623452e9b4",
"md5": "7408bd28e27805749b2a42237ccc03ab",
"sha256": "86452350fd8ac14b8c9b193eeca5e793909aaf3e904711d1dc055a2a3d913455"
},
"downloads": -1,
"filename": "odsexport-0.0.1.tar.gz",
"has_sig": false,
"md5_digest": "7408bd28e27805749b2a42237ccc03ab",
"packagetype": "sdist",
"python_version": "source",
"requires_python": null,
"size": 24621,
"upload_time": "2024-06-27T21:44:29",
"upload_time_iso_8601": "2024-06-27T21:44:29.447798Z",
"url": "https://files.pythonhosted.org/packages/d7/18/4d8b7478f611916d50a08ae8fdbd634341883b2701d38a0259623452e9b4/odsexport-0.0.1.tar.gz",
"yanked": false,
"yanked_reason": null
}
],
"upload_time": "2024-06-27 21:44:29",
"github": true,
"gitlab": false,
"bitbucket": false,
"codeberg": false,
"github_user": "johndoe31415",
"github_project": "odsexport",
"travis_ci": false,
"coveralls": false,
"github_actions": false,
"lcname": "odsexport"
}
JSON
