Export to Excel the loaded data in datagrid

[kiran1234]

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.

[ehussain]

try phpExcel

https://phpexcel.codeplex.com/wikipage?title=Examples&referringTitle=Home

I can help if you want to do phpExcel.

Ejaz

[kiran1234]

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++;
 }

[ehussain]

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

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