Notifications
Clear all
Power Query
4
Posts
3
Users
0
Reactions
1,131
Views
Topic starter
Hi, 2 PDF files are attached - I put them in a folder - when I load the files - get data - from the folder
- I can't get the table in the preview and therefore can't convert the files to Excel.
what can we do??
Thank you very much, Leah
Posted : 22/06/2023 1:41 am
Those PDFs contain images, rather than tables. Power Query can't see the data because it's an image. That's why you can't select the cells in the PDF table. It's just one big image.
Posted : 22/06/2023 6:42 am
Topic starter
I understood that.
The problem is that the software downloads the file for me in this way. what can we do???
Posted : 22/06/2023 6:51 am
Lea
Depending on what version of Excel you are running (I am running 365) there is an option on the Data Tab under Get and Transform Data to paste a picture into Excel. Excel will try to convert the picture to an excel sheet. I am not sure if this is available in earlier versions. It often requires some editing. Because I don't have Hebrew linked to my keyboard, I was able to bring it into excel but with many, many corrections required because my version of Excel did not recognize the Hebrew. Good Luck with this.
Alan
Posted : 22/06/2023 3:38 pm
