Skip to Content
avatar image
Former Member

OfficeControl and data transfer

Hi,

i developed a Webdynpro which displays an Excel sheet using the UI Element OFFICECONTROL.

It is required that a template is loaded (from a set of fixed Excel Sheet) with some data from DB tables, then the user modifies it as he wish on the Excel view, then sends it back and data is stored on DB tables.

Fact is, I don't understand how data can travel back and forth...the only example i found, in the SIOS package, uses an XML file with constant data, is there a way to generate a similar XML at runtime? The format looks the same as when trying to export an ALV report list to XML, but I don't know ho to manage it programatically.

Thanks in advance

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

2 Answers

  • Best Answer
    Feb 24, 2011 at 03:20 PM

    This XML format is the Microsoft Office XML specification. You can find documentation on this format within the Microsoft documentation. You can build up such XML format dynamically (as the ALV does) using either the ABAP iXML libraries, XSLTs, or even just concatenating strings. It isn't a simple matter however and requires good working knowledge of both the expected Microsoft XML format and the usage of the ABAP XML tools.

    Add comment
    10|10000 characters needed characters exceeded

    • Former Member

      Hi, and thanks for the input.

      Since by manually exporting an ALV list to XML format, i get the data in the desired XML format, I assume that there already are function modules or classes in the system to do the conversion for me; or is it a wrong assumption?

      I'm looking at class CL_SALV_WD_EXPORT_UTIL, which exposes a method to convert ALV to XML format, but i can't seem to understand how to use it; and in a Webdynpro context I can't use anything which is GUI-dependent.

      I thought that OfficeControl UI was for "Office Integration", that means there should be a well-defined set of common function, and that i was simply missing how to use them, not that i should learn how to use Microsoft internal XML representation of data.

      So, the OfficeControl is intended to provide an IFrame-like embedding to an Office Document with no high-level support?

  • avatar image
    Former Member
    Apr 15, 2011 at 02:06 PM

    Hi Giuseppe,

    have you manage to implement the above actions, namely : "..then the user modifies it as he wish on the Excel view, then sends it back and data is stored on DB table." ?

    I'm trying to get access to the changed data after the user input but I haven't manage to get an way to do that...

    Have you manage to implement this?

    Best Regards,

    Luis Moita

    Add comment
    10|10000 characters needed characters exceeded

    • Former Member

      I did not manage to manipulate and send data back, I had very short time and could not complete what was simply a feasibility study. The feature was eventually offered as a more easily implementable offline editing.