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)

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".

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.

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.

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.

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!