Skip to Content
author's profile photo Former Member
Former Member

How to convert pdf file data to excel file

Posted on Nov 27, 2008 at 10:45 AM 974 Views

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 .

ABAP Development
Add comment
10|10000 characters needed characters exceeded

3 Answers

  • author's profile photo Former Member
    Former Member
    Posted on Nov 27, 2008 at 12:38 PM

    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.

    Add comment
    10|10000 characters needed characters exceeded

    • Former Member
      Nov 28, 2008 at 05:45 AM

      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 .

  • author's profile photo Former Member
    Former Member
    Posted on Nov 28, 2008 at 06:02 AM

    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

    Add comment
    10|10000 characters needed characters exceeded

    • Former Member
      Nov 29, 2008 at 07:51 AM

      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 .

  • author's profile photo Amit Gujargoud
    Amit Gujargoud
    Posted on Nov 29, 2008 at 08:07 AM

    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

    Add comment
    10|10000 characters needed characters exceeded