Import Data from Office Control (Web Dynpro for ABAP) into SAP-Table

[Former Member]

Hello,

I have a question concerning the Office Control UI-Eelement in Web Dynpro for ABAP:

How can I import spreadsheet data from the Office Control in a SAP-table?

I have an Excel-sheet (without any data) which is shown initially in the Office Control. First the empty Excel-Sheet will be loaded and in the second step data from an alvxml-transformation will be loaded into the Excel-sheet with the method 'activatexmlsource'. This works so far. When I change the loaded data in the Office Control and save it it will be stored as XLS-File. The problem is that I'm not able to use existing Upload-FM because every function module I tried uses GUI-functions and WebDynpro has no GUI-functionality. I always get the error that data from clipboard cannot be imported.

So now the question is:

How can I import changed data from the Office control into a SAP-table staying in Web Dynpro application?

Please give some advice, if you have some useful code or ideas.

Thanks in advance,

Philipp

Edited by: Philipp Hiebler on Feb 11, 2008 10:15 AM

[Former Member]

Hi,

Once you save to desktop again you have made some changes to that file, this file you want to upload it right.

Then in that case you need to use the FILEUPLOAD UI element right.

Regards,

Lekha.

[Former Member]

Hi Lekha,

changed data from the Office control into a SAP-table.

thanks.

rama

[Former Member]

hi Philipp,

my requirement also same ,please help me on this..

thanks,

RAMA