How to Upload Data through Excel

[Former Member]

Hi Friends,

How to upload the content into the ECC System from Excel file at the same time I have to display the data in Frontend Also.

How to upload the content into the ECC System from Excel file select particular data fields click on submit button that time the data will be saved in ECC System at the same time I have to display the data in Frontend Also.

How to do these two application if u have any example please give that.

Regards

Vijay K

[p330068 · Accepted solution]

Hi Vijay,

Use JXL API and read the excel content row-by-row and store in the context node. Once all row has been read by JXL API then call method for saving data in ECC and bye the same time you can display data in screen.

Hope this will helps you.

thanks

Arun

[Former Member · Accepted solution]

Hi,

can u tell me process.and u have exampls can u send me

[p330068 · Accepted solution]

Hi Vijay

You will need jxl.jar fille to placed in NWDS lib folder.

Please follow the below [LINK|http://jexcelapi.sourceforge.net/]

Thanks

Arun

[Former Member · Accepted solution]

Vijay,

Have a look at the following links. Both are essentially the same.

[http://www.sdn.sap.com/irj/scn/go/portal/prtroot/docs/library/uuid/d0d2ac59-e58f-2c10-9fa8-b8e93ff8d975?quicklink=index&overridelayout=true]

[http://www.sdn.sap.com/irj/scn/weblogs?blog=/pub/wlg/4210] [original link is broken] [original link is broken] [original link is broken];

These would guide you on uploading data from excel into a web dynpro app. Once the data is uploaded into the web dynpro app, you could make a RFC call to save the data in the ECC system.

Regards,

Prathamesh