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.
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