当前位置: 代码迷 >> PHP >> 念导出的$objWriter->save('my-test'$id.'xls');里的文件,但实际保存的是整个页面的信息,求大神指点
  详细解决方案

念导出的$objWriter->save('my-test'$id.'xls');里的文件,但实际保存的是整个页面的信息,求大神指点

热度:860   发布时间:2012-12-29 10:28:09.0
想导出的$objWriter->save('my-test'.$id.'.xls');里的文件,但实际保存的是整个页面的信息,求大神指点
$phpexceldao = $db->query("select a.uri,b.order_id,b.product_id,b.qty,b.goods_groups,b.attr,a.product_img ,d.order_sn,d.dateline,c.supplier_name from ".RP_TABLEPRE."order_goods  as b  left join product as a on a.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();
//行高
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','备货期');       
$objPHPExcel->getActiveSheet()->setCellValue('A'.$i,$row[uri]);

$objPHPExcel->getActiveSheet()->setCellValue('B1','采购编号');       
$objPHPExcel->getActiveSheet()->setCellValue('B'.$i,$row[order_id]);

$objPHPExcel->getActiveSheet()->setCellValue('C1','产品型号');       
$objPHPExcel->getActiveSheet()->setCellValue('C'.$i,$row[product_id]);

$objPHPExcel->getActiveSheet()->setCellValue('D1','数量');       
$objPHPExcel->getActiveSheet()->setCellValue('D'.$i,$row[qty]);

$objPHPExcel->getActiveSheet()->setCellValue('E1','品类');       
$objPHPExcel->getActiveSheet()->setCellValue('E'.$i,$row[goods_groups]);

$objPHPExcel->getActiveSheet()->setCellValue('F1','尺码');       
$objPHPExcel->getActiveSheet()->setCellValue('F'.$i,$row[attr]);

$objPHPExcel->getActiveSheet()->setCellValue('H1','订单号');       
$objPHPExcel->getActiveSheet()->setCellValue('H'.$i,$row[order_sn]);

$objPHPExcel->getActiveSheet()->setCellValue('I1','订单日期');       
$objPHPExcel->getActiveSheet()->setCellValue('I'.$i,$row[dateline]);

$objPHPExcel->getActiveSheet()->setCellValue('J1','供应商编号');       
$objPHPExcel->getActiveSheet()->setCellValue('J'.$i,$row[supplier_name]);
//添加图片        
$objPHPExcel->getActiveSheet()->setCellValue('G1','产品图片');  
$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'.$id.'.xls');

  header("Content-type: text/csv");//重要
  相关解决方案