I have been trying to fill the editable text boxes in a PDF documents from the data read from an excel file. I have done similar work earlier as well however, this time I am having some weird container issue in my editable PDF document.
I have set the correct preferences as well as the accessibility that works well for PDF automation (as per my knowledge from the prior projects) however still everytime I am trying to fetch the selector of those text boxes, the entire document is coming under one container (the blue screen). I have also tried opening the document in the browser thinking it might help me fetch the selectors for the boxes, but no success there too. I am trying to use the Anchor Base activity, so that my bot searches the header first and then in the text box beside that header, it can type the required data using type into activity.
But it will just not work. I could really use some good advice here!!
Hi, thanks for your quick response.
Python script is already installed and I have now installed everything that was pending in the package, but still that activity is not showing up. I guess, I need to install latest version of UiPath 3.0
Hi, I’m getting an error while running this. Screenshot attached for your reference, could u please have a look and let me know what’s going wrong?
I need your help to understand this process.
We want to fetch values from excel and fill the pdf with that data. In the script, you have hard coded the values, how can this be made dynamic so it extracts value from excel and fill multiple pdfs in loop?
Thank you Sanjay for your help.
I have attached the PDF, it is same as shared by Kaustav. I’m unable to upload the Microsoft Excel Macro-enabled worksheet as ‘.xlsm’ format is not supported here. Would you please create macro worksheet/.xlsm file at your end and fill in some dummy data?
Can you let me know how can I get the pdf data using powershell , just give me a small example of how to extract data using powershell and then how can I get that data in uipath variable.