HConvert PDF to Excel

[BBCC_0000]

Hi everyone, is there any way to convert a whole pdf file to excel file? I have tried but it doesn’t work. Thanks in advance.

[Gokul001 (Gokul Balaji)]

Hi @BBCC_0000

What is the error did you facing while processing? Can you share the screenshot of the issue?

Regards
Gokul

[Gokul001 (Gokul Balaji)]

Hi @BBCC_0000

Have a look on the blog

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

Check out this thread

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…

Hope it will helps

Regards
Gokul

[BBCC_0000]

Hi Gokul,

Same thing that I have encountered, I am not able to use the ‘Read PDF text’ (Pic 1) as I am using Windows not Windows-Legacy, still can’t find a proper way to solve this.

[BBCC_0000]

May I know is it possible to use the other ‘Read PDF Text’? As I am only able to use that activity.

Thank you very much!

[Gokul001 (Gokul Balaji)]

HI @BBCC_0000

Do you install the PDF package ?

[BBCC_0000]

Hi Gokul,

Yes, I have installed, you may check the thread if you want. It doesn’t work on me.

Read full PDF is missing - Help / Forum - UiPath Community Forum

[Gokul001 (Gokul Balaji)]

@Gokul001

Check out this thread

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)

Have you check this thread and try this workflow @BBCC_0000

[supermanPunch (Arpan)]

Hi @BBCC_0000 ,

Have you installed the UiPath.PDF.Activities package (Latest version) ? From the Thread you have posted you were pointing to a different package (Different Author) that was being used in the Old Project.

If you require that Package itself that was present in the Old Project, you would have to either request the Author to perform a conversion to the .NET 6 compatible version so that you may be able to use it within Windows version Or You could shift back to the Windows-Legacy version.

PDF Activities - RPA Component | UiPath Marketplace

If using the Windows version is your only approach, then we could try helping you out by providing a workflow (Using activities) which does the same task as the operation performed by the Previous Activity. We would simply need to know what was the Activity working or what was the Output when given an Input.