Quattro Pro provides the power of spreadsheet functions combined with Internet connectivity. With Quattro Pro, you can use HTML and XML to publish spreadsheets to the World Wide Web. You can also use Web querying and Web linking capabilities to add a dynamic element to your work.
In this section, you'll learn about
publishing spreadsheet data in HTML
setting HTML style options
using XML with Quattro Pro
working with Web queries
working with Web links
linking to Web graphics
For more information about working with the Internet, see "Reference: Working with the Internet."
Publishing spreadsheet data in HTML
Using Quattro Pro, you can save spreadsheet ranges as Hypertext Markup Language (HTML) documents. You can also save charts as HTML documents. As well, you can reorganize HTML documents to move or delete cell ranges.
To an HTML document you can add such information as when the document was last updated, who wrote the document and their email address, and the title of the document. You can also add hidden meta text to the HTML file which allows you to specify keywords to produce hits when performing searches on the Internet.
To save a spreadsheet range as an HTML document
1 Click File Publish to Internet.
2 In the Ranges and charts to convert area, click the Range picker and select a range of cells.
3 Click Add.
4 In the Export range as area, enable one of the following options:
Table-exports HTML table formatting tags
Text-exports only text, excluding HTML table formatting tags
5 Type a path and filename in the Save file box.
To save a table or chart as an HTML document
1 Click File Publish to Internet.
2 In the Ranges and charts to convert area, click Chart.
3 In the View chart dialog box, choose a chart from the Selected chart list.
4 Type a path and filename in the Save file box.
If you want to save tables or charts in an existing HTML file, enable the Insert only tables and charts into existing HTML file check box.
Note
When using Insert only tables and charts into existing HTML file, the selected ranges are inserted into the file specified in the Save file box at the <!- -## TABLE ##- - > tag if the file contains an HTML table, or at the <!- -## CHART## - - > tag if the file contains an HTML chart. If the specified file does not contain a <!- -## TABLE ##- -> or <!- - ## CHART ##- -> tag, the selected ranges are appended to the end of the file.
To reorganize an HTML document
1 Click File Publish to Internet.
2 Choose a cell range or chart from the Ranges and charts to convert list.
3 Click one of the following:
Delete-deletes the cell range or chart from the HTML file
Move up-moves the cell range or chart up one item in the list of ranges
Move down-moves the cell range or chart down one item in the list of ranges
To add document information to an HTML document
1 Click File Publish to Internet.
2 Type a path and filename in the Save file box.
3 In the Document info area, type information in any of the following boxes:
Last updated on-lets you add the date on which the document was last updated; by default, Quattro Pro automatically enters the date saved according to your system's internal date
By-lets you add the name of the person who updated the document; by default, Quattro Pro automatically enters the name stored in the login setting
Email-lets you add an email address to which Internet users can send email
Title-lets you add a title to display in the title bar of the document
Tip
You can also choose an HTML document by clicking Browse.
To add meta text to an HTML document
1 Click File Publish to Internet.
2 Type a path and filename in the Save file box.
3 In the Meta text area, type information in any of the following boxes:
Header-lets you add a name to display in the heading section of the HTML source code
Description below header-lets you add keywords or a description of the document
Notes
If you entered a subject in the document summary, it displays in the Header box. In the HTML source code, the header text displays as meta text in the heading section. For more information about document summaries, see "To record summary information about a notebook."
If you entered comments in the document summary, they display in the Description below header box. In the HTML source code, the keywords and description display as meta text in the heading section. For more information about document summaries, see "To record summary information about a notebook."
Tip
You can also choose an HTML document by clicking Browse.
Setting HTML style options
You can set the graphic type when you export a chart to an HTML document. For example, you can set the graphic to appear as a Graphics Interchange Format (*.GIF), or as a Joint Photographic Experts Group (*.JPG) file.
You can set page layout options to display spreadsheet data on a single page, on a frame-enhanced page, or on multiple pages. A frame-enhanced page is divided into three frames. One frame contains a list of hyperlinks to each Web page created. When you click a hyperlink, the corresponding Web page displays in the second frame. The third frame contains the HTML document information (for example, email address, author, or date the document was last updated). When you display data on multiple pages, Quattro Pro creates a separate index page, instead of a frame, which contains hyperlinks to each Web page created. When you click a hyperlink, the corresponding Web page displays in the browser.
By default, Quattro Pro uses the color settings associated with your Web browser for the text, hyperlinks, and background on a Web page. You can customize these color settings.
To set the graphic type for an HTML document
1 Click File Publish to Internet.
2 Type a path and filename in the Save file box.
3 Click Options.
4 In the Publish to HTML options dialog box, enable one of the following options:
Graphics Interchange Format (*.GIF)
Joint Photographic Experts Group (*.JPG)
Tip
You can also choose an HTML document by clicking Browse.
To set the page layout for an HTML document
1 Click File Publish to Internet.
2 Type a path and filename in the Save file box.
3 Click Options.
4 In the Publish to HTML options dialog box, enable one of the following options:
Single page-publishes cell ranges or charts on one Web page
Frame-enhanced page-publishes cell ranges or charts using a frame-enhanced Web page
Multiple pages-publishes cell ranges or charts on multiple Web pages
Notes
Frame-enhanced pages can be viewed only by Web browsers that support frames.
When you enable the frame-enhanced page or multiple pages options Quattro Pro creates separate Web pages for each range of selected data to convert to HTML.
Tip
You can also choose an HTML document by clicking Browse.
To customize color settings for an HTML document
1 Click File Publish to Internet.
2 Type a path and filename in the Save file box.
3 Click Options.
4 In the Publish to HTML options dialog box, enable the Use my color settings option.
5 In the Color settings area, make choices for any of the following settings:
Text color-lets you select the color of the text
Link color-lets you select the color of the hyperlinks
Background color-lets you select the color of the page background
Background wallpaper-lets you select a graphics file to display as the background
Notes
Quattro Pro automatically applies colors used in the spreadsheet to the HTML document for such items as text and background colors.
Quattro Pro converts colors in a spreadsheet to their corresponding Red Green Blue (RGB) hex values in the HTML document. For information about RGB hex values, see "Color control."
Tip
You can also choose an HTML document by clicking Browse.
Using XML with Quattro Pro
Quattro Pro gives you the flexibility to manually or automatically create XML tags. Tags can be created automatically either from labels or from row and column titles. You can also display an output of the XML tags that have been created.
As well, you can use Quattro Pro to create top-level root elements and then publish tagged data as an XML file.
To manually create XML tags
1 Select a cell or range of cells containing text to use to create XML tags.
2 Click Insert XML tags.
3 In the Tag box, type the name of the tag.
4 Click Add.
To automatically create XML tags from labels
1 Select a cell or range of cells to use to create XML tags.
2 Click Insert XML tags.
3 Click Labels.
4 In the Direction area enable one of the following options:
Right-creates XML tags for the cell immediately to the right of any valid cells in the selected range
Left-creates XML tags for the cells immediately to the left of any valid cells in the selected range
Down-creates XML tags for any cells immediately below all valid cells in the selected range
Up-creates XML tags for any cells immediately above all valid cells in the selected range
Note
For additional information about creating XML tags, see "Example: XML tag creation."
To automatically create XML tags from row or column titles
1 Click Insert XML tags.
2 Click Generate.
3 In the Generate XML tags dialog box, click the Range picker, and select the cells to tag.
Include the designated labels or headings to use to create the XML tags in the selected cell range.
4 In the Create XML tags area, enable any of the following check boxes:
Under top row-creates an XML tag for each cell in the selected range, excluding the top row. The XML tags created are based on the text in the top row.
Right of left-most column-creates an XML tag for each cell in the selected range, excluding the left-most column. The XML tags created are based on the text in the left-most column.
Above bottom row-creates an XML tag for each cell in the selected range, excluding the bottom row. The XML tags created are based on the text in the bottom row.
Left of right-most column-creates an XML tag for each cell in the selected range, excluding the right-most column. The XML tags created are based on the text in the right-most column.
Tag cells at intersections-creates a compound XML tag definition for each intersecting cell that includes a row and column label. The XML tags created incorporate both the row and column labels.
Note
For additional information about creating XML tags, see "Example: XML tag creation."
To display XML tags
1 Click Insert XML tags.
2 Click Output.
3 In the Tag table dialog box, type a cell location in the Cells box.
Note
The cell you specify in the Cells box should be in a new area of the spreadsheet, where existing data won't be overwritten by the output column.
To create a top-level root element
1 Type a period in each cell around the perimeter of the cell block you want to publish.
2 Click Insert XML tags.
3 In the XML tags dialog box, choose the cell range of all the cells you want to include in the root element.
Include the designated labels, headings, and periods used to create the XML tags in the selected cell range.
Note
XML files can contain only one root element. When publishing with the default range, several root elements are created at the same level so that XML-compliant parsers return an error message.
Tip
You can also choose the cell range of all the cells you want to include in the root element by clicking Generate and dragging to select the cells.
To publish tagged data as an XML file
1 Click File Publish to Publish to XML.
2 Click the Range picker and select a range of cells.
3 Type a path and filename in the Save file box.
4 Click Publish.
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. As well, 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.
Include the search parameters of the URL in the text string (for example, to retrieve stock quotes type http://quote.pathfinder.com/money/quote/qc?symbols=["symbols", "Enter one or several company symbols separated by spaces:"]).
3 Type a path and filename in the Save to box.
Tip
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.
Notes
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.
Tip
If you are not sure how much area you require when putting Web query results into an existing notebook, type the coordinates of a single cell as the starting location. Ensure that the area beneath and to the right of the cell is clear of data.
To change how a Web query obtains a parameter value
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 prompt string-displays a dialog box with the instructions you type in the box. The dialog box displays during the query, and typically the instructions prompt a particular value to be entered.
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:
Wrap data to beginning of range-loads the source data at the beginning of a cell or cell range and replaces existing data. If the cell range is full of refreshed data, you can clear the range before loading the next value into the first cell of the range by enabling the Clear data on wrap check box.
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
Note
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 day-choose an end day from the list box
Working with Web links
Using Quattro Pro, you can create Web links, which allow you to retrieve data from the Internet and place it into a notebook. You can access (HTTP), gopher, and File Transfer Protocol (FTP) sites.
You can refresh Web link data in a range of cells. For example, you can track a company's stock price changes over the course of a day at hourly intervals. As well, you can manually refresh Web links, or set automatic refresh intervals to update linked data. You can also edit and delete Web links.
To create a Web link
1 Click File Open.
2 Type a URL in the Filename box.
3 Click Open.
4 Find the cell containing the relevant information and note its location.
5 Select the destination cell where you want the link to display.
6 Type +[URL]Sheet:Cell reference
Sheet:Cell reference is where the information displayed when you opened it in a notebook. For example, +[http://www.corel.ca/product/prod.htm]C:B9
7 In the Link to box, type the cell location where you want the information to display.
Note
Web links are saved along with the notebook.
Tip
You can also select the cell where you want the information to display by clicking the Range picker and selecting the cell.
To refresh Web link data in a range of cells
1 Select a cell that contains a Web link.
2 Click Tools Internet Edit Web link.
3 In the Link to box, click the Range picker and select the range of cells.
4 Enable one of the following options:
Wrap data to beginning of range-loads the source data at the beginning of a cell or cell range, and replaces existing data
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
To manually refresh a Web link
1 Click Edit Links Refresh links.
2 Click a link.
To set a Web link refresh interval
1 Select a cell that contains a Web link.
2 Click Tools Internet Edit Web link.
3 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 day-choose an end day from the list box
To edit a Web link
1 Select a cell containing a Web link.
2 Click Tools Internet Edit Web link.
3 Modify any settings.
To delete a Web link
1 Click Edit Links Delete links.
2 Click a link.
Linking to Web graphics
Quattro Pro lets you insert Web graphics into a spreadsheet by dragging them from your Web browser. When you drag a graphic from the browser to a spreadsheet, you create a link to that graphic that is similar to a hyperlink. Quattro Pro supports dragging graphics from the Internet using the Netscape Navigator browser. For information about hyperlinks, see "To insert a hyperlink."
You can also create a live image link to dynamic graphics on the Internet. Live image links are updated automatically at set refresh intervals. For example, if you create a live image link to a dynamic weather map, Quattro Pro displays the weather map as a graphic on the spreadsheet and updates the graphic with weather changes at specified refresh intervals.
To insert a Web graphic
1 Open Netscape Navigator.
2 Locate a URL that contains a graphic.
3 Drag the graphic from Netscape Navigator to a notebook.
To create a live image link to a dynamic Web graphic
1 Open Netscape Navigator.
2 Locate a URL that contains a dynamic graphic.
3 Drag the graphic from Netscape Navigator to a notebook.
4 Double-click the graphic.
5 In the Refresh area, enable any of the following check boxes:
Refresh every-updates the live link at regular intervals according to the unit and time interval you choose
Refresh on open-updates the live link each time you open the notebook
Notes
Live image links work in conjunction with the settings in the Windows Control Panel of your desktop. Before creating a live image link, you must change your temporary Internet file settings to check for newer versions of stored pages on every visit to the page.
You must have Microsoft Internet Explorer (to change the Internet settings) and Netscape Navigator 4.5 or later (to use the drag-and-drop feature) installed on your system to create a live image link.
Tip
If Quattro Pro is minimized, drag the graphic from Netscape Navigator to the Windows taskbar. Quattro Pro automatically maximizes the application window, and you can drop the graphic on the open notebook.
Reference: Working with the Internet
Extensible Markup Language (XML) is an open international standard issued by the World Wide Web Consortium (W3C). XML provides both a platform-independent and an application-independent environment for defining document architecture and document markup. Quattro Pro allows you to automatically create XML tags based on data.
Example: XML tag creation
When you automatically create XML tags for a range of cells, Quattro Pro applies the label in each row or column to all selected cells in that row or column. If you create XML tags in more than one location, Quattro Pro creates a set of tags for each set of labels. For example, if you select A1..C4 from the figure below and create XML tags for cell ranges located under the top row and right of the left-most column, five names are created: Jan., B2..B4; Feb., C2..C4; Housing, B2..C2; Utilities, B3..C3; and Food, B4..C4.
If you create XML tags at cell intersections, Quattro Pro adds an additional tag to each cell by combining the two sets of labels. The following is a table of the additional XML tags for this example.
