Home>Article>Topics> How to export tables in pdf

How to export tables in pdf

藏色散人
藏色散人 Original
2020-03-24 09:50:14 32088browse

How to export tables in pdf

How to export tables in pdf?

Quickly copy the table data in the PDF to Excel and sort it into columns

Open the PDF file that needs to be copied and find the "Select Text" at the top of the page button (the position of this button may be different in different PDF readers, just look carefully)

How to export tables in pdf

Select all the data that needs to be copied (the selected data will be There is a layer of blue background), right-click the mouse and select "Copy". Open Excel 2003, right-click on a blank cell and click "Paste".

How to export tables in pdf

At this time, the data just copied has been pasted. But you will find that all data has only one column, not multiple columns like in PDF. At this time, you need to click a "Paste Options" icon below the cell.

How to export tables in pdf

The text import wizard pops up. We observe the data in the previous example. The data in each column in the same row is separated by spaces. Then we select the delimiter symbol. After the next step, select "Space". You can see the data separation in the data preview below. If you are satisfied, click Next.

How to export tables in pdf

Here you can choose the format of each column to be imported. Generally, it is left unchanged by default. Click "Finish". At this time you can see that the data in each row has been separated.

How to export tables in pdf

Notes

You need to choose different separation methods according to the original data of the table in the PDF

The above is the detailed content of How to export tables in pdf. For more information, please follow other related articles on the PHP Chinese website!

Statement:
The content of this article is voluntarily contributed by netizens, and the copyright belongs to the original author. This site does not assume corresponding legal responsibility. If you find any content suspected of plagiarism or infringement, please contact admin@php.cn