topic Printing excel list through internal table in Application Development and Automation Discussions

Printing excel list through internal table

Former Member — Thu, 29 Jan 2009 09:38:31 GMT

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.

Re: Printing excel list through internal table

Former Member — Thu, 29 Jan 2009 11:26:36 GMT

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

Re: Printing excel list through internal table

Former Member — Thu, 29 Jan 2009 11:32:02 GMT

HI,

You can take help from this

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

regards,

Lokesh

Re: Printing excel list through internal table

Former Member — Thu, 29 Jan 2009 12:41:56 GMT

Hi sudheer,

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

regards,

DInesh.