Download Excel Program

[Former Member]

Hi All,

I want to download the data to excel sheet.

Currently i have used GUI_DOWNLOAD.

Problem is

I have three internal table.

1. Contains Data in the Rows.

2. Contais the Ranges like where the data should be placed in excel.

eg: row 1 column 2

row 2 column 4 Base on this data needs to be downloaded

is there any function module to do this.

[Former Member]

Hi Praveen,

prepare ur internal table with type string.

add first row as the column heading

then add the table data

then pass it to function module 'SAP_CONVERT_TO_XLS_FORMAT'.

Regards,

Md Ziauddin

[Former Member]

Hi,

Thanks for your time.

But data will not be downloaded as i specified.

Internal table contains data

1. Table1-> Contains Data.

First row-> 1

[Former Member]

Hi All

Sorry.

Table 1 contains the data as follows

1 1 Value1

1 1 value 2

Table 2 contians

rowno columnno

1 1

2 2

When I download the data

Value1 from Table1 should come in First Row First Coulmn

Value2 should come in 2nd row 2nd column.

[Former Member]

Hi

See this site and follow it

http://www.thespot4sap.com/articles/Download_to_excel.asp

[Former Member]

Thanks.

But it is not working for me.

[Sandra_Rossi]

> is there any function module to do this

No, it doesn't exist, you must code it yourself, copy an existing function module and adapt it

[Former Member]

Hi,

I think that un axample can help finding the solution.

But, i sugest this for help Programe of example "XXLSTEST" whith the FM "CALL FUNCTION 'XXL_SIMPLE_API'"

help?

reguards,

M

[Former Member]

Prepared an seperate internal table.

By combining the common data into tmp table and downloaded the data.