### 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 choosing Customized Report. The Customized Excel Report dialog box appears.

Customized Excel Report dialog box

This dialog box lets you define 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 will be generated from this file.

Output - This defines the excel sheet's file name and location to which Datapage+ will send the data.

Drop down list - The 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.

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

Column - This specifies the column to which to send the data.

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

- 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.

Large edit box - The large edit box contains all the strings the exporter will use to send data to the output file. You can manually edit existing strings, cut or paste them, or even 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.

Close - This closes the dialog box.