![]() ![]() ![]() Select by clicking on the line HTML_tables (or another line if the data do not correspond to the desired table).The Available pages/ ranges area will now show a list of the type (in the example above) : The dialog for import options disappears.After a few seconds (sometimes a bit longer) a new window appears:.Press ↵ Enter to validate this address.It is also possible to copy the address from the address bar of your browser, then paste it into the URL box (with. Write in the URL of external data source box, the address of the internet page containing the data table to be recovered, for example.Choose the URL of the page source in the list.Select File Type = Web Page Query (Calc) (*.html *.xhtml *.htm) (at the bottom of the list)." button to the right of the URL of external data source box. If the internet page that interests you has been saved locally :.Click on a cell in the table (A1 for example).Create a new LibreOffice Calc document.How to import data tables from an Internet site and have them automatically updated ![]()
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |