How to export Views data in separate sheets/tables to Excel file? I've two content types say Reports-1 and Reports-2. Using views I've displayed them as shown in the image. Reports-2 is attachment for Reports-1.

I used Views Calc to display sum at bottom of the table. (Total SUM)


By using Views data export module I could able to export data to Excel format. 

Right now the exported excel looks like follows. 


But my question is is there any possibility to show the data in separate tables with headers as Reports-1 and Reports-2? (like following image) to recognize the Reports. I need to display sum as well for Individual reports. 

I'm also thinking to export views in different sheet of the same Excel. Is it possible?.



Can I do modifications on views-data-export tpl files. Is there any chance to render views output there? Any hints/suggestions!! ?
You can do it by using Phpexcel

check out the above link.may it will help you.
i have customised my excel and csv files using phpexcel and it works great their.