how to upload excel and word file in web dynpro application

[Former Member]

Dear friends,

i m creating one web dynpro application in abap. in my application my requirement is to upload exce file and word file into application from pc. in case of excel file, i want to upload it into internal table and process it then.

in case of word file, i have to save it into database. do i need to create and so10 object for save this word file or can save directly into database.

so how can i implement these task. plz guide me.

[Former Member]

Sunil,

check these links for excel upload

http://wiki.sdn.sap.com/wiki/display/WDABAP/ExcelFileUploadAndDisplayDataUsingWebDynPro+ABAP

http://wiki.sdn.sap.com/wiki/display/WDABAP/ModifyingexistingexcelsheetusingWDABAP

check this for word

http://help.sap.com/saphelp_sm40/helpdata/en/8e/128b41b4b3b55fe10000000a1550b0/content.htm

Thanks

Bala Duvvuri

Edited by: Bala Duvvuri on Jun 23, 2010 1:20 AM

[Former Member]

HI BALA,

THANX FOR YOUR REPLY.

I TRIED YOUR SOLUTION. BT WHEN I DISPLAY DATA ON TABLE DATA DISPLAY IN FORMAT OF STRING FORMAT. NOT IN CHAR FORMAT. IN YOUR CODE , THERE IS CONVERSION OF XSTRING TO STRING BT NOT FROM XSTRING TO STRING.

COULD YOU TELL ME HOW TO DISPLAY DATA INTO CHAR FORMAT.

THANX,

SUNIL

[Former Member]

Hi,

use FM CRM_IC_XML_STRING2XSTRING for conversion from string to xstring; likewise, CRM_IC_XML_XSTRING2STRING converts the other way.

Regards,

Trond

[Former Member]

Hi ,

You can't directly upload a Excel file contents..

Please check the below thread for the right solution

Regards,

Lakshmi.