excel sheet problem

[Former Member]

This is emergency requirement that i have one internal table that change with i collomn i want to add that colomn to excelfile that already present in presentation sercver.

how to do that ?

i am try for that ?

i am able to get replace whole file,

append to existing file with respect to rows .

please help me .

it's emergency ? ....................

[Former Member]

One easy solution could be

First read the excel file in an internal table. Then populate the additional column of internal table. Then overwrite the contents of excel file.

But the performance depends on the size of excel file.. It might result in performance degradation if the file contents are large.

[Former Member]

Hi Sunil,

First upload the data using GUI_UPLOAD into an itab.

Addd the column data to that itab(Or another itab).

Then use the GUI_DOWNLOAD with the same file name.

Regards,

Ravi

[Former Member]

Hi Sunil,

If you are familliar with OOPs then try to use this class.

CL_GUI_FRONTEND_SERVICES

Reward if useful!

[Former Member]

HI,

Go for GUI_upload and upload it in internal table. In that internal table add the column which u want. Then using FM GUI_Download, u can dowmnload it into XL sheet.

Regards,

-->Suresh