Click OK to close this dialog and insert the linked data.You can also specify that the ranges or tables are updated every (number of) seconds. In the Available tables/range list, select the named ranges or tables you want to insert.Press Enter to get Calc to load the list of available tables. On the External Data dialog, type the URL of the source document or click the button to open a file selection dialog.Select the cell where the upper left-hand cell of the external data is to be inserted.A set of CLI/.NET bindings come with the SDK, and are by default installed in ( example for SDK v3. Its analogous to how you can control Microsoft Office via COM. Open the Calc document where the external data is to be inserted. You can use OpenOffice this way to accomplish a number of different things one example is converting files from one file format to another.However, if the file has several tables, and you want to pick only one of them, you may not be able to easily determine which is which in that case, the Navigator method may be easier. If your file has named ranges or named tables, and you know the name of the range or table you want to link to, using the External Data dialog method is quick and easy. You can do this in two ways: using the External Data dialog or using the Navigator. You can insert tables from HTML documents, and data located within named ranges from an Calc or Microsoft Excel spreadsheet, into a Calc spreadsheet (To use other data sources, including database files in OOo Base, see Linking to registered data sources).

Openoffice calc database