From ed5640d8b587fbcfed7dd7967f3de04b37a76f26 Mon Sep 17 00:00:00 2001 From: Daniel Baumann Date: Sun, 7 Apr 2024 11:06:44 +0200 Subject: Adding upstream version 4:7.4.7. Signed-off-by: Daniel Baumann --- helpcontent2/source/text/scalc/guide/webquery.xhp | 107 ++++++++++++++++++++++ 1 file changed, 107 insertions(+) create mode 100644 helpcontent2/source/text/scalc/guide/webquery.xhp (limited to 'helpcontent2/source/text/scalc/guide/webquery.xhp') diff --git a/helpcontent2/source/text/scalc/guide/webquery.xhp b/helpcontent2/source/text/scalc/guide/webquery.xhp new file mode 100644 index 000000000..c98461be3 --- /dev/null +++ b/helpcontent2/source/text/scalc/guide/webquery.xhp @@ -0,0 +1,107 @@ + + + + + + + + + + +Inserting External Data in Table (WebQuery) +/text/scalc/guide/webquery.xhp + + + +HTML WebQuery +ranges; inserting in tables +external data; inserting +tables; inserting external data +web pages; importing data +WebQuery filter +inserting; external data +data sources; external data +UFI: removed "external data;WebQuery" because both index entries "external data" led to this page. +Inserting External Data in Table (WebQuery) + +With the help of the Web Page Query ($[officename] Calc) import filter, you can insert tables from HTML documents in a Calc spreadsheet. +You can use the same method to insert ranges defined by name from a Calc or Microsoft Excel spreadsheet. +The following insert methods are available: +Inserting by Dialog + + +Set the cell cursor at the cell where the new content will be inserted. + + +Choose Sheet - External Links. This opens the External Data dialog. + + +Enter the URL of the HTML document or the name of the spreadsheet. Press Enter when finished. Click the Browse button to open a file selection dialog.only after Enter the URL will be requested from the net. + + +In the large list box of the dialog, select the named ranges or tables you want to insert. + + +You can also specify that the ranges or tables are updated every n seconds. + + +The import filter can create names for cell ranges on the fly. As much formatting as possible is retained, while the filter intentionally does not load any images. +Inserting by Navigator + + +Open two documents: the $[officename] Calc spreadsheet in which the external data is to be inserted (target document) and the document from which the external data derives (source document). + + +In the target document open the Navigator. + + +In the lower combo box of the Navigator select the source document. The Navigator now shows the range names and database ranges or the tables contained in the source document. + + +In the Navigator select the Insert as link drag mode +Icon + . + + +Drag the desired external data from the Navigator into the target document. + + +If you have loaded an HTML document with the Web Page Query filter as the source document, you will find the tables in the Navigator, named continuously from "HTML_table1" onwards, and also two range names that have been created: + + + +HTML_all - designates the entire document + + + +HTML_tables - designates all HTML tables in the document + + +Editing the external data + + +Open Edit - Links. Here you can edit the link to the external data. + + +
+External data dialog + +
+ + -- cgit v1.2.3