Coding Cheatsheets - Learn to Code

1. Download XLS sheet in CakePHP In the controller function function downloadXLS(){         $this->set('contacttracker', $this->paginate()); $this->layout = false; header ("Expires: Mon, 28 Oct 2008 05:00:00 GMT"); header ("Last-Modified: " . gmdate("D,d M YH:i:s") . " GMT"); header ("Cache-Control: no-cache, must-revalidate"); header ("Pragma: no-cache"); header ("Content-type: application/vnd.ms-excel"); header ("Content-Disposition: attachment; filename=contacts_".date('d-m-Y').".xls"); header ("Content-Description: Generated Report" ); } In the view section download_xls.ctp <STYLE type="text/css"> .table{font-family:arial; font-size:12px;} .tdheading{font-weight:bold;color:#fff;background-color:#2E2E2E;border-width: 0.5pt;border: solid;border-color:#fff; } .tdcontent{border-width:0.5pt; border: solid;} ...