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
Showing results for 
Search instead for 
Did you mean: 

ALV to excel download

Former Member
0 Kudos

Hi guys,

Can you tell me how can i download data from an ALV display into an excel file without truncating the leading zeroes. I want the file to be downloaded to a specific file name enetred at the selection screen.

Also i wana know how do i disable the use of layouts in the alv display.

would be glad if anyone could help me on this.

cheers

arindam

6 REPLIES 6

Former Member
0 Kudos

Hi

Use these function modules :

SAP_CONVERT_TO_XLS_FORMAT

-> MS_EXCEL_OLE_STANDARD_DAT

-> RSPO_DOWNLOAD_SPOOLJOB

RH_START_EXCEL_WITH_DATA

Header Description Length will be based on the field length.

With Regards

Nikunj Shah

Former Member
0 Kudos

Also i wana know how do i disable the use of layouts in the alv display.

http://help.sap.com/saphelp_nw04/helpdata/en/d7/b22041aa7df323e10000000a155106/content.htm

Former Member
0 Kudos

Hi,

Try FM SAP_CONVERT_TO_XLS_FORMAT. This should help you.

Regards,

Lalit

former_member181995
Active Contributor
0 Kudos

Ani,

use WS_EXCEL Fm.

Amit.

RoySayak
Active Participant
0 Kudos

Hi Arindam,

Try with this two FM's:

> SAP_CONVERT_TO_XLS_FORMAT

> ALSM_EXCEL_TO_INTERNAL_TABLE

Best Regards,

Sayak...

"Giving points for helpful answer is always appreciating"