setWorkbookSettings

setWorkbookSettings

BASIC / ADVANCED / PREMIUM

Sets workbook settings.

Description
public setWorkbookSettings($options = array())

This method sets workbook settings.

Parameters

options

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

The resulting XLSX looks like:

Release notes
  • phpxlsx 2.5:
    • readOnly, fullCalcOnLoad and forceFullCalc options.
  • phpxlsx 1.0:
    • new method.