|
| DisposableFirstRow | | Developers can specify disposable regions to avoid writing complicated formulas to dynamically update formulas, charts, pivot tables and other Excel spreadsheet objects. A disposable row is equivalent to a dummy row of data - the row is removed from the final output after all datarows are added.
Specify the first row for the disposable region that does not overlap with any row from the corresponding pattern block region. |
| DisposableLastRow | | Developers can specify disposable regions to avoid writing complicated formulas to dynamically update formulas, charts, pivot tables and other Excel spreadsheet objects. A disposable row is equivalent to a dummy row of data - the row is removed from the final output after all datarows are added.
Specify the last row for the disposable region that does not overlap with any row from the corresponding pattern block region. |
| FillMode | | Set this attribute to specify template is filled with data. The two modes are "Insert" and "Overwrite".
Insert Mode (default):
The server will insert new rows into the Excel template for each row of data returned by the data layer. The number of rows inserted is equal to the total number of rows in the pattern block range.
Overwrite Mode:
The server will write data to existing rows in the Excel template. Data and formatting that exists in the template may get overwritten using this mode.
NOTE: Use caution when mixing fill modes for pattern blocks defined in a single Template definition. Avoid undesirable results by choosing one fill mode for all pattern blocks. |
| FirstRow | | (Required) Specify the first row for this pattern block. The row number must either correspond to a row from the Excel spreadsheet or a row from the parent pattern block. |
| ID | | (Required) The ID attribute is a pervasive attribute that uniquely identifies an element within a definition file. The ID needs to be a unique value within the definition. |
| LastRow | | (Required) Specify the last row for this pattern block. The last row must either correspond to a row from the Excel spreadsheet or a row from the parent pattern block.
Note: Make the First Row and Last Row equal to specify a one row block. |
| Worksheet | | Type the name of the worksheet to use for this PatternBlock, or select the worksheet name from the Suggestions Panel.
Note: The default worksheet is the first worksheet that appears in the workbook. |