Robocorp Excel automation library
Project description
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
👉 Check that you have added the dependency in your configuration; this library is not part of the robocorp bundle.
- conda.yaml for automation Task Packages
- 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 below1.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.
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.
API Reference
Explore our API for extensive documentation.
Changelog
A list of releases and corresponding changes can be found in the changelog.
Project details
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 robocorp_excel-0.4.4-py3-none-any.whl
Algorithm | Hash digest | |
---|---|---|
SHA256 | 3c694cd6308aab787c552e0375b38a062ed29a24b8a45363ad742fa1c26aa737 |
|
MD5 | 7530399f2d7769b9a2c333749910790a |
|
BLAKE2b-256 | f64183eed919dfb58f6a486f04413e48e5a49e713fdffb43364e2d1bf43b3a8d |