PHPOffice /
PhpSpreadsheet
| @@ 2006-2015 (lines=10) @@ | ||
| 2003 | * @throws Exception |
|
| 2004 | * @return Worksheet |
|
| 2005 | */ |
|
| 2006 | public function insertNewRowBefore($pBefore = 1, $pNumRows = 1) |
|
| 2007 | { |
|
| 2008 | if ($pBefore >= 1) { |
|
| 2009 | $objReferenceHelper = ReferenceHelper::getInstance(); |
|
| 2010 | $objReferenceHelper->insertNewBefore('A' . $pBefore, 0, $pNumRows, $this); |
|
| 2011 | } else { |
|
| 2012 | throw new Exception("Rows can only be inserted before at least row 1."); |
|
| 2013 | } |
|
| 2014 | return $this; |
|
| 2015 | } |
|
| 2016 | ||
| 2017 | /** |
|
| 2018 | * Insert a new column, updating all possible related data |
|
| @@ 2025-2034 (lines=10) @@ | ||
| 2022 | * @throws Exception |
|
| 2023 | * @return Worksheet |
|
| 2024 | */ |
|
| 2025 | public function insertNewColumnBefore($pBefore = 'A', $pNumCols = 1) |
|
| 2026 | { |
|
| 2027 | if (!is_numeric($pBefore)) { |
|
| 2028 | $objReferenceHelper = ReferenceHelper::getInstance(); |
|
| 2029 | $objReferenceHelper->insertNewBefore($pBefore . '1', $pNumCols, 0, $this); |
|
| 2030 | } else { |
|
| 2031 | throw new Exception("Column references should not be numeric."); |
|
| 2032 | } |
|
| 2033 | return $this; |
|
| 2034 | } |
|
| 2035 | ||
| 2036 | /** |
|
| 2037 | * Insert a new column, updating all possible related data |
|
