今天做phpexcel导出,发现导出如果行(列)超过三四十行(列)就显示发现不可读取的内容。求指教。 ini_set("error_reporting","E_ALL & ~E_NOTICE");
include_once('PHPExcel/Writer/IWriter.php') ;
include_once('PHPExcel/Writer/Excel5.php') ;
include_once('PHPExcel.php') ;
include_once('PHPExcel/IOFactory.php') ;
$list = $post_data['list'];
$totalAll = $post_data['totalAll']; $obj_phpexcel = new PHPExcel();
$obj_phpexcel->getActiveSheet()->getColumnDimension('A')->setWidth(20);
$obj_phpexcel->getActiveSheet()->getColumnDimension('B')->setWidth(25);
$obj_phpexcel->getActiveSheet()->getColumnDimension('C')->setWidth(20);
$obj_phpexcel->getActiveSheet()->getStyle('A1')->applyFromArray(array('font' => array ('size' => '11'),'alignment' => array('horizontal' => PHPExcel_Style_Alignment::HORIZONTAL_CENTER)));
$obj_phpexcel->getActiveSheet()->getStyle('B1')->applyFromArray(array('font' => array ('size' => '11'),'alignment' => array('horizontal' => PHPExcel_Style_Alignment::HORIZONTAL_CENTER)));
$obj_phpexcel->getActiveSheet()->getStyle('C1')->applyFromArray(array('font' => array ('size' => '11'),'alignment' => array('horizontal' => PHPExcel_Style_Alignment::HORIZONTAL_CENTER)));
$obj_phpexcel->getActiveSheet()->getStyle('C3')->applyFromArray(array('font' => array ('size' => '10'),'alignment' => array('horizontal' => PHPExcel_Style_Alignment::HORIZONTAL_CENTER)));
$obj_phpexcel->getActiveSheet()->setCellValue('A1','项目编号');
$obj_phpexcel->getActiveSheet()->setCellValue('B1','销售机会名称');
$obj_phpexcel->getActiveSheet()->setCellValue('C1','本月总成本');
$obj_phpexcel->getActiveSheet()->mergeCells('A1:A3');
$obj_phpexcel->getActiveSheet()->mergeCells('B1:B3');
$obj_phpexcel->getActiveSheet()->mergeCells('C1:C2');
$obj_phpexcel->getActiveSheet()->getStyle('C3')->applyFromArray(array('font' => array ('size' => '10'),'alignment' => array('horizontal' => PHPExcel_Style_Alignment::HORIZONTAL_CENTER)));
$obj_phpexcel->getActiveSheet()->setCellValue('C3',$totalAll); if($list){
$i =4;
foreach ($list as $value) {
$obj_phpexcel->getActiveSheet()->getStyle('A'.$i)->applyFromArray(array('font' => array ('size' => '10'),'alignment' => array('horizontal' => PHPExcel_Style_Alignment::HORIZONTAL_CENTER)));
$obj_phpexcel->getActiveSheet()->getStyle('C'.$i)->applyFromArray(array('font' => array ('size' => '10'),'alignment' => array('horizontal' => PHPExcel_Style_Alignment::HORIZONTAL_CENTER)));
$obj_phpexcel->getActiveSheet()->setCellValue('A'.$i,$value['potentials_id']);
$obj_phpexcel->getActiveSheet()->setCellValue('B'.$i,$value['potentials_name']);
$obj_phpexcel->getActiveSheet()->setCellValue('C'.$i,round($value['total'],2));
$i++;
}
}
$filename = "项目成本.xls";
$filename = iconv("utf-8", 'gbk', $filename);
$obj_Writer = PHPExcel_IOFactory::createWriter($obj_phpexcel,'Excel5');
header ( 'Content-Type: application/vnd.ms-excel' );
header ( "Content-Disposition: attachment;filename=$filename" );
header ( 'Cache-Control: max-age=0' );
$obj_Writer->save('php://output');exit;
include_once('PHPExcel/Writer/IWriter.php') ;
include_once('PHPExcel/Writer/Excel5.php') ;
include_once('PHPExcel.php') ;
include_once('PHPExcel/IOFactory.php') ;
$list = $post_data['list'];
$totalAll = $post_data['totalAll']; $obj_phpexcel = new PHPExcel();
$obj_phpexcel->getActiveSheet()->getColumnDimension('A')->setWidth(20);
$obj_phpexcel->getActiveSheet()->getColumnDimension('B')->setWidth(25);
$obj_phpexcel->getActiveSheet()->getColumnDimension('C')->setWidth(20);
$obj_phpexcel->getActiveSheet()->getStyle('A1')->applyFromArray(array('font' => array ('size' => '11'),'alignment' => array('horizontal' => PHPExcel_Style_Alignment::HORIZONTAL_CENTER)));
$obj_phpexcel->getActiveSheet()->getStyle('B1')->applyFromArray(array('font' => array ('size' => '11'),'alignment' => array('horizontal' => PHPExcel_Style_Alignment::HORIZONTAL_CENTER)));
$obj_phpexcel->getActiveSheet()->getStyle('C1')->applyFromArray(array('font' => array ('size' => '11'),'alignment' => array('horizontal' => PHPExcel_Style_Alignment::HORIZONTAL_CENTER)));
$obj_phpexcel->getActiveSheet()->getStyle('C3')->applyFromArray(array('font' => array ('size' => '10'),'alignment' => array('horizontal' => PHPExcel_Style_Alignment::HORIZONTAL_CENTER)));
$obj_phpexcel->getActiveSheet()->setCellValue('A1','项目编号');
$obj_phpexcel->getActiveSheet()->setCellValue('B1','销售机会名称');
$obj_phpexcel->getActiveSheet()->setCellValue('C1','本月总成本');
$obj_phpexcel->getActiveSheet()->mergeCells('A1:A3');
$obj_phpexcel->getActiveSheet()->mergeCells('B1:B3');
$obj_phpexcel->getActiveSheet()->mergeCells('C1:C2');
$obj_phpexcel->getActiveSheet()->getStyle('C3')->applyFromArray(array('font' => array ('size' => '10'),'alignment' => array('horizontal' => PHPExcel_Style_Alignment::HORIZONTAL_CENTER)));
$obj_phpexcel->getActiveSheet()->setCellValue('C3',$totalAll); if($list){
$i =4;
foreach ($list as $value) {
$obj_phpexcel->getActiveSheet()->getStyle('A'.$i)->applyFromArray(array('font' => array ('size' => '10'),'alignment' => array('horizontal' => PHPExcel_Style_Alignment::HORIZONTAL_CENTER)));
$obj_phpexcel->getActiveSheet()->getStyle('C'.$i)->applyFromArray(array('font' => array ('size' => '10'),'alignment' => array('horizontal' => PHPExcel_Style_Alignment::HORIZONTAL_CENTER)));
$obj_phpexcel->getActiveSheet()->setCellValue('A'.$i,$value['potentials_id']);
$obj_phpexcel->getActiveSheet()->setCellValue('B'.$i,$value['potentials_name']);
$obj_phpexcel->getActiveSheet()->setCellValue('C'.$i,round($value['total'],2));
$i++;
}
}
$filename = "项目成本.xls";
$filename = iconv("utf-8", 'gbk', $filename);
$obj_Writer = PHPExcel_IOFactory::createWriter($obj_phpexcel,'Excel5');
header ( 'Content-Type: application/vnd.ms-excel' );
header ( "Content-Disposition: attachment;filename=$filename" );
header ( 'Cache-Control: max-age=0' );
$obj_Writer->save('php://output');exit;
http://blog.csdn.net/hexiaoniao/article/details/56482459