How to Convert PDF to Excel without string manipulation

Help Studio
, ,
1

Hi Team,
Can anyone help me how to convert the pdf into the excel?

PDF Image :

image
image747×332 26.7 KB

Excel Image :

image
image1803×162 3.9 KB

without using string manipulation

2

@Madhups

Try using regex…again that si a kind of string manipulation only

Else use document understanding

You can use the invoice model

Cheers

3

Hi @Madhups

Since, you said that you can’t use String manipulation

  1. you canwrite Regex expressions by Reading the PDF with activities “Read PDF Text” or “Read PDF with OCR” and using Matches activity.(you need to install UiPath.PDF.Activities).

  2. Use Document Understanding steps to achieve the output. For more information on Document Understanding try referring the YouTube or reading the “UiPath Document Understanding Overview” course from UiPath Academy. Install( UiPath.IntelligentOCR.Activities, UiPath.OmniPage.Activities(Omni Page OCR),UiPath.DocumentUnderstanding.ML.Activities)

Hope it helps!!
Regards,

4

@Parvathy @Anil_G we cant use the document understanding as we don’t have admin access to Orch and ROI is very less to get the license. Also for Regex right when i am writing the pdf file to text file the data in the table is not coming correctly the data is mixing up. Is there any C# code for directly converting pdf to Excel as it is?

5

@Madhups

Did you try read text with preserve format check…then it will be little better

we can try counting the spaces or use regex…with out preserve format definitely it is messed

Try opening pdf using word document activities and check if that works for you

cheers