One approach would be to use a multi-tiered solution, where Excel and a your
Java-COM server ran on an NT machine, and your servlet made RMI calls to it.
Excel can function in this manner as a faceless server, because it is a COM
Automation object. You can even instruct it to save a file to a networked
location so that the Servlet can pick up the file later.
IBM alphaWorks has a JavaBean that communicates with Excel, if you want a
demonstration of the COM aspect of this idea.
Another (more complicated, more expensive) solution is to use a Java-CORBA-COM
architecture. Your Java Servlet on Solaris makes CORBA calls to an Excel stub
in a Naming Service that was generated on-the-fly by VisualEdge's ObjectBridge
(a COM-CORBA bridge).
Regards,
David.
> Currently I am generating ASCII flat file, FTPing it to Windows and
> importing it in Excel.
>
> To by-pass this cumbersome process I would like to generate .xls file (on
> the fly), store it on server (Unix) and give a URL for viewing/downloading
> it from browser.
>
> So, I would like to know is it possible to generate .xls (Excel files) from
> Servlets. If so, any pointers to that info is appreciated.
>
> Thanks
> Venkat
>
> ___________________________________________________________________________
> To unsubscribe, send email to [EMAIL PROTECTED] and include in the body
> of the message "signoff SERVLET-INTEREST".
>
> Archives: http://archives.java.sun.com/archives/servlet-interest.html
> Resources: http://java.sun.com/products/servlet/external-resources.html
> LISTSERV Help: http://www.lsoft.com/manuals/user/user.html
--
David Bullock
Project Manager - Strategic Applications
[EMAIL PROTECTED]
"It's no use saying 'We are doing our best.' You
have got to succeed in doing what's necessary."
...Winston Churchill
LISAcorp
http://www.lisa.com.au/
Adelaide Sydney
-------------------- ------------------------
38 Greenhill Rd Level 3, 228 Pitt Street
Wayville S.A. 5034 Sydney NSW 2000
PH +61 8 8272 1555 PH +61 2 9283 0877
FAX +61 8 8271 1199 FAX +61 2 9283 0866
-------------------- ------------------------
___________________________________________________________________________
To unsubscribe, send email to [EMAIL PROTECTED] and include in the body
of the message "signoff SERVLET-INTEREST".
Archives: http://archives.java.sun.com/archives/servlet-interest.html
Resources: http://java.sun.com/products/servlet/external-resources.html
LISTSERV Help: http://www.lsoft.com/manuals/user/user.html
