on 04-08-2009 11:05 AM
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
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.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
82 | |
10 | |
10 | |
9 | |
6 | |
6 | |
5 | |
5 | |
4 | |
3 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.