Question

List the produce involved in linking html tables to calc worksheet.​

Answer 1

Answer:

Open the web page which contains the table you want to import.

Copy the URL.

Open a Calc document and then select a cell.

Choose the Link to External Data.

Press Enter or Return.

Answer 2

Answer:

Using the External Data dialog

1. Open the Calc worksheet where the external data is to be inserted. This is the target worksheet.

2. Select the cell where the upper left-hand cell of the external data is to be inserted.

3. Choose Insert -> Link to External Data.

4.On the External Data dialog ,type the URL of the source worksheet or click the [...] button

to open a file selection dialog. Press Enter to get Calc to load the list of available tables.

5. In the Available tables/range list, select the named ranges or tables you want to insert.

You can also specify that the ranges or tables are updated every (number of) seconds.

6. Click OK to close this dialog and insert the linked data.