Excel automation

I need to loop through the rows of a worksheet…how do I make the excel file in my computer accessible to robocorp?..like can i give
open workbook excel_file_path…
Giving direct path like this gave me an error…pls help

Hi, @rpastudent77! Yes, that should work. If you can paste your code, maybe we can spot the error.

// Jani

  • Use double-backslashes (\\) OR
  • Use the ${/} variable as the directory separator - it replaces the separator with a working one
1 Like

Thank u so much…it worked …can i add 1 more doubt…how can i take each element of a particular column

1 Like

sorry…i got it using get table column activity