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.

👉 robocorp-excel is not yet production ready. We work in semver and 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 production usage.

Getting started

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)

Further user guides and tutorials can be found in Robocorp Docs.

API Reference

Information on specific functions or classes: robocorp.excel

Changelog

A list of releases and corresponding changes can be found in the changelog.