topic Re: excel sheet problem in Application Development and Automation Discussions

excel sheet problem

Former Member — Fri, 20 Apr 2007 09:03:46 GMT

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 ? ....................

Re: excel sheet problem

Former Member — Fri, 20 Apr 2007 09:10:32 GMT

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.

Re: excel sheet problem

Former Member — Fri, 20 Apr 2007 09:13:40 GMT

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

Re: excel sheet problem

Former Member — Fri, 20 Apr 2007 09:14:40 GMT

Hi Sunil,

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

CL_GUI_FRONTEND_SERVICES

Reward if useful!

Re: excel sheet problem

Former Member — Fri, 20 Apr 2007 09:17:03 GMT

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