topic excel export problem in Application Development and Automation Discussions

excel export problem

Former Member — Fri, 14 Sep 2007 10:50:39 GMT

HI Experts !

In a program while exporting data from alv grid to excel , its exporting only one last column . what is the solution so that all columns be transported .

plz help .

thanks.

ranjana

Re: excel export problem

Former Member — Fri, 14 Sep 2007 11:01:16 GMT

HI Ranjana,

You must be passing the header to the function module which is not clear thats why it contains the last value of the itab.pass the entire internal table.

you have to do some loop.endloop. and write your excel code inside the loop.

try these maybe you get your solution

thanks

vivekanand

Message was edited by:

Alvaro Tejada Galindo

Re: excel export problem

Former Member — Fri, 14 Sep 2007 11:29:58 GMT

Hi Ranjana,

It is best to use the export inside the Loop Endloop as it will export all the columns and their values one by one.

In case you still have any clarifications,please let me know.

Regards,

Puneet Jhari.