Reading data from .xls file(MSExcel) through SunSeeBeyond?

Hi Folks,

We need to read the data and process the same from .xls file(EXCELFile).I was tring the same using file eWay and I was getting some marshal exception while creating the project itself and later I came to know that we need to use COM/DCOM eWay to read the data from MicroSoft product(Word,Excel and etc).But I am not very much familiar with COM/DCOM eWay.If anybody have done the same earlier please give reply..

Thanks in Advance,

Renga.S.

[474 byte] By [RengaScreen] at [2007-11-26 11:28:20]
# 1
hi renga,give http://jakarta.apache.org/poi/ a try.tragrds chris
ChrisBrennsteiner at 2007-7-7 3:44:00 > top of Java-index,Java Enterprise System,Java Composite Application Platform Suite -- General Discussion...
# 2
Another alternative would be to consider the OpenOffice SDK : http://download.openoffice.org/680/sdk.htmlSeb
sebsto at 2007-7-7 3:44:00 > top of Java-index,Java Enterprise System,Java Composite Application Platform Suite -- General Discussion...
# 3
We use poi to write .xls. It works fine.
AKsuited at 2007-7-7 3:44:00 > top of Java-index,Java Enterprise System,Java Composite Application Platform Suite -- General Discussion...
# 4
Hi,How can I use POI API inside the JCD.Is there any jar file which I need to import into my project and JCD,and I f I want to invoke this POI api what are the setting/configurations to be done.Thanks,Renga.S.
RengaScreen at 2007-7-7 3:44:00 > top of Java-index,Java Enterprise System,Java Composite Application Platform Suite -- General Discussion...
# 5
hi renga,yes you have o download api from apache and in clude it into your jcd.see using jars in manual of egate.regards chris
ChrisBrennsteiner at 2007-7-7 3:44:00 > top of Java-index,Java Enterprise System,Java Composite Application Platform Suite -- General Discussion...