![]() ![]() This does work, but it has a drawback that we'll see later.Ĩ. Select the Update Every option, if you want to update the content, and specify how often in seconds. HTML_1 inserts the first table, and so on.Ħ. HTML_All inserts everything in the HTML page. The online help says to paste it in, then press Enter.ĥ. If you want to try making an HTTP URL work, then paste in that URL instead. In the window that appears, browse to the file that you saved to your computer. Click in the cell at the upper left range of where you want the table(s) to appear.ģ. ![]() You're going to need to figure out which table you want by knowing what order the tables appear in.Ģ. 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.Īlso, take a look at the tables if there are more than one. Save the file to your computerif it's not there already. Go to the web page containing the table that you want to use. In this case, you might always want to use this approach.ġ. If anyone else can, write and let me know how.) (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. To put those in a spreadsheet and have them update every 30 or 300 Maybe you want to display stock quotes from a Web page-you can choose So you can use this approach, instead.Īlso, if you are so inclined, how do you get it to update regularly? However, I understand that doesn't work for everyone. 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. Or, frankly, how do you just suck some HTML content into a spreadsheet? ![]() How do you get an HTML table into a spreadsheet? I blogged here about how to get a spreadsheet into a Writer table.Īs for the opposite, getting a Writer table into a spreadsheet, you just copy and paste. ![]()
0 Comments
Leave a Reply. |