File APIs for Java Developers
Manipulate DOC, XLS, PPT, PDF and many others from your application.
The moose likes Java in General and the fly likes Automation Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login
JavaRanch » Java Forums » Java » Java in General
Bookmark "Automation" Watch "Automation" New topic


Ramya Iyer
Ranch Hand

Joined: Jul 29, 2003
Posts: 66

We are planning to automate a manual report generation process, which will comprise of the following

a) Web Interface for the user to view the reports
b) Loading/Processing Data which we obtain in excel files, Loading it into SQL Server database
c) Option to save the report as an excel workbook, which would have all the conditional formatting and other borders, outlining and formats.

Can anyone suggest how to go about with this? I am looking at eSpreedsheets provided by Actuate as one of the options. We are also thinking about which is the best technology to use for this. Java vs Microsoft.

Looking for advise in this regard.

Stan James
(instanceof Sidekick)
Ranch Hand

Joined: Jan 29, 2003
Posts: 8791
Microsoft will make it easier to do complex manipulation of Excel through COM. There are Java COM bridge products (free or expensive) and projects like POI to communicate with Office APIs, but none of them make me completely comfortable.

Can you look at high-dollar commercial solutions? My shop uses Actuate. I have no hands-on experience but I bet it could do what you need with some custom routines.

A good question is never answered. It is not a bolt to be tightened into place but a seed to be planted and to bear more seed toward the hope of greening the landscape of the idea. John Ciardi
I agree. Here's the link:
subject: Automation
It's not a secret anymore!