Dialogs - Conversion Options

Open file after conversion

If this option is checked, PDF2XL Enterprise will automatically open the converted file once it's done converting.

Ask for filename

If this option is checked, PDF2XL Enterprise will ask for a filename before converting, and save the conversion results in that name.

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 unchecked, 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 unchecked, the column names will not be converted.

Keep empty rows

If this option is checked, the output will include empty rows (rows where all cells are empty). If unchecked, such rows will be omitted from the output.

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 unchecked will make PDF2XL Enterprise split overflowing words between the cells.

Use 2007 Format

If this option is checked, PDF2XL Enterprise will use the MS Office 2007 file format when saving (and will use the .xlsx, .docx or .pptx file extensions). If unchecked, the file will be saved in the old format (.xls, .doc or .ppt).
This option requires MS Office 2007 to be installed on the computer.

Keep text attributes

If this option is checked, PDF2XL Enterprise will keep the text attributes - size, color, italic, bold, and type - of the original data when converting to Excel or OpenDocument Spreadsheet. If unchecked, the default text attributes will be used.

Merge cells to match layout

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

Keep leading zeros

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.

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.

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 might not have all the installed Add-ins enabled. Checking this option will ensure that they will work in that instance.
Checking this option might make the conversion slightly slower.

When File Exists

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

OptionDescription
OverwriteReplace 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 doThe 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.

File Metadata

This is the meta data that will be put in the converted file.

Cell Format

Number Format
This is the format that will be set in the Excel sheet for cells marked as having numeric data.

Currency Format
This is the format that will be set in the Excel sheet for cells marked as having currency data.

Date Format
This is the format that will be set in the Excel sheet for cells marked as having dates.

Time Format
This is the format that will be set in the Excel sheet for cells marked as having time data.

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 that contain the separator character or the quote character.

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.

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

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.

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.