How to export Views data in separate sheets/tables to Excel file?
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.