which is displayed as:

Quarter	Earnings	Profit
Q198	30000	5000
Q298	42000	8000

Additional parameters can be specified within the tags, for example, to right align text, use the ALIGN=RIGHT parameter, as shown here:

<TD ALIGN=RIGHT>32000

This code can be generated almost entirely within a Notes view -- with one exception: Notes Views have a header to hold the opening <TABLE> tag, and the column headers, but have no equivalent footer to place the closing </TABLE>. Fortunately, Domino has an answer to this. View templates can hold both top and tail tags, and do so in a more manageable fashion than cramming HTML tags into the standard view header.

Careful HTML authors would also include closing tags, e.g. </TD> and </TR> at the end of each cell and row respectively. These can however be dispensed with, for simpler views, and quicker page builds. [At DominoPower, we never recommend skipping closing tags, even though most browsers will allow it. -- DG]

Simple example
Let's say you want to create a Notes view of the columns you wish to turn into a Web page. The process is similar to constructing a standard Notes view with the following exceptions:

• In the "'Propellerhead" tab of the View Properties InfoBox, check Treat View Contents as HTML

• In the InfoBox, uncheck Show Column Headings

• Convert all column values to text, using appropriate @text formula for the format you desire. For example, "(F,2" will format a number to decimal places, separate the 1000s with a comma and place negative values in brackets.

• Prefix the first column value with a <TR>

• Prefix each column value with a <TD>, as shown in Figure A.

FIGURE A

This shows the first column in the view (nicely coded with a closing </TD> tag).

That's all there is to the view component. Since the header is not being used for the page itself, you're free to use it for your own comments; putting the Excel column letter in here helps when putting in formula later.

Figure B demonstrates subsequent columns:

FIGURE B

Here's a sample formula for a numeric cell in an HTML table.

Here's an important note. Only use currency formats if you're national symbol is the dollar sign ($). Other currency symbols will be displayed correctly in the Domino built Web page, but will likely show up as raw HTML when the sheet is loaded into Excel.

The view template
To add a view template, create a plain Notes form with the name "$$ViewTemplate for YourViewName". Select Embedded View from the Create->Web Element menu to select your view and position it on the page. Then add the top and tail tags, which must be marked as HTML rather than ordinary static text. You can do this either by selecting Treat document contents as HTML in the defaults tab of the form properties, by using the HTML text style, or by putting square brackets around the HTML.