Convert PDF File into Excel from studio

[Agantuk_Avi]

Hi

I want a help in UiPath studio to convert pdf to excel data but i dont want to use pdf to text converter apart from there is any tool from which i can easily convert the file i have also used feat system pdf conversion package but these not solving my problem

Thanks

[mkankatala (Mahesh Kankatala)]

Hi @Agantuk_Avi

=> Use the Read pdf text activity to read the pdf file and store in a String variable.
=> After that use Generate Datatable activity to convert the text to datatable.
=> Use the Write range workbook activity to write the datatable to excel.

Hope it helps!!

[rlgandu (Rajyalakshmi Gandu)]

@Agantuk_Avi

Brainstorming Solutions for Editing Data in PDFs

I have a set of PDF files that contain two or three tables each and I wish to extract and store the tables into excel, but unfortunately, the activities present such as OCR and Read PDF Text won’t generate the desired outcome. [StructuredDatatable] [unstructured_data] Is there any way to capture tables present inside PDF’s(Structured or unstructured) and store them into excel? Help would be appreciated, and thanks in advance! P.S. I’ve tried using EpsilonAI.Activities, that didn’t work eith…

[Anil_G (Anil Gorthi)]

@Agantuk_Avi

Try converting or opening the pdf file as word and then try to extract

cheers

[Parvathy (PS Parvathy)]

Hi @Agantuk_Avi

=> Use “Read PDF Text” activity or “Read PDF with OCR” activity to read the PDF and store it in a variable.
=> Use “Generate Data Table From Text” activity to convert it to an data table. Click on Preview button to see whether to see the format of excel.
=> Use “Write Range Workbook” activity to write the data table to excel.

Hope it helps!!