Downloading and reading an Excel file

*** 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-web-store-order-processor/raw/main/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

from RPA.Excel.Files import Files from RPA.HTTP import HTTP excel_lib = Files() http_lib = HTTP() excel_file_url= "https://github.com/robocorp/example-web-store-order-processor/raw/main/devdata/Data.xlsx" def download_the_excel_file(url): http_lib.download(url, overwrite=True) def open_the_file_as_table(): excel_lib.open_workbook("Data.xlsx") table = excel_lib.read_worksheet_as_table(header=True) excel_lib.close_workbook() return table def loop_over_table(table): for row in table: print(row) # Define a main() function that calls the other functions in order: def main(): download_the_excel_file(excel_file_url) table = open_the_file_as_table() loop_over_table(table) # Call the main() function, checking that we are running as a stand-alone script: if __name__ == "__main__": main()