upload xls to sap

[Former Member]

Hi friends ,

how to upload the data from excel to sap but the problem is it has to upload the data based on the header available on the excel can any one give me the solution

Thanks in advance,

sasi

[Former Member]

Hi,

You have to use upload UI element to select the file from your loacal machine. For uploading the file you can get the tutorial in sdn.

To read the data from xl sheet you can use jxl api or hssf api of poi.

jxl requires only one jar file - jxl.jar and hssf requires 4 jar files which you will have to download.

Check the first row when you are reading the data from xl sheet ,and allow to upload the data only if the table headers are matching.

Regards

Deepak

[Former Member]

Hi sasi,

refer

https://www.sdn.sap.com/irj/sdn/go/portal/prtroot/docs/library/uuid/edc2f3c2-0401-0010-8898-acd5b6a9...

Regards,

P.Manivannan

[Former Member]

Hi,

Pl go through this

Regards

Ayyapparaj