Reply from giovanniricupero on Apr 18 at 5:07 PM Hi Ann,
I tried to use the reflection technique, but I too was having a hard time.
Instead what I did is to create my java program, placed it in the
PeopleSoft classpath directory, and then referencing the java class through
PeopleCode. I found that solution simpler and less messy PeopleCode. I used
Apache POI to create xls files, but not read them. However I think it's
just as simple. I need to look through my code if there is anything I can
share.
Giovanni
| | | ---------------Original Message---------------
From: Ann Howard
Sent: Wednesday, April 18, 2012 3:53 PM
Subject: Read an Excel File from a PeopleCode Push Button Event Running On a Linux
I need to read an Excel file from a PeopleCode push button event running on a Linux server. I tried to implement the jxl solution from http://thinktibits.blogspot.com/2011/04/read-modify-excel-files-in-peoplecode.html . When I used the reflection techniques exactly as as in the tutorial I ended up with this error from my PeopleCode.
Objects of class java.lang.Class cannot be serialized. (2,694)
The current program requires that the value of an object of the given class be sent across the network, but the class does not support this operation.
When I tried to implement with a wrapper I also got a serialization error that pointed to that class. I would like to either solve my serialization error or implement Apache POI. POI would be ideal so that we could use Excel 2007 but I am a beginner in java.
Does anyone have a solution for the serialization error I am getting with jxl or an example of the PeopleCode to call Apache POI?
Thanks! |
| Reply to this email to post your response. __.____._ |   _.____.__ |
No comments:
Post a Comment