导出数据超出EXCEL行列本身限制时如何解决！！！

1、//导入PHPExcel类库，因为PHPExcel没有用命名空间，只能inport导入
import("OrgUtilPHPExcel");
import("OrgUtilPHPExcelWriterExcel5");
import("OrgUtilPHPExcelIOFactoryphp");
$date = date("Y_m_d",time());
$fileName = "_{$date}xls";
2、 //创建PHPExcel对象，注意，不能少了\
$objPHPExcel = new \PHPExcel();
$objProps = $objPHPExcel->getProperties();
3、//设置表头
$key = 0;
4、 //print_r($headArr);exit;
foreach($headArr as $v){
5、//注意，不能少了。将列数字转换为字母\
$colum = \PHPExcel_Cell::stringFromColumnIndex($key);
$objPHPExcel->setActiveSheetIndex(0) ->setCellValue($colum'1', $v);
$key += 1; }
$column = 2;
$objActSheet = $objPHPExcel->getActiveSheet();
foreach($data as $key => $rows){ //行写入 $span = 0;
foreach($rows as $keyName=>$value){// 列写入
$j = \PHPExcel_Cell::stringFromColumnIndex($span);
$objActSheet->setCellValue($j$column, $value);
$span++; }
$column++; }
$fileName = iconv("utf-8", "gb2312", $fileName);
7、//重命名表
$objPHPExcel->getActiveSheet()->setTitle($date);
8、//设置字体大小
$objPHPExcel->getDefaultStyle()->getFont()->setSize(14);
9、 //设置单元格宽度
$objPHPExcel->getActiveSheet()->getColumnDimension('A')->setWidth(15);
10、 //设置默认行高
$objPHPExcel->getActiveSheet()->getDefaultRowDimension()->setRowHeight(23);
11、//设置活动单指数到第一个表,所以Excel打开这是第一个表
$objPHPExcel->setActiveSheetIndex(0);
header('Content-Type: application/vndms-excel');
header("Content-Disposition: attachment;filename=\"$fileName\"");
header('Cache-Control: max-age=0');
$objWriter = \PHPExcel_IOFactory::createWriter($objPHPExcel, 'Excel5');
$objWriter->save('php://output'); //文件通过浏览器下载exit;}

去找phpexeelPHPExcel 是相当强大的 MS Office Excel 文档生成类库，当需要输出比较复杂格式数据的时候，PHPExcel 是个不错的选择。不过其使用方法相对来说也就有些繁琐。列举以记之。view plaincopy to clipboardprint< //设置PHPExcel类库的include path set_include_path('logogif'); $objDrawing->setHeight(36); $objDrawing->setCoordinates('C23'); $objDrawing->setOffsetX(10); $objDrawing->setRotation(15); $objDrawing->getShadow()->setVisible(true); $objDrawing->getShadow()->setDirection(36); $objDrawing->setWorksheet($objActSheet); //添加一个新的worksheet $objExcel->createSheet(); $objExcel->getSheet(1)->setTitle('测试2'); //保护单元格 $objExcel->getSheet(1)->getProtection()->setSheet(true); $objExcel->getSheet(1)->protectCells('A1:C22', 'PHPExcel'); // //输出内容 // $outputFileName = "outputxls"; //到文件 ////$objWriter->save($outputFileName); //or //到浏览器 ////header("Content-Type: application/force-download"); ////header("Content-Type: application/octet-stream"); ////header("Content-Type: application/download"); ////header('Content-Disposition:inline;filename="'$outputFileName'"'); ////header("Content-Transfer-Encoding: binary"); ////header("Expires: Mon, 26 Jul 1997 05:00:00 GMT"); ////header("Last-Modified: " gmdate("D, d M Y H:i:s") " GMT"); ////header("Cache-Control: must-revalidate, post-check=0, pre-check=0"); ////header("Pragma: no-cache"); ////$objWriter->save('php://output'); >

---