PDF to Excel conversion in Irregular format

Sample.pdf (805.1 KB)
Hi,
Good Noon l!!

PFA and I need to convert the PDF to Excel or CSV Format. Kindly gave solution convert the pdf to excel format in UiPath. I tried to using Read PDF text and Feat System. In Feat System, we can able to convert up to 3 pages only

Thanks & Regards,
M.Santhosh Kumar

Hi @Santhosh_Kumar

Use Generate Data Table From Text activity

image

@Santhosh_Kumar

Use Read pdf text activity or read pdf text with ocr
Then use generate Datatable activity ,Specify the format which you want to store the data either by commas,new line or tab based on your requirement.
write datatable

Hello @Santhosh_Kumar

  1. Read PDF Text:
  • Use “Read PDF Text” activity to extract text from the PDF.
  • Store the text in a variable, e.g., pdfText.
  1. Data Manipulation:
  • Process pdfText to extract and structure the data.
  1. Write to Excel:
  • Use “Excel Application Scope” activity.
  • Inside it, use “Write Range” activity to write the processed data to an Excel file.

Thanks & Cheers!!!

Hello @Santhosh_Kumar

Try to Use these Activities,
Read PdfText Activity - Generate DataTable Activity (Pass the Output of Read PdfText Activity)

Hope this help you

@Santhosh_Kumar

OUTPUT :

xaml :
Sequence3.xaml (7.3 KB)

Try this
Regards

HI @Santhosh_Kumar ,
I test my WF with your file
I thought read pdf to get String
Then generate String to Data
write data to Excel
test.xaml (20.0 KB)
fr.xlsx (11.8 KB)
Sample.pdf (805.1 KB)

Other solution
You can try to extract data from PDF and then write data to Excel

Regards,
LNV

Hi All,

Thanks for your response. I Need to extract te value as attached format of excel.
Sample.xlsx (117.6 KB)

use export pdf as image activity

Regards

@Santhosh_Kumar
Sequence3.xaml (8.1 KB)

check this out

OUTPUT :

Insert image activity is present in balareva.excel.activities package

Regards

Hi,

PFA. How to solve this error.

you need to import all the packages like pdf package , Balareva packages




after installing packages refer the follwing sequence

Regards,

Hi,

Thanks For your Solution,

If I convert as Image Can able to read the excel file as row by row. Is it possible to retrieve the Data.

No that wouldnot be possible as it is in the form of image

If you have found my solution helpful kindly mark as solution :innocent:

Regards,