Excel import export using Office Control

[Former Member]

Hi,

We have the requirement to provide a feature like an excel uplaod and download in our UI (WD ABAP).Basically we have some WD table view and we need to collect all the data in each cell and then download the data in an excel file.Similarly we need to get the data in the Excel and fill the table view with this data from the excel.

Is this possible through the Office Control?I checked out the examples in SIOS but my impression was that it more or less embeds office objects(excel,word etc) in Webdynpro container,but does not really get the data to be filled in an internal table.Also I am not sure whether I can download data from my WD table view to an excel file using this.

Can anyone please tell me if there is some way to do this through an office control.If not what are the options available for me to achieve this functionality.

Thanks and Regards

Sourav

[Former Member]

Hi Sourav,

If you use WDP ALV table, it has an 'Export' functionality which will export the contents of the table into an Excel.

Regards,

Wenonah

[Former Member]

Hi Wenonah

Thanks for your reply,but we dont use an ALV table we use WD Table.

Best regards

Sourav