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

HELP

Former Member
0 Likes
608

HI ALL,

Please tell me the function modulesfor download the ALV report into excel sheet . the sheet contains all the headings .

kind regards,

1 ACCEPTED SOLUTION
Read only

sreeramkumar_madisetty
Active Contributor
0 Likes
587

Hi

In tha ALV list itself you can find one option for download the ALV list into Excel file.

Please check it out and let me know.

Regards,

kumar

4 REPLIES 4
Read only

sreeramkumar_madisetty
Active Contributor
0 Likes
588

Hi

In tha ALV list itself you can find one option for download the ALV list into Excel file.

Please check it out and let me know.

Regards,

kumar

Read only

0 Likes
587

Hi ,

Check this function module XXL_FULL_API.....

I hope it will work.....

Regards,

Kiran.

Read only

Former Member
0 Likes
587

Hello Vandana,

Is option alread existing for ALV. Check the APplication tollbar of the ALV output.

There U can download the output to any type of Microsoft format.

Vasanth

Read only

Former Member
0 Likes
587

Hi,

Use this FM,

call function 'EXCEL_OLE_STANDARD_DAT'

exporting

file_name = 'c:\Total_Plant Waste.xls'

tables

  • PIVOT_FIELD_TAB =

data_tab = t_excel1

fieldnames = flditab

exceptions

file_not_exist = 1

filename_expected = 2

communication_error = 3

ole_object_method_error = 4

ole_object_property_error = 5

invalid_filename = 6

invalid_pivot_fields = 7

download_problem = 8

others = 9.

clear: t_excel1,flditab.

refresh: t_excel1,flditab.

Regards,

U. Uma