Excel Template File - Revision history

>Johno: /* Main Sheet */

2015-12-03T22:26:59Z

‎Main Sheet

>Johno: /* Main Sheet */

2015-12-03T22:25:15Z

‎Main Sheet

>Johno: /* Export Tag */

2015-12-03T22:20:33Z

‎Export Tag

>Johno: /* Export Tag */

2015-12-03T22:18:42Z

‎Export Tag

>Johno: /* Export Tag */

2015-12-03T22:07:42Z

‎Export Tag

>Johno: /* Main Sheet */

2015-12-03T21:58:10Z

‎Main Sheet

>Johno: /* Main Sheet */

2015-12-03T21:57:06Z

‎Main Sheet

>Johno: /* Select Sheet */

2015-12-03T21:54:12Z

‎Select Sheet

>Johno: /* Export Tag */

2013-06-05T00:04:51Z

‎Export Tag

>Johno: /* Export Tag */

2013-06-04T23:42:00Z

‎Export Tag

@@ Line 45: / Line 45: @@
 |-
 !SheetName || SheetExistsAction || Banding || Selection || Definition || SheetAction
 |-
 |style="padding-left: 10px;"|Member Totals  || || || Clear || MbrTotals || Process
@@ Line 51: / Line 53: @@
 |}
-In the above example, the template must contain a total of 4 sheets: Select, Main, MbrTotals and MbrTotalsByBranch.
+In the above example, the template must contain a total of 5 sheets: Select, Main, Instructions, MbrTotals and MbrTotalsByBranch.  The Instructions sheet is copied without any additional processing.
 == Definition Sheets ==

@@ Line 36: / Line 36: @@
 '''Definition''' (required)
 : The name of a definition sheet.  A sheet with this name '''must exist''' in the current document.  If the definition sheet name is prefixed by a # character, the sheet will be ignored.
 '''Main Sheet Example:'''
@@ Line 41: / Line 44: @@
 {| class="wikitable" style="padding-left: 10px;" stype="border-spacing: 2, 2, 2, 2;"
 |-
-!SheetName || SheetExistsAction || Banding || Selection || Definition
+!SheetName || SheetExistsAction || Banding || Selection || Definition || SheetAction
 |-
-|style="padding-left: 10px;"|Member Totals  || || || Clear || MbrTotals
+|style="padding-left: 10px;"|Member Totals  || || || Clear || MbrTotals || Process
 |-
-|style="padding-left: 10px;"|<band> Mbrs || || MBR_BRANCH_NAME || ||MbrTotalsByBranch
+|style="padding-left: 10px;"|<band> Mbrs || || MBR_BRANCH_NAME || ||MbrTotalsByBranch || Process
 |}

@@ Line 157: / Line 157: @@
 :: Sets the specified Excel Range Name to the cell range containing the exported data.  Range names can include <band> and $(varname).  Blanks are not allowed in a range name and will be removed.
 : If multiple format options are being specified, they should be separated by a comma as follows:
-  <Format>Bold=1, AutoFitColumn=1</Format>
+  <Format>Bold=1, AutoFitColumn=1, RangeName=LNDATA_<Band></Format>

@@ Line 154: / Line 154: @@
 : *AutoFitColumn
 :: When selected (=1) adjusts the width of the column to fit the cell contents - useful for chart images.
 : If multiple format options are being specified, they should be separated by a comma as follows:
   <Format>Bold=1, AutoFitColumn=1</Format>

@@ Line 136: / Line 136: @@
 * '''Format''' (optional)
 : Several formatting parameters can be specified as part of the export tag.  By default, the format from the corresponding cell of the template file is used.  These formatting options are applied after the default settings have been applied.
 : *Bold
 :: When selected (=1) displays text in bold.

@@ Line 29: / Line 29: @@
 '''Banding''' (optional)
-: The name of a banding field.  When a banding field is specified, the definition sheet is re-evaluated for each unique value of the banding field.  Specifying a banding field causes "sheet level" banding and a new sheet will be created for each unique (possible) value.  The banding value can be included in the output sheet name using the syntax: <band>
+: The name of a banding field.  When a banding field is specified, the definition sheet is re-evaluated for each unique value of the banding field.  Specifying a banding field causes "sheet level" banding and a new sheet will be created for each unique (possible) value.  The banding value should be included in the output sheet name using the syntax: <band>
 '''Selection''' (optional)

@@ Line 23: / Line 23: @@
 : * <band> - The current banding value.  Use for file level banding.
 : * <date> - The current date.  This is the actual create date when the file was created.
-: * $(varname) - The value of any [[QlikView Variables|qlikview variable]].
+: * $(varname) - The value of any [[QlikView Variables|qlikview variable]].  Variables can be created by the selection.
 '''SheetExistsAction''' (ignored)

@@ Line 14: / Line 14: @@
 == Select Sheet ==
-This sheet contains local selection definitions used by the current report.  Each selection consists of one or more steps that share the same [[Defining a Selection|selection name]].
+This sheet contains local [[Defining a Selection|selection definitions]] used by the current report.  Each selection consists of one or more steps that share the same selection name.
 == Main Sheet ==

@@ Line 92: / Line 92: @@
 The general form of the export tag is:
-  <Export><ObjectType>QlikView Object ID</ObjectType><Select>...</Select><Dims>...</Dims><Parms>...</Parms></Export>
+  <Export><ObjectType>QlikView Object ID</ObjectType><Select>...</Select><Dims>...</Dims><Parms>...</Parms><Format>...</Format></Export>
 In version 1.5.3 (and higher), in addition to exporting charts and tables (as data) it is possible to export charts as an image.  Exporting the image of Text Boxes is also supported.
@@ Line 123: / Line 123: @@
 : Several chart parameters can be temporarily changed prior to the export:
 : *SuppressHeader
-:: Suppress the chart header.  When selected (=1) no headers will be included in the export.  In this case, chart header values should be supplied in the definition template.
+:: Suppresses the chart header.  When selected (=1) no headers will be included in the export.  In this case, chart header values should be supplied in the definition template.
 :: ''Note: This option is only supported with charts.  It is ignored for straight tables.''
 : *SuppressTotals
-:: Suppress chart totals. When selected (=1) no totals will be included in the export.
+:: Suppresses chart totals. When selected (=1) no totals will be included in the export.
 : *AlwaysFullyExpanded
 :: Valid only for Pivot Tables.  When selected (=1) forces all pivot dimensions to be fully expanded prior to the export.
 : If multiple parms are being specified, they should be separated by a comma as follows:
   <Parms>SuppressHeader=1, AlwaysFullyExpanded=1</Parms>

@@ Line 106: / Line 106: @@
 To export the Image of a '''text box''', use:
   <Export><Text>QlikView Object ID</Text>...</Export>
-: Note this is not the same as using a Text Tag.  This exports a Text Box defined in the QLikView document.
+: ''Note: This is not the same as using a Text Tag.  This exports an actual QlikView Text Box whereas a Text Tag creates a string of text.''
 * '''[[QlikView Object ID|Object ID]]''' (required)
@@ Line 124: / Line 124: @@
 : *SuppressHeader
 :: Suppress the chart header.  When selected (=1) no headers will be included in the export.  In this case, chart header values should be supplied in the definition template.
-:: ''Note: Works only with charts, does not work with straight tables.''
+:: ''Note: This option is only supported with charts.  It is ignored for straight tables.''
 : *SuppressTotals
 :: Suppress chart totals. When selected (=1) no totals will be included in the export.