Application Development Discussions
Join the discussions or start your own on all things application development, including tools and APIs, programming models, and keeping your skills sharp.
cancel
Showing results for 
Search instead for 
Did you mean: 

How to convert pdf file data to excel file

Former Member
0 Kudos
5,513

Dear sap Friends ,

I have a requirement from my company side . I have converted my smartforms into pdf format but i need to convert that pdf file to excel . I have used 'RSPO_DOWNLOAD_SPOOLJOB' function module . But the data is not coming in proper manner it is aligned .

do we have any method to convert pdf to excel in proper way means all columns correctly placed .

Thanks ,

Amit Ranjan .

5 REPLIES 5

Former Member
0 Kudos
792

hi,

you take that data into an internal table and then call the fm GUI_DOWNLOAD and it will convert to excel.pass filtype as DAT.

0 Kudos
792

HI,

Thanks for reply . OK I will take smart forms data into internal table and then use the aforesaid f.m. but this process is not generalized means i have to do it for each smart form . i want a common method which will convert smart forms data or pdf data directly into excel . is there any way out for this .

Thanks ,

Amit Ranjan .

Former Member
0 Kudos
792

hi

please refer to this link

http://help.sap.com/saphelp_erp2004/helpdata/en/d6/0dba8f494511d182b70000e829fbfe/frameset.htm

also try out the FM

HRHAP_POPUP_EXCEL_DOWNLOAD

hope this helps

regards

Aakash Banga

0 Kudos
792

HI,

Will u plz elaborate this function module .means what we have to write in

CALL FUNCTION 'HRHAP_POPUP_EXCEL_DOWNLOAD'

EXPORTING

T_DOCUMENTS =

S_REFERENCE =

becoz i have never used this f.m. before .

Thanks,

Amit Ranjan .

former_member181995
Active Contributor
0 Kudos
792

Once you got PDF than for PDF to Excel you may need 3rd party S/W other than SAP.

Which you can download from below link.

http://3d2f.com/programs/37-667-pdf-to-excel-converter-download.shtml