• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Extracting certain data from the electronic tax website

H

Hany ali

Active Member
Hello my Dear,I Want Your Help to Extract Certin Data from this Site
https://invoicing.eta.gov.eg/documents
to excel Sheet According to the attachments .The data to be extracted from the invoices are the data colored in yellow and blue in this screen
and invoice in Pdf form
thanks alot with my Best Regardes
 

Attachments

  • Screenshot 2023-08-23 213815.png
    Screenshot 2023-08-23 213815.png
    239.7 KB · Views: 17
  • invoice.pdf
    50.4 KB · Views: 7
  • Suppliers Invoices.xlsx
    9.9 KB · Views: 7
See Private Conversation.
In the attached is a Power Query query which extracts information from a single pdf file saved locally.
Currently, it won't work on your system without a change to tell it where to find the folder/file on your system.
Right-click on the table at cell B5 and choose Table, then Edit query…
On the right hand side of the Power Query Editor which pops up, in the APPLIED STEPS area, click on the first step Source, and you will see something like:

1692962150798.png

Click on the Edit Settings button, then click on the Browse… button to locate your pdf file and then click on Import, then OK.
Then click on the Home tab, then Close & Load.

1692963680248.png

Then you should be back on the Excel sheet, and if the table does not update itself automatically, right-click on it and choose Refresh.
 

Attachments

  • Chandoo54682Suppliers Invoices.xlsx
    18.6 KB · Views: 4
thanks alot for your reply ,i will try to make it because i don't want to extract Data From Pdf but form Certain Site
 
So you must understand webpage code - html - then how to log on a website and how to scrape it under VBA​
like you can find on Web in forums, blogs, …​
​
 
hello ..No way to extract these data by Excel from this Site ?!
 

Attachments

  • Suppliers Invoicesss.xlsx
    8.9 KB · Views: 3
You must log in or register to reply here.
Back
Top