Using Sheet Component in Visualforce

The created sheet can be displayed as a component in any Visualforce page. Deployed components can also control their behavior from Visualforce pages via scripts.

To place a Sheet component on a Visualforce page, follow these steps:

1. Prepare a Visualforce page and add SheetView component as shown below.

<apex:page>
  // ...
  <msmxSheet:SheetView
    id="(Component ID)"
    bookId="(Book ID)"
    sheetId="(Sheet ID)"
    width="100%"
    height="400px"
  />
</apex:page>

Attributes that can be specified for the SheetView component are as follows.

• id - Visualforce component ID to display

• bookId - ID of the book to display. The value of book ID can be referred to from sheet setting. (required)

• sheetId - ID of the sheet to display. The sheet ID value can be referred to from the sheet setting. If not specified, all the sheets included in the book are displayed in tabs.

• recordId - ID of the context record. This ID value is used as the "Context Record ID" of the ID filter.

• width - Width of the component. You can specify it by pixel or percent.

• height - Height of the component. You can specify it by pixel or percent.