PDF file to Excel

Help
, , ,
1

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)

2

Hi @ALEX_HERNAN_GONZALEZ

Use export pdf to excel activity

Thanks
Ashwin.S

3

Thanks for your response. Do you refer this: Link ?
Could you help me or guide me, please?

4

Hi @ALEX_HERNAN_GONZALEZ

Yes

Thanks
Ashwin.S

5

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?

6

Hi @ALEX_HERNAN_GONZALEZ

Try this

Thanks
Ashwin S

1 Like
7

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?

8

Hi @ALEX_HERNAN_GONZALEZ
Instead of that you can try doing it read pdf with ocr and then use generated build datatable and then use write range

Thanks
Ashwin S

9

OK. I’ll try. Thanks for your time. Have a great day! :slightly_smiling_face: