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: 

Printing excel list through internal table

Former Member
0 Kudos

hi,

i want to create excel sheet having fixed(pre defined) column width through internal table , in program i m using FM 'DOWNLOAD' and passing internal table and getting excel list but how to get fixed column width. also how to display leading zero in excel

pls help .

regards,

Sudhir Ghag.

SAP ABAP Consultant.

3 REPLIES 3

Former Member
0 Kudos

Hi Sudhir,

You have to use OLE for this.

Using OLE you can set properties of column and sheet like border,width,font etc.

an also you can format cells(For leading zeros).

Search SCN for OLE exmples, you will get a lot.

Regards,

Manoj Kumar P

Former Member
0 Kudos

HI,

You can take help from this

/people/mark.finnern/blog/2004/08/10/spread-the-love

regards,

Lokesh

Former Member
0 Kudos

Hi sudheer,

pass the import parameter 'WK1_N_SIZE ' of the FM 'gui_download' and check..hope that solves your problem.

regards,

DInesh.