topic generate excel sheet list file through program in Application Development and Automation Discussions

generate excel sheet list file through program

Former Member — Tue, 16 Dec 2008 10:34:24 GMT

Hi,

I have to generate list in excel which is having column with fixed length.

I m using classical report for output then in output i m generating excel file .

but that file is not with fixed column length.

how ALV will be useful in this case

Please help.

Regards,

Sudhir Ghag.

Re: generate excel sheet list file through program

Former Member — Tue, 16 Dec 2008 10:48:59 GMT

Use FM XXL_FULL_API.

This creates an excel as per your requirement.

Re: generate excel sheet list file through program

Former Member — Tue, 16 Dec 2008 10:50:32 GMT

Hi,

As from Ur query u required the output in the fixed length of columns as output in the excel. This is not possible by using Type pool ole2. We have to control the length of the excel cell as fixed.

Hope this will help U