« Hyperlinks : Linking to a webpage | Main | Selecting an entire sheet »
October 20, 2004
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.
Posted by Dave at October 20, 2004 07:14 AM
Comments
you are heaven sent. your instructions were more precise, concise, and helpful than the openoffice calc "help" file. thank you.
Posted by: sookietex at June 13, 2005 04:34 PM
Hi,
I am generating report from my .NET web application which is very complex WITH HIGH ROWSPAN ( more than 300 rows are spaned). I am preparing report in html table, sending it to response (Response.Write) and setting the header "Content-Disposition" as "attachment;filename=report.sxc". This will ask user to download OpenOffice.org Spreadsheet file on client machine.
I tried with OpenOffice.org 1.1.4 and OpenOffice.org 1.1.9 (i.e. 2.0 Beta) on client.
The problems I faced:
# with version 1.1.4- The report is downloaded properly in OpenOffice.org calc, when I click "Open" button in dialog box. However, report was not taking rowspan for a cell more than 256. which was disturbing whole format of the report. Also, the style I apply is also not visible. (which is properly applied in MS-Excel).
For your reference, when I tried to make changes in downloaded .sxc file on client machine, It gave me error as "Can not save documents in Web Page Query (OpenOffice.org 1.0 Calc) format"
# with version 1.1.9 - The report is generated properly. However, it does not display as a spreadsheet, but displays as HTML only.
Kindly, suggest
Posted by: Amol at August 10, 2005 12:35 AM