Inserting a Sheet applet
The following HTML code shows how to insert the Sheet applet into the application Web page.
<APPLET NAME="shoeSheet" CODEBASE="..\..\.." CODE="lotus.sheet.Sheet" WIDTH=400 HEIGHT=350>
<PARAM NAME="filename" VALUE="PQueryTemplate.html">
<PARAM NAME="RowHeadingsVisible" VALUE="false">
<PARAM NAME="ColumnHeadingsVisible" VALUE="false">
<PARAM NAME="HorizontalScrollBarVisible" VALUE="true">
<PARAM NAME="VerticalScrollBarVisible" VALUE="true">
<PARAM NAME="EditLineVisible" VALUE="false">
<PARAM NAME="StatusLineVisible" VALUE="false">
</APPLET>
Within the APPLET tag, the various attributes do the following:
- NAME assigns a reference name to the applet so that you can refer to it in your code.
- CODEBASE specifies the base URL of the applet. That is, the directory or folder that contains the applet's code. If this attribute is not specified, then the document's URL is used.
- CODE gives the name of the file that contains the applet's compiled Applet subclass. This file is relative to the base URL of the applet. It cannot be absolute.
- WIDTH and HEIGHT define the size of the applet's display region in the HTML document. This is measured in pixels.
Each PARAM tag for the Sheet applet lets you set specific applet configuration options. The option is specified by the NAME attribute and the option value is specified with the VALUE attribute.
- "filename" lets you specify the filename of a spreadsheet template that will contain all range names, formats, and formulas defined for presenting the results of the database query.
- "ColumnHeadingsVisible" set to a "false" value disables column headers.
- "RowHeadingsVisible" set to a "false" value disables row headers.
- "HorizontalScrollBarVisible" set to a "true" value enables the sheet horizontal scroll bar.
- "VerticalScrollBarVisible" set to a "true" value enables the sheet vertical scroll bar.
- "EditLineVisible" set to a "false" value disables the sheet edit line.
- "StatusLineVisible" set to a "false" value disables the sheet status line.