From The Document Foundation Wiki
How can I import data from an HTML page or from Calc and refresh the data every x seconds?
- On selecting the menu ▸ , a window appears asking for the URL or filename. The button with the ellipsis allows you to navigate to find your file quickly.
- When you have chosen your file, the field below the name tables the possible options, select the one you want
- Click on "Execute every x seconds"
- The table appears and will be refreshed every x seconds
Note : This method is only possible with HTML pages or Calc