PDF to Excel conversion in Irregular format

Help Studio
, ,
1

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

2

Hi @Santhosh_Kumar

Use Generate Data Table From Text activity

image

3

@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

4

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!!!

5

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

6

@Santhosh_Kumar

image
image462×589 16.1 KB

OUTPUT :

image
image1148×570 15.3 KB

xaml :
Sequence3.xaml (7.3 KB)

Try this
Regards

7

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)

image
image555×801 21 KB

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

Regards,
LNV

8

Hi All,

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

9

use export pdf as image activity

Regards

10

@Santhosh_Kumar
Sequence3.xaml (8.1 KB)

image
image596×532 17.7 KB

check this out

OUTPUT :

image
image651×768 74.6 KB

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

Regards

11

Hi,

PFA. How to solve this error.

PDF_Excel_Conversion_Error
PDF_Excel_Conversion_Error1348×689 56.3 KB

12

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

image
image974×657 56.1 KB

image
image955×545 32.3 KB

image
image596×532 17.7 KB

after installing packages refer the follwing sequence

Regards,

13

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.

14

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,