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.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 ?
I attached file. Can you tell me if this form is satisfing for you ?
Untitled.zip (574 bajty)
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.
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