can we import a excel data into the webdynpro

[Former Member]

hi all,

i have a requirement that to read the excel data from the webdynpro application.

i had worked out the example to export the table data into excel, but i want to read the data from the excel

please help me

Thanks in advance

Siva Sankar N

[Former Member]

Hi Siva Sankar,

have you seen the OfficeControl, This might help you:

http://help.sap.com/saphelp_nw2004s/helpdata/en/ef/3483789514b748b6fe1f145e9685ab/frameset.htm

For NW2004 it works a little different, have a look at:

http://help.sap.com/saphelp_nw04/helpdata/de/ef/3483789514b748b6fe1f145e9685ab/frameset.htm

Kind Regards

Stefanie

[Former Member]

hi,

thanks Stafanie.

can we convet the excel data into the table format in the webdynpro application.

[Former Member]

Hi Siva,

U can read the Excel file data and display it in the table.

For reading excel files data remember to add the jxl.jar file in the buildpath.

- Nagarajan.

[Former Member]

Hi,

There seems to be no such option available in Web Dynpro.

However, you can manipulate excel data. Go thru the blog,

/people/perumal.kanthan/blog/2005/03/21/reading-excel-data-from-java-using-hssf-api

Hope this helps.

Regards

Srinivasan T

[Former Member]

Hi Siva,

This can be done.

For this:

1. First upload the excel file and get it in ur context.

2. To read and write an excel sheet u need to add jxl.jar to ur project build path (its an open source)

2. Using JExcel API u can read an excel file and also write into it.

3. Read each cell and set this value to ur context attribute that is binded to ur table column cell.

Below links can guide u the steps to be followed to use the jexcel api:

/people/subramanian.venkateswaran2/blog/2006/08/16/exporting-table-data-to-ms-excel-sheetenhanced-web-dynpro-binary-cache

/people/subramanian.venkateswaran2/blog/2006/10/02/enhanced-file-upload--uploading-and-processing-excel-sheets

Hope this may server ur purpose

Regards,

Aparna.

[Former Member]

hi,

when i am uploading a excel file their was an exception raised, the following was the exception

<b>"Parse method is not possible for this type"</b>

please can any one help me

Thanks in advance