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

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

WBOY
Freigeben: 2016-06-13 10:21:11
Original
1617 Leute haben es durchsucht

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

------解决方案--------------------
header("Content-type: text/csv");//重要
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');

这段放到$objWriter->save('my-test'.$id.'.xls');前面去

Verwandte Etiketten:
Quelle:php.cn
Erklärung dieser Website
Der Inhalt dieses Artikels wird freiwillig von Internetnutzern beigesteuert und das Urheberrecht liegt beim ursprünglichen Autor. Diese Website übernimmt keine entsprechende rechtliche Verantwortung. Wenn Sie Inhalte finden, bei denen der Verdacht eines Plagiats oder einer Rechtsverletzung besteht, wenden Sie sich bitte an admin@php.cn
Beliebte Tutorials
Mehr>
Neueste Downloads
Mehr>
Web-Effekte
Quellcode der Website
Website-Materialien
Frontend-Vorlage