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: 

Download excel template file

Former Member
0 Kudos

Hi all,

I am uploading data from excel file to tables through BDC. Uploading is done.

Now my requirement is to give user a template of the excel file which he can download and enter the data in it and use for uploading.

Please tell me how to do this.

Regards

Natasha Garg

5 REPLIES 5

Former Member
0 Kudos

hi ,

0 Kudos

Hi,

I have asked for excel download.

This is excel upload.

I want a tempplate to create in the program through FM etc and then provide the user with the option to download that template.

Regards

Natasha Garg

0 Kudos

HI,,

I am facing the same issue
You have any solution..

Former Member
0 Kudos

Hello,

Please check the transaction DWDM in SAP under OLE --> Download to excel.

This is a demo program and this may help you.

This link may also help you..

http://www.sap-img.com/abap/download-to-excel-with-format-border-color-cell-etc.htm

Hope this helps.

0 Kudos

Hi,

In selection screen give one custom button 'Template' and when user click on that button it generates one file usinf OLE or GUI_DOWNLOAD functionality.

In GUI_DOWNLOAD maintain headings in one internal table and pass that itab to t_outtab.