smartform in EXCEL format

[Former Member]

Hi Experts,

I designed a smartform . if the user clicks the line in report output the corresponding layout is displaying using smartform and i provided option that output is exporting in PDF file.

now my latest requirement is to disaply the layout in EXCEL format.

so could please tell which is the best way to achive.

1) is there any FM like that bo convert PDF to EXCEL?

2) are can we export the smartform layout data to EXCEL format?

Help will be rewarded

Regards

sri

[Former Member]

Hi ,

Could you please tell me that which is the best way to export from smartform to excel?

Thank advance.

Edited by: karenloria on Nov 9, 2009 9:22 AM

[Former Member]

hi

good

first convert to OTF to PDF format:

CALL FUNCTION 'CONVERT_OTF'

EXPORTING

format = 'PDF'

IMPORTING

bin_filesize = wrk_filesiz

TABLES

otf = st_prnout_info-otfdata[]

lines = it_lines

EXCEPTIONS

err_max_linewidth = 1

err_format = 2

err_conv_not_possible = 3

OTHERS = 4.

IF sy-subrc <> 0.

MESSAGE ID sy-msgid TYPE sy-msgty NUMBER sy-msgno

WITH sy-msgv1 sy-msgv2 sy-msgv3 sy-msgv4.

ENDIF.

>> then download it to pc and then upload and send email using any of the

FM available in SAP

thanks

mrutyun^

[Former Member]

no FM to do them

But there are many many software can convert PDF to EXCEL

just go to google use 'convert PDF to EXCEL' to search

they are not expensive