How to convert pdf file data to .xlsx

[Gokul001 (Gokul Balaji)]

Hi @bhanu.priya2

Refer to this Thread for more info

UiPath-PDF tables to Excel Automation | ISID's Main Website

Extracting PDF data into Excel

Check this example I set up for a POC, it extracts a PDF table into a DataTable. There is a ‘tableExtractRegex’ regex which should extracts the table part and a ‘rowSplitRegex’ to extract the rows. ReadConfirmationPDF.xaml (7.1 KB) TableExtractor.xaml (14.6 KB) CSVToDataTable.xaml (5.2 KB) Auftragsbestaetigung-Kramer-3pos.pdf (195.2 KB)

How to convert Pdf file to excel and save in one location?

Posting this here also, since I solved this for him in private for anyone else seeking ideas on PDF extraction. This almost made my head explode, but I got it working. I’m not entirely sure if it meets all your requirements, but it formulates the text to a table with all the headers and places the check number, date, and amount in the filename. Much of it is driven by vb.net lambda (ie .Select, .Where, .Split). I did my best to create it as dynamically as possible, but with limited testing t…

Regards
Gokul