会python真的可以为所欲为0(回)
362天前
这里还有人吗1(回)
547天前这里还有人吗0(回)
547天前
每天面对着电脑屏幕，敲打键盘。我所面对的并不只是代码，而是一种生活方式。0(回)
772天前到处都是羊，不想上班0(回)
852天前
鸽子
0(回)
856天前php 导出页面，不能输出任何其他信息，不能echo print var_dump等，否则，导出EXCEL，，显示无法打开 |
$this->load->library("PHPExcel"); |
$resultPHPExcel = new PHPExcel(); |
$resultPHPExcel->getActiveSheet()->setCellValue('A1', '季度'); |
$resultPHPExcel->getActiveSheet()->setCellValue('B1', '名称'); |
$resultPHPExcel->getActiveSheet()->setCellValue('C1', '数量'); |
$resultPHPExcel->getActiveSheet()->getColumnDimension('A')->setWidth(15); //设置宽度 |
$resultPHPExcel->getActiveSheet()->getColumnDimension('C')->setWidth(35); |
$resultPHPExcel->getActiveSheet()->getColumnDimension('D')->setWidth(15); |
$resultPHPExcel->getActiveSheet()->getColumnDimension('E')->setWidth(30); |
$i = 2; |
|
for($j=0;$j<5;$j++){ |
$resultPHPExcel->getActiveSheet()->setCellValue('A' . $i, $j); |
$resultPHPExcel->getActiveSheet()->setCellValue('B' . $i, $j); |
$resultPHPExcel->getActiveSheet()->setCellValue('C' . $i, $j); |
|
$i ++; |
} |
$title = "报名概况表"; |
$resultPHPExcel->getActiveSheet()->setTitle( $title ); |
// Set active sheet index to the first sheet, so Excel opens this as the first sheet |
$resultPHPExcel->setActiveSheetIndex(0); |
// Redirect output to a client’s web browser (Excel2007) |
header('Content-Type: application/vnd.openxmlformats-officedocument.spreadsheetml.sheet'); |
header('Content-Disposition: attachment;filename="'.$title.'.xlsx"'); |
header('Cache-Control: max-age=0'); |
|
$objWriter = PHPExcel_IOFactory::createWriter($resultPHPExcel, 'Excel2007'); |
$objWriter->save('php://output'); |
exit; |
//设置字段类型 |
$resultPHPExcel->getActiveSheet()->setCellValueExplicit('C'.$i,$v['z']['shenfenhao'],PHPExcel_Cell_DataType::TYPE_STRING); |
$resultPHPExcel->getActiveSheet()->getStyle('C'.$i)->getNumberFormat()->setFormatCode("@"); |
