Excel section properties

Like other kinds of sections, you can create an Excel section by selecting the tab that will contain the section and clicking the Add Section action. You then set the value of the Type property to Excel Section.

After you have set the value of the Type property, the next property you will probably want to set the value of is the Excel (.htm) Document property. The value of the Excel (.htm) Document property is used to determine which form report template will be used to generate the contents of this Excel section.

To select a form report template, click the search icon in the Excel (.htm) Document property. Clicking the X icon causes a panel to pop up over the Properties panel containing a list of the documents in the Document Manager.

To specify which document to use as the form report template, select the document's radio button and then click the OK action on the list.

After you have set the value of the Excel (.htm) Document property, you may want to set the value of some of the other properties.

Common section properties includes information about the following properties in an Excel section: Type, Name, Label, Height, Title Bar Color, Visible, Expand Section, Read Only, Show Title Bar, Style Class, Start Row, Row Span, Start Column, and Col Span.

After you have saved an Excel section for the first time, under the properties is a form section that contains a spreadsheet. Initially the spreadsheet is blank. After you have specified the Excel (.htm) Document, the spreadsheet you are using as a template should appear in place of the blank spreadsheet.