Excel over HTTP or SOAP question.

[Guest]

I am a complete newbie to the Excel plug-in programming and
was hoping to collect some references for further reading.
I am thinking of writing a plug-in that would interact with
an existing j2ee app. Is that possible? If you need to
know more what I'm trying to do: I have a web app that has
been recently getting a lot of enhancement request to do
with excel support. People want to be able to upload input
data into the up as an excel sheet, rather than manually
type it in, as well as request custom reports as fancy
excel sheets. Until now I've been using POI, a Jakarta
freebie that is both buggy and flaky, so I've been thinking
perhaps I'll move excel support out of java and into excel
itself. Thank you in advance,
Igor.

 

[Jake Marx]

Hi Igor,

I'm not sure about the uploading Excel workbooks part. Do you want entire
workbooks to be uploaded, or just data? What is the site doing with the
workbooks/data to be uploaded?

For the report generation piece, you may want to check this product out:

http://officewriter.softartisans.com/default.aspx?PageID=37

I haven't used it, but it looks promising. And it is probably much better
than automating Excel on the server, which can lead to memory leaks, hanging
instances of Excel, etc.

--
Regards,

Jake Marx
www.longhead.com

[please keep replies in the newsgroup - email address unmonitored]