on 04-03-2013 7:24 AM
Dear Experts,
Kindly guide me is there any possiblity in getting the data downloaded in same Excel sheet but into different worksheets??
Thanks & Regards
Arun.K.P
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi Arun,
You can do this using XML, transform XML as xstring and call this method.
CALL METHOD cl_wd_runtime_services=>attach_file_to_response
EXPORTING
i_filename = 'plantilla.XLS'
i_content = lv_content
i_mime_type = 'application/vnd.ms-excel'
i_in_new_window = 'X'
i_inplace = 'X'.
Regards !!
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi Arun,
I think you could do this:
1) Upload an excel sheet (a kind of template) with different tabs on AL11 as XML. Take a look to that XML file, it will give you an idea of the pattern you have to follow to manage different TABS.
2) Manage that XML data (from Web Dynpro) to insert data information on different tabs in the way you need. You can use "OPEN_DATASET" sentence from Web Dynpro.Firstly, get the information fas STRING and then convert to XSTRING.
3) Once you have it as XSTRING, call
CALL METHOD cl_wd_runtime_services=>attach_file_to_response
EXPORTING
i_filename = 'plantilla.XLS'
i_content = lv_content
i_mime_type = 'application/vnd.ms-excel'
i_in_new_window = 'X'
i_inplace = 'X'.
Regards !!
Hi,
I used to use ole2 Objects, but you can not use it from webdynpro applications, so I recommend you to use abap2xlsx, ckeck this blog by Ivan Femia where he explains how it works.
Regards.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
85 | |
23 | |
11 | |
9 | |
8 | |
5 | |
5 | |
5 | |
5 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.