office control ui element spread sheet

[Former Member]

Hi exprots,

My requirememt i want display reoptr in spread sheet by using office control ui element spread sheet(EXCEL) DEMO EXAMPLE TYPE IOS_TEST_SPREADSHEET_MS. I need to get data from data base directly display EXCEL spread sheet, after getting data ,edit and submit to sap database.

thanks

Rama.

[Former Member]

Hi,

You can open it in Office control, when you edit the

same excel then you need to use the Filedonwload/Upload UI element

to save the same data to the database right.

Regards,

Lekha.

[Former Member]

Hi Lekha,

how to map sap data base fields to office control ui element MS_EXCEL(SPREAD SHEET).

is it possible by writing code?

But in interactive control we cam map from context.

thanks,

Rama

[Former Member]

Hi,

There is a DATACOURCE where you can bind the node.

Create a context attribute of type XSTRING and fill some data to thisand bind this to the DATASOUCRCE property of this UI element.

Regards.

Lekha.

[Former Member]

Hi Lekha,

how to display itab data into Spread sheet(excel office conteol ui) by usying datas type xstring.

please sed me code (from internal table data to (excel office conteol ui)).

thanks,

Rama

Edited by: Ramakullay Challa on Sep 5, 2009 12:33 PM

Edited by: Ramakullay Challa on Sep 5, 2009 12:34 PM

[Former Member]

Hi ,

how to display itab data into Spread sheet(excel office conteol ui) by usying datas type xstring.

please sed me code (from internal table data to (excel office conteol ui)).

thanks,

Rama

[Former Member]

Hi,

loop at itab_sflight into ls_sflight.

concatenate text ls_sflight-mandt

ls_sflight-carrid

ls_sflight-connid

ls_sflight-fldate

ls_sflight-currency

ls_sflight-planetype

cl_abap_char_utilities=>newline into text separated by

cl_abap_char_utilities=>horizontal_tab.

endloop.

call function 'SCMS_STRING_TO_XSTRING'

exporting

text = text

importing

buffer = datas.

how to fill office control ui ?

datas to datasource .

could you guys please help me on this

thanks

Rama

Edited by: Ramakullay Challa on Sep 15, 2009 10:50 AM

[Former Member]

Hi,

Create a node with an attribute content type XSTRING.

What ever data you got, bind it to this node.Then bind the DATASOURCE of office UI to this CONTENT attribute.

Regards,

Lekha.

[Former Member]

Hi Lekha ,

Thanks your reply, I already did ,but it showing empty excel.

thanks

Rama

[Former Member]

ok

Edited by: Ramakullay Challa on Sep 23, 2009 3:14 PM

[Former Member]

Hi,

can you please tell me how did you resolved this issue. I did similar coding in my WD application but getting blank xls file.

rgds

sudhanshu