background image

33

Converting Tables to Spreadsheets

This conversion can be used for PDF files containing partly or mainly tables or 
spreadsheets. Each detected table is converted and placed in a separate 
worksheet inside Microsoft Excel file (extension XLS). All content not detected as 
a table is placed in a separate worksheet at the end and it is named Overview. 
This Overview sheet contains hyperlinks leading to the relevant worksheet tables.

The following diagram summarizes the two ways you can convert tables. The 
example is a 3-page PDF file shown vertically on the left. It contains text, a title, a 
graphic and two tables. The top row shows the outcome when it is converted as a 
document. The bottom row shows the outcome in Excel when it is converted as a 
spreadsheet.

Summary of Contents for PDF CONVERTER STANDARD 3 - GUIDE

Page 1: ...ScanSoft PDF Converter 3 Online Help...

Page 2: ...tly from these applications edit them and save them in the appropriate file type To learn more about ScanSoft s office productivity and speech recognition solutions please visit www scansoft com Copyr...

Page 3: ...two main dialog boxes PDF Converter Assistant This lets you start conversions giving you a preview of the PDF file to be converted and providing control over the process PDF Converter Settings This ca...

Page 4: ...get Help This product is supplied with a printed Quick Reference Guide giving mainly installation and activation guidance This guide is available in a PDF file on the CD and after installation in the...

Page 5: ...lled High Color in Windows 2000 and Medium Color in XP and 800 x 600 pixel resolution Windows compatible pointing device CD ROM drive for installation Internet connection for activation de activation...

Page 6: ...o keep the serial number in a safe place it is fully checked only during product activation and is also needed for any re installations The installer offers a default location for the program Accept i...

Page 7: ...g version 3 Keep the serial number of the earlier version to retain the option of installing it on a different computer Note The user performing installation or un installation should have Administrat...

Page 8: ...t Microsoft Excel and Rich Text RTF An extended range of PDF files can be successfully converted Built in OCR helps in converting image only files into textual documents without the requirement to hav...

Page 9: ...onversions and then choose Microsoft Word WordPerfect or Rich Text Format under Target Select Form for PDF files containing forms The only target application is Microsoft Word is this case Select Spre...

Page 10: ...select a file and click Open A preview of the first PDF page appears in the Assistant 3 Decide the output file format first Document or Form 4 Use the navigation buttons to view other pages 5 Accept o...

Page 11: ...ft Outlook 1 Select a message that has a PDF attachment The PDF Converter button will become active 2 Click the PDF Converter button in the Outlook toolbar or in the message toolbar A dialog box appea...

Page 12: ...PDF file name with full path and extension or browse to select a file and click Open A preview of the first PDF page appears in the Preview panel of the PDF Converter Assistant 3 Use the navigation b...

Page 13: ...d file will be displayed in the target application when conversion is finished 5 Set a page range if desired See Preview panel 6 Specify settings if required in the Document Options panel 7 Click Open...

Page 14: ...ting conversions from Microsoft Outlook Windows Explorer The PDF Converter Assistant offers the following panels Preview This shows a preview of the PDF and lets you define the conversion type Documen...

Page 15: ...Preview panel PDF Converter Settings is selected from the Microsoft Excel Tools menu It lets you decide how image only pages color conversion and resolution for graphic elements should be handled and...

Page 16: ...s documents For more guidance see Converting Forms Converting Documents and Converting Tables to Spreadsheets Preview Once an input PDF file name is chosen a preview of its first page appears in the P...

Page 17: ...instructions Example Pages to be converted 2 Page 2 only 3 7 Pages 3 4 5 6 and 7 8 4 Pages 8 7 6 5 and 4 5 Pages 1 2 3 4 and 5 11 All pages from 11 to end of file 2 4 6 9 7 Pages 2 3 4 6 9 8 7 3 15 1...

Page 18: ...izable characters are represented by a reject character which is a tilde by default You can change this reject character if you wish Skip Image only pages will be skipped When pages are skipped you wi...

Page 19: ...d colored backgrounds will also be transferred De select this to have all text transferred as black and colored or shaded backgrounds converted to white De selecting this setting does not prevent the...

Page 20: ...encoded pages Most PDF files use standard character encoding If not this is the case enable this option to extract text using OCR Language selection made in the OCR Settings dialog box will be used C...

Page 21: ...as in the PDF If the PDF file has images with a higher value than you specify they will be reduced to the given value When the PDF has large images or it has many image only pages and you requested th...

Page 22: ...at the end of the list only if the PDF file really contains text in more than one language This setting enables all eleven listed languages For better accuracy de select Multi lingual when it is no l...

Page 23: ...Conversion Non standard encoded pages and Resolution for Graphic Elements For details see the Document Options panel Settings for each processing type are stored separately to give you better control...

Page 24: ...provided Other buttons give access to the ScanSoft web site containing knowledge bases and user forums for different products to Web Update reports and to the Quick Reference Guide Press the Help butt...

Page 25: ...ed settings Starting from Excel only Spreadsheet Options are displayed Starting from WordPerfect only Document Options can be set The PDF Converter Settings dialog box may present the following panels...

Page 26: ...s your work when you have a repeating task with many PDF files coming from a known source and you have prior knowledge of the PDF content If you do not need a preview of the file want to convert all i...

Page 27: ...ernet Explorer Enable this to add a PDF Converter item to the shortcut menu that appears when you right click on a link to a PDF file in a web page or to an HTML page hosting a PDF file The referenced...

Page 28: ...t a big document we publish some indicative speed data The average time for converting a standard sized page is Black and white 2 5 3 0 seconds Grayscale 3 2 3 8 seconds Color page 5 5 7 0 seconds The...

Page 29: ...Files Sample document The program is supplied with a sample document located on the program CD and also copied to the local computer usually to the folder My documents This location may vary dependin...

Page 30: ...the Form Options panel If you want to do one click processing without the Assistant open the File Open Settings panel in the PDF Converter Settings dialog box and choose Automatically Convert as Forms...

Page 31: ...ttings panel in the PDF Converter Settings dialog box and choose Automatically Convert as Documents When to use True Page conversion When transfer of the textual information in the form is just as imp...

Page 32: ...for conversion quality Process it using both of the above methods to see the difference between them Note The output Word document contains static form elements You can activate them in Word to create...

Page 33: ...is placed in a separate worksheet at the end and it is named Overview This Overview sheet contains hyperlinks leading to the relevant worksheet tables The following diagram summarizes the two ways you...

Page 34: ...rd as Target 3 Click browse for your PDF file to be converted select it and click Open 4 Select Page Range and type in 1 2 in our example 5 Check the output file name under Save as If your PDF file is...

Page 35: ...16 Change the output file name under Save as to avoid overwriting the file created under point 7 E g sample1 doc 17 Click Form Options and make changes if necessary 18 Click Convert The converted file...

Page 36: ...o ways of having this done Flowing Columns and True Page The latter places all page elements in text boxes or frames The former removes boxes when possible and uses column and paragraph breaks and mar...

Page 37: ...t Word Help If you choose Text in Boxes formatting text blocks will also be placed in boxes If the end of a paragraph is not visible scroll down in the text box to see it Re size the text box or selec...

Page 38: ...how in the View menu to make the end of paragraphs visible 2 Select Tools Settings Display Symbols and check that symbols you want displayed on screen are enabled If you need to restore the original l...

Page 39: ...dify it When starting from inside a target application the saved file is displayed When starting from the Windows Start menu display is optional If you open a PDF file in Microsoft Word with File Open...

Page 40: ...an result from scanning a paper document opening an electronic image file or a PDF file Images do not have editable text characters they have many tiny dots pixels that together form character shapes...

Page 41: ...editing o Voice readback facility o And much more Scan new pages into the converted document Add new pages from fax or image files Save to other formats including OmniPage Pro s internal format for do...

Page 42: ...t text attributes graphics and tables are retained 4 No formatting Text is decolumnized and rendered as plain text Graphics and tables are retained but not in their original locations This option is c...

Page 43: ...yed A text layer was detected for this page This page is image only Navigate through all pages in the document If you see both icons or if the image only icon displays for all pages then use the Docum...

Page 44: ...assword is sufficient Please supply the open password or the permissions password The file will be converted Permissions password is necessary Please supply the permissions password to have the file c...

Page 45: ...n English Polish Portuguese Standard Portuguese Brazilian Provencal Quechua Rhaetic Romanian Romany Ruanda Rundi Sami Samoan Sardinian Serbian Shona Sioux Slovak Slovenian Somali Sorbian Wend Sotho Sp...

Page 46: ...lect ScanSoft PDF Converter 3 0 3 Click Remove to uninstall the program or Change to auto repair it A de activation step is performed at the start of uninstallation allowing you to reinstall the progr...

Page 47: ...Document Options panel If the Add to Document as Image option is selected all the pages without a text layer in the PDF file will be put as images in the converted file Remember in the Preview panel y...

Page 48: ...G Group s software copyright 1991 1995 Thomas G Lane This software is based in part on the work of the Independent JPEG Group The software is based in part on the work of Colosseum Builders Inc The so...

Page 49: ...Inc Words are checked against the 80 307 90 406 105 785 115 784 word Proximity Collins Linguibases Trademarks Productivity Without Boundaries ScanSoft the ScanSoft logo OmniPage Pro True Page and Logi...

Page 50: ...TIFICATIONS The Software contains a component that will automatically activate your Internet browser and attempt to initiate a connection through the Internet to a website maintained by ScanSoft that...

Page 51: ...American Arbitration Association then in effect with the losing party paying all costs of arbitration This Agreement shall not be governed by the United Nations Convention on Contracts for the Interna...

Page 52: ...52...

Reviews: