Community
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
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: 
Read only

Download internal table data in excel format

Former Member

‎2008 Dec 15 5:32 PM

0 Likes
494

Hi ,

i have a requirement where i need to download the internal table data in excel format .. I tried using the FM SAP_CONVERT_TO_XLS_FORMAT but this downloads to excel sheet same as .txt file foemat without columns ... i need to have the data in excel sheet with column heading and separated by each coulmn which should be similar as a general sheet with column names and the respective data in the columns . Appreciate any inputs .

Thanks,

Latha.

Hi ,

i have a requirement where i need to download the internal table data in excel format .. I tried using the FM SAP_CONVERT_TO_XLS_FORMAT but this downloads to excel sheet same as .txt file foemat without columns ... i need to have the data in excel sheet with column heading and separated by each coulmn which should be similar as a general sheet with column names and the respective data in the columns . Appreciate any inputs .

Thanks,

Latha.

Reply
2 REPLIES 2
Read only

Former Member

‎2008 Dec 15 5:47 PM

0 Likes
463

Hi,

Did you search on SCN , there are loads of threads already for this requirement.Here is one such [thread|; Check Vijay's reply in the end.

regards,

Advait

Read only

Former Member

‎2008 Dec 15 5:49 PM

0 Likes
463

Hi,

you can this in Debugging mode,

say,once you got entire data into ITAB

salect the TABLE option and provide the table name

now on the top most you can see excel icon,you click

on that,now system will prompts you for to the file to be saved.

Regards,

Vijaya.