I blogged here about how to get a spreadsheet into a Writer table.
As for the opposite, getting a Writer table into a spreadsheet, you just copy and paste. Very easy.
How do you get an HTML table into a spreadsheet?
Or, frankly, how do you just suck some HTML content into a spreadsheet?
You should be able to copy and paste--when I paste a table, it comes into the spreadsheet nicely with the rows and columns retained correctly. However, I understand that doesn't work for everyone. So you can use this approach, instead.
Also, if you are so inclined, how do you get it to update regularly? Maybe you want to display stock quotes from a Web page--you can choose to put those in a spreadsheet and have them update every 30 or 300 seconds. (This feature works correctly with links to files and it really should work, in theory, to link your spreadsheet to a web page on the net but I can't get it to work with a URL, just with a file. If anyone else can, write and let me know how.)
In this case, you might always want to use this approach.
1. Go to the web page containing the table that you want to use. Save the file to your computerif it's not there already. The window and the online help indicate that you can just link to a URL starting with HTTP but I can't make it work.
Also, take a look at the tables if there are more than one. You're going to need to figure out which table you want by knowing what order the tables appear in.
2. Go to your spreadsheet. Click in the cell at the upper left range of where you want the table(s) to appear.
3. Choose Insert > Link to External Date.
4. In the window that appears, browse to the file that you saved to your computer. If you want to try making an HTTP URL work, then paste in that URL instead. The online help says to paste it in, then press Enter.
5. Select the content you want to insert. HTML_All inserts everything in the HTML page. HTML_Tables inserts all the tables. HTML_1 inserts the first table, and so on.
6. Select the Update Every option, if you want to update the content, and specify how often in seconds. This does work, but it has a drawback that we'll see later.
7. Click OK.
9. To format the content to wrap within the cell, select the cells, choose Format > Cells, and in the Alignment tab select the Wrap option shown. Click OK.
10. Whenever the HTML file changes, the spreadsheet updates. However, as you will see, all your beautiful wrap formatting goes away.
If your content in the table is fairly wide, then:
- Resign yourself to it looking like this in the spreadsheet
- Widen the cells in the spreadsheet
- Don't choose to update the content