### Exporting Customized Excel Reports

You can export any text data to an existing excel template or empty excel sheet by clicking the Output as EXCEL icon and then select Customized Report. The Customized Excel Report dialog box appears.

Customized Excel Report dialog box

This dialog box defines the data to send to the excel sheet and what cells should accept that data.

Template - This defines the excel template to use. This can be a legitimate template file (.xlt) or it can just be another .xls file that is used as a template. The output excel sheet is then generated from this file.

Output - This defines the excel sheet's file name and location to which DataPage+ sends the data.

Sheet No: - The defines the excel sheet's sheet number to which DataPage+ sends the data.

Parameters - This drop down list contains all the available data fields to export. These fields are identical to the column headings described in the detailed mode of the Feature Monitor tab.

Trace: - Select the desired transaction date and trace field from the list to export the data.

- This arrow creates a string of text in the large edit box that the excel exporter can use to determine where to output the data and what data to send.

For example, suppose you have this string:

Row: 3 - 61; Column:A; FeatVarName

DataPage+ would start with the cell at row 3 at column A and would put in the first feature variable's name. Row 4 in column A would contain the second feature variable's name and so forth until either you have no more feature variables or until the current row reaches row 62.

Row - The From and To boxes in this area allows you to define a range of rows to which to send the data.

Column - The From and To boxes in this area allows you to define a range of columns to which to send the data.

The Row and Column portions of the dialog box work together to ultimately define specific cells to which to send a data field.

Large edit box - The large edit box contains all the strings the exporter use to send data to the output file. You can manually edit existing strings, cut or paste them, or type your own.

Read only - This check box causes the final report to be marked with the read-only protection flag. This means the file cannot be deleted or edited until the read-only protection flag is cleared on the file. You can clear a read-only flag by right-clicking on the file inside Windows Explorer, selecting Properties and then clearing the Read-only check box.

Save - This saves your current export settings as a text file. You can load them later.

Load - This loads you saved export settings.

OK - This performs the export, sending data to the defined .xls output file; it then closes the dialog box.

Cancel - This closes the dialog box.