on 02-24-2011 11:39 AM
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
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.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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?
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
88 | |
23 | |
11 | |
9 | |
8 | |
5 | |
5 | |
5 | |
5 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.