refresh excel inplace data

[Former Member]

hello,

in sap plm there is a transaction clmm (assign values in matrix). there is a alv grid in which I can change the data and with a button refresh I can save the data in sap. I also can download the data in excel with excel inplace. in excel I can go to file - refresh. it seems as if there is also the possibility to change and save the sap data. but the data are not saved in sap. To solve this problem I read a lot about alv and desctop office integration. with als everybody seems to be interested in downloading data to excel and not vice versa. with desctop office integration I checked my installation with check_doi.exe and doi_xls_check.xls. everything seems to be o.k.

Can anybody help how to save data in sap out of excel?

thanks in advance

manuel nagler

[michael_bennett · Accepted solution]

Hi Manuel,

I will give my opinion. Normally you use DOI to control Excel and the methods of the interface I_OI_SPREADSHEET to load data from SAP to Excel and also retrieve the data of the spreadsheet from Excel. An example is the method GET_RANGES_DATA. So bascically you must develop and application that creates various DOI objects and then uses the methods to control setting and getting the data from the desktop application.

The ALV grid has built in functionality to allow the contents of the grid to be shown in Excel but it does not necessarily expose a mechanism to get this data back into SAP. There might be a way but I have never needed this and it is certainly not a documented feature of the ALV that I am aware of.

So I would say that if you want to allow data to be edited in Excel and then for your application to get the data back from Excel you have to explicitly use the DOI interfaces.

Just because a SAP transaction or application uses an ALV grid does not mean you can get the data back from Excel. You can of course save a "copy" of the spreadsheet to a file on your desktop (i.e. as you mention change and save the SAP data, which is really now just spreadsheet data).

The examples of DOI in the resuse library, SE83, give an indication of how DOI can be used to actually "drive" the desktop application.

Hope this helps.

Michael

[Former Member · Accepted solution]

Hello Michael,

thanks for your answer. It is clear for me that a alv does not necessarily expose a mechanism to get data out of excel back into SAP. but in the transaction clmm if you go to excel inplace there you can click refresh under file. also in the alv there is a button refresh with which you can save the data you changed in the alv. so i thought there is also the possibility to do this in excel. maybe sap wanted to implement this functionality and made the buttons and then they didn't implement it. I dont know.

kind regards

manuel nagler