PHP PHPExcel_Writer_Excel5_BIFFwriter::__construct方法代码示例

 /**
  * Constructor
  *
  * @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
  * @param boolean	$preCalculateFormulas	Flag indicating whether formulas should be calculated or just written
  * @param string	$phpSheet		The worksheet to write
  * @param PHPExcel_Worksheet $phpSheet
  */
 public function __construct(&$str_total, &$str_unique, &$str_table, &$colors, $parser, $preCalculateFormulas, $phpSheet)
 {
     // It needs to call its parent's constructor explicitly
     parent::__construct();
     // change BIFFwriter limit for CONTINUE records
     //		$this->_limit = 8224;
     $this->_preCalculateFormulas = $preCalculateFormulas;
     $this->_str_total =& $str_total;
     $this->_str_unique =& $str_unique;
     $this->_str_table =& $str_table;
     $this->_colors =& $colors;
     $this->_parser = $parser;
     $this->_phpSheet = $phpSheet;
     //$this->ext_sheets		= array();
     //$this->offset			= 0;
     $this->_xls_strmax = 255;
     $this->_colinfo = array();
     $this->_selection = array(0, 0, 0, 0);
     $this->_active_pane = 3;
     $this->_print_headers = 0;
     $this->_outline_style = 0;
     $this->_outline_below = 1;
     $this->_outline_right = 1;
     $this->_outline_on = 1;
     $this->_fntHashIndex = array();
     // calculate values for DIMENSIONS record
     $minR = 1;
     $minC = 'A';
     $maxR = $this->_phpSheet->getHighestRow();
     $maxC = $this->_phpSheet->getHighestColumn();
     // Determine lowest and highest column and row
     //		$this->_firstRowIndex = ($minR > 65535) ? 65535 : $minR;
     $this->_lastRowIndex = $maxR > 65535 ? 65535 : $maxR;
     $this->_firstColumnIndex = PHPExcel_Cell::columnIndexFromString($minC);
     $this->_lastColumnIndex = PHPExcel_Cell::columnIndexFromString($maxC);
     //		if ($this->_firstColumnIndex > 255) $this->_firstColumnIndex = 255;
     if ($this->_lastColumnIndex > 255) {
         $this->_lastColumnIndex = 255;
     }
     $this->_countCellStyleXfs = count($phpSheet->getParent()->getCellStyleXfCollection());
 }

 /**
  * 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());
         }
     }
 }

 /**
  * Constructor
  *
  * @param int  $BIFF_version		 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
  * @param string   $tempDir	  The temporary directory to be used
  * @param PHPExcel_Worksheet $phpSheet
  */
 public function __construct($BIFF_version, &$str_total, &$str_unique, &$str_table, &$colors, $parser, $preCalculateFormulas, $phpSheet)
 {
     // It needs to call its parent's constructor explicitly
     parent::__construct();
     $this->_BIFF_version = $BIFF_version;
     if ($BIFF_version == 0x600) {
         // change BIFFwriter limit for CONTINUE records
         $this->_limit = 8224;
     }
     $this->_preCalculateFormulas = $preCalculateFormulas;
     $this->_str_total =& $str_total;
     $this->_str_unique =& $str_unique;
     $this->_str_table =& $str_table;
     $this->_colors =& $colors;
     $this->_parser = $parser;
     $this->_phpSheet = $phpSheet;
     //$this->ext_sheets		= array();
     //$this->offset			= 0;
     $this->_xls_strmax = 255;
     $this->_colinfo = array();
     $this->_selection = array(0, 0, 0, 0);
     $this->_active_pane = 3;
     $this->_print_headers = 0;
     $this->_outline_style = 0;
     $this->_outline_below = 1;
     $this->_outline_right = 1;
     $this->_outline_on = 1;
     // calculate values for DIMENSIONS record
     $this->_firstRowIndex = 0;
     $this->_lastRowIndex = -1;
     $this->_firstColumnIndex = 0;
     $this->_lastColumnIndex = -1;
     foreach ($this->_phpSheet->getCellCollection(false) as $cellID) {
         preg_match('/^(\\w+)(\\d+)$/U', $cellID, $matches);
         list(, $col, $row) = $matches;
         $column = PHPExcel_Cell::columnIndexFromString($col) - 1;
         // Don't break Excel!
         if ($row + 1 > 65536 or $column + 1 > 256) {
             break;
         }
         $this->_firstRowIndex = min($this->_firstRowIndex, $row);
         $this->_lastRowIndex = max($this->_lastRowIndex, $row);
         $this->_firstColumnIndex = min($this->_firstColumnIndex, $column);
         $this->_lastColumnIndex = max($this->_lastColumnIndex, $column);
     }
     $this->_countCellStyleXfs = count($phpSheet->getParent()->getCellStyleXfCollection());
 }

 /**
  * 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, &$colors, $parser)
 {
     // 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->_colors =& $colors;
     $this->_setPaletteXl97();
     $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 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 == 0x600) {
             $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());
         }
     }
 }

	/**
	 * Constructor
	 *
	 * @param int $BIFF_version
	 *        	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
	 * @param string $tempDir
	 *        	The temporary directory to be used
	 * @param PHPExcel_Worksheet $phpSheet        	
	 */
	public function __construct($BIFF_version, &$str_total, &$str_unique, &$str_table, &$colors, $parser, $preCalculateFormulas, $phpSheet) {
		// It needs to call its parent's constructor explicitly
		parent::__construct ();
		
		$this->_BIFF_version = $BIFF_version;
		if ($BIFF_version == 0x0600) {
			// change BIFFwriter limit for CONTINUE records
			$this->_limit = 8224;
		}
		
		$this->_preCalculateFormulas = $preCalculateFormulas;
		$this->_str_total = &$str_total;
		$this->_str_unique = &$str_unique;
		$this->_str_table = &$str_table;
		$this->_colors = &$colors;
		$this->_parser = $parser;
		
		$this->_phpSheet = $phpSheet;
		
		// $this->ext_sheets = array();
		// $this->offset = 0;
		$this->_xls_strmax = 255;
		$this->_colinfo = array ();
		$this->_selection = array (
				0,
				0,
				0,
				0 
		);
		$this->_active_pane = 3;
		
		$this->_print_headers = 0;
		
		$this->_outline_style = 0;
		$this->_outline_below = 1;
		$this->_outline_right = 1;
		$this->_outline_on = 1;
		
		// calculate values for DIMENSIONS record
		$col = $row = array ();
		foreach ( $this->_phpSheet->getCellCollection ( false ) as $cellID ) {
			list ( $c, $r ) = sscanf ( $cellID, '%[A-Z]%d' );
			$row [$r] = $r;
			$col [$c] = strlen ( $c ) . $c;
		}
		// Determine lowest and highest column and row
		$this->_firstRowIndex = (count ( $row ) > 0) ? min ( $row ) : 1;
		$this->_lastRowIndex = (count ( $row ) > 0) ? max ( $row ) : 1;
		if ($this->_firstRowIndex > 65535)
			$this->_firstRowIndex = 65535;
		if ($this->_lastRowIndex > 65535)
			$this->_lastRowIndex = 65535;
		
		$this->_firstColumnIndex = (count ( $col ) > 0) ? PHPExcel_Cell::columnIndexFromString ( substr ( min ( $col ), 1 ) ) : 1;
		$this->_lastColumnIndex = (count ( $col ) > 0) ? PHPExcel_Cell::columnIndexFromString ( substr ( max ( $col ), 1 ) ) : 1;
		
		if ($this->_firstColumnIndex > 255)
			$this->_firstColumnIndex = 255;
		if ($this->_lastColumnIndex > 255)
			$this->_lastColumnIndex = 255;
		
		$this->_countCellStyleXfs = count ( $phpSheet->getParent ()->getCellStyleXfCollection () );
	}

 /**
  * Constructor
  *
  * @param int  $BIFF_version		 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
  * @param string   $tempDir	  The temporary directory to be used
  * @param PHPExcel_Worksheet $phpSheet
  */
 public function __construct($BIFF_version, &$str_total, &$str_unique, &$str_table, $parser, $tempDir = '', $phpSheet)
 {
     // It needs to call its parent's constructor explicitly
     parent::__construct();
     $this->_BIFF_version = $BIFF_version;
     if ($BIFF_version == 0x600) {
         // change BIFFwriter limit for CONTINUE records
         $this->_limit = 8224;
     }
     $this->_str_total =& $str_total;
     $this->_str_unique =& $str_unique;
     $this->_str_table =& $str_table;
     $this->_parser = $parser;
     $this->_phpSheet = $phpSheet;
     //$this->ext_sheets		= array();
     $this->_filehandle = '';
     $this->_using_tmpfile = true;
     //$this->fileclosed		= 0;
     //$this->offset			= 0;
     $this->_xls_strmax = 255;
     $this->_colinfo = array();
     $this->_selection = array(0, 0, 0, 0);
     $this->_active_pane = 3;
     $this->_print_headers = 0;
     $this->_outline_style = 0;
     $this->_outline_below = 1;
     $this->_outline_right = 1;
     $this->_outline_on = 1;
     $this->_dv = array();
     $this->_tmp_dir = $tempDir;
     // calculate values for DIMENSIONS record
     $this->_firstRowIndex = 0;
     $this->_lastRowIndex = -1;
     $this->_firstColumnIndex = 0;
     $this->_lastColumnIndex = -1;
     foreach ($this->_phpSheet->getCellCollection(false) as $cell) {
         $row = $cell->getRow() - 1;
         $column = PHPExcel_Cell::columnIndexFromString($cell->getColumn()) - 1;
         // Don't break Excel!
         if ($row + 1 > 65536 or $column + 1 > 256) {
             break;
         }
         $this->_firstRowIndex = min($this->_firstRowIndex, $row);
         $this->_lastRowIndex = max($this->_lastRowIndex, $row);
         $this->_firstColumnIndex = min($this->_firstColumnIndex, $column);
         $this->_lastColumnIndex = max($this->_lastColumnIndex, $column);
     }
     $this->_initialize();
     $this->_countCellStyleXfs = count($phpSheet->getParent()->getCellStyleXfCollection());
 }