Some month ago I had the task to implement a reporting for learning activities. One requirement was an export into an existing Excel worksheet, having prepared pivot tables and charts. My first intention was to look for existing solutions and I tried to build it using PHPExcel. Unfortunately the library is converting input files in an internal format which is not capable of holding charts and pivot tables. Since i didn’t find any other tool to reach my goal, I started to implement my own solution, which i published as open source:
Briefly, exceldatatables takes an existing excel file as template and only overwrites the last worksheet with your report data. Therefor any pivot table or chart is untouched and loading the result file with Excel updates these summaries.
So if you are looking for an easy way to write reports into an excel file, try this library and if you have any issues, tell me!