topic Re: HELP in Application Development and Automation Discussions

HELP

Former Member — Tue, 20 Feb 2007 11:45:05 GMT

HI ALL,

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

kind regards,

Re: HELP

sreeramkumar_madisetty — Tue, 20 Feb 2007 11:46:18 GMT

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

Re: HELP

Former Member — Tue, 20 Feb 2007 11:47:33 GMT

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

Re: HELP

Former Member — Tue, 20 Feb 2007 11:59:19 GMT

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

Re: HELP

Former Member — Tue, 20 Feb 2007 12:04:26 GMT

Hi ,

Check this function module XXL_FULL_API.....

I hope it will work.....

Regards,

Kiran.