You are here

class PHPExcel_Worksheet_PageSetup in Loft Data Grids 7.2

Same name and namespace in other branches
  1. 6.2 vendor/phpoffice/phpexcel/Classes/PHPExcel/Worksheet/PageSetup.php \PHPExcel_Worksheet_PageSetup

PHPExcel_Worksheet_PageSetup

<code> Paper size taken from Office Open XML Part 4 - Markup Language Reference, page 1988:

1 = Letter paper (8.5 in. by 11 in.) 2 = Letter small paper (8.5 in. by 11 in.) 3 = Tabloid paper (11 in. by 17 in.) 4 = Ledger paper (17 in. by 11 in.) 5 = Legal paper (8.5 in. by 14 in.) 6 = Statement paper (5.5 in. by 8.5 in.) 7 = Executive paper (7.25 in. by 10.5 in.) 8 = A3 paper (297 mm by 420 mm) 9 = A4 paper (210 mm by 297 mm) 10 = A4 small paper (210 mm by 297 mm) 11 = A5 paper (148 mm by 210 mm) 12 = B4 paper (250 mm by 353 mm) 13 = B5 paper (176 mm by 250 mm) 14 = Folio paper (8.5 in. by 13 in.) 15 = Quarto paper (215 mm by 275 mm) 16 = Standard paper (10 in. by 14 in.) 17 = Standard paper (11 in. by 17 in.) 18 = Note paper (8.5 in. by 11 in.) 19 = #9 envelope (3.875 in. by 8.875 in.) 20 = #10 envelope (4.125 in. by 9.5 in.) 21 = #11 envelope (4.5 in. by 10.375 in.) 22 = #12 envelope (4.75 in. by 11 in.) 23 = #14 envelope (5 in. by 11.5 in.) 24 = C paper (17 in. by 22 in.) 25 = D paper (22 in. by 34 in.) 26 = E paper (34 in. by 44 in.) 27 = DL envelope (110 mm by 220 mm) 28 = C5 envelope (162 mm by 229 mm) 29 = C3 envelope (324 mm by 458 mm) 30 = C4 envelope (229 mm by 324 mm) 31 = C6 envelope (114 mm by 162 mm) 32 = C65 envelope (114 mm by 229 mm) 33 = B4 envelope (250 mm by 353 mm) 34 = B5 envelope (176 mm by 250 mm) 35 = B6 envelope (176 mm by 125 mm) 36 = Italy envelope (110 mm by 230 mm) 37 = Monarch envelope (3.875 in. by 7.5 in.). 38 = 6 3/4 envelope (3.625 in. by 6.5 in.) 39 = US standard fanfold (14.875 in. by 11 in.) 40 = German standard fanfold (8.5 in. by 12 in.) 41 = German legal fanfold (8.5 in. by 13 in.) 42 = ISO B4 (250 mm by 353 mm) 43 = Japanese double postcard (200 mm by 148 mm) 44 = Standard paper (9 in. by 11 in.) 45 = Standard paper (10 in. by 11 in.) 46 = Standard paper (15 in. by 11 in.) 47 = Invite envelope (220 mm by 220 mm) 50 = Letter extra paper (9.275 in. by 12 in.) 51 = Legal extra paper (9.275 in. by 15 in.) 52 = Tabloid extra paper (11.69 in. by 18 in.) 53 = A4 extra paper (236 mm by 322 mm) 54 = Letter transverse paper (8.275 in. by 11 in.) 55 = A4 transverse paper (210 mm by 297 mm) 56 = Letter extra transverse paper (9.275 in. by 12 in.) 57 = SuperA/SuperA/A4 paper (227 mm by 356 mm) 58 = SuperB/SuperB/A3 paper (305 mm by 487 mm) 59 = Letter plus paper (8.5 in. by 12.69 in.) 60 = A4 plus paper (210 mm by 330 mm) 61 = A5 transverse paper (148 mm by 210 mm) 62 = JIS B5 transverse paper (182 mm by 257 mm) 63 = A3 extra paper (322 mm by 445 mm) 64 = A5 extra paper (174 mm by 235 mm) 65 = ISO B5 extra paper (201 mm by 276 mm) 66 = A2 paper (420 mm by 594 mm) 67 = A3 transverse paper (297 mm by 420 mm) 68 = A3 extra transverse paper (322 mm by 445 mm) </code>

@category PHPExcel @package PHPExcel_Worksheet @copyright Copyright (c) 2006 - 2014 PHPExcel (http://www.codeplex.com/PHPExcel)

Hierarchy

Expanded class hierarchy of PHPExcel_Worksheet_PageSetup

File

vendor/phpoffice/phpexcel/Classes/PHPExcel/Worksheet/PageSetup.php, line 107

View source
class PHPExcel_Worksheet_PageSetup {

  /* Paper size */
  const PAPERSIZE_LETTER = 1;
  const PAPERSIZE_LETTER_SMALL = 2;
  const PAPERSIZE_TABLOID = 3;
  const PAPERSIZE_LEDGER = 4;
  const PAPERSIZE_LEGAL = 5;
  const PAPERSIZE_STATEMENT = 6;
  const PAPERSIZE_EXECUTIVE = 7;
  const PAPERSIZE_A3 = 8;
  const PAPERSIZE_A4 = 9;
  const PAPERSIZE_A4_SMALL = 10;
  const PAPERSIZE_A5 = 11;
  const PAPERSIZE_B4 = 12;
  const PAPERSIZE_B5 = 13;
  const PAPERSIZE_FOLIO = 14;
  const PAPERSIZE_QUARTO = 15;
  const PAPERSIZE_STANDARD_1 = 16;
  const PAPERSIZE_STANDARD_2 = 17;
  const PAPERSIZE_NOTE = 18;
  const PAPERSIZE_NO9_ENVELOPE = 19;
  const PAPERSIZE_NO10_ENVELOPE = 20;
  const PAPERSIZE_NO11_ENVELOPE = 21;
  const PAPERSIZE_NO12_ENVELOPE = 22;
  const PAPERSIZE_NO14_ENVELOPE = 23;
  const PAPERSIZE_C = 24;
  const PAPERSIZE_D = 25;
  const PAPERSIZE_E = 26;
  const PAPERSIZE_DL_ENVELOPE = 27;
  const PAPERSIZE_C5_ENVELOPE = 28;
  const PAPERSIZE_C3_ENVELOPE = 29;
  const PAPERSIZE_C4_ENVELOPE = 30;
  const PAPERSIZE_C6_ENVELOPE = 31;
  const PAPERSIZE_C65_ENVELOPE = 32;
  const PAPERSIZE_B4_ENVELOPE = 33;
  const PAPERSIZE_B5_ENVELOPE = 34;
  const PAPERSIZE_B6_ENVELOPE = 35;
  const PAPERSIZE_ITALY_ENVELOPE = 36;
  const PAPERSIZE_MONARCH_ENVELOPE = 37;
  const PAPERSIZE_6_3_4_ENVELOPE = 38;
  const PAPERSIZE_US_STANDARD_FANFOLD = 39;
  const PAPERSIZE_GERMAN_STANDARD_FANFOLD = 40;
  const PAPERSIZE_GERMAN_LEGAL_FANFOLD = 41;
  const PAPERSIZE_ISO_B4 = 42;
  const PAPERSIZE_JAPANESE_DOUBLE_POSTCARD = 43;
  const PAPERSIZE_STANDARD_PAPER_1 = 44;
  const PAPERSIZE_STANDARD_PAPER_2 = 45;
  const PAPERSIZE_STANDARD_PAPER_3 = 46;
  const PAPERSIZE_INVITE_ENVELOPE = 47;
  const PAPERSIZE_LETTER_EXTRA_PAPER = 48;
  const PAPERSIZE_LEGAL_EXTRA_PAPER = 49;
  const PAPERSIZE_TABLOID_EXTRA_PAPER = 50;
  const PAPERSIZE_A4_EXTRA_PAPER = 51;
  const PAPERSIZE_LETTER_TRANSVERSE_PAPER = 52;
  const PAPERSIZE_A4_TRANSVERSE_PAPER = 53;
  const PAPERSIZE_LETTER_EXTRA_TRANSVERSE_PAPER = 54;
  const PAPERSIZE_SUPERA_SUPERA_A4_PAPER = 55;
  const PAPERSIZE_SUPERB_SUPERB_A3_PAPER = 56;
  const PAPERSIZE_LETTER_PLUS_PAPER = 57;
  const PAPERSIZE_A4_PLUS_PAPER = 58;
  const PAPERSIZE_A5_TRANSVERSE_PAPER = 59;
  const PAPERSIZE_JIS_B5_TRANSVERSE_PAPER = 60;
  const PAPERSIZE_A3_EXTRA_PAPER = 61;
  const PAPERSIZE_A5_EXTRA_PAPER = 62;
  const PAPERSIZE_ISO_B5_EXTRA_PAPER = 63;
  const PAPERSIZE_A2_PAPER = 64;
  const PAPERSIZE_A3_TRANSVERSE_PAPER = 65;
  const PAPERSIZE_A3_EXTRA_TRANSVERSE_PAPER = 66;

  /* Page orientation */
  const ORIENTATION_DEFAULT = 'default';
  const ORIENTATION_LANDSCAPE = 'landscape';
  const ORIENTATION_PORTRAIT = 'portrait';

  /* Print Range Set Method */
  const SETPRINTRANGE_OVERWRITE = 'O';
  const SETPRINTRANGE_INSERT = 'I';

  /**
   * Paper size
   *
   * @var int
   */
  private $_paperSize = PHPExcel_Worksheet_PageSetup::PAPERSIZE_LETTER;

  /**
   * Orientation
   *
   * @var string
   */
  private $_orientation = PHPExcel_Worksheet_PageSetup::ORIENTATION_DEFAULT;

  /**
   * Scale (Print Scale)
   *
   * Print scaling. Valid values range from 10 to 400
   * This setting is overridden when fitToWidth and/or fitToHeight are in use
   *
   * @var int?
   */
  private $_scale = 100;

  /**
   * Fit To Page
   * Whether scale or fitToWith / fitToHeight applies
   *
   * @var boolean
   */
  private $_fitToPage = FALSE;

  /**
   * Fit To Height
   * Number of vertical pages to fit on
   *
   * @var int?
   */
  private $_fitToHeight = 1;

  /**
   * Fit To Width
   * Number of horizontal pages to fit on
   *
   * @var int?
   */
  private $_fitToWidth = 1;

  /**
   * Columns to repeat at left
   *
   * @var array Containing start column and end column, empty array if option unset
   */
  private $_columnsToRepeatAtLeft = array(
    '',
    '',
  );

  /**
   * Rows to repeat at top
   *
   * @var array Containing start row number and end row number, empty array if option unset
   */
  private $_rowsToRepeatAtTop = array(
    0,
    0,
  );

  /**
   * Center page horizontally
   *
   * @var boolean
   */
  private $_horizontalCentered = FALSE;

  /**
   * Center page vertically
   *
   * @var boolean
   */
  private $_verticalCentered = FALSE;

  /**
   * Print area
   *
   * @var string
   */
  private $_printArea = NULL;

  /**
   * First page number
   *
   * @var int
   */
  private $_firstPageNumber = NULL;

  /**
   * Create a new PHPExcel_Worksheet_PageSetup
   */
  public function __construct() {
  }

  /**
   * Get Paper Size
   *
   * @return int
   */
  public function getPaperSize() {
    return $this->_paperSize;
  }

  /**
   * Set Paper Size
   *
   * @param int $pValue
   * @return PHPExcel_Worksheet_PageSetup
   */
  public function setPaperSize($pValue = PHPExcel_Worksheet_PageSetup::PAPERSIZE_LETTER) {
    $this->_paperSize = $pValue;
    return $this;
  }

  /**
   * Get Orientation
   *
   * @return string
   */
  public function getOrientation() {
    return $this->_orientation;
  }

  /**
   * Set Orientation
   *
   * @param string $pValue
   * @return PHPExcel_Worksheet_PageSetup
   */
  public function setOrientation($pValue = PHPExcel_Worksheet_PageSetup::ORIENTATION_DEFAULT) {
    $this->_orientation = $pValue;
    return $this;
  }

  /**
   * Get Scale
   *
   * @return int?
   */
  public function getScale() {
    return $this->_scale;
  }

  /**
   * Set Scale
   *
   * Print scaling. Valid values range from 10 to 400
   * This setting is overridden when fitToWidth and/or fitToHeight are in use
   *
   * @param 	int?	$pValue
   * @param boolean	$pUpdate	Update fitToPage so scaling applies rather than fitToHeight / fitToWidth
   * @return PHPExcel_Worksheet_PageSetup
   * @throws 	PHPExcel_Exception
   */
  public function setScale($pValue = 100, $pUpdate = true) {

    // Microsoft Office Excel 2007 only allows setting a scale between 10 and 400 via the user interface,
    // but it is apparently still able to handle any scale >= 0, where 0 results in 100
    if ($pValue >= 0 || is_null($pValue)) {
      $this->_scale = $pValue;
      if ($pUpdate) {
        $this->_fitToPage = false;
      }
    }
    else {
      throw new PHPExcel_Exception("Scale must not be negative");
    }
    return $this;
  }

  /**
   * Get Fit To Page
   *
   * @return boolean
   */
  public function getFitToPage() {
    return $this->_fitToPage;
  }

  /**
   * Set Fit To Page
   *
   * @param boolean $pValue
   * @return PHPExcel_Worksheet_PageSetup
   */
  public function setFitToPage($pValue = TRUE) {
    $this->_fitToPage = $pValue;
    return $this;
  }

  /**
   * Get Fit To Height
   *
   * @return int?
   */
  public function getFitToHeight() {
    return $this->_fitToHeight;
  }

  /**
   * Set Fit To Height
   *
   * @param int? $pValue
   * @param boolean $pUpdate Update fitToPage so it applies rather than scaling
   * @return PHPExcel_Worksheet_PageSetup
   */
  public function setFitToHeight($pValue = 1, $pUpdate = TRUE) {
    $this->_fitToHeight = $pValue;
    if ($pUpdate) {
      $this->_fitToPage = TRUE;
    }
    return $this;
  }

  /**
   * Get Fit To Width
   *
   * @return int?
   */
  public function getFitToWidth() {
    return $this->_fitToWidth;
  }

  /**
   * Set Fit To Width
   *
   * @param int? $pValue
   * @param boolean $pUpdate Update fitToPage so it applies rather than scaling
   * @return PHPExcel_Worksheet_PageSetup
   */
  public function setFitToWidth($pValue = 1, $pUpdate = TRUE) {
    $this->_fitToWidth = $pValue;
    if ($pUpdate) {
      $this->_fitToPage = TRUE;
    }
    return $this;
  }

  /**
   * Is Columns to repeat at left set?
   *
   * @return boolean
   */
  public function isColumnsToRepeatAtLeftSet() {
    if (is_array($this->_columnsToRepeatAtLeft)) {
      if ($this->_columnsToRepeatAtLeft[0] != '' && $this->_columnsToRepeatAtLeft[1] != '') {
        return true;
      }
    }
    return false;
  }

  /**
   * Get Columns to repeat at left
   *
   * @return array Containing start column and end column, empty array if option unset
   */
  public function getColumnsToRepeatAtLeft() {
    return $this->_columnsToRepeatAtLeft;
  }

  /**
   * Set Columns to repeat at left
   *
   * @param array $pValue Containing start column and end column, empty array if option unset
   * @return PHPExcel_Worksheet_PageSetup
   */
  public function setColumnsToRepeatAtLeft($pValue = null) {
    if (is_array($pValue)) {
      $this->_columnsToRepeatAtLeft = $pValue;
    }
    return $this;
  }

  /**
   * Set Columns to repeat at left by start and end
   *
   * @param string $pStart
   * @param string $pEnd
   * @return PHPExcel_Worksheet_PageSetup
   */
  public function setColumnsToRepeatAtLeftByStartAndEnd($pStart = 'A', $pEnd = 'A') {
    $this->_columnsToRepeatAtLeft = array(
      $pStart,
      $pEnd,
    );
    return $this;
  }

  /**
   * Is Rows to repeat at top set?
   *
   * @return boolean
   */
  public function isRowsToRepeatAtTopSet() {
    if (is_array($this->_rowsToRepeatAtTop)) {
      if ($this->_rowsToRepeatAtTop[0] != 0 && $this->_rowsToRepeatAtTop[1] != 0) {
        return true;
      }
    }
    return false;
  }

  /**
   * Get Rows to repeat at top
   *
   * @return array Containing start column and end column, empty array if option unset
   */
  public function getRowsToRepeatAtTop() {
    return $this->_rowsToRepeatAtTop;
  }

  /**
   * Set Rows to repeat at top
   *
   * @param array	$pValue	Containing start column and end column, empty array if option unset
   * @return PHPExcel_Worksheet_PageSetup
   */
  public function setRowsToRepeatAtTop($pValue = null) {
    if (is_array($pValue)) {
      $this->_rowsToRepeatAtTop = $pValue;
    }
    return $this;
  }

  /**
   * Set Rows to repeat at top by start and end
   *
   * @param int $pStart
   * @param int $pEnd
   * @return PHPExcel_Worksheet_PageSetup
   */
  public function setRowsToRepeatAtTopByStartAndEnd($pStart = 1, $pEnd = 1) {
    $this->_rowsToRepeatAtTop = array(
      $pStart,
      $pEnd,
    );
    return $this;
  }

  /**
   * Get center page horizontally
   *
   * @return bool
   */
  public function getHorizontalCentered() {
    return $this->_horizontalCentered;
  }

  /**
   * Set center page horizontally
   *
   * @param bool $value
   * @return PHPExcel_Worksheet_PageSetup
   */
  public function setHorizontalCentered($value = false) {
    $this->_horizontalCentered = $value;
    return $this;
  }

  /**
   * Get center page vertically
   *
   * @return bool
   */
  public function getVerticalCentered() {
    return $this->_verticalCentered;
  }

  /**
   * Set center page vertically
   *
   * @param bool $value
   * @return PHPExcel_Worksheet_PageSetup
   */
  public function setVerticalCentered($value = false) {
    $this->_verticalCentered = $value;
    return $this;
  }

  /**
   *	Get print area
   *
   * @param	int		$index	Identifier for a specific print area range if several ranges have been set
   *							Default behaviour, or a index value of 0, will return all ranges as a comma-separated string
   *							Otherwise, the specific range identified by the value of $index will be returned
   *							Print areas are numbered from 1
   * @throws	PHPExcel_Exception
   * @return	string
   */
  public function getPrintArea($index = 0) {
    if ($index == 0) {
      return $this->_printArea;
    }
    $printAreas = explode(',', $this->_printArea);
    if (isset($printAreas[$index - 1])) {
      return $printAreas[$index - 1];
    }
    throw new PHPExcel_Exception("Requested Print Area does not exist");
  }

  /**
   * Is print area set?
   *
   * @param	int		$index	Identifier for a specific print area range if several ranges have been set
   *							Default behaviour, or an index value of 0, will identify whether any print range is set
   *							Otherwise, existence of the range identified by the value of $index will be returned
   *							Print areas are numbered from 1
   * @return	boolean
   */
  public function isPrintAreaSet($index = 0) {
    if ($index == 0) {
      return !is_null($this->_printArea);
    }
    $printAreas = explode(',', $this->_printArea);
    return isset($printAreas[$index - 1]);
  }

  /**
   * Clear a print area
   *
   * @param	int		$index	Identifier for a specific print area range if several ranges have been set
   *							Default behaviour, or an index value of 0, will clear all print ranges that are set
   *							Otherwise, the range identified by the value of $index will be removed from the series
   *							Print areas are numbered from 1
   * @return	PHPExcel_Worksheet_PageSetup
   */
  public function clearPrintArea($index = 0) {
    if ($index == 0) {
      $this->_printArea = NULL;
    }
    else {
      $printAreas = explode(',', $this->_printArea);
      if (isset($printAreas[$index - 1])) {
        unset($printAreas[$index - 1]);
        $this->_printArea = implode(',', $printAreas);
      }
    }
    return $this;
  }

  /**
   * Set print area. e.g. 'A1:D10' or 'A1:D10,G5:M20'
   *
   * @param	string	$value
   * @param	int		$index	Identifier for a specific print area range allowing several ranges to be set
   *							When the method is "O"verwrite, then a positive integer index will overwrite that indexed
   *								entry in the print areas list; a negative index value will identify which entry to
   *								overwrite working bacward through the print area to the list, with the last entry as -1.
   *								Specifying an index value of 0, will overwrite <b>all</b> existing print ranges.
   *							When the method is "I"nsert, then a positive index will insert after that indexed entry in
   *								the print areas list, while a negative index will insert before the indexed entry.
   *								Specifying an index value of 0, will always append the new print range at the end of the
   *								list.
   *							Print areas are numbered from 1
   * @param	string	$method	Determines the method used when setting multiple print areas
   *							Default behaviour, or the "O" method, overwrites existing print area
   *							The "I" method, inserts the new print area before any specified index, or at the end of the list
   * @return	PHPExcel_Worksheet_PageSetup
   * @throws	PHPExcel_Exception
   */
  public function setPrintArea($value, $index = 0, $method = self::SETPRINTRANGE_OVERWRITE) {
    if (strpos($value, '!') !== false) {
      throw new PHPExcel_Exception('Cell coordinate must not specify a worksheet.');
    }
    elseif (strpos($value, ':') === false) {
      throw new PHPExcel_Exception('Cell coordinate must be a range of cells.');
    }
    elseif (strpos($value, '$') !== false) {
      throw new PHPExcel_Exception('Cell coordinate must not be absolute.');
    }
    $value = strtoupper($value);
    if ($method == self::SETPRINTRANGE_OVERWRITE) {
      if ($index == 0) {
        $this->_printArea = $value;
      }
      else {
        $printAreas = explode(',', $this->_printArea);
        if ($index < 0) {
          $index = count($printAreas) - abs($index) + 1;
        }
        if ($index <= 0 || $index > count($printAreas)) {
          throw new PHPExcel_Exception('Invalid index for setting print range.');
        }
        $printAreas[$index - 1] = $value;
        $this->_printArea = implode(',', $printAreas);
      }
    }
    elseif ($method == self::SETPRINTRANGE_INSERT) {
      if ($index == 0) {
        $this->_printArea .= $this->_printArea == '' ? $value : ',' . $value;
      }
      else {
        $printAreas = explode(',', $this->_printArea);
        if ($index < 0) {
          $index = abs($index) - 1;
        }
        if ($index > count($printAreas)) {
          throw new PHPExcel_Exception('Invalid index for setting print range.');
        }
        $printAreas = array_merge(array_slice($printAreas, 0, $index), array(
          $value,
        ), array_slice($printAreas, $index));
        $this->_printArea = implode(',', $printAreas);
      }
    }
    else {
      throw new PHPExcel_Exception('Invalid method for setting print range.');
    }
    return $this;
  }

  /**
   * Add a new print area (e.g. 'A1:D10' or 'A1:D10,G5:M20') to the list of print areas
   *
   * @param	string	$value
   * @param	int		$index	Identifier for a specific print area range allowing several ranges to be set
   *							A positive index will insert after that indexed entry in the print areas list, while a
   *								negative index will insert before the indexed entry.
   *								Specifying an index value of 0, will always append the new print range at the end of the
   *								list.
   *							Print areas are numbered from 1
   * @return	PHPExcel_Worksheet_PageSetup
   * @throws	PHPExcel_Exception
   */
  public function addPrintArea($value, $index = -1) {
    return $this
      ->setPrintArea($value, $index, self::SETPRINTRANGE_INSERT);
  }

  /**
   * Set print area
   *
   * @param	int		$column1	Column 1
   * @param	int		$row1		Row 1
   * @param	int		$column2	Column 2
   * @param	int		$row2		Row 2
   * @param	int		$index		Identifier for a specific print area range allowing several ranges to be set
   *								When the method is "O"verwrite, then a positive integer index will overwrite that indexed
   *									entry in the print areas list; a negative index value will identify which entry to
   *									overwrite working bacward through the print area to the list, with the last entry as -1.
   *									Specifying an index value of 0, will overwrite <b>all</b> existing print ranges.
   *								When the method is "I"nsert, then a positive index will insert after that indexed entry in
   *									the print areas list, while a negative index will insert before the indexed entry.
   *									Specifying an index value of 0, will always append the new print range at the end of the
   *									list.
   *								Print areas are numbered from 1
   * @param	string	$method		Determines the method used when setting multiple print areas
   *								Default behaviour, or the "O" method, overwrites existing print area
   *								The "I" method, inserts the new print area before any specified index, or at the end of the list
   * @return	PHPExcel_Worksheet_PageSetup
   * @throws	PHPExcel_Exception
   */
  public function setPrintAreaByColumnAndRow($column1, $row1, $column2, $row2, $index = 0, $method = self::SETPRINTRANGE_OVERWRITE) {
    return $this
      ->setPrintArea(PHPExcel_Cell::stringFromColumnIndex($column1) . $row1 . ':' . PHPExcel_Cell::stringFromColumnIndex($column2) . $row2, $index, $method);
  }

  /**
   * Add a new print area to the list of print areas
   *
   * @param	int		$column1	Start Column for the print area
   * @param	int		$row1		Start Row for the print area
   * @param	int		$column2	End Column for the print area
   * @param	int		$row2		End Row for the print area
   * @param	int		$index		Identifier for a specific print area range allowing several ranges to be set
   *								A positive index will insert after that indexed entry in the print areas list, while a
   *									negative index will insert before the indexed entry.
   *									Specifying an index value of 0, will always append the new print range at the end of the
   *									list.
   *								Print areas are numbered from 1
   * @return	PHPExcel_Worksheet_PageSetup
   * @throws	PHPExcel_Exception
   */
  public function addPrintAreaByColumnAndRow($column1, $row1, $column2, $row2, $index = -1) {
    return $this
      ->setPrintArea(PHPExcel_Cell::stringFromColumnIndex($column1) . $row1 . ':' . PHPExcel_Cell::stringFromColumnIndex($column2) . $row2, $index, self::SETPRINTRANGE_INSERT);
  }

  /**
   * Get first page number
   *
   * @return int
   */
  public function getFirstPageNumber() {
    return $this->_firstPageNumber;
  }

  /**
   * Set first page number
   *
   * @param int $value
   * @return PHPExcel_Worksheet_HeaderFooter
   */
  public function setFirstPageNumber($value = null) {
    $this->_firstPageNumber = $value;
    return $this;
  }

  /**
   * Reset first page number
   *
   * @return PHPExcel_Worksheet_HeaderFooter
   */
  public function resetFirstPageNumber() {
    return $this
      ->setFirstPageNumber(null);
  }

  /**
   * Implement PHP __clone to create a deep clone, not just a shallow copy.
   */
  public function __clone() {
    $vars = get_object_vars($this);
    foreach ($vars as $key => $value) {
      if (is_object($value)) {
        $this->{$key} = clone $value;
      }
      else {
        $this->{$key} = $value;
      }
    }
  }

}

Members

Namesort descending Modifiers Type Description Overrides
PHPExcel_Worksheet_PageSetup::$_columnsToRepeatAtLeft private property * Columns to repeat at left * *
PHPExcel_Worksheet_PageSetup::$_firstPageNumber private property * First page number * *
PHPExcel_Worksheet_PageSetup::$_fitToHeight private property * Fit To Height * Number of vertical pages to fit on * *
PHPExcel_Worksheet_PageSetup::$_fitToPage private property * Fit To Page * Whether scale or fitToWith / fitToHeight applies * *
PHPExcel_Worksheet_PageSetup::$_fitToWidth private property * Fit To Width * Number of horizontal pages to fit on * *
PHPExcel_Worksheet_PageSetup::$_horizontalCentered private property * Center page horizontally * *
PHPExcel_Worksheet_PageSetup::$_orientation private property * Orientation * *
PHPExcel_Worksheet_PageSetup::$_paperSize private property * Paper size * *
PHPExcel_Worksheet_PageSetup::$_printArea private property * Print area * *
PHPExcel_Worksheet_PageSetup::$_rowsToRepeatAtTop private property * Rows to repeat at top * *
PHPExcel_Worksheet_PageSetup::$_scale private property * Scale (Print Scale) * * Print scaling. Valid values range from 10 to 400 * This setting is overridden when fitToWidth and/or fitToHeight are in use * *
PHPExcel_Worksheet_PageSetup::$_verticalCentered private property * Center page vertically * *
PHPExcel_Worksheet_PageSetup::addPrintArea public function * Add a new print area (e.g. 'A1:D10' or 'A1:D10,G5:M20') to the list of print areas * *
PHPExcel_Worksheet_PageSetup::addPrintAreaByColumnAndRow public function * Add a new print area to the list of print areas * *
PHPExcel_Worksheet_PageSetup::clearPrintArea public function * Clear a print area * *
PHPExcel_Worksheet_PageSetup::getColumnsToRepeatAtLeft public function * Get Columns to repeat at left * *
PHPExcel_Worksheet_PageSetup::getFirstPageNumber public function * Get first page number * *
PHPExcel_Worksheet_PageSetup::getFitToHeight public function * Get Fit To Height * *
PHPExcel_Worksheet_PageSetup::getFitToPage public function * Get Fit To Page * *
PHPExcel_Worksheet_PageSetup::getFitToWidth public function * Get Fit To Width * *
PHPExcel_Worksheet_PageSetup::getHorizontalCentered public function * Get center page horizontally * *
PHPExcel_Worksheet_PageSetup::getOrientation public function Get Orientation
PHPExcel_Worksheet_PageSetup::getPaperSize public function Get Paper Size
PHPExcel_Worksheet_PageSetup::getPrintArea public function * Get print area * *
PHPExcel_Worksheet_PageSetup::getRowsToRepeatAtTop public function * Get Rows to repeat at top * *
PHPExcel_Worksheet_PageSetup::getScale public function * Get Scale * *
PHPExcel_Worksheet_PageSetup::getVerticalCentered public function * Get center page vertically * *
PHPExcel_Worksheet_PageSetup::isColumnsToRepeatAtLeftSet public function * Is Columns to repeat at left set? * *
PHPExcel_Worksheet_PageSetup::isPrintAreaSet public function * Is print area set? * *
PHPExcel_Worksheet_PageSetup::isRowsToRepeatAtTopSet public function * Is Rows to repeat at top set? * *
PHPExcel_Worksheet_PageSetup::ORIENTATION_DEFAULT constant
PHPExcel_Worksheet_PageSetup::ORIENTATION_LANDSCAPE constant
PHPExcel_Worksheet_PageSetup::ORIENTATION_PORTRAIT constant
PHPExcel_Worksheet_PageSetup::PAPERSIZE_6_3_4_ENVELOPE constant
PHPExcel_Worksheet_PageSetup::PAPERSIZE_A2_PAPER constant
PHPExcel_Worksheet_PageSetup::PAPERSIZE_A3 constant
PHPExcel_Worksheet_PageSetup::PAPERSIZE_A3_EXTRA_PAPER constant
PHPExcel_Worksheet_PageSetup::PAPERSIZE_A3_EXTRA_TRANSVERSE_PAPER constant
PHPExcel_Worksheet_PageSetup::PAPERSIZE_A3_TRANSVERSE_PAPER constant
PHPExcel_Worksheet_PageSetup::PAPERSIZE_A4 constant
PHPExcel_Worksheet_PageSetup::PAPERSIZE_A4_EXTRA_PAPER constant
PHPExcel_Worksheet_PageSetup::PAPERSIZE_A4_PLUS_PAPER constant
PHPExcel_Worksheet_PageSetup::PAPERSIZE_A4_SMALL constant
PHPExcel_Worksheet_PageSetup::PAPERSIZE_A4_TRANSVERSE_PAPER constant
PHPExcel_Worksheet_PageSetup::PAPERSIZE_A5 constant
PHPExcel_Worksheet_PageSetup::PAPERSIZE_A5_EXTRA_PAPER constant
PHPExcel_Worksheet_PageSetup::PAPERSIZE_A5_TRANSVERSE_PAPER constant
PHPExcel_Worksheet_PageSetup::PAPERSIZE_B4 constant
PHPExcel_Worksheet_PageSetup::PAPERSIZE_B4_ENVELOPE constant
PHPExcel_Worksheet_PageSetup::PAPERSIZE_B5 constant
PHPExcel_Worksheet_PageSetup::PAPERSIZE_B5_ENVELOPE constant
PHPExcel_Worksheet_PageSetup::PAPERSIZE_B6_ENVELOPE constant
PHPExcel_Worksheet_PageSetup::PAPERSIZE_C constant
PHPExcel_Worksheet_PageSetup::PAPERSIZE_C3_ENVELOPE constant
PHPExcel_Worksheet_PageSetup::PAPERSIZE_C4_ENVELOPE constant
PHPExcel_Worksheet_PageSetup::PAPERSIZE_C5_ENVELOPE constant
PHPExcel_Worksheet_PageSetup::PAPERSIZE_C65_ENVELOPE constant
PHPExcel_Worksheet_PageSetup::PAPERSIZE_C6_ENVELOPE constant
PHPExcel_Worksheet_PageSetup::PAPERSIZE_D constant
PHPExcel_Worksheet_PageSetup::PAPERSIZE_DL_ENVELOPE constant
PHPExcel_Worksheet_PageSetup::PAPERSIZE_E constant
PHPExcel_Worksheet_PageSetup::PAPERSIZE_EXECUTIVE constant
PHPExcel_Worksheet_PageSetup::PAPERSIZE_FOLIO constant
PHPExcel_Worksheet_PageSetup::PAPERSIZE_GERMAN_LEGAL_FANFOLD constant
PHPExcel_Worksheet_PageSetup::PAPERSIZE_GERMAN_STANDARD_FANFOLD constant
PHPExcel_Worksheet_PageSetup::PAPERSIZE_INVITE_ENVELOPE constant
PHPExcel_Worksheet_PageSetup::PAPERSIZE_ISO_B4 constant
PHPExcel_Worksheet_PageSetup::PAPERSIZE_ISO_B5_EXTRA_PAPER constant
PHPExcel_Worksheet_PageSetup::PAPERSIZE_ITALY_ENVELOPE constant
PHPExcel_Worksheet_PageSetup::PAPERSIZE_JAPANESE_DOUBLE_POSTCARD constant
PHPExcel_Worksheet_PageSetup::PAPERSIZE_JIS_B5_TRANSVERSE_PAPER constant
PHPExcel_Worksheet_PageSetup::PAPERSIZE_LEDGER constant
PHPExcel_Worksheet_PageSetup::PAPERSIZE_LEGAL constant
PHPExcel_Worksheet_PageSetup::PAPERSIZE_LEGAL_EXTRA_PAPER constant
PHPExcel_Worksheet_PageSetup::PAPERSIZE_LETTER constant
PHPExcel_Worksheet_PageSetup::PAPERSIZE_LETTER_EXTRA_PAPER constant
PHPExcel_Worksheet_PageSetup::PAPERSIZE_LETTER_EXTRA_TRANSVERSE_PAPER constant
PHPExcel_Worksheet_PageSetup::PAPERSIZE_LETTER_PLUS_PAPER constant
PHPExcel_Worksheet_PageSetup::PAPERSIZE_LETTER_SMALL constant
PHPExcel_Worksheet_PageSetup::PAPERSIZE_LETTER_TRANSVERSE_PAPER constant
PHPExcel_Worksheet_PageSetup::PAPERSIZE_MONARCH_ENVELOPE constant
PHPExcel_Worksheet_PageSetup::PAPERSIZE_NO10_ENVELOPE constant
PHPExcel_Worksheet_PageSetup::PAPERSIZE_NO11_ENVELOPE constant
PHPExcel_Worksheet_PageSetup::PAPERSIZE_NO12_ENVELOPE constant
PHPExcel_Worksheet_PageSetup::PAPERSIZE_NO14_ENVELOPE constant
PHPExcel_Worksheet_PageSetup::PAPERSIZE_NO9_ENVELOPE constant
PHPExcel_Worksheet_PageSetup::PAPERSIZE_NOTE constant
PHPExcel_Worksheet_PageSetup::PAPERSIZE_QUARTO constant
PHPExcel_Worksheet_PageSetup::PAPERSIZE_STANDARD_1 constant
PHPExcel_Worksheet_PageSetup::PAPERSIZE_STANDARD_2 constant
PHPExcel_Worksheet_PageSetup::PAPERSIZE_STANDARD_PAPER_1 constant
PHPExcel_Worksheet_PageSetup::PAPERSIZE_STANDARD_PAPER_2 constant
PHPExcel_Worksheet_PageSetup::PAPERSIZE_STANDARD_PAPER_3 constant
PHPExcel_Worksheet_PageSetup::PAPERSIZE_STATEMENT constant
PHPExcel_Worksheet_PageSetup::PAPERSIZE_SUPERA_SUPERA_A4_PAPER constant
PHPExcel_Worksheet_PageSetup::PAPERSIZE_SUPERB_SUPERB_A3_PAPER constant
PHPExcel_Worksheet_PageSetup::PAPERSIZE_TABLOID constant
PHPExcel_Worksheet_PageSetup::PAPERSIZE_TABLOID_EXTRA_PAPER constant
PHPExcel_Worksheet_PageSetup::PAPERSIZE_US_STANDARD_FANFOLD constant
PHPExcel_Worksheet_PageSetup::resetFirstPageNumber public function Reset first page number
PHPExcel_Worksheet_PageSetup::setColumnsToRepeatAtLeft public function * Set Columns to repeat at left * *
PHPExcel_Worksheet_PageSetup::setColumnsToRepeatAtLeftByStartAndEnd public function * Set Columns to repeat at left by start and end * *
PHPExcel_Worksheet_PageSetup::setFirstPageNumber public function Set first page number
PHPExcel_Worksheet_PageSetup::setFitToHeight public function * Set Fit To Height * *
PHPExcel_Worksheet_PageSetup::setFitToPage public function * Set Fit To Page * *
PHPExcel_Worksheet_PageSetup::setFitToWidth public function * Set Fit To Width * *
PHPExcel_Worksheet_PageSetup::setHorizontalCentered public function * Set center page horizontally * *
PHPExcel_Worksheet_PageSetup::setOrientation public function Set Orientation
PHPExcel_Worksheet_PageSetup::setPaperSize public function Set Paper Size
PHPExcel_Worksheet_PageSetup::setPrintArea public function * Set print area. e.g. 'A1:D10' or 'A1:D10,G5:M20' * *
PHPExcel_Worksheet_PageSetup::setPrintAreaByColumnAndRow public function * Set print area * *
PHPExcel_Worksheet_PageSetup::SETPRINTRANGE_INSERT constant
PHPExcel_Worksheet_PageSetup::SETPRINTRANGE_OVERWRITE constant
PHPExcel_Worksheet_PageSetup::setRowsToRepeatAtTop public function * Set Rows to repeat at top * *
PHPExcel_Worksheet_PageSetup::setRowsToRepeatAtTopByStartAndEnd public function * Set Rows to repeat at top by start and end * *
PHPExcel_Worksheet_PageSetup::setScale public function * Set Scale * * Print scaling. Valid values range from 10 to 400 * This setting is overridden when fitToWidth and/or fitToHeight are in use * *
PHPExcel_Worksheet_PageSetup::setVerticalCentered public function * Set center page vertically * *
PHPExcel_Worksheet_PageSetup::__clone public function * Implement PHP __clone to create a deep clone, not just a shallow copy.
PHPExcel_Worksheet_PageSetup::__construct public function Create a new PHPExcel_Worksheet_PageSetup