top of page

How to navigate to different URLs based on an Excel spreadsheet

💡 Do you need to navigate to multiple URLs iteratively? Each of the URLs contains dynamic values which need to be read from an Excel spreadsheet.

Solution


The following flow provides a high level overview of the solution:



We will need to read the Excel data as a datatable using the action “Read from Excel worksheet”. Remember to specify that the first line of range contains column names under the advanced properties.



Then, using the action “For each”, we will loop through each of the datarow “CurrentItem“ ****in the datatable. For each iteration of the loop, we use the action “Go to web page” to navigate to the URL “%Url%/%CurrentItem[0]%/%CurrentItem[1]%” which consists of 3 parts:

  1. %Url% which is fixed and is “https://links.sgx.com/1.0.0/corporate-announcements/” in this example

  2. %CurrentItem[0]% refer to the first column of the current datarow, i.e. “CurrentItem“, which is read from the Excel

  3. %CurrentItem[1]% refer to the second column of the current datarow, i.e. “CurrentItem“, which is read from the Excel



Additional Information


  • Last updated on: 24 Jan 2023

  • Tested version(s): 2.27.177.22340

  • Prerequisites: Excel, Browser (e.g. Edge)

  • Dependencies: None

  • Known issues: None

Robotic Process Automation Singapore

CFB Bots is a leading technology service provider in the fast-growing field of Intelligent Automation. We partner with large enterprises in their Digital Transformation journey and help them and their employees thrive in the Future of Work.

NAVIGATE
CONTACT US
STAY CONNECTED

Singapore

CFB Bots Pte Ltd

Registration No.: 201705263H

77 High Street

#05-09, High Street Plaza

Singapore 179433

T: +65 6909 2099

E: enquiries@cfb-bots.com

Malaysia

CFB Bots Sdn Bhd

Registration No.: 202401045826 (1591672-X)

Suite: 33-01, 33rd Floor

Menara Keck Seng

203 Jalan Bukit Bintang

55100 Kuala Lumpur

T: +60 39 388 0352

E: my@cfb-bots.com

Australia

T: +61 2 8880 5998

E: au@cfb-bots.com

Join our mailing list to get the latest insights on automation

  • LinkedIn Social Icon
  • Facebook Social Icon
  • Twitter Social Icon
  • Instagram Social Icon
  • YouTube Social  Icon
TS Master Logo.png

© 2017-2025 CFB Bots Pte Ltd. All Rights Reserved. Tel: (65) 6909 2099 | Email: enquiries@cfb-bots.com | Privacy Policy | Terms of Use

bottom of page