topic Code to dowload excel .xslx format in Application Development and Automation Discussions

Code to dowload excel .xslx format

Former Member — Wed, 23 Nov 2011 21:41:07 GMT

Hi gourou,

We use some function to dowload in xls format but didn't work in .xlsx format (convert error).

Can you provide me a function or method we can use it to download excel in .xslx format.

Thanks a lot

Soufiene

Re: Code to dowload excel .xslx format

madhu_vadlamani — Thu, 24 Nov 2011 04:54:51 GMT

Hi Soufiene,

Please check with CL_GUI_FRONTEND_SERVICES and file_copy,FILE_COPY.Just go through this wiki also.

[Abap To Xlsx|http://wiki.sdn.sap.com/wiki/display/ABAP/abap2xlsx]

Regards,

Madhu.

Re: Code to dowload excel .xslx format

Former Member — Thu, 24 Nov 2011 06:28:20 GMT

Use this code it will helps u.........

*DOWNLOAD THE ITAB DATA

if not it is initial.

data: l_filename type string,

l_path type string,

l_fullpath type string,

l_result type i.

Display save dialog window

call method cl_gui_frontend_services=>file_save_dialog

exporting

window_title = 'FILE PATH'

default_extension = 'XLS'

default_file_name = 'CREDIT LIMIT DATA'

INITIAL_DIRECTORY = 'c:\temp\'

changing

filename = l_filename

path = l_path

fullpath = l_fullpath

user_action = l_result.

Check user did not cancel request

check l_result eq '0'.

call function 'GUI_DOWNLOAD'

exporting

BIN_FILESIZE =

filename = l_fullpath

filetype = 'ASC'

write_field_separator = 'X'

tables

data_tab = it_crdt_limit

endif.

<begging removed by moderator>

Thanks

Gupta

Edited by: Thomas Zloch on Nov 24, 2011 4:07 PM