Working with Web queries
You can create and run a Web query to retrieve information stored on the Internet and insert it directly into a spreadsheet without using a browser. For example, you can use a Web query to retrieve the latest stock quotes from the Internet and place them in a spreadsheet table. By default, when you run a Web query, you automatically create a link between the retrieved data and the Internet source data.
You can change the way in which information is obtained when you run a query. In addition, various Web query options can be set to help you customize the formatting of the query.
You can insert specific Web query data into a notebook at selected positions in a range of cells. Refresh intervals can be set to keep data current.
To create a Web query |  |
|
1.
|
|
Click Tools
 Internet Create Web query. |
|
2.
|
|
In the URL box, type a URL.
|
|
3.
|
|
Type a path and filename in the Save to box.
|
|
•
|
|
If a parameter is not part of the URL, type it in the POST parameters box.
|
To run a Web query | |
|
1.
|
|
Click Tools
Internet Run Web query. |
|
2.
|
|
Choose the drive and folder where the Web query is stored.
|
|
3.
|
|
Double-click the filename.
|
|
4.
|
|
In the Run Web query dialog box, click the Data tab.
|
|
5.
|
|
Enable the New notebook option.
|
|
6.
|
|
Click OK.
|
|
If a parameter is required for the query, type it in the Enter parameter value dialog box which appears.
|
|
7.
|
|
In the Web query preview dialog box, select the cell or range of cells in the preview window that you wish to query.
|
|
8.
|
|
Click the Range picker
 and select the cell or range of cells on the spreadsheet to link to the Internet source data. |
|
•
|
|
If you don’t want to preview the Web document, disable the Preview Web document before loading in the notebook check box in the Run Web query dialog box.
|
|
•
|
|
Quattro Pro uses an .iqy file to run a Web query. You can use the query files provided with Quattro Pro, or you can create your own .iqy files. For information on creating Web query files, see “To create a Web query.” Sample query files are stored in the queries folder that is installed with WordPerfect Office, or you can run .iqy files that you find on the Internet or obtain
through your Web administrator. |
To change how a parameter value is assigned to a Web query | |
|
1.
|
|
Click Tools
Internet Run Web query. |
|
2.
|
|
Choose the drive and folder where the Web query is stored.
|
|
3.
|
|
Double-click the filename.
|
|
4.
|
|
In the Run Web query dialog box, click the Parameters tab.
|
|
5.
|
|
In the Get the data for parameter using area, enable one of the following options:
|
|
•
|
The following value — lets you specify a value (for example, a company stock symbol) by typing it in the box
|
|
•
|
The value from the following cell — lets you type the cell address or range in the notebook from which a value (for example, a company stock symbol) can be retrieved
|
To set Web query options | |
|
1.
|
|
Click Tools
Internet Run Web query. |
|
2.
|
|
Choose the drive and folder where the Web query is stored.
|
|
3.
|
|
Double-click the filename.
|
|
4.
|
|
In the Run Web query dialog box, click Options.
|
|
5.
|
|
In the Web query options dialog box, enable any of the following options:
|
|
•
|
Save Web query as Web link — creates a link between the source data and the retrieved Web query data in the spreadsheet
|
|
•
|
Import only tables from HTML file — inserts only tables from the HTML file to the spreadsheet
|
|
•
|
Automatically size columns to fit data — adjusts the column width to fit the data from the HTML document
|
|
•
|
Retain HTML formatting and layout — applies the format and layout of the HTML document to the spreadsheet
|
|
•
|
Refresh data on file open — updates the Web query data in your spreadsheet each time the file is opened
|
To insert specific Web query data | |
|
1.
|
|
Click Tools
Internet Run Web query. |
|
2.
|
|
Choose the drive and folder where the Web query is stored.
|
|
3.
|
|
Double-click the filename.
|
|
4.
|
|
In the Run Web query dialog box, click the Data tab.
|
|
5.
|
|
Enable the Existing notebook option.
|
|
6.
|
|
Click OK.
|
|
If a parameter is required for the query, type it in the Enter parameter value dialog box which appears.
|
|
7.
|
|
In the Web query preview dialog box, select the cell or range of cells in the preview window that you wish to query.
|
|
8.
|
|
Click the Range picker
and select the cell or range of cells on the spreadsheet to link to the Internet source data. |
|
9.
|
|
Click Link, and enable one of the following options:
|
|
•
|
Insert data at end of range — loads the source data at the end of the cell range, and shifts the previous values up or left in the range with each subsequent refresh
|
|
•
|
Insert data at beginning of range — loads the source data at the beginning of the cell range, and shifts all previous values down or to the right in the range with each subsequent refresh
|
|
•
|
|
For information on setting a refresh interval for your web query, see “To set a Web query refresh interval.”
|
To set a Web query refresh interval | |
|
1.
|
|
In the Web query preview dialog box, click Link.
|
|
2.
|
|
In the Refresh interval area, specify one of the following settings:
|
|
•
|
Refresh every — select a unit and time interval from the list box. Acceptable ranges are as follows: seconds 1 to 59, minutes 1 to 59, hours 1 to 24, days 1 to 10.
|
|
•
|
Start refresh at — type a start time, and choose either a.m. or p.m
|
|
•
|
End refresh at — type an end time, and choose either a.m. or p.m
|
|
•
|
Start day — choose a start day from the list box
|
|
•
|
End da
y — choose an end day from the list box |