Value from a web page placed into a cell

Discuss the spreadsheet application
Post Reply
User avatar
RMRavik
Posts: 4
Joined: Sun Nov 24, 2024 6:46 pm
Location: Aberdeen, Washington

Value from a web page placed into a cell

Post by RMRavik »

Using Calc I have an inventory of precious metals. There is a website that has a running chart of spot prices. There is a box on this site that shows the current price. I would like the contents of that box placed into a cell at the activation of that cell.
At present I hyperlink to the site, copy the box and then paste the info into the cell.
It seems like I could do it with a macro but am not familiar with them.
I think I just answered my question. I'll keep looking.
Thanks for your help
Open Office 4.1.14 - Windows 11, 64
User avatar
robleyd
Moderator
Posts: 5288
Joined: Mon Aug 19, 2013 3:47 am
Location: Murbko, Australia

Re: Value from a web page placed into a cell

Post by robleyd »

Depending on how the web page is structured, you might be able to use Linking to external data. There is also information in the offline HELP - search external data.
Slackware 15 64 bit
Apache OpenOffice 4.1.15
LibreOffice 24.8.3.2; SlackBuild for 24.8.3 by Eric Hameleers
---------------------
Roses are Red, Violets are Blue
Unexpected '{' on line 32
.
User avatar
Lupp
Volunteer
Posts: 3623
Joined: Sat May 31, 2014 7:05 pm
Location: München, Germany

Re: Value from a web page placed into a cell

Post by Lupp »

Users of LibreOffice V 4.2 or higher may also try WEBSERVICE() combined with FILTERXML().

Please note:
I'm not an expert in pulling details from the web, and used the mentioned functions myself only once for a solution years ago.
On Windows 10: LibreOffice 24.8.3 and older versions, PortableOpenOffice 4.1.7 and older, StarOffice 5.2
---
Lupp from München
User avatar
RMRavik
Posts: 4
Joined: Sun Nov 24, 2024 6:46 pm
Location: Aberdeen, Washington

Re: Value from a web page placed into a cell

Post by RMRavik »

I haven't found a web page that will allow me to use the only number I'm after so I'm still searching. I did find one that allows me to use a range of data with the number I'm after but I can't figure out how to access that particular number. I did set up a link to the site so that I can copy the number and place it for now. I'll figure it out and thanks for your help.
Open Office 4.1.14 - Windows 11, 64
Post Reply