Win a copy of Re-engineering Legacy Software this week in the Refactoring forum
or Docker in Action in the Agile forum!
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic

Automation

 
Ramya Iyer
Ranch Hand
Posts: 66
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Hi,

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.

Thanks,
Ramya.
 
Stan James
(instanceof Sidekick)
Ranch Hand
Posts: 8791
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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.
 
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic