setWorkbookSettings

Key	Type	Description
activeSheetAsActiveTab	bool	Active sheet number as the active tab. Default as false.
activeTab	int	Active tab number. The first tab is 0.
forceFullCalc	bool	Enable Force Full Calculation.
fullCalcOnLoad	bool	Enable Full Calculation On Load.
readOnly	bool	Set as read only. Default as false.

Code samples

Example #1

require_once 'classes/CreateXlsx.php';

$xlsx = new CreateXlsx();

// add new sheets
$xlsx->addSheet(array('name'=> 'My 1'));
$xlsx->addSheet(array('name'=> 'Other', 'removeSelected' => true, 'selected' => true, 'active' => true));

// change sheet settings
$xlsx->setSheetSettings(array('tabSelected' => false));

$xlsx->setActiveSheet(array('position' => 1));
$xlsx->setSheetSettings(array('tabSelected' => true));

// set the second sheet as the active tab in the workbook
$xlsx->setWorkbookSettings(array('activeTab' => 1));

$xlsx->saveXlsx('output');

​x
 
require_once 'classes/CreateXlsx.php';
​
$xlsx = new CreateXlsx();
​
// add new sheets
$xlsx->addSheet(array('name'=> 'My 1'));
$xlsx->addSheet(array('name'=> 'Other', 'removeSelected' => true, 'selected' => true, 'active' => true));
​
// change sheet settings
$xlsx->setSheetSettings(array('tabSelected' => false));
​
$xlsx->setActiveSheet(array('position' => 1));
$xlsx->setSheetSettings(array('tabSelected' => true));
​
// set the second sheet as the active tab in the workbook
$xlsx->setWorkbookSettings(array('activeTab' => 1));
​
$xlsx->saveXlsx('output');
​

The resulting XLSX looks like:

Release notes

phpxlsx 2.5:
- readOnly, fullCalcOnLoad and forceFullCalc options.

phpxlsx 1.0:
- new method.