Hello. I hope you can help me, please. I’m beginning in UIPath and I’m trying to convert the pdf file attached to excel, maintaining the format. I’ve read all topics about this topic, but I’ve can’t solve this.
Only I need transform all items from “Transaction History” to excel file, in a legible view (similar to original PDF).
Actually I’ve can to read the pdf file and convert this to txt file.
But, how can I read this txt file, line by line, and extract the transactions to Excel?
Please, I’ll thank everything tip.
Example.pdf (1.6 MB)
Use export pdf to excel activity
Thanks for your response. Do you refer this: Link ?
Could you help me or guide me, please?
Thanks for your response,Ashwin. Unfortunately, that activity does not available. Could possible to use substrings, IF and arrays for this requirement? Can you guide me?
Thanks. I’ll try. Is possible convert read a TXT file line by line and depending the content (Ex: word, amount, blank space), saved in determined cell in Excel?
Instead of that you can try doing it read pdf with ocr and then use generated build datatable and then use write range
OK. I’ll try. Thanks for your time. Have a great day!