The "hide" tags are a group of tags that hide parts of a workbook. All hide tags must contain a body. There are tags for hiding columns, hiding rows, and hiding an entire sheet.
The jt:hideCols tag will hide (or show) all columns in the tag's body.
In this example, the cell B1 contains the text <hideCols test="true">. This tag will affect columns B-E. Column D is hidden. The cell H1 contains the text <jt:hideCols test="false">. This tag will affect columns H-K. Column J is hidden.
When transformed, columns B-E are hidden. Column D, which was already hidden in the template, remains hidden. Columns H-K are visible. Column J, which was hidden in the template, is now visible.
The jt:hideRows tag will hide (or show) all rows in the tag's body.
In this example, the cell A2 contains the text <jt:hideRows test="true">. This tag will affect rows 2-5. Row 4 is hidden. The cell A8 contains the text <jt:hideRows test="false">. This tag will affect rows 8-11. Row 10 is hidden.
When transformed, rows 2-5 are hidden. Row 4, which was already hidden in the template, remains hidden. Rows 8-11 are visible. Column 10, which was hidden in the template, is now visible.
The jt:hideSheet tag will hide (or show) the entire sheet on which the tag is found.
In this example, the cell B2 in the sheet "HideSheet" contains the text <jt:hideSheet test="true">. This tag will affect the entire sheet. There is a sheet hidden in the template workbook called "ShowSheet". In that sheet, the cell B2 contains the text <jt:hideSheet test="false">. This tag will affect the entire sheet.
When transformed, the entire sheet "HideSheet" is hidden. The previously hidden sheet, "ShowSheet", is now visible.
