on 10-08-2013 7:41 AM
Hi,
I have a requirement to get the contents of an excel file and displaying it in a table. I have tried the code in scn but nothing works.
Can anyone please provide me the complete steps for this.
Thanks,
Murali Krishnan
Hi Murali,
Please follow the article Uploading excel file using WebDynpro for Java. There it has been given step by step procedure for reading cells of excel file and uploading the same in WebDynpro table.
Reply with proper explanation if you have any problems.
Regards,
Prasanna
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi Murali,
To use the jxl.jar for reading excel, excel should be in '97-2003 workbook' format with extension '.xls'. if you use higher versions you will get BiffException.
The code given in the article will work fine in NWDS7.3 also, no need to change anything.
But make sure you have pasted the jxl.jar file in proper location. follow javalangnoclassdeffounderror--not-again for more information where to copy jar file(only if you get build error or classNotFound exception in runtime).
Regards
Prasanna N
Hi Murali,
You are using FileUpload UI element for uploading excel right?? if so you can upload from the location you specified. on upload a path name will be generated for the location where the file is stored in RFC. That path name you should take while reading the contents of excel. The steps are same if you are following the article Uploading excel file using WebDynpro for Java.
Regarding exception, can you please provide the trace of exception?
Regards,
Prasanna N
Hope this helps!!
Regards
Vijay Kalluri
you should debug to see why it is not working
it is so basic,
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
101 | |
13 | |
13 | |
11 | |
11 | |
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.