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.

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.

Information on specific functions or classes: robocorp.excel

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