The file in the $ objWriter-> save('my-test'.mongoid.'.xls '); to be exported, but the information of the entire page is saved.

The exported objects are stored in the 'my-test'.mongoid.'.xls 'file, but the information on the entire page is saved. for details, see $ phpexceldao = $ db-& gt; query (& quot; selecta. uri, B want to export the $ objWriter-> save('my-test'.mongoid.'.xls '); file, but actually save the information of the entire page.
$ Phpexceldao = $ db-> query ("select. uri, B. order_id, B. product_id, B. qty, B. goods_groups, B. attr,. product_img, d. order_sn, d. dateline, c. supplier_name from ". RP_TABLEPRE. "order_goods as B left join product as a on. product_id = B. product_id left join supplier as c on c. supplier_name = B. supplier_name left join 'order' as d on d. order_id = B. order_id where B. order_id = $ id ");


$ ObjPHPExcel = new PHPExcel ();
// Row height
For ($ I = 2; $ I <= 17; $ I ++)
{
$ ObjPHPExcel-> getActiveSheet ()-> getRowDimension ($ I)-> setRowHeight (22 );
}


$ I = 2;
If ($ phpexceldao ){
While ($ row = mysql_fetch_array ($ phpexceldao )){
$ ObjPHPExcel-> getActiveSheet ()-> setCellValue ('A1', 'stocking out ');
$ ObjPHPExcel-> getActiveSheet ()-> setCellValue ('A'. $ I, $ row [uri]);

$ ObjPHPExcel-> getActiveSheet ()-> setCellValue ('b1 ', 'purchase number ');
$ ObjPHPExcel-> getActiveSheet ()-> setCellValue ('B'. $ I, $ row [order_id]);

$ ObjPHPExcel-> getActiveSheet ()-> setCellValue ('C1 ', 'product Model ');
$ ObjPHPExcel-> getActiveSheet ()-> setCellValue ('C'. $ I, $ row [product_id]);

$ ObjPHPExcel-> getActiveSheet ()-> setCellValue ('d1 ', 'qty ');
$ ObjPHPExcel-> getActiveSheet ()-> setCellValue ('D'. $ I, $ row [qty]);

$ ObjPHPExcel-> getActiveSheet ()-> setCellValue ('e1 ', 'category ');
$ ObjPHPExcel-> getActiveSheet ()-> setCellValue ('E'. $ I, $ row [goods_groups]);

$ ObjPHPExcel-> getActiveSheet ()-> setCellValue ('F1 ', 'size ');
$ ObjPHPExcel-> getActiveSheet ()-> setCellValue ('F'. $ I, $ row [attr]);

$ ObjPHPExcel-> getActiveSheet ()-> setCellValue ('h1 ', 'Order No ');
$ ObjPHPExcel-> getActiveSheet ()-> setCellValue ('H'. $ I, $ row [order_sn]);

$ ObjPHPExcel-> getActiveSheet ()-> setCellValue ('i1', 'Order date ');
$ ObjPHPExcel-> getActiveSheet ()-> setCellValue ('I'. $ I, $ row [dateline]);

$ ObjPHPExcel-> getActiveSheet ()-> setCellValue ('j1', 'vendor number ');
$ ObjPHPExcel-> getActiveSheet ()-> setCellValue ('j'. $ I, $ row [supplier_name]);
// Add an image
$ ObjPHPExcel-> getActiveSheet ()-> setCellValue ('g1 ', 'product image ');
$ ObjDrawing = new PHPExcel_Worksheet_Drawing ();
$ ObjDrawing-> setName ('photo ');
$ ObjDrawing-> setDescription ('photo ');
$ ObjDrawing-> setPath ($ row [product_img]);
$ ObjDrawing-> setHeight (70 );
$ ObjDrawing-> setWidth (20 );
$ ObjDrawing-> setCoordinates ('g'. $ I );
$ ObjDrawing-> setWorksheet ($ objPHPExcel-> getActiveSheet ());

$ I ++;
}
}

}
$ ObjWriter = PHPExcel_IOFactory: createWriter ($ objPHPExcel, 'excel5 ');
$ ObjWriter-> save('my-test'.mongoid.'.xls ');

Header ("Content-type: text/csv"); // important
Header ('content-Disposition: attachment; filename = "test'.$id.'.xls "');
Header ('cache-Control: must-revalidate, post-check = 0, pre-check = 0 ');
Header ("Content-Type: application/vnd. ms-execl ");
Header ('expires: 0 ');
Header ('pragma: public ');

------ Solution --------------------
Header ("Content-type: text/csv"); // important
Header ('content-Disposition: attachment; filename = "test'.$id.'.xls "');
Header ('cache-Control: must-revalidate, post-check = 0, pre-check = 0 ');
Header ("Content-Type: application/vnd. ms-execl ");
Header ('expires: 0 ');
Header ('pragma: public ');

Put this section in $ objWriter-> save('my-test'.mongoid.'.xls ');