Excel Upload and display in a table

[Former Member]

Hi,

I need to upload an excel file and read the contents from the excel sheet and display them in a table.

For this iam using File upload UI element; and a "Upload" button, and a table for displaying the data. I bound the "resource property" of FileUpload Element to a context attribute of type "com.sap.ide.webdynpro.uielementdefinitions.Resource".

I want to upload an excel file, and on the click of the Upload button, i want the contents of the excel sheet to be copied to a table.

Can anyone guide me how to read the contents of the excel file and display them in a table?

Im planning on using HSSF api for reading excel content.

Thanks in advance.

Regards,

Padmalatha.K

[Former Member]

Thank God! I found the answer on sdn itself......