2007 Apr 20 10:03 AM
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 ? ....................
2007 Apr 20 10:10 AM
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.
2007 Apr 20 10:10 AM
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.
2007 Apr 20 10:13 AM
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
2007 Apr 20 10:14 AM
Hi Sunil,
If you are familliar with OOPs then try to use this class.
CL_GUI_FRONTEND_SERVICES
Reward if useful!
2007 Apr 20 10:17 AM
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