Application Development Discussions
Join the discussions or start your own on all things application development, including tools and APIs, programming models, and keeping your skills sharp.
cancel
Showing results for 
Search instead for 
Did you mean: 

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

Former Member
0 Kudos

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~

3 REPLIES 3

Former Member
0 Kudos

take a look at this

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

and easy reference for ole documentation you can find the doc in that page

Message was edited by:

Mustafa SADIK

0 Kudos

Hi Mustafa SADIK

I have ever tired to use OLE to create the excel file but it is slowly.

what I thought is to use a subsistent template and at the begin of the program to copy from the template and then open the copy file to write into datas.

so now, I don't know how to open the exist excel file and write into datas.

thanks

0 Kudos

I got it~

thanks