Application Development 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
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 

Need to send data in .xls format

Go to solution
Former Member

‎01-31-2007 8:11 PM

0 Kudos

Hi all ,

I have to send data from internal table to .xls file . Iam just giving file extension in .xls .Iam getting file .xls format also . my requirement one field data should be in one column .is there any function module for that?

1 ACCEPTED SOLUTION

Go to solution
Former Member

‎01-31-2007 8:15 PM

0 Kudos

Hi,

You can use the FM GUI_DOWNLOAD to download the data from an internal table to xls file..

pass the WRITE_FIELD_SEPARATOR = 'X' to have one field in one column..

Thanks

Naren

3 REPLIES 3

Go to solution
Former Member

‎01-31-2007 8:15 PM

0 Kudos

Hi,

You can use the FM GUI_DOWNLOAD to download the data from an internal table to xls file..

pass the WRITE_FIELD_SEPARATOR = 'X' to have one field in one column..

Thanks

Naren

Go to solution
ferry_lianto
Active Contributor

‎01-31-2007 8:23 PM

0 Kudos

Hi,

Please check also FM SAP_CONVERT_TO_XLS_FORMAT.

Regards,

Ferry Lianto

Go to solution
Former Member

‎02-02-2007 1:50 AM

0 Kudos

you can have a look at

http://www.saptechnical.com/Tips/ABAP/downloadToExcel.htm

You can find an example here on downloading to excel with many advanced features