PDF to Excel data export issue

[NiranjanK1]

Hi All,

im trying to export the PDF data as it is to Excel but it is not working as expected. Kindly help me to resolve this issue. I have attached expected Excel Output file.

Thanks

Niranjan

[NiranjanK1]

@Felipe_Ribeir0 If i get the same format of details with my real time data, i can atleast work with the details but im not getting fileld names. 

[Felipe_Ribeir0]

Field names where? As a row?

try to replace this

df2 = tabula.read_pdf(FullPath, pages="all", area=[36, 18, 200, 800])

by this

df2 = tabula.read_pdf(FullPath, pages="all", area=[36, 18, 580, 800], pandas_options={'header': None})

[NiranjanK1]

@Felipe_Ribeir0Column names with data, if i get extra columns also fine. I can use formula tool to merge as per my requirement. 

[NiranjanK1]

@Felipe_Ribeir0 I got only 8 Columns of details