Dialogs - Conversion Options
Open file after conversion
If this option is checked, PDF2XL CLI will automatically open the converted file once it's done converting.
Ask for filename
If this option is checked, PDF2XL CLI will ask for a filename before converting, and save the conversion results in that name.
Write table names
If this option is checked, PDF2XL CLI 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 CLI 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 CLI split overflowing words between the cells.
Use 2007 Format
If this option is checked, PDF2XL CLI 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 CLI 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 CLI 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 CLI 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 CLI will scan your XLStart folder and attempt to load your start-up workbooks.
Note that for security reasons, PDF2XL CLI will only load XLS, XLSX, XLSB and XLSM files from your XLStart folder.
When PDF2XL CLI 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 CLI will handle the conversion when converting into an Excel file that already exists. The options include:
|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.|
This is the meta data that will be put in the converted file.
This is the format that will be set in the Excel sheet for cells marked as having numeric data.
This is the format that will be set in the Excel sheet for cells marked as having currency data.
This is the format that will be set in the Excel sheet for cells marked as having dates.
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.
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).
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.