Please help: Open Browser: Cannot find column 1

Help Orchestrator
#1

Hi guys, I’m trying to make an activity where I have a .xlsx table with some links, and for each row I want to open the browser and scrape for 2 elements on the page. The error I get so far is “Open Browser: Cannot find column 1.” Can you please have a look?

Also how can I close the tab after the data is scraped on one page so i don’t have a bunch of tabs open?

Thanks!

#2

Hy @madalin.slaniceanu if you are using a excel remove the hyper link
can u send a screenshot of the error

#3

Thanks for your response @Tharusha_Fernando. I’ve attached a screenshot. Also, the hyperlinks in the excel are off.

ice_screenshot_20210222-133522
ice_screenshot_20210222-1335221316×932 50.3 KB

#4

try to mention your column by name ex - row(“Email”).tostring

#5

yass, that worked, thanks a lot @Tharusha_Fernando ! My next issue is regarding the fact that after all the browsers open, in the write range I only get the last result and not all the results that are scraped. Do you have any clue here?

workflow-1
workflow-11062×2014 193 KB

#6

@madalin.slaniceanu, since you are running a loop, the extracted results gets replaced by the next item thereby leaving only the last item. Try to change your Excel (Write Range) file names like this:

"C:\Users\offic\Desktop\write range\ " + row(“website”).ToString + “.xlsx” and you should be able to see the results of all the extractions.

If you want the results to be in a single file then you can use row(“website”).ToString as the sheet name.

If you want the results to be in the same file then you can use Append Range instead of Write Range.

Hope this helps.