Sheet Applet

The Sheet class defines Sheet objects, which store and perform calculations on data.

By setting HTML parameters or calling API properties and methods, you can manipulate the look and behavior of your Sheet objects. For example, you can configure your spreadsheet to show vertical and horizontal scroll bars. You can also perform various tasks programmatically, such as inserting and deleting rows, creating range names, copying ranges of data, and sorting data.

Creating instances of Sheet objects

To create an instance of a Sheet object, embed an Applet tag in your HTML file as follows:

<APPLET
CODE="lotus.sheet.Sheet"
NAME="MySheet"
CODEBASE="../.."
ARCHIVE="jars/devpack_sheet_app.jar"
WIDTH=500 HEIGHT=450>
<PARAM NAME="cabinets" VALUE="cabs/devpack_sheet_app.cab">
</APPLET>

Once you've created a Sheet object, you can set PARAM tags to change the look of the Sheet. You can also use JavaScript to obtain a reference to the Sheet object and manipulate it using the Sheet API properties and methods.

Using JavaScript to obtain a reference to a Sheet object

You can obtain a reference to an existing Sheet instance using JavaScript code as follows:

First, instantiate the Sheet object:
<APPLET CODE="lotus.sheet.Sheet" NAME="MySheet" . . .> </APPLET>

Then, obtain a reference to the Sheet instance using JavaScript code:

var sheetApplet = document.MySheet

Information on HTML tags and Sheet

Sheet Parameters
Embedding and Configuring Applets


Information on the Sheet API

Sheet Object Model
Sheet API


Example

Charting sheet data example