If an acrobat page is copied and pasted to Word or XL it is pasted as picture. Can I convert the picture as data and use the XL cell formats to process the data converted from the picture.
My Product Information:
Acrobat Standard 4, Windows
If I understand your question correctly, you want to have the content of the pdf exported to use in Excel, correct?
First, check to see if the text is renderable, meaning it is already text and graphics on the page. Click the page with the Select tool. If you see a flashing cursor, the text is already present.
If not, follow these steps:
1. Choose Document > OCR Text Recognition > Recognize Text Using OCR to open the dialog box.2. You can use the default settings, and click OK to close the dialog box and process the file.
3. Now try again with the Select tool. In a table, you'll see the Select tool's cursor change to crosshairs with a small image of a table.
4. Click when you see that cursor display. All the text in the table will now be selected, and a small icon will popup on the page.
5. Click the icon to open a menu and choose Open Table in Spreadsheet.
6. The content is pasted into a cell structure in Excel.
You can only use this command in Acrobat 8 Professional. Acrobat 7 didn't have the capability to export directly into a spreadsheet. In that case, you can copy the content as a table, paste it into Word, and then export the table into Excel.
donna.
A prolific author and writer of many Acrobat books, as well as books on graphic and Web design software.
Donna lives on a lakeshore in central Canada, where all manner of wildlife from muskrats to coyotes come to call.
If I understand your question correctly, you want to have the content of the pdf exported to use in Excel, correct?
First, check to see if the text is renderable, meaning it is already text and graphics on the page. Click the page with the Select tool. If you see a flashing cursor, the text is already present.
If not, follow these steps:
1. Choose Document > OCR Text Recognition > Recognize Text Using OCR to open the dialog box.2. You can use the default settings, and click OK to close the dialog box and process the file.
3. Now try again with the Select tool. In a table, you'll see the Select tool's cursor change to crosshairs with a small image of a table.
4. Click when you see that cursor display. All the text in the table will now be selected, and a small icon will popup on the page.
5. Click the icon to open a menu and choose Open Table in Spreadsheet.
6. The content is pasted into a cell structure in Excel.
You can only use this command in Acrobat 8 Professional. Acrobat 7 didn't have the capability to export directly into a spreadsheet. In that case, you can copy the content as a table, paste it into Word, and then export the table into Excel.
donna.
A prolific author and writer of many Acrobat books, as well as books on graphic and Web design software.
Donna lives on a lakeshore in central Canada, where all manner of wildlife from muskrats to coyotes come to call.