topic Re: changing existing excel-file using SAP DOI in Application Development and Automation Discussions

changing existing excel-file using SAP DOI

103343 — Wed, 02 Apr 2008 06:55:40 GMT

I try to change data in an existing excel-sheet using SAP desktop office integration.

When changing several cells with method SET_RANGES_DATA of interface I_OI_SPREADSHEET all given cells do not get new values but get empty even if they had values before.

Since i didn't want to give every cell a range-name I used parameter RANGESDEF instead of RANGES as described in documentation:


      CLEAR empty[]. 
      CALL METHOD spreadsheet->set_ranges_data 
        EXPORTING 
          ranges    = empty[] 
          no_flush  = '' 
          updating  = 1 
          contents  = data_table[] 
          rangesdef = ranges[] 
        IMPORTING 
          error     = error 
          retcode   = ret_string.

Does anybody have any idea why the values in data_table are not filled in? I looked with debugger in the tables data_table and ranges an they looked good. Retcode sais "OK" after execution.

regards

Herbert

Re: changing existing excel-file using SAP DOI

Former Member — Wed, 02 Apr 2008 08:47:43 GMT

Hi,

I have a other solution for you.

Why don't you use the OLE object?

Re: changing existing excel-file using SAP DOI

103343 — Wed, 02 Apr 2008 08:57:32 GMT

Hi Marc,

I consider OLE as a fallback if I do not get DOI to work.

But i would prefer to get DOI working because it is (at least theoretically) able to work with several office applications, not only with MS excel.