Report Actions › Export Reports to Spreadsheets › Set Up the Export Options

Set Up the Export Options

You can choose one of the following export methods, and then specify the additional options.

Export Method:

Export method determines how your report data is split into columns. Additionally, your second step in the wizard can be either the Setup Column Widths or Setup Column Delimiters, depending on your choice. The following options are available:

• Fixed Width
• Delimited

By default, Fixed Width is selected.

Fixed width splits the report into columns of certain sizes. For example, you might have a column that is 20 characters wide, and another column which is 35 characters wide.

The Delimited option splits the report into columns using a special character to determine where the column break must be applied. For example, your report has several columns separated by commas, like in a .csv (comma separated values) file, then you could split the report into columns based on the comma character.

Proceed to the next step to actually set up the columns.

You can set up the following additional options for both export methods, as required:

Include only lines containing

Displays only lines that have the specified string. For example, if you select this check box and specify data set, only lines that have the word data set are included in the spreadsheet (all other lines are excluded).

Note: Only the exact string is matched and selected for export.

In the above example, only lines containing the string data set are selected for export; lines containing either data or set are not matched and not selected for export.

Exclude lines containing

Excludes lines that have the specified string. For example, if you select this check box and specify page, every line that has the word page is excluded and all other lines are included in the spreadsheet.

Exclude blank lines

Excludes blank rows (lines with no data) from the output spreadsheet.

Exclude Lines from the top of each page

Excludes the number of specified lines from the top of each page. For example, if you select this check box and chose 5, then five lines from the top of each page of the report is excluded from the export.

Default: 0

Exclude Lines from the bottom of each page

Excludes the number of specified lines from the bottom of each page. For example, if you select this check box and chose 5, then five lines from the bottom of each page of the report is excluded from the export.

Default: 0

The additional options are set up.