|
PDF2XL Online Help
Table of Contents User Interface Dialogs Settings Output Settings Page
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 application.
If this option is checked, PDF2XL 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.
If this option is checked, PDF2XL 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.
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.
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 split overflowing words between the cells.
If Office 2007 is installed, and this option is checked, PDF2XL 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).
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.
Checking this option will make PDF2XL merge cells in Excel or OpenDocument Spreadsheet if there are merged cells in the table layout.
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.
Normally, PDF2XL 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 will scan your XLStart folder and attempt to load your start-up workbooks.
Note that for security reasons, PDF2XL will only load XLS, XLSX, XLSB and XLSM files from your XLStart folder.
When PDF2XL 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.
Select the way PDF2XL 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 will add the data to the first sheet.
If the setting is to convert to multiple sheets, then PDF2XL 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. |
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.
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.
Sets the format set in the Excel sheet for cells marked as holding dates. This value should be in Excel's Cell Format 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.
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:
Checking this option will make PDF2XL merge cells in the Word (or Powerpoint) table if there are merged cells in the table layout.
Checking this option will make PDF2XL quote all the fields in the CSV output; leaving it clear will quote only fields the contain the separator character or the quote character.
Checking this option will make PDF2XL 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.
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.
|
