This panel appears in the PDF Converter Assistant if:
-
Spreadsheet is selected in the drop-down list of the Mode tool, or
-
Spreadsheet is selected in the Options menu.
The following options can be chosen in this panel: Create Sheet, Retain Hyperlinks, Retain Headers and Footers, Processing Options and Handling Graphics.
The only available output format for spreadsheets is Microsoft Excel.
Create Sheet
This controls how to arrange sheets in an Excel file. The selection box provides two choices:
-
Per Table
One table per sheet will appear in the Excel file.
Each detected table is converted and placed in a separate worksheet. All content not detected as a table is placed in a separate worksheet at the end of the workbook, and it is named Overview. This Overview sheet contains hyperlinks leading to the relevant worksheet tables.
When this option is selected, the header/footer selection is disabled, because the generated output file does not follow the pages of the input file.
When to use this?
If there are two or more tables on a page and the table structures are different: the tables contain different number of columns or their column width is different. Note: If you choose the other option (Create Sheet Per Page) for tables with different structures, the column width cannot be retained.
If formatting of non-table text is less important. Note: Some formatting - such as multi-column structure, text centering - will not be retained. A whole line will be put in the first cell.
-
Per Page
One page per sheet will appear in the Excel file.
When to use this?
If a page contains only one table, or the tables on a page have nearly the same structure, i.e. the number of columns and the column width are nearly the same
If you want to keep textual information together with a table on a sheet.
For details on all the other options see Standard Document.
Note
The processing settings are stored separately for each processing mode.
For advice on choosing the best mode for your needs, see Choosing the Processing Mode.
