Export query content to excel through any of your controllers, also can set cssClass for header/odd/even rows, auto download
To generate excel by query content, and download through any controller. You also can bind cssClass to header/odd/even rows. As for header, you even can set cssClass for each column.
$this->export2excel($excel_content,$excel_file);
in your controller.