/**
* 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
}
}
}
