Page Comparison

By the end of this section you will be able to associate a Microsoft Excel template with a view.

...

We have included a copy of this template in train.zip. To see what the template looks like:

1. Download train.zip and extract the contents to a folder on your computer (indicated as <path> in the following instructions).
2. Open <path>\train\excelTemplates\debtOverview.xls. The file opens with one worksheet, called Formatted Data, which shows how the data will be formatted.
3. If the file is protected, enable editing.
4. There is a another, hidden worksheet. To view it, right-click on the Formatted Data worksheet tab and select Unhide.

...

1. Open the model Dashboards and Forms 01-08: Views, filters and dashboards in the workspace.

   Expand
   title How?
   Insert excerpt _open_model _open_model nopanel true

   
   

2. Open the properties settings tab for the stream view called Overall Debt Levels. To do this:

   1. First open the properties settings for the  Overall Debt Levels stream. In the model, click on the stream icon.

   2. Then, in the stream properties settings → Views section, double-click on the view called Overall Debt Levels.
3. Add an Excel template to the stream view. In properties settings → Advanced section → Excel Template box, enter debtOverview.xls, then click 

   Insert excerpt
   _finish _finish nopanel true

   .

...