topic Re: Download Excel Program in Application Development and Automation Discussions

Download Excel Program

Former Member — Wed, 28 Apr 2010 12:29:21 GMT

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.

Re: Download Excel Program

Former Member — Wed, 28 Apr 2010 12:46:50 GMT

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

Re: Download Excel Program

Former Member — Wed, 28 Apr 2010 12:51:19 GMT

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

Re: Download Excel Program

Former Member — Wed, 28 Apr 2010 12:53:48 GMT

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.

Re: Download Excel Program

Former Member — Wed, 28 Apr 2010 13:00:29 GMT

See this site and follow it

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

Re: Download Excel Program

Former Member — Wed, 28 Apr 2010 13:21:10 GMT

Thanks.

But it is not working for me.

Re: Download Excel Program

Sandra_Rossi — Wed, 28 Apr 2010 14:43:23 GMT

> 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

Re: Download Excel Program

Former Member — Wed, 28 Apr 2010 15:09:42 GMT

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,

Re: Download Excel Program

Former Member — Tue, 11 May 2010 14:31:25 GMT

Prepared an seperate internal table.

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