Webquery : Importing HTML tables
With the help of the Web Page Query OpenOffice.org Calc import filter, you can insert tables from HTML documents in a OpenOffice.org Calc spreadsheet.
Let us step through the relatively straightforward process of importing data from tables in a HTML document.
The data for this example was obtained from an excellent website with tons of population data from all over the world : citypopulation.de
Here is what the source HTML file looks like : swiss.html
For this example, we will be importing awebpage from the local disk.
The External Data dialog is activated by Insert-External Data.
Once we fill in the path to the local copy of the HTML file and the table inside this file we wish to import - we hit OK and we are done - it is that easy.
August 2nd, 2007 at 9:27 am
Can we do a similar thing with data we copy and paste into Calc? If we just have text that is delimited by spaces that should be broken into columns, Excel has the function Data> Text to Columns that allows one to specify delimiters to break up data into several columns. Is there an analogous function in Calc?