PHPExcel の使用時に発生するいくつかの小さな問題

<?
//首先要导入phpexcel
require_once ($yourpath.'PHPExcel.php');
//创建phpexcel对象
$objPHPExcel = new PHPExcel ();
//设置属性
$objPHPExcel->getProperties ()->setCreator ( "Miss Yang" )
		->setLastModifiedBy ( "Miss Yang" )
		->setTitle ( "Office 2003 XLS Document" )
		->setSubject ( "Office 2003 XLS Document" )
		->setDescription ( "TrunkBow" )
		->setKeywords ( "TrunkBow" )
		->setCategory ( "TrunkBow" );
        
//设置当前的sheet索引，用于后续的内容操作。  
//缺省情况下，PHPExcel会自动创建第一个sheet被设置SheetIndex=0  
$objExcel->setActiveSheetIndex(0); 
$objActSheet = $objExcel->getActiveSheet();  
 
 //设置当前活动sheet的名称  
$objActSheet->setTitle('Sheet1');  

//设置单元格内容
 $objActSheet->setCellValue('A1', '字符串内容');  // 字符串内容  
 $objActSheet->setCellValue('A2', 26);            // 数值  
 $objActSheet->setCellValue('A3', true);          // 布尔值  
 $objActSheet->setCellValue('A4', '=SUM(A2:A2)'); // 公式   

//显式指定内容类型  
 $objActSheet->setCellValueExplicit('A5','8757584',PHPExcel_Cell_DataType::TYPE_STRING);

//设置单元格格式
$objActSheet ->getStyle ('A1' )
             ->getFont ()
             ->getColor()
             ->setARGB(PHPExcel_Style_Color::COLOR_RED);   
$objActSheet ->getStyle ('A1' )
             ->getFont ()
             ->setBold(true); 
$objActSheet ->getStyle ('A')
             ->getNumberFormat()
             ->setFormatCode ( PHPExcel_Style_NumberFormat::FORMAT_TEXT );
$objActSheet ->getColumnDimension ('A')
             ->setWidth(20); 
$objActSheet ->getColumnDimension ('B')
             ->setAutoSize(true); 
$activeSheet ->getColumnDimension('C')
             ->setVisible(false); 

//生成下拉列表框
$list = "item1,item2,item3";
$objValidation1 = $activeSheet->getCell('A1')->getDataValidation();
$objValidation1->setType( PHPExcel_Cell_DataValidation::TYPE_LIST )
               ->setErrorStyle(PHPExcel_Cell_DataValidation::STYLE_INFORMATION )
               ->setAllowBlank(false)
               ->setShowInputMessage(true)
               ->setShowErrorMessage(true)
               ->setShowDropDown(true)
               ->setErrorTitle('输入的值有误')
               ->setError('您输入的值不在下拉框列表内.')
               ->setPromptTitle('下拉选择框')
               ->setPrompt('请从下拉框中选择您需要的值！')
               ->setFormula1('"' . $list . '"');    

//下载输出
$filename = "testphp.xls";
$filename = iconv("utf-8", 'gbk', $filename);
$objWriter = PHPExcel_IOFactory::createWriter ( $objPHPExcel, 'Excel5' );
header ( 'Content-Type: application/vnd.ms-excel' );
header ( "Content-Disposition: attachment;filename=$filename" );
header ( 'Cache-Control: max-age=0' );
$objWriter->save ( 'php://output' );
exit(0);   

//显示指定内容类型
 $objActSheet->setCellValueExplicit('A5','8757584',PHPExcel_Cell_DataType::TYPE_STRING); 

$cacheMethod = PHPExcel_CachedObjectStorageFactory::cache_in_memory; 
PHPExcel_Settings::setCacheStorageMethod($cacheMethod); 

$cacheMethod = PHPExcel_CachedObjectStorageFactory:: cache_to_phpTemp; 
$cacheSettings = array( ' memoryCacheSize ' => '8MB' ); 
PHPExcel_Settings::setCacheStorageMethod($cacheMethod, $cacheSettings); 

$cacheMethod = PHPExcel_CachedObjectStorageFactory::cache_to_APC; 
$cacheSettings = array( 'cacheTime' => 600 ); 
PHPExcel_Settings::setCacheStorageMethod($cacheMethod, $cacheSettings); ?

$cacheMethod = PHPExcel_CachedObjectStorageFactory::cache_to_memcache; 
$cacheSettings = array( 'memcacheServer'=> 'localhost', 
                                       'memcachePort' => 11211, 
                                       'cacheTime' => 600 );  
PHPExcel_Settings::setCacheStorageMethod($cacheMethod, $cacheSettings); 

//解决下拉框数据来源字串长度过大：将每个来源字串分解到一个空闲的单元格中
$str_list = "item1,item2,item3,......" ;
$str_len = strlen($str_list);
if($str_len>=255){
        $str_list_arr = explode(',', $str_list); 
        if($str_list_arr) 
              foreach($str_list_arr as $i =>$d){
                     $c = "P".($i+1);
                     $activeSheet->setCellValue($c,$d); 
               } 
         $endcell = $c;
         $activeSheet->getColumnDimension('P')->setVisible(false); 
} 

$objValidation2 = $activeSheet->getCell("A1")->getDataValidation(); 
$objValidation2->setType( PHPExcel_Cell_DataValidation::TYPE_LIST ) 
                ->setErrorStyle( PHPExcel_Cell_DataValidation::STYLE_INFORMATION ) 
               ->setAllowBlank(true) 
               ->setShowInputMessage(true)
               ->setShowErrorMessage(true) 
               ->setShowDropDown(true)
               ->setErrorTitle('输入的值有误') 
               ->setError('您输入的值不在下拉框列表内.')
               ->setPromptTitle('下拉选择框')
               ->setPrompt('请从下拉框中选择您需要的值！');
if($str_len<255) 
       $objValidation2->setFormula1('"' . $str_list . '"'); 
else 
       $objValidation2->setFormula1("sheet1!P1:{$endcell}");