Hi,
If any one has requirement of creating tabledata, reports in Excel Microsoft .
Read/write operations with PowerPoint Microsoft.
You can go with a APACHE POI opensource Java library.
As it has some limitations with charts, currently we can create dynamic charts in excel by template approach method..for reference you can refer to the url ExcelChart creation using POI
After googling i found few below chart libraries .