Hi
I am aware that MS released Get data from PDF around August 2020 for Office 365 users in the US and other parts of the world.
So far it is still not available in this part of the world (Ireland).
I have registered to receive updates as they are released.
Is there a way to find this out - I tried post a message to Office support but got no reply.
If anyone has a suggestion, I would appreciate it.
Pat
You can try Power BI Desktop, Power Query is stronger there and has the PDF tools, it's free. (at least, there is a free version)
Thank you Catalin
I am aware of Power BI and its ability to get data from PDF.
I need it in Excel because I am using the output in conjunction with other sheets/queries in Excel.
I have always found it difficult to output or export the information from Power BI
in Power BI, you can easily export to a csv or xlsx, you cannot do that in excel Power Query.
If you install R language support for Power BI , you can write a query to export the result of the query:
Transform->Run R Script
write.csv(dataset,"e:\test.csv")
For export in xlsx, install package openxlsx in R GUI ,
require(openxlsx) write.xlsx(dataset,"e:\test.xlsx")
Or, to export in xlsx and a defined table:
require(openxlsx) write.xlsx(dataset,"e:\test.xlsx", asTable = TRUE)
It's still your best option, unless you want to wait for Microsoft, this can take years...
Hi Catalin
Thank you very much for your assistance and the code.
I will investigate this - it sounds like a good option.
