Skip to Content
Former Member
Dec 01, 2006 at 06:20 AM

How to open .xls and write data into it and save it on local path


My requirement is to open the template excel file and inset the data from sap and save it.the template file is on local path.

First I copy the template into c:\ (by using cl_gui_frontend_services=>file_copy) and then use FM RH_START_EXCEL_WITH_DATA to write data but it is failed.

It seems to be create an excel file only.whether I cant use this FM to open the exist file and write data into it? Or is there another FM can be used to open and write data?

many thanks~