putputPHPExcel.txt文件如何正确使用？

本文共计325个文字，预计阅读时间需要2分钟。

php输出到文件 putputPHPExcel.txt，数组 $arr： $v) { $objPHPExcel->getActiveSheet()->setCellValueByColumnAndRow($i, $j + 1, $v); if ($key==0) { $objPHPExcel->getActiveSheet()->setCellValueByColumnAndRow($i, $j + 1, $v); }}?>

putputPHPExcel.txt

$arr){ //默认第一行有列标题 $i=0; foreach($arr as $k => $v) { $objPHPExcel->setActiveSheetIndex(0)->setCellValue(PHPExcel_Cell::stringFromColumnIndex($i).($j+1),$v); if($key==0){ $objPHPExcel->setActiveSheetIndex(0)->setCellValue(PHPExcel_Cell::stringFromColumnIndex($i).$j,$k); } $i++; } $j++; } //设置默认字体 $objPHPExcel->getDefaultStyle()->getFont()->setName( 'Arial'); $objPHPExcel->getDefaultStyle()->getFont()->setSize(12); //设置列宽 $objPHPExcel->getActiveSheet()->getDefaultColumnDimension()->setWidth(14); $objPHPExcel->getActiveSheet()->getColumnDimension('F')->setWidth(20); //设置居中 $objPHPExcel->getDefaultStyle()->getAlignment()->setHorizontal(PHPExcel_Style_Alignment::HORIZONTAL_CENTER); $objPHPExcel->getDefaultStyle()->getAlignment()->setVertical(PHPExcel_Style_Alignment::VERTICAL_CENTER); //excel保存在根目录下 如要导出文件，以下改为注释代码 //$objPHPExcel->getActiveSheet() -> setTitle('SetExcelName'); //$objPHPExcel-> setActiveSheetIndex(0); //$objWriter = $iofactory -> createWriter($objPHPExcel, 'Excel2007'); //$objWriter -> save('SetExcelName.xlsx'); //导出代码 $objPHPExcel->getActiveSheet() -> setTitle('订单列表'); $objPHPExcel-> setActiveSheetIndex(0); $objWriter=PHPExcel_IOFactory::createWriter($objPHPExcel,'Excel2007'); $filename = '会员列表.xlsx'; ob_end_clean();//清除缓存以免乱码出现 header('Content-Type: application/vnd.ms-excel'); header('Content-Type: application/octet-stream'); header('Content-Disposition: attachment; filename="' . $filename . '"'); header('Cache-Control: max-age=0'); $objWriter -> save('php://output'); //echo PHPExcel_Cell::columnIndexFromString('A'); ?>