excel download into a sheet-2by taking formula from another sheet.-1

[Former Member]

i hv an internal table itab.which contain 3 fields a,b,c.

a,b are input parameters (int).c = ab.Now i hv to download the values of a,b,c into a excel sheet-2 by <b>taking the formula</b>(c = ab) <b>from another sheet-1</b>.and everytime the new vales of a,b,c should be appended ito the sheet2.

can anybody tell me which fm i shoud use?? or some sample code will be grrr88.

points will be rewarded.

[Former Member]

i cant understand why dont anybody reply me.....is that possible at all??

[Former Member]

See if these blogs can help you ...

/people/rich.heilman2/blog/2005/09/12/manipulate-excel-with-ole-abap

/people/sap.user72/blog/2006/02/07/downloading-data-into-excel-with-format-options

Not sure if you can do the calculations.

Regards,

Ravi

[Former Member]

hi ravi...

thanx for ur reply.....

i hv seen some example of OLE. although i am not good in ole...

but still i hv not seen any example of ole/or any prog. that updates the excel-sheet <b>using formula from another sheet</b>.

do u hv any idea regarding that....

[Former Member]

Unfortunately I haven't done this myself.

Regards,

Ravi

[Former Member]

anybody else.....