How to convert pdf file data to .xlsx

[bhanu.priya2 (Bhanu Priya)]

Hi All,

Kindly fine the below input file

Above file is my pdf file and i want same data to be extracted with .xlsx… i tried using read pdf and attach window but is is not working….manually if we click on file which is left top corner then click on save as .xlsx it is working fine…i want output same as below

please help me

[gabrielribas4 (Gabriel Ribas)]

Hey @bhanu.priya2 !! Can you send a sample pdf, please? Thank you!

[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

[bhanu.priya2 (Bhanu Priya)]

Form 11feb18.pdf (72.2 KB)
Hi, Thanks for your reply please check the above attached pdf…

[bhanu.priya2 (Bhanu Priya)]

Hi Thanks for your reply, but here in my case I just don’t want to extract table…I want to extract the
complete data as same as in pdf into excel sheet as shown below.

please help

[Gokul001 (Gokul Balaji)]

Hi @bhanu.priya2

You can try with Generated Data Table activity

Regards
Gokul

[THIRU_NANI (NaNi)]

Hi!

Use this below component to achieve your requirement.

Feat Systems - PDF to Excel - RPA Component | UiPath Marketplace

Package: FestSystems.PDFtoExcel.Activities

Regards,
NaNi

[bhanu.priya2 (Bhanu Priya)]

Hi,

Okay, but how do i write into excel ?

[THIRU_NANI (NaNi)]

Hi!

No need to give any value for the ouput, file will store automatically in the same path with the same name with .xlsx extension.

E.g. PDF file path D:\Pdf File\Demo.pdf

After conversion from pdf to excel, excel file will store in the same path or directory as,

D:\PDF File\Demo.xlsx

What you’ve to do is just Run the workflow.

If you’re converting only tabular data from pdf to excel, enter pdf input path into pdf input box and enter false in Tabular input box and execute the bot, after execution output excel file will be open automatically without any human action and you can find the excel output file in the directory (same location) where the pdf file is available.

NOTE: If you need tabular data along with text then set the Tabular value as true, you need to set the value according to your requirement.

Regards,
NaNi

[bhanu.priya2 (Bhanu Priya)]

Hi,

it is throwing an above error…but the path which i mentioned is correct only not sure why it is showing notfoundexeption…

[bhanu.priya2 (Bhanu Priya)]

Any solution? please help me