一、设置PHPExcel单元格文本格式

1.在设置值的时候显示的指定数据类型$objPHPExcel = new PHPExcel();$objPHPExcel->setActiveSheetIndex(0);$objPHPExcel->getActiveSheet()->setTitle('Simple');$objPHPExcel->getActiveSheet()->setCellValueExplicit('D1',123456789033,PHPExcel_Cell_DataType::TYPE_STRING);2.在数字字符串前加一个空格使之成为字符串$objPHPExcel = new PHPExcel();$objPHPExcel->setActiveSheetIndex(0);$objPHPExcel->getActiveSheet()->setTitle('Simple');$objPHPExcel->getActiveSheet()->setCellValue('D1', ' ' . 123456789033);

 二、多sheet

vendor('PHPExcel.PHPExcel');$obpe = new \PHPExcel();//设置当前sheet索引,用于后续的内容操作//一般用在对个Sheet的时候才需要显示调用//缺省情况下,PHPExcel会自动创建第一个SHEET被设置SheetIndex=0//设置SHEET$obpe->setactivesheetindex();$obpe->getActiveSheet()->setTitle('电费');//处理sheet内容//写入多行数据foreach($mulit_arr as $k=>$v){     $k = $k+1;     /* @func 设置列 */    $obpe->getactivesheet()->setcellvalue('A'.$k, $v[0]);    $obpe->getactivesheet()->setcellvalue('B'.$k, $v[1]);    $obpe->getactivesheet()->setcellvalue('C'.$k, $v[2]);}//创建一个新的工作空间(sheet)$obpe->createSheet();$obpe->setactivesheetindex(1);//写入多行数据foreach($mulit_arr as $k=>$v){    $k = $k+1;     /* @func 设置列 */    $obpe->getactivesheet()->setcellvalue('A'.$k, $v[0]);    $obpe->getactivesheet()->setcellvalue('B'.$k, $v[1]);}//写入类容    $obwrite = \PHPExcel_IOFactory::createWriter($obpe, 'Excel5'); //创建一个新的工作空间(sheet)    $obpe->createSheet();    $obpe->setactivesheetindex(1);    //写入多行数据    foreach($mulit_arr as $k=>$v){         $k = $k+1;          /* @func 设置列 */         $obpe->getactivesheet()->setcellvalue('A'.$k, $v[0]);        $obpe->getactivesheet()->setcellvalue('B'.$k, $v[1]);         $obpe->getactivesheet()->setcellvalue('C'.$k, $v[2]);    }                       //写入类容    $obwrite = \PHPExcel_IOFactory::createWriter($obpe, 'Excel5');    //ob_end_clean();    //保存文件    ob_end_clean();//清楚缓存区，解决乱码问题        header('Content-Type: application/vnd.ms-excel');        $name = time();        header('Content-Disposition: attachment;filename="'.$name.'.xls"');        header('Cache-Control: max-age=0');        $obwrite->save('php://output');