Issues in Convert PDF File to Excel, In Excel Getting all values in one Column A1?

excel

#1

Hi @aksh1yadav @vvaidya

I have search and tried for convert the PDF File to Excel File . I have converted But all my PDF data’s are falling in one column (Like as Column A1)

here is my xaml file:
Main.xaml (10.4 KB)

And My sample Pdf file :
1090444_COMS_Commission Statement[1].PDF (148.3 KB)

my out put File as below in wrong format :
Untitled.xlsx (10.6 KB)

Can you Please help me to solve this issues ?

Regards
RaviDevaraj


#2

Hi @RaviDevaraj

I attached file. Can you tell me if this form is satisfing for you ?
Untitled.zip (574 bajty)


#3

Hi @fudi5 @aksh1yadav @vvaidya
Sorry for late reply, just now i see your attached file .

instead of Putting a each details as below below (row by row) we can able to put as it is in column by column ? is this possible ?

In that it reads the PDF File in row wise and its putting in to the Excel as Column !!!

I need exactly how appearance in PDF File that information in EXCEL Format.
or
otherwise the in excel i need the total transaction separate as comma .
Like this is possible ,
Header Part : ACCT#CUSTOMER NAME, POLICY NUMBER EFF/EXP DATENEW/RENEW COMMENT,BALANCE DUE,DATERECT,CHECK NUMBER,GROSS NET,CSAH RECH,COMM RATE,COMM RETAINED,COMM PAID as in one row itself it need to come

Below row need to all transactions data

TRANSCATION DETAILS : PHSD129907 12/08/2017-12/08/2018 RENEW,0.00,01/23/2018,2545661,G,1266.36,0.1200,0.00,151.96

Regards
RaviDevaraj