cancel
Showing results for 
Search instead for 
Did you mean: 

how can i import data from excel sheet to in abap wapdynpro table ui elemen

Former Member
0 Kudos

Hi All i have just joined a comp which works in SAP Tech.

So my task is How to import data from excel sheet to abap webdynpro table.

if u have any solution Pls help me.

Susheel Joshi

Bangalore

Edited by: Thomas Jung on Apr 8, 2009 8:44 AM

Accepted Solutions (0)

Answers (3)

Answers (3)

thomas_jung
Developer Advocate
Developer Advocate
0 Kudos

There are many threads and a few blogs on the topic of importing Excel into ABAP. The FileUpload UI element will get you the content in a binary string, but that is the easy part. If you need to do anything with the data beside store the original file; then you need to parse through the data. ABAP has no functionality to process the native, binary XLS format. Therefore someone must save the file within Excel into one of the more open formats like Text Tab Delimited or XML. Once you have the data in an open format, you can process within ABAP using different techniques. For Text Tab Delimited you can use the SPLIT command to parse the text string. For XML you can use an XSLT or the iXML parser.

Former Member
0 Kudos

hi,

check out this thread :

Thanx.

saket_abhyankar
Active Participant
0 Kudos

Hi

You can use File upload UI element.

refer following link

http://help.sap.com/erp2005_ehp_04/helpdata/EN/b3/be7941601b1d09e10000000a155106/frameset.htm

Regards,

Saket.

Former Member
0 Kudos

Hi saket how r u?thanks .if u have steps for my problem pls send me.

Regards

Susheel