copy from a web page to Excel spreadsheet

(1) Share

Report

Posted on by dheminger1018

Problem:

Web application produces a window:

I need to copy this to a blank Excel spreadsheet.

Manually, I would Ctrl-A, Ctrl-C and Ctrl-V into cell A1 of the Excel spreadsheet.

The Excel would automatically parse into columns and I would save with the appropriate name.

I have tried many different things:

Extract data from web page;

Take screenshot of web page;

Extract data from window;

I have tried storing the output of the above in ClipboardText;

Also, storing it directly to an ExcelInstance. ( get all information in A1)

The above will not paste into my blank Excel sheet.

I have tried Send Keys {Control}{(A)}

{Control}{(C)} to web page(error "There isn't an active application to send keystrokes to.", then {Control}{(V)} to ExcelInstance.

I summary, I have tried many different avenues but I cannot get the information to Excel as if I had done it manually.

All help is appreciated. Thank you,

David

Categories:

Power Automate Desktop

I have the same question (0)

All responses (4)

Answers (0)

Sort by

crelke 75 on at

Like
a
(0)

Report
Copy link

Link copied!

Have you tried using the "Get details of webpage" action? To grab the page details and then paste into the excel file? You might need to parse out some html in that output, but that should get you all text on the web page.

Was this reply helpful? Yes No
dheminger1018 33 on at

Like
a
(0)

Report
Copy link

Link copied!

Did not work.
I used Write to Excel worksheet to paste data:

All in cell A1. Also, not even all text from the webpage in the cell:
I scrolled thru the data in the formula box and all is not there.

Any other ideas?

David

Was this reply helpful? Yes No
Arshavince 6 on at

Like
a
(0)

Report
Copy link

Link copied!

Hi did you ever solve this?
I am doing a similar thing and I have taken the advice and used "get details of webpage" and set it to webpage text.
When pasted it looks the same as yours, but it goes beyond the height of the cell, even though there are many more lines of text stored.
You can use "data to columns" in excel and then use "ctrl+J" as a delimiter which is for the carriage return. This will give you each line of text in A1 in separate cells in row 1.
You can then copy and transpose paste this information into column A.
From there you might be able to do some sort of automation to restructure it how you need it. I'm going to try and transform the data in power automate before I put it in excel as I think it will be easier to work with there.
Since this is from a web app, though, is the web app provider not able to produce this as a standalone report for you?
The other thing that I have come across is inspecting the UI elements of the page by manually adding a UI element from the UI elements panel, and then going "inspect ui elements".
In this way you can more easily select UI elements that are otherwise hard to click using the tool. Once you have the base CSS you can paste it into the extract data from web > advanced step.

Was this reply helpful? Yes No
Agnius Bartninkas Most Valuable Professional on at

Like
a
(0)

Report
Copy link

Link copied!

This is because Get details of element in web page returns a single string.

I recommend trying to use Extract data from web page. This will result in a data table. When you write the data table into Excel, it will write it properly, with each value being sent to an appropriate cell.

Was this reply helpful? Yes No