Knowledge Base

Welcome to The Carlisle Group's Knowledge Base.

Search or Ask a Question

This is a keyword search that looks for matching articles that contain one or more words specifically by a user in articles’ tags, title and content. Admin writes brief intro content here via admin end. If you are unable to find an answer to your issue, please submit an issue here.

Back to Articles List

Excel Template Report | CAS

Added: 05/11/2016; Last Modified: 05/11/2016; Visits:19,180

Some CAS users wish to insert report output data from CAS into an Excel file with preset formatting, colors, gridlines, text etc.. The Table Report allows this through the use of an Excel Template. 

In your Table Report, you will notice a line where you can set an Excel Template file path.

 

In your Excel File, you will utilize the named Range (Name Box) feature to define which CAS data goes into which Excel Cell(s).

For data to go into one cell only, click on a cell where you want data to go, then go to the name box and create a name, hit Enter.

In the CAS Items of the Table Report, go to the "Summary Stats" tab and make the description match the newly created Named Range.

For a multi-cell range of data, highlight the range in Excel and name the range.

In the CAS Items, go to the Item title on the "Settings" tab and set it to match the newly created Named Range. 

 

Keywords: Excel Template Preformatted pre-formatted links