# xlsxopera
Working on xlsx (Microsoft Excel) files. Convert to list, dict, get headers, cell values, positions and more.
Developed by voidayan (c) 2022
## Install
Install package from pip:
```
pip3 install xlsxopera
```
Note: Required packages is openpyxl
## How to work
Create an object
```python
from xlsxopera import Notebook
# Load file to operate and sheet name
notebook = Notebook("file-to-path.xlsx", "sheet_name")
# Or load file to operate without sheet name. Default will be active spreadsheet.
notebook = Notebook("file-to-path.xlsx")
```
Get rows in list of lists:
```python
# Get all rows (from 1 to last)
rows_in_spreadsheet = notebook.list_rows()
# Get rows (for e.g, from 9 to 13)
rows_in_spreadsheet = notebook.list_rows(start=9, end=13)
```
Raw data
{
"_id": null,
"home_page": "https://github.com/voidayan/xlsxopera",
"name": "xlsxopera",
"maintainer": "",
"docs_url": null,
"requires_python": "",
"maintainer_email": "",
"keywords": "python,xlsx,xls,excel,microsoft excel,cell",
"author": "voidayan",
"author_email": "jan.emil.wojda@gmail.com",
"download_url": "https://files.pythonhosted.org/packages/59/2a/4e6daf91f81f28e62aab086914f0afb6b365eb727d8440c9ec661a6870a9/xlsxopera-1.1.tar.gz",
"platform": null,
"description": "# xlsxopera\nWorking on xlsx (Microsoft Excel) files. Convert to list, dict, get headers, cell values, positions and more.\n\nDeveloped by voidayan (c) 2022\n\n## Install\n\nInstall package from pip:\n```\npip3 install xlsxopera\n```\nNote: Required packages is openpyxl\n## How to work\n\nCreate an object\n\n```python\nfrom xlsxopera import Notebook\n\n# Load file to operate and sheet name\nnotebook = Notebook(\"file-to-path.xlsx\", \"sheet_name\")\n# Or load file to operate without sheet name. Default will be active spreadsheet.\nnotebook = Notebook(\"file-to-path.xlsx\")\n```\n\nGet rows in list of lists:\n```python\n# Get all rows (from 1 to last)\nrows_in_spreadsheet = notebook.list_rows()\n# Get rows (for e.g, from 9 to 13)\nrows_in_spreadsheet = notebook.list_rows(start=9, end=13)\n```\n\n\n",
"bugtrack_url": null,
"license": "",
"summary": "Work on .xlsx files.",
"version": "1.1",
"split_keywords": [
"python",
"xlsx",
"xls",
"excel",
"microsoft excel",
"cell"
],
"urls": [
{
"comment_text": "",
"digests": {
"md5": "b3195cbe310dd9c8786f3c7ed36a9b4d",
"sha256": "a8f7013778a1546d38e12af725ec7fe81b937a75b1d7bc6510c948ae15a4dd34"
},
"downloads": -1,
"filename": "xlsxopera-1.1-py3-none-any.whl",
"has_sig": false,
"md5_digest": "b3195cbe310dd9c8786f3c7ed36a9b4d",
"packagetype": "bdist_wheel",
"python_version": "py3",
"requires_python": null,
"size": 5750,
"upload_time": "2022-12-30T23:43:11",
"upload_time_iso_8601": "2022-12-30T23:43:11.152081Z",
"url": "https://files.pythonhosted.org/packages/04/87/169579036df6040bcdbf444482eb937ce858a8c625f5871a5970561fe938/xlsxopera-1.1-py3-none-any.whl",
"yanked": false,
"yanked_reason": null
},
{
"comment_text": "",
"digests": {
"md5": "65d843f7cd85db0b1e3f5b4237d1addd",
"sha256": "1aa06a032fe28a675be5e0fed7ef3a055715143ee23d78c05934a1f493ee92b8"
},
"downloads": -1,
"filename": "xlsxopera-1.1.tar.gz",
"has_sig": false,
"md5_digest": "65d843f7cd85db0b1e3f5b4237d1addd",
"packagetype": "sdist",
"python_version": "source",
"requires_python": null,
"size": 5292,
"upload_time": "2022-12-30T23:43:12",
"upload_time_iso_8601": "2022-12-30T23:43:12.772048Z",
"url": "https://files.pythonhosted.org/packages/59/2a/4e6daf91f81f28e62aab086914f0afb6b365eb727d8440c9ec661a6870a9/xlsxopera-1.1.tar.gz",
"yanked": false,
"yanked_reason": null
}
],
"upload_time": "2022-12-30 23:43:12",
"github": true,
"gitlab": false,
"bitbucket": false,
"github_user": "voidayan",
"github_project": "xlsxopera",
"travis_ci": false,
"coveralls": false,
"github_actions": false,
"requirements": [
{
"name": "openpyxl",
"specs": [
[
"==",
"3.0.10"
]
]
},
{
"name": "pytest",
"specs": [
[
"==",
"7.2.0"
]
]
}
],
"lcname": "xlsxopera"
}
JSON
