Output Settings Page

This page is one of the pages in the Settings dialog.

This page allows you to change various output settings for the PDF2XL Enterprise application.

Write table names

If this option is checked, PDF2XL Enterprise will include each table's name in the output (when not using the Convert into multiple sheets option). If this option is cleared, the table name will not be displayed in the output.

Write column names

If this option is checked, PDF2XL Enterprise will include each table's column names in the output (if there are column names for the table). If this option is cleared, the column names will not be converted.

Keep empty rows in output

Checking this option will result in the output including empty rows, i.e., rows in which all the cells are empty. If this option is cleared, such rows will not be sent to the output.

Automatically merge cells with overflow text

Checking this option will result in merging the contents of cells where a word is overflowing from one into the other; if converting to a format that supports merging the actual cells (for example, Excel or Word), the cells themselves will also be merged if that option is set.
Leaving this option clear will make PDF2XL Enterprise split overflowing words between the cells.

Use 2007 Format in Office documents

If Office 2007 is installed, and this option is checked, PDF2XL Enterprise will use the new 2007 file format when saving (and will default to use the .xlsx, .docx or .pptx file extensions). If it is cleared, the file will be saved in the old format (.xls, .doc or .ppt).

Excel and OpenOffice Calc: Keep text attributes

Checking this option will result in keeping the text attributes - size, color, italic, bold, and type - of the original data when converting to Excel or OpenDocument Spreadsheet.
Unchecking this option will result in using the default text attributes.

Excel and OpenOffice Calc: Merge cells to match layout

Checking this option will make PDF2XL Enterprise merge cells in Excel or OpenDocument Spreadsheet if there are merged cells in the table layout.

Excel and OpenOffice Calc: Keep leading zeros in numbers

Checking this option will make sure that Excel and OpenOffice will treat cells that contain numbers with leading zeros as text, even when not marked as text in the Conversion Format.
Note that this does not apply to columns specifically marked as Numeric, but only to columns that have no set format.

Excel: Use XLStart Folder

Normally, PDF2XL Enterprise launches your converted file in Excel without using any of your automatically-loaded workbooks, such as your Personal Macro Workbook (PERSONAL.XLS or PERSONAL.XLSB); this is done because of a limitation in Excel Automation.
If you check this box, then while launching Excel with your converted data, PDF2XL Enterprise will scan your XLStart folder and attempt to load your start-up workbooks.
Note that for security reasons, PDF2XL Enterprise will only load XLS, XLSX, XLSB and XLSM files from your XLStart folder.

Excel: Enable Add-ins

When PDF2XL Enterprise converts data into Excel or Excel File (with the Open File after Conversion option checked), the opened Excel instance may not have all the installed Add-ins enabled.
To make sure they are working in that instance, check this box; note that the conversion may be a little slower when this option is set.

When file already exists

Select the way PDF2XL Enterprise will handle the conversion when converting into an Excel file that already exists.
The options include:

Option	Description
Overwrite	Replace the existing file
Add new sheet(s)	Add one or more new sheets to the workbook and put the newly converted data into them
Add to existing sheet(s)	Append the data to the existing sheets. If the current setting is to convert all the data into a single sheet, then PDF2XL Enterprise will add the data to the first sheet. If the setting is to convert to multiple sheets, then PDF2XL Enterprise will search the file for a sheet with the same name. If found, the new contents for that sheet will be appended to it; if not found, a new sheet will be added.
Ask me what to do	The user will be asked which of the previous three options to use. If the last one (Add to existing sheets) is selected and the output will only be a single table, the user can select to which sheet to add the data, and even where to put it.

Number Format

Sets the format set in the Excel sheet for cells marked as holding numeric data. This value should be in Excel's Cell Format format.

Currency Format

Sets the format set in the Excel sheet for cells marked as holding currency data. This value should be in Excel's Cell Format format.

Date Format

Sets the format set in the Excel sheet for cells marked as holding dates. This value should be in Excel's Cell Format format.

Time Format

Sets the format set in the Excel sheet for cells marked as holding time data. This value should be in Excel's Cell Format format.

Word and Powerpoint: Keep text attributes

Checking this option will result in keeping the text attributes - size, color, italic, bold, and type - of the original data when converting to Word or Powerpoint.

Unchecking this option will result in using Word's default text attributes.

The third part of the page contains viewing format options:

Word and Powerpoint: Merge cells to match layout

Checking this option will make PDF2XL Enterprise merge cells in the Word (or Powerpoint) table if there are merged cells in the table layout.

CSV: Quote all fields

Checking this option will make PDF2XL Enterprise quote all the fields in the CSV output; leaving it clear will quote only fields the contain the separator character or the quote character.

CSV: Quote empty fields

Checking this option will make PDF2XL Enterprise quote any empty fields in the CSV output (i.e., putting "" between separators); leaving it clear will result in writing the separators only.

CSV: Separator

This setting allows you to select the separator used in the conversion into CSV files. The default is Comma, and you can also select Tab from the combo box. If you wish for any other character, select 'Other' from the combo box and type it into the edit box (see, for example, the 'o' as a separator in the image above).

HTML: Excel look

When this box is set, the resulting HTML will look quite similar to Excel 2007. If it is clear, the a default HTML table will be created instead (and the additional row-number column, which is necessary for the Excel-like output, will not be added).
This option is on by default.

HTML: Full HTML File

When this box is set, the resulting file will contain HTML headers and footers. If it is clear, only the table will be in the output file.
This option is on by default.