php使用PHPExcel18 限制38列输出

要限制PHPExcel 1.8输出的列数为38列，可以使用以下代码：

// 加载PHPExcel类库 require_once 'PHPExcel/PHPExcel.php';

// 创建PHPExcel对象 $objPHPExcel = new PHPExcel();

// 设置ActiveSheet的列数为38列 $objPHPExcel->getActiveSheet()->getColumnDimension('A')->setWidth(10); $objPHPExcel->getActiveSheet()->getColumnDimension('B')->setWidth(10); $objPHPExcel->getActiveSheet()->getColumnDimension('C')->setWidth(10); $objPHPExcel->getActiveSheet()->getColumnDimension('D')->setWidth(10); $objPHPExcel->getActiveSheet()->getColumnDimension('E')->setWidth(10); $objPHPExcel->getActiveSheet()->getColumnDimension('F')->setWidth(10); $objPHPExcel->getActiveSheet()->getColumnDimension('G')->setWidth(10); $objPHPExcel->getActiveSheet()->getColumnDimension('H')->setWidth(10); $objPHPExcel->getActiveSheet()->getColumnDimension('I')->setWidth(10); $objPHPExcel->getActiveSheet()->getColumnDimension('J')->setWidth(10); $objPHPExcel->getActiveSheet()->getColumnDimension('K')->setWidth(10); $objPHPExcel->getActiveSheet()->getColumnDimension('L')->setWidth(10); $objPHPExcel->getActiveSheet()->getColumnDimension('M')->setWidth(10); $objPHPExcel->getActiveSheet()->getColumnDimension('N')->setWidth(10); $objPHPExcel->getActiveSheet()->getColumnDimension('O')->setWidth(10); $objPHPExcel->getActiveSheet()->getColumnDimension('P')->setWidth(10); $objPHPExcel->getActiveSheet()->getColumnDimension('Q')->setWidth(10); $objPHPExcel->getActiveSheet()->getColumnDimension('R')->setWidth(10); $objPHPExcel->getActiveSheet()->getColumnDimension('S')->setWidth(10); $objPHPExcel->getActiveSheet()->getColumnDimension('T')->setWidth(10); $objPHPExcel->getActiveSheet()->getColumnDimension('U')->setWidth(10); $objPHPExcel->getActiveSheet()->getColumnDimension('V')->setWidth(10); $objPHPExcel->getActiveSheet()->getColumnDimension('W')->setWidth(10); $objPHPExcel->getActiveSheet()->getColumnDimension('X')->setWidth(10); $objPHPExcel->getActiveSheet()->getColumnDimension('Y')->setWidth(10); $objPHPExcel->getActiveSheet()->getColumnDimension('Z')->setWidth(10); $objPHPExcel->getActiveSheet()->getColumnDimension('AA')->setWidth(10); $objPHPExcel->getActiveSheet()->getColumnDimension('AB')->setWidth(10); $objPHPExcel->getActiveSheet()->getColumnDimension('AC')->setWidth(10); $objPHPExcel->getActiveSheet()->getColumnDimension('AD')->setWidth(10); $objPHPExcel->getActiveSheet()->getColumnDimension('AE')->setWidth(10); $objPHPExcel->getActiveSheet()->getColumnDimension('AF')->setWidth(10); $objPHPExcel->getActiveSheet()->getColumnDimension('AG')->setWidth(10); $objPHPExcel->getActiveSheet()->getColumnDimension('AH')->setWidth(10); $objPHPExcel->getActiveSheet()->getColumnDimension('AI')->setWidth(10); $objPHPExcel->getActiveSheet()->getColumnDimension('AJ')->setWidth(10); $objPHPExcel->getActiveSheet()->getColumnDimension('AK')->setWidth(10); $objPHPExcel->getActiveSheet()->getColumnDimension('AL')->setWidth(10); $objPHPExcel->getActiveSheet()->getColumnDimension('AM')->setWidth(10); $objPHPExcel->getActiveSheet()->getColumnDimension('AN')->setWidth(10); $objPHPExcel->getActiveSheet()->getColumnDimension('AO')->setWidth(10); $objPHPExcel->getActiveSheet()->getColumnDimension('AP')->setWidth(10);

// 输出到浏览器 header('Content-Type: application/vnd.ms-excel'); header('Content-Disposition: attachment;filename="example.xls"'); header('Cache-Control: max-age=0'); $objWriter = PHPExcel_IOFactory::createWriter($objPHPExcel, 'Excel5'); $objWriter->save('php://output');

上述代码将设置ActiveSheet的列数为38列，并输出到浏览器，可以将其保存为Excel文件