Hi,
I want to use this feature of MS excel. Is there any way to use this in UiPath via any activity or by hitting an endpoint that returns datatable? Waiting for the help! Thanks.
Hello @Umer_Shahid
You can use the Excel file as a template with the Power query and place it in a specific location.
The Excel Get data from the specific PDF in a specific location. Keep the location Constant.
Each time Move the PDF file to a specific location and specific name.
Copy the template file from the template folder and place it in the Work folder then refresh the Excel file. The data will append to it. Later you can use the excel file in your process.
1 Like
Can you provide me with the power query to extract data from pdf?
Anil_G
Yoichi
Chirag_Shetty_Divakar
supermanPunch
fernando_zuluaga
Pavanraj_Shetty
Mohammad_Irfan
Muhammed_Sahil
Gvivek9889
mohan_sai365