Change PDF File to Excel File

[RaviDevaraj]

Hi @ClaytonM

To Convert to PDF File to Excel File ,in PDFfile we have to two types of header

Eg:
page1-10 one header Part and page 11-20 we have another Header Part is there .how we can able to convert this ?
Regards
RaviDevaraj

[AshwinS2 (Ashwin S)]

hi @RaviDevaraj

1.Use read pdf text with ocr and range give 1-10 and store the value in string
2.Use read pdf text with ocr and range give 11-20 and store the value in string
3.use Write range activity and mention the range based on the header part

Thanks
Ashwin S

[sreekanth]

Pdftext.xaml (8.8 KB)
Refer this file @RaviDevaraj

(or)
*Build data table with columns defined
*Use Start process and provide executable file of default pdf reader

• Use read pdf with Ocr and provide the range 1-10 and read pdf with Ocr and provide the range 10-20 in properties and pass the extacted variables using add data row to datatable
• use write range to write to excel file

[RaviDevaraj]

@sreekanth

Use read pdf with Ocr

Thanks for your response .
I am using read pdf text and in Read Pdf with OCR asking Drop OCR engine activity here ?

i am using assign activity for header part and remaining what need to do i dont know

can you please help me !!!

my xaml file here : Main.xaml (17.6 KB)

i cannot able to upload my sample PDF file [throws an Error : Too Big size : 13.7 MB]
Regards
RaviDevaraj

[sreekanth]

@RaviDevaraj

Read Pdf with OCR asking Drop OCR engine activity here

Use Google Ocr or Microsoft ocr

@sreekanth

Build data table with columns defined

*Use Start process and provide executable file of default pdf reader

Use read pdf with Ocr and provide the range 1-10 and read pdf with Ocr and provide the range 10-20 in properties and pass the extacted variables using add data row to datatable
use write range to write to excel file

Follow this process

[RaviDevaraj]

@sreekanth

Build data table with columns defined

In Build table I Need to create a column by manually !

[sreekanth]

Main.xaml (19.6 KB)
Yes

[RaviDevaraj]

Hi @sreekanth
Thanks for your Sample Build Data Table and Your step-by-step Guidelines too.

As Like you said i have created the Build Table and read file OCR you Done.

Then using Assign activity i List out the Header Part [14 assign activity] and Add Row activity and write CSV File.

Note : In My PDF File totally 431 Pages
i.e., Page No : 1-17 One header Part and contains the Data.
Page No : 18-431 Second Header Part is and contains the Data.
Then Each and Every transaction we have the total values at the end.
Second Part page no is my focus Pg.no : 18-431

My xaml file executing 4 minutes and throwes an error :

In Property windows: Need to set any Value !!!

My Updated xaml File Here:Main.xaml (26.5 KB)

Are you there @sreekanth

Regards
RaviDevaraj

[sreekanth]

Click on Google Ocr,In the properties panel,Create an output variable in Text field @RaviDevaraj
pdfreader.xaml (23.7 KB) Once Refer to this file

[RaviDevaraj]

@sreekanth

Click on Google Ocr,In the properties panel,Create an output variable in Text field

I have created already “header1”

in my xaml file i build the data table and using read pdf with ocr and google ocr after that i used the Assign activity all assign activity throws an ERROR like object references why ?

Below that Add rowdata activity enter all header value,and using write csv activity
i cannot able to create this variable type:

How to create this ?

Regards
RaviDevaraj

[sreekanth]

@RaviDevaraj

i cannot able to create this variable type:

You want to use this variable in write range?If yes try to change the scope of variable and try

@RaviDevaraj

in my xaml file i build the data table and using read pdf with ocr and google ocr after that i used the Assign activity all assign activity throws an ERROR like object references why ?

the variables which you are assigning does not contain any value.Try to use writeline and check whether it has any value

[RaviDevaraj]

@sreekanth

You want to use this variable in write range?

No, in Assign activity i decleared as files variable = Directory.GetFiles(“C:\Users\ravi_d\Downloads\Ameritas - 02-28-2018.pdf”)

for this i want to create variable type as :string i cannot able to find?

@RaviDevaraj

i used the Assign activity all assign activity throws an ERROR like object references why ?

for this issues what can i do for this
Please find the my xaml file Main.xaml (27.4 KB)

Regards
RaviDevaraj

[sreekanth]

@RaviDevaraj

for this i want to create variable type as :string i cannot able to find?

select array in variable type and choose string

@RaviDevaraj

for this issues what can i do for this

You have use readfile in assign activity.Try to use Writeline activity and pass readfile and check whether any value is displayed

[RaviDevaraj]

@sreekanth

Try to use writeline and check whether it has any value

so now i need to remove all Assign activity and newly need to create Write line Activity ?

Regards
RaviDevaraj

[sreekanth]

@RaviDevaraj

so now i need to remove all Assign activity and newly need to create Write line Activity ?

No,Just add below and check your output console whether it has any value

[RaviDevaraj]

Hi @sreekanth
No throws an error see the error screenshot :

i think in my xaml build data table,read with PDF,Google OCR,Add row dat,write csv activity only correct rest of things all shows an error only [ I Think ].

Regards
RaviDevaraj

[sreekanth]

The code which you assigned to readfile variable does’nt return any value.This is the reason for your error.Try to change the code so that it returns a value and also you need to complete the academy training so that you have better idea of implementing it

[RaviDevaraj]

@sreekanth

The code which you assigned to readfile variable does’nt return any value.This is the reason for your error.Try to change the code so that it returns a value

To get a value how we need to do in that ?

For that i can assign Readfile=Directory.GetFiles(“C:\Users\ravi_d\Downloads\Ameritas - 02-28-2018.pdf”) like this is Possible to get the values !!

Regards
RaviDevaraj

[sreekanth]

assign the output of read pdf with ocr to readfile,I went through your .xaml file.Its header1.Assign this to readfile and check

[RaviDevaraj]

@sreekanth

assign the output of read pdf

Regards
RaviDevaraj