Log In
Register
Home
Excel Expert
Operations Management
Excel Customer Service
December 3, 2016
Offline
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
See Answer
November 8, 2013
Offline
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)
Answers Post
Excel Expert
Operations Management
Excel Customer Service
December 3, 2016
Offline
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
November 8, 2013
Offline
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...
1 Guest(s)
