PHP PHPExcel_Writer_Excel5_Parser::setExtSheet方法代码示例

 /**
  * Class constructor
  *
  * @param PHPExcel    $phpExcel        The Workbook
  * @param int        &$str_total        Total number of strings
  * @param int        &$str_unique    Total number of unique strings
  * @param array        &$str_table        String Table
  * @param array        &$colors        Colour Table
  * @param mixed        $parser            The formula parser created for the Workbook
  */
 public function __construct(PHPExcel $phpExcel = null, &$str_total, &$str_unique, &$str_table, &$colors, $parser)
 {
     // It needs to call its parent's constructor explicitly
     parent::__construct();
     $this->parser = $parser;
     $this->biffSize = 0;
     $this->palette = array();
     $this->countryCode = -1;
     $this->strTotal =& $str_total;
     $this->strUnique =& $str_unique;
     $this->strTable =& $str_table;
     $this->colors =& $colors;
     $this->setPaletteXl97();
     $this->phpExcel = $phpExcel;
     // set BIFFwriter limit for CONTINUE records
     //        $this->_limit = 8224;
     $this->codepage = 0x4b0;
     // Add empty sheets and Build color cache
     $countSheets = $phpExcel->getSheetCount();
     for ($i = 0; $i < $countSheets; ++$i) {
         $phpSheet = $phpExcel->getSheet($i);
         $this->parser->setExtSheet($phpSheet->getTitle(), $i);
         // Register worksheet name with parser
         $supbook_index = 0x0;
         $ref = pack('vvv', $supbook_index, $i, $i);
         $this->parser->references[] = $ref;
         // Register reference with parser
         // Sheet tab colors?
         if ($phpSheet->isTabColorSet()) {
             $this->addColor($phpSheet->getTabColor()->getRGB());
         }
     }
 }

	/**
	 * Class constructor
	 *
	 * @param PHPExcel $phpExcel
	 *        	The Workbook
	 * @param int $BIFF_verions
	 *        	BIFF version
	 * @param int $str_total
	 *        	number of strings
	 * @param int $str_unique
	 *        	number of unique strings
	 * @param array $str_table        	
	 * @param mixed $parser
	 *        	The formula parser created for the Workbook
	 */
	public function __construct(PHPExcel $phpExcel = null, $BIFF_version = 0x0600, &$str_total, &$str_unique, &$str_table, &$colors, $parser) {
		// It needs to call its parent's constructor explicitly
		parent::__construct ();
		
		$this->_parser = $parser;
		$this->_biffsize = 0;
		$this->_palette = array ();
		$this->_codepage = 0x04E4; // FIXME: should change for BIFF8
		$this->_country_code = - 1;
		
		$this->_str_total = &$str_total;
		$this->_str_unique = &$str_unique;
		$this->_str_table = &$str_table;
		$this->_colors = &$colors;
		$this->_setPaletteXl97 ();
		
		$this->_phpExcel = $phpExcel;
		
		if ($BIFF_version == 0x0600) {
			$this->_BIFF_version = 0x0600;
			// change BIFFwriter limit for CONTINUE records
			$this->_limit = 8224;
			$this->_codepage = 0x04B0;
		}
		
		// Add empty sheets and Build color cache
		$countSheets = $phpExcel->getSheetCount ();
		for($i = 0; $i < $countSheets; ++ $i) {
			$phpSheet = $phpExcel->getSheet ( $i );
			
			$this->_parser->setExtSheet ( $phpSheet->getTitle (), $i ); // Register
			                                                        // worksheet name
			                                                        // with parser
			                                                        
			// for BIFF8
			if ($this->_BIFF_version == 0x0600) {
				$supbook_index = 0x00;
				$ref = pack ( 'vvv', $supbook_index, $i, $i );
				$this->_parser->_references [] = $ref; // Register reference with
				                                      // parser
			}
			// Sheet tab colors?
			if ($phpSheet->isTabColorSet ()) {
				$this->_addColor ( $phpSheet->getTabColor ()->getRGB () );
			}
		}
	}

 /**
  * Class constructor
  *
  * @param PHPExcel $phpExcel The Workbook
  * @param int $BIFF_verions BIFF version
  * @param int  $str_total		Total number of strings
  * @param int  $str_unique		Total number of unique strings
  * @param array  $str_table
  * @param mixed   $parser	  The formula parser created for the Workbook
  */
 public function __construct(PHPExcel $phpExcel = null, $BIFF_version = 0x600, &$str_total, &$str_unique, &$str_table, $parser, $tempDir = '')
 {
     // It needs to call its parent's constructor explicitly
     parent::__construct();
     $this->_parser = $parser;
     $this->_biffsize = 0;
     $this->_palette = array();
     $this->_codepage = 0x4e4;
     // FIXME: should change for BIFF8
     $this->_country_code = -1;
     $this->_str_total =& $str_total;
     $this->_str_unique =& $str_unique;
     $this->_str_table =& $str_table;
     $this->_setPaletteXl97();
     $this->_tmp_dir = $tempDir;
     $this->_phpExcel = $phpExcel;
     if ($BIFF_version == 0x600) {
         $this->_BIFF_version = 0x600;
         // change BIFFwriter limit for CONTINUE records
         $this->_limit = 8224;
         $this->_codepage = 0x4b0;
     }
     // Add empty sheets
     $countSheets = count($phpExcel->getAllSheets());
     for ($i = 0; $i < $countSheets; ++$i) {
         $phpSheet = $phpExcel->getSheet($i);
         $this->_parser->setExtSheet($phpSheet->getTitle(), $i);
         // Register worksheet name with parser
         // for BIFF8
         if ($this->_BIFF_version == 0x600) {
             $supbook_index = 0x0;
             $ref = pack('vvv', $supbook_index, $i, $i);
             $this->_parser->_references[] = $ref;
             // Register reference with parser
         }
     }
 }