vurwo.blogg.se

'loop through every cell in the selected range For i = 0 To - 1 'Set the variable of the number of columns in the table The VBA code below which will cycle through the selected data and recreate a table layout.ĭim NoOfColumns As Integer Dim TargetRow As Integer Dim TargetCol As Integer Dim i As Integer 'Set the initial values for the variables of where to place the table If the paste into Excel is just a list of values in one column we can turn to VBA for a bit of help. It may not be perfect, but it’s still closer than what you had before. Or maybe, which is more likely, you have a table which requires a bit of tweaking.

You may now have a perfect data table in Excel. However, Word is actually better at dealing with PDF tables. Here is our example PDF file: Copy table from PDF to Excel via WordĮxcel is a software program which is designed to work with tables, whilst Word is designed to work with text. One of these should work, providing reasonable results and saving you time.

I would love to offer you the perfect solution to get the PDF data table into Excel, however I don’t believe there is one. If the paste displays as a picture, then as far as I know, you will need to resort to third-party software which contains OCR. If the paste is either a list of values or a continuous text string, then there are some possible workarounds. In my experience the pasted data will show as one of the following: The pasted information will be displayed in Excel differently based on how the PDF was created.