Link to home
Start Free TrialLog in
Avatar of heyday2004
heyday2004

asked on

Java and Excel file?

I have a complicated Excel (2007) template with pivot tables, etc. Now I want to automate the excel generation process: fill in the data to this template, auto-refresh the datasource/pivot table, save the file, etc. All automatically done in Java. Is it possible? Is POI capable of doing this? Thanks for any input.
ASKER CERTIFIED SOLUTION
Avatar of mccarl
mccarl
Flag of Australia image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
SOLUTION
Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
SOLUTION
Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
SOLUTION
Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Avatar of heyday2004
heyday2004

ASKER

Thanks for the replies. I'm using Excel 2007, seems JExcelApi doesn't support Excel 2007? My purpose is to automate the excel file generation, i.e. auto refresh pivot table data, etc. Thanks for any further input.
SOLUTION
Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial