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.
<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