setSheetSettings

setSheetSettings

BASIC / ADVANCED / PREMIUM

Sets sheet settings.

Description
public setSheetSettings($options = array())

This method sets sheet settings.

Parameters

options

Key Type Description
activeCell string Active cell.
color string HEX value.
marginTop float Measurement in inches.
marginRight float Measurement in inches.
marginBottom float Measurement in inches.
marginLeft float Measurement in inches.
marginHeader float Measurement in inches.
marginFooter float Measurement in inches.
orient string portrait, landscape.
paperType string A4, A3, letter, legal, A4-landscape, A3-landscape, letter-landscape, legal-landscape.
rtl bool Set to true for right to left.
state string hidden, visible.
tabSelected bool Tab selected.
view string View mode: normal, pageBreakPreview, pageLayout.
Code samples

Example #1

The resulting XLSX looks like:

Release notes
  • phpxlsx 3.0:
    • color option.
  • phpxlsx 2.0:
    • state and view options.
  • phpxlsx 1.0:
    • new method.