Application Development and Automation 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: 
Read only

FM required

Former Member
0 Likes
802

Hi Gurus,

Is there any FM, which can download a list in Excel format in desktop.

I hav used GUI_DOWNLOAD, but other than that is there anything else??

Will be rewarded.

With Regards,

Seevangi Mishra

Hi Gurus,

Is there any FM, which can download a list in Excel format in desktop.

I hav used GUI_DOWNLOAD, but other than that is there anything else??

Will be rewarded.

With Regards,

Seevangi Mishra

6 REPLIES 6
Read only

Former Member
0 Likes
787

Pls. chk FM "XXL_FULL_API".

Sample programs :

XXLFTEST

XXLTTEST

Best regards,

Prashant

Read only

Former Member
0 Likes
787

Hi,

Which version of SAP you are currently using? why do you need another FM other than gui_download when this is working right?

Anita

Read only

Former Member
0 Likes
787

try

XXL_FULL_API-Output Excel list viewer list

MCP_PRINT_EXCEL-Transferring the planning table to EXCEL

But the best available FM for this purpose is GUI_DOWNLOAD

thanks

Reward if useful

Richa

Read only

prasanth_kasturi
Active Contributor
0 Likes
787

hi,

try the fm

SAP_CONVERT_TO_XLS_FORMAT

EXAMPLE

data : begin of itab occurs 0,

fi(5) type c,

end of itab.

itab-fi = 00100.

append itab.

itab-fi = 00010.

append itab.

CALL FUNCTION 'SAP_CONVERT_TO_XLS_FORMAT'

EXPORTING

i_filename = 'D:\Documents and Settings\vzf91z\Desktop\x.xls'

tables

i_tab_sap_data = itab.

regards

prasanth

Read only

Former Member
0 Likes
787

Hi,

Try this FM , 'SAP_CONVERT_TO_XLS_FORMAT'.

Regards,

Prabakaran.S

Read only

ritesh_dugad2
Active Participant
0 Likes
787

You can also Function: EXCEL_OLE_STANDARD_DAT. Its simple and easy to use.