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

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

WBOY
Release: 2016-06-13 13:01:42
Original
1253 people have browsed it

想导出的$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  {
$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");//重要

Related labels:
source:php.cn
Statement of this Website
The content of this article is voluntarily contributed by netizens, and the copyright belongs to the original author. This site does not assume corresponding legal responsibility. If you find any content suspected of plagiarism or infringement, please contact admin@php.cn
Popular Tutorials
More>
Latest Downloads
More>
Web Effects
Website Source Code
Website Materials
Front End Template