Hi - I am trying to open /click rows in an excel with URL link. I need to extract that data once the URL is open pasting it back to to the corresponding row. Anyone has done something similar?
Solved! Go to Solution.
You need to open Excel with your file, read its content, oprn a browser, loop through each row?, open the cell value as URL in a browser, extract your data and write it back to Excel to a named or numbered cell
https://docs.microsoft.com/en-us/power-automate/desktop-flows/automation-web
You need to open Excel with your file, read its content, oprn a browser, loop through each row?, open the cell value as URL in a browser, extract your data and write it back to Excel to a named or numbered cell
https://docs.microsoft.com/en-us/power-automate/desktop-flows/automation-web
Hey, is there any more possible information on how to solve this. I have read through links provided by fraenK and I am still struggling to complete the same job as Anons post. Working through a list of URLs within excel, extracting info from selected URL and writing data onto the next column (Looping through each row intillfinish). Any simple guided templates would be greatly appreciated.
Assuming you are doing this in chrome:
Best of luck!
Thank you so much! I'll make sure to update you when I have it working
An Error is thrown on action 9 (Focus window) Window instance must be an integer value?
Hello @DarkinArch
Here is working example of desktop flow.
Excel.LaunchAndOpen Path: $'''C:\\Users\\User01\\Documents\\Open URL to Get Infor from Web.xlsx''' Visible: True ReadOnly: False LoadAddInsAndMacros: False Instance=> ExcelInstance
Excel.ReadAllCells Instance: ExcelInstance ReadAsText: False FirstLineIsHeader: True RangeValue=> ExcelData
SET RowIndex TO 2
LOOP FOREACH CurrentItem IN ExcelData
WebAutomation.LaunchEdge Url: CurrentItem['URL'] WindowState: WebAutomation.BrowserWindowState.Normal ClearCache: False ClearCookies: False Timeout: 60 BrowserInstance=> Browser
WAIT 2
WebAutomation.DataExtraction.GetDetailsOfElement BrowserInstance: Browser Control: appmask['Web Page \'h ... nd-august/\'']['Author and Publish Date'] AttributeName: $'''Own Text''' AttributeValue=> AttributeValue
WebAutomation.CloseWebBrowser BrowserInstance: Browser
Excel.WriteCell Instance: ExcelInstance Value: AttributeValue Column: 3 Row: RowIndex
Variables.IncreaseVariable Value: RowIndex IncrementValue: 1 IncreasedValue=> RowIndex
END
Excel.CloseAndSave Instance: ExcelInstance
Thank you.
Fantastic! Works perfectly Thank you!
Could be even faster if you move the "Launch new Microsoft edge" up before the for each
The use "Go to webpage" inside the "For each" loop
Then when the loop finish, close the web browser.
In that way you don't have to start and close the web browser all the time.
@Highboy do you know how can I complete this flow by using extracting data from webpage instead of get details of element on web page
Not quite sure what you are asking for.
@Highboy Thanks for your quick reply.
I have an Excel file with the following URL's
I want to open each of these websites and then webscrape multiple items on the pages.
E.g. contact details for multiple dealers.
Many thanks in advance
A quick solution would be something like this
@Highboy hello high boy,
i am having issues with following this. Attaching the issue and my doc here. thanks for much in advance for your help.!
Replace %20 with %%20
Ahhh can I have the excel file and the code, then I wil test it or we can take it online if you want