Faq/Base/019

TDF LibreOffice Document Liberation Project Community Blogs Weblate Nextcloud Redmine Ask LibreOffice Donate

• Wiki Home
• Development
• Design
• QA
• Events
• Documentation
• Website
• Localization
• Accessibility
• Marketing
• Diversity
• Wiki Help

• Documentation Home
• Official Publications
• Other Resources
• FAQ
• HowTo
• Macros
• Docs Development

• FAQ Home
• General
• Writer
• Calc
• Impress
• Draw
• Math
• Base

How can I import data from an HTML page via Calc and refresh the data every x seconds?

In Calc, a link to an external data source must be entered via Table ▸ Link to external data… menu.

If a link to external data is entered here, it must be confirmed with Return.

Only then can individual tables, recognizable by the displayed contents HTML_1, HTML_2, etc., be selected.

For these data an update can be specified, so that they are reloaded in the time period from the net again.

The base file must now access the table document.

It will then read the contents of all the spreadsheets in the Calc file.

The name for the tables is defined by the name of the table sheets.

 Note:  This method only works with HTML pages via Calc.

Content modified and testet by Robert Grosskopf - 2021-14-08.