Hi, I have configured with PHPExcel.

Its working well.  But I'm unable to get column names as header. Can u please help.

$q = mysql_query("select * from mytable");

while($mrow = mysql_fetch_assoc($q)) {
    $col = 0;
    foreach($mrow as $key=>$value) {
        $objPHPExcel->getActiveSheet()->setCellValueByColumnAndRow($col, 0, $key);
        $objPHPExcel->getActiveSheet()->setCellValueByColumnAndRow($col, $row + 1, $value);
        $col++;
    }
    $row++;
 }

I tried the topics posted in the forum, but non was helpful. Is there any other solution to export the data from datagrid with same format to excel. Please help. Need header and data. Thanks.