How to read data from uploaded Excel sheet in NWDS 2004s using file upload

[Former Member]

Hi

I have the following requirement. I am using NWDS 2004s SP9

1] I need to read data in excel sheet,which is uploaded using file upload UI element and display the same in the table in the view.

I have context attribute of type com.sap.ide.webdynpro.uielementdefinitions.Resource which is bound to "resouce" property of the file upload UI element.

How do I read the data from the uploaded excel sheet using this.

2]Download the data in excel sheet using file download UI element.

It would be really helpful if coding sample is provided for the above requirements.

Thanks in advance

Regards

Gauri

[Former Member · Accepted solution]

Hi Gauri,

you can check the API to read the excel file on bellow URL. you can find a tutorial also on the site.

<a href="http://www.andykhan.com/jexcelapi/index.html">http://www.andykhan.com/jexcelapi/index.html</a>

Thanks

Ninad