# robocorp-excel
This library provides a simple way to deal with both legacy `.xls` files and newer `.xlsx` files directly. It can be used to read and edit them directly without having Microsoft Excel installed.
## Usage
[](https://pypi.org/project/robocorp-excel/)
> 👉 Check that you have added the dependency in your configuration; this library is not part of the [**robocorp**](https://pypi.org/project/robocorp/) bundle.
> - _conda.yaml_ for automation [Task Packages](https://robocorp.com/docs/robot-structure)
> - _package.yaml_ for automation Action Packages
> - _requirements.txt_, _pyproject.toml_, _setup.py|cfg_ etc. for the rest
> âš `robocorp-excel` is not yet production ready.
> We work in SemVer, so consider versions below `1.0.0` as development phase releases. You can use them, but to get to **v1**, we need to get the feature support and testing to a level where we feel comfortable recommending this library for production usage.
```python
from robocorp import excel
from robocorp.tasks import task
@task
def inspect_workbook():
workbook = excel.open_workbook("orders.xlsx")
worksheet = workbook.worksheet("Sheet1")
for row in worksheet.as_table(header=True):
print(row)
```
## Guides
Further user guides and tutorials can be found in [Robocorp Docs](https://robocorp.com/docs).
## API Reference
Explore our [API](https://github.com/robocorp/robocorp/blob/master/excel/docs/api/README.md) for extensive documentation.
## Changelog
A list of releases and corresponding changes can be found in the [changelog](https://github.com/robocorp/robocorp/blob/master/excel/docs/CHANGELOG.md).
Raw data
{
"_id": null,
"home_page": "https://github.com/robocorp/robocorp/",
"name": "robocorp-excel",
"maintainer": null,
"docs_url": null,
"requires_python": "<4.0,>=3.9",
"maintainer_email": null,
"keywords": null,
"author": "Fabio Z.",
"author_email": "fabio@robocorp.com",
"download_url": "https://files.pythonhosted.org/packages/c1/a6/455dd06a1d9e0f5ddd343a67efcd89c48c0463df40c27282670d476e0485/robocorp_excel-0.4.5.tar.gz",
"platform": null,
"description": "# robocorp-excel\n\nThis library provides a simple way to deal with both legacy `.xls` files and newer `.xlsx` files directly. It can be used to read and edit them directly without having Microsoft Excel installed.\n\n## Usage\n\n[](https://pypi.org/project/robocorp-excel/)\n\n> \ud83d\udc49 Check that you have added the dependency in your configuration; this library is not part of the [**robocorp**](https://pypi.org/project/robocorp/) bundle.\n> - _conda.yaml_ for automation [Task Packages](https://robocorp.com/docs/robot-structure)\n> - _package.yaml_ for automation Action Packages\n> - _requirements.txt_, _pyproject.toml_, _setup.py|cfg_ etc. for the rest\n\n> \u26a0 `robocorp-excel` is not yet production ready. \n> We work in SemVer, so consider versions below `1.0.0` as development phase releases. You can use them, but to get to **v1**, we need to get the feature support and testing to a level where we feel comfortable recommending this library for production usage.\n\n```python\nfrom robocorp import excel\nfrom robocorp.tasks import task\n\n@task\ndef inspect_workbook():\n workbook = excel.open_workbook(\"orders.xlsx\")\n worksheet = workbook.worksheet(\"Sheet1\")\n\n for row in worksheet.as_table(header=True):\n print(row)\n```\n\n## Guides\n\nFurther user guides and tutorials can be found in [Robocorp Docs](https://robocorp.com/docs).\n\n## API Reference\n\nExplore our [API](https://github.com/robocorp/robocorp/blob/master/excel/docs/api/README.md) for extensive documentation.\n\n## Changelog\n\nA list of releases and corresponding changes can be found in the [changelog](https://github.com/robocorp/robocorp/blob/master/excel/docs/CHANGELOG.md).\n",
"bugtrack_url": null,
"license": "Apache-2.0",
"summary": "Robocorp Excel automation library",
"version": "0.4.5",
"project_urls": {
"Homepage": "https://github.com/robocorp/robocorp/",
"Repository": "https://github.com/robocorp/robocorp/"
},
"split_keywords": [],
"urls": [
{
"comment_text": "",
"digests": {
"blake2b_256": "c06d122b4dca3a6078040be7c6ba5c1f5ff77e213f8c4f8d4483dae4c936321e",
"md5": "c30f3bc17df264026dd8253faed88a01",
"sha256": "66f7146f70a8391d9e0024b69bf4d09576bb5961dec327b94adb597dec91074c"
},
"downloads": -1,
"filename": "robocorp_excel-0.4.5-py3-none-any.whl",
"has_sig": false,
"md5_digest": "c30f3bc17df264026dd8253faed88a01",
"packagetype": "bdist_wheel",
"python_version": "py3",
"requires_python": "<4.0,>=3.9",
"size": 26833,
"upload_time": "2024-09-26T12:07:19",
"upload_time_iso_8601": "2024-09-26T12:07:19.005695Z",
"url": "https://files.pythonhosted.org/packages/c0/6d/122b4dca3a6078040be7c6ba5c1f5ff77e213f8c4f8d4483dae4c936321e/robocorp_excel-0.4.5-py3-none-any.whl",
"yanked": false,
"yanked_reason": null
},
{
"comment_text": "",
"digests": {
"blake2b_256": "c1a6455dd06a1d9e0f5ddd343a67efcd89c48c0463df40c27282670d476e0485",
"md5": "5b43402cd83ca09442bea800f1fe5f79",
"sha256": "833183ef0372ebeb7df515f97d1840a4e8b8784f64391aa19e0e4ea1ef457100"
},
"downloads": -1,
"filename": "robocorp_excel-0.4.5.tar.gz",
"has_sig": false,
"md5_digest": "5b43402cd83ca09442bea800f1fe5f79",
"packagetype": "sdist",
"python_version": "source",
"requires_python": "<4.0,>=3.9",
"size": 25240,
"upload_time": "2024-09-26T12:07:20",
"upload_time_iso_8601": "2024-09-26T12:07:20.123169Z",
"url": "https://files.pythonhosted.org/packages/c1/a6/455dd06a1d9e0f5ddd343a67efcd89c48c0463df40c27282670d476e0485/robocorp_excel-0.4.5.tar.gz",
"yanked": false,
"yanked_reason": null
}
],
"upload_time": "2024-09-26 12:07:20",
"github": true,
"gitlab": false,
"bitbucket": false,
"codeberg": false,
"github_user": "robocorp",
"github_project": "robocorp",
"travis_ci": false,
"coveralls": false,
"github_actions": true,
"lcname": "robocorp-excel"
}
JSON
