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

Printing excel list through internal table

Former Member

‎2009 Jan 29 9:38 AM

0 Likes
887

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.

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.

Reply
3 REPLIES 3
Read only

Former Member

‎2009 Jan 29 11:26 AM

0 Likes
857

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

Read only

Former Member

‎2009 Jan 29 11:32 AM

0 Likes
857

HI,

You can take help from this

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

regards,

Lokesh

Read only

Former Member

‎2009 Jan 29 12:41 PM

0 Likes
857

Hi sudheer,

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

regards,

DInesh.