Downloading and reading an Excel file

This example demonstrates how to download and how to read data from an Excel file. We will use RPA.Excel.Files and RPA.HTTP libraries from the RPA Framework.

*** Settings ***
Documentation   Download an Excel file and read the rows.
Library         RPA.Excel.Files
Library         RPA.HTTP

*** Variables ***
${EXCEL_FILE_URL}=  https://github.com/robocorp/example-activities/raw/master/web-store-order-processor/devdata/Data.xlsx

*** Tasks ***
Download an Excel file and read the rows
    Download        ${EXCEL_FILE_URL}           overwrite=True
    Open Workbook   Data.xlsx
    ${table}=       Read Worksheet As Table     header=True
    Close Workbook

    FOR     ${row}  IN  @{table}
        Log     ${row}
    END

See RPA.Excel.Files keyword documentation to learn more about working with Excel files.