So, Power Query translated this bulleted list into an importable table. When we look at the PDF, we notice that this section wasn’t stored in a true “table” either … this was a bulleted list. When we inspect the Table002, we see this: In other words, Power Query was able to detect the tabs and translate that into the type of tabular table data we want.
When we inspect the PDF file, we note that the sales commission values were not stored in a formal “table” … but were instead created with tabs. We can see Tables and Pages, and when we select one we can view a preview: In the Navigator dialog, we can see a list of items that are recognized by Power Query that we can import. If your Excel version doesn’t support this, you may be able to accomplish it with Power BI instead. At the time of this writing, this data source is available in O365. Depending on your version of Excel, you may not have this command.
Note: this command is found within the Get & Transform group of commands. We then browse to the desired PDF file and click Import. Stepsįirst, we use the Data > Get Data > From File > From PDF command. At the time of this writing, this data source is available in O365. Note: depending on when you are reading this and which version of Excel you are using, you may or may not have the From PDF option. We can accomplish this using Power Query. We would like a way to extract the commission table into Excel, like this: We have a PDF file, perhaps it looks like this: We can use Power Query to retrieve values from PDF files. Historically we have been able to get PDF data into Excel using a standard copy/paste or some third-party tools.
0 kommentar(er)
