on 10-20-2006 1:23 PM
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
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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.
User | Count |
---|---|
87 | |
10 | |
10 | |
9 | |
7 | |
7 | |
6 | |
5 | |
4 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.