MewesK / TwigExcelBundle

Wrapper/XlsDocumentWrapper.php

Braces +38 added lines, -19 removed lines

@@ -58,61 +58,80 @@
 
     protected function initializeMappings()
     {
-        $this->mappings['category'] = function ($value) {
+        $this->mappings['category'] = function ($value)
+        {
             $this->object->getProperties()->setCategory($value);
         };
-        $this->mappings['company'] = function ($value) {
+        $this->mappings['company'] = function ($value)
+        {
             $this->object->getProperties()->setCompany($value);
         };
-        $this->mappings['created'] = function ($value) {
+        $this->mappings['created'] = function ($value)
+        {
             $this->object->getProperties()->setCreated($value);
         };
-        $this->mappings['creator'] = function ($value) {
+        $this->mappings['creator'] = function ($value)
+        {
             $this->object->getProperties()->setCreator($value);
         };
-        $this->mappings['defaultStyle'] = function ($value) {
+        $this->mappings['defaultStyle'] = function ($value)
+        {
             $this->object->getDefaultStyle()->applyFromArray($value);
         };
-        $this->mappings['description'] = function ($value) {
+        $this->mappings['description'] = function ($value)
+        {
             $this->object->getProperties()->setDescription($value);
         };
-        $this->mappings['format'] = function ($value) {
+        $this->mappings['format'] = function ($value)
+        {
             $this->attributes['format'] = $value;
         };
-        $this->mappings['keywords'] = function ($value) {
+        $this->mappings['keywords'] = function ($value)
+        {
             $this->object->getProperties()->setKeywords($value);
         };
-        $this->mappings['lastModifiedBy'] = function ($value) {
+        $this->mappings['lastModifiedBy'] = function ($value)
+        {
             $this->object->getProperties()->setLastModifiedBy($value);
         };
-        $this->mappings['manager'] = function ($value) {
+        $this->mappings['manager'] = function ($value)
+        {
             $this->object->getProperties()->setManager($value);
         };
-        $this->mappings['modified'] = function ($value) {
+        $this->mappings['modified'] = function ($value)
+        {
             $this->object->getProperties()->setModified($value);
         };
-        $this->mappings['security']['lockRevision'] = function ($value) {
+        $this->mappings['security']['lockRevision'] = function ($value)
+        {
             $this->object->getSecurity()->setLockRevision($value);
         };
-        $this->mappings['security']['lockStructure'] = function ($value) {
+        $this->mappings['security']['lockStructure'] = function ($value)
+        {
             $this->object->getSecurity()->setLockStructure($value);
         };
-        $this->mappings['security']['lockWindows'] = function ($value) {
+        $this->mappings['security']['lockWindows'] = function ($value)
+        {
             $this->object->getSecurity()->setLockWindows($value);
         };
-        $this->mappings['security']['revisionsPassword'] = function ($value) {
+        $this->mappings['security']['revisionsPassword'] = function ($value)
+        {
             $this->object->getSecurity()->setRevisionsPassword($value);
         };
-        $this->mappings['security']['workbookPassword'] = function ($value) {
+        $this->mappings['security']['workbookPassword'] = function ($value)
+        {
             $this->object->getSecurity()->setWorkbookPassword($value);
         };
-        $this->mappings['subject'] = function ($value) {
+        $this->mappings['subject'] = function ($value)
+        {
             $this->object->getProperties()->setSubject($value);
         };
-        $this->mappings['template'] = function ($value) {
+        $this->mappings['template'] = function ($value)
+        {
             $this->attributes['template'] = $value;
         };
-        $this->mappings['title'] = function ($value) {
+        $this->mappings['title'] = function ($value)
+        {
             $this->object->getProperties()->setTitle($value);
         };
     }

Wrapper/XlsSheetWrapper.php

Braces +109 added lines, -55 removed lines

@@ -79,167 +79,221 @@ 
     protected function initializeMappings()
     {
         $this->mappings['columnDimension']['__multi'] = true;
-        $this->mappings['columnDimension']['__object'] = function ($key = 'default') {
+        $this->mappings['columnDimension']['__object'] = function ($key = 'default')
+        {
             return $key === 'default' ? $this->object->getDefaultColumnDimension() : $this->object->getColumnDimension($key);
         };
-        $this->mappings['columnDimension']['autoSize'] = function ($key, $value) {
+        $this->mappings['columnDimension']['autoSize'] = function ($key, $value)
+        {
             $this->mappings['columnDimension']['__object']($key)->setAutoSize($value);
         };
-        $this->mappings['columnDimension']['collapsed'] = function ($key, $value) {
+        $this->mappings['columnDimension']['collapsed'] = function ($key, $value)
+        {
             $this->mappings['columnDimension']['__object']($key)->setCollapsed($value);
         };
-        $this->mappings['columnDimension']['columnIndex'] = function ($key, $value) {
+        $this->mappings['columnDimension']['columnIndex'] = function ($key, $value)
+        {
             $this->mappings['columnDimension']['__object']($key)->setColumnIndex($value);
         };
-        $this->mappings['columnDimension']['outlineLevel'] = function ($key, $value) {
+        $this->mappings['columnDimension']['outlineLevel'] = function ($key, $value)
+        {
             $this->mappings['columnDimension']['__object']($key)->setOutlineLevel($value);
         };
-        $this->mappings['columnDimension']['visible'] = function ($key, $value) {
+        $this->mappings['columnDimension']['visible'] = function ($key, $value)
+        {
             $this->mappings['columnDimension']['__object']($key)->setVisible($value);
         };
-        $this->mappings['columnDimension']['width'] = function ($key, $value) {
+        $this->mappings['columnDimension']['width'] = function ($key, $value)
+        {
             $this->mappings['columnDimension']['__object']($key)->setWidth($value);
         };
-        $this->mappings['columnDimension']['xfIndex'] = function ($key, $value) {
+        $this->mappings['columnDimension']['xfIndex'] = function ($key, $value)
+        {
             $this->mappings['columnDimension']['__object']($key)->setXfIndex($value);
         };
-        $this->mappings['pageMargins']['top'] = function ($value) {
+        $this->mappings['pageMargins']['top'] = function ($value)
+        {
             $this->object->getPageMargins()->setTop($value);
         };
-        $this->mappings['pageMargins']['bottom'] = function ($value) {
+        $this->mappings['pageMargins']['bottom'] = function ($value)
+        {
             $this->object->getPageMargins()->setBottom($value);
         };
-        $this->mappings['pageMargins']['left'] = function ($value) {
+        $this->mappings['pageMargins']['left'] = function ($value)
+        {
             $this->object->getPageMargins()->setLeft($value);
         };
-        $this->mappings['pageMargins']['right'] = function ($value) {
+        $this->mappings['pageMargins']['right'] = function ($value)
+        {
             $this->object->getPageMargins()->setRight($value);
         };
-        $this->mappings['pageMargins']['header'] = function ($value) {
+        $this->mappings['pageMargins']['header'] = function ($value)
+        {
             $this->object->getPageMargins()->setHeader($value);
         };
-        $this->mappings['pageMargins']['footer'] = function ($value) {
+        $this->mappings['pageMargins']['footer'] = function ($value)
+        {
             $this->object->getPageMargins()->setFooter($value);
         };
-        $this->mappings['pageSetup']['fitToHeight'] = function ($value) {
+        $this->mappings['pageSetup']['fitToHeight'] = function ($value)
+        {
             $this->object->getPageSetup()->setFitToHeight($value);
         };
-        $this->mappings['pageSetup']['fitToPage'] = function ($value) {
+        $this->mappings['pageSetup']['fitToPage'] = function ($value)
+        {
             $this->object->getPageSetup()->setFitToPage($value);
         };
-        $this->mappings['pageSetup']['fitToWidth'] = function ($value) {
+        $this->mappings['pageSetup']['fitToWidth'] = function ($value)
+        {
             $this->object->getPageSetup()->setFitToWidth($value);
         };
-        $this->mappings['pageSetup']['horizontalCentered'] = function ($value) {
+        $this->mappings['pageSetup']['horizontalCentered'] = function ($value)
+        {
             $this->object->getPageSetup()->setHorizontalCentered($value);
         };
-        $this->mappings['pageSetup']['orientation'] = function ($value) {
+        $this->mappings['pageSetup']['orientation'] = function ($value)
+        {
             $this->object->getPageSetup()->setOrientation($value);
         };
-        $this->mappings['pageSetup']['paperSize'] = function ($value) {
+        $this->mappings['pageSetup']['paperSize'] = function ($value)
+        {
             $this->object->getPageSetup()->setPaperSize($value);
         };
-        $this->mappings['pageSetup']['printArea'] = function ($value) {
+        $this->mappings['pageSetup']['printArea'] = function ($value)
+        {
             $this->object->getPageSetup()->setPrintArea($value);
         };
-        $this->mappings['pageSetup']['scale'] = function ($value) {
+        $this->mappings['pageSetup']['scale'] = function ($value)
+        {
             $this->object->getPageSetup()->setScale($value);
         };
-        $this->mappings['pageSetup']['verticalCentered'] = function ($value) {
+        $this->mappings['pageSetup']['verticalCentered'] = function ($value)
+        {
             $this->object->getPageSetup()->setVerticalCentered($value);
         };
-        $this->mappings['printGridlines'] = function ($value) {
+        $this->mappings['printGridlines'] = function ($value)
+        {
             $this->object->setPrintGridlines($value);
         };
-        $this->mappings['protection']['autoFilter'] = function ($value) {
+        $this->mappings['protection']['autoFilter'] = function ($value)
+        {
             $this->object->getProtection()->setAutoFilter($value);
         };
-        $this->mappings['protection']['deleteColumns'] = function ($value) {
+        $this->mappings['protection']['deleteColumns'] = function ($value)
+        {
             $this->object->getProtection()->setDeleteColumns($value);
         };
-        $this->mappings['protection']['deleteRows'] = function ($value) {
+        $this->mappings['protection']['deleteRows'] = function ($value)
+        {
             $this->object->getProtection()->setDeleteRows($value);
         };
-        $this->mappings['protection']['formatCells'] = function ($value) {
+        $this->mappings['protection']['formatCells'] = function ($value)
+        {
             $this->object->getProtection()->setFormatCells($value);
         };
-        $this->mappings['protection']['formatColumns'] = function ($value) {
+        $this->mappings['protection']['formatColumns'] = function ($value)
+        {
             $this->object->getProtection()->setFormatColumns($value);
         };
-        $this->mappings['protection']['formatRows'] = function ($value) {
+        $this->mappings['protection']['formatRows'] = function ($value)
+        {
             $this->object->getProtection()->setFormatRows($value);
         };
-        $this->mappings['protection']['insertColumns'] = function ($value) {
+        $this->mappings['protection']['insertColumns'] = function ($value)
+        {
             $this->object->getProtection()->setInsertColumns($value);
         };
-        $this->mappings['protection']['insertHyperlinks'] = function ($value) {
+        $this->mappings['protection']['insertHyperlinks'] = function ($value)
+        {
             $this->object->getProtection()->setInsertHyperlinks($value);
         };
-        $this->mappings['protection']['insertRows'] = function ($value) {
+        $this->mappings['protection']['insertRows'] = function ($value)
+        {
             $this->object->getProtection()->setInsertRows($value);
         };
-        $this->mappings['protection']['objects'] = function ($value) {
+        $this->mappings['protection']['objects'] = function ($value)
+        {
             $this->object->getProtection()->setObjects($value);
         };
-        $this->mappings['protection']['password'] = function ($value) {
+        $this->mappings['protection']['password'] = function ($value)
+        {
             $this->object->getProtection()->setPassword($value);
         };
-        $this->mappings['protection']['pivotTables'] = function ($value) {
+        $this->mappings['protection']['pivotTables'] = function ($value)
+        {
             $this->object->getProtection()->setPivotTables($value);
         };
-        $this->mappings['protection']['scenarios'] = function ($value) {
+        $this->mappings['protection']['scenarios'] = function ($value)
+        {
             $this->object->getProtection()->setScenarios($value);
         };
-        $this->mappings['protection']['selectLockedCells'] = function ($value) {
+        $this->mappings['protection']['selectLockedCells'] = function ($value)
+        {
             $this->object->getProtection()->setSelectLockedCells($value);
         };
-        $this->mappings['protection']['selectUnlockedCells'] = function ($value) {
+        $this->mappings['protection']['selectUnlockedCells'] = function ($value)
+        {
             $this->object->getProtection()->setSelectUnlockedCells($value);
         };
-        $this->mappings['protection']['sheet'] = function ($value) {
+        $this->mappings['protection']['sheet'] = function ($value)
+        {
             $this->object->getProtection()->setSheet($value);
         };
-        $this->mappings['protection']['sort'] = function ($value) {
+        $this->mappings['protection']['sort'] = function ($value)
+        {
             $this->object->getProtection()->setSort($value);
         };
-        $this->mappings['rightToLeft'] = function ($value) {
+        $this->mappings['rightToLeft'] = function ($value)
+        {
             $this->object->setRightToLeft($value);
         };
         $this->mappings['rowDimension']['__multi'] = true;
-        $this->mappings['rowDimension']['__object'] = function ($key) {
+        $this->mappings['rowDimension']['__object'] = function ($key)
+        {
             return $key === 'default' ? $this->object->getDefaultRowDimension() : $this->object->getRowDimension($key);
         };
-        $this->mappings['rowDimension']['collapsed'] = function ($key, $value) {
+        $this->mappings['rowDimension']['collapsed'] = function ($key, $value)
+        {
             $this->mappings['rowDimension']['__object']($key)->setCollapsed($value);
         };
-        $this->mappings['rowDimension']['outlineLevel'] = function ($key, $value) {
+        $this->mappings['rowDimension']['outlineLevel'] = function ($key, $value)
+        {
             $this->mappings['rowDimension']['__object']($key)->setOutlineLevel($value);
         };
-        $this->mappings['rowDimension']['rowHeight'] = function ($key, $value) {
+        $this->mappings['rowDimension']['rowHeight'] = function ($key, $value)
+        {
             $this->mappings['rowDimension']['__object']($key)->setRowHeight($value);
         };
-        $this->mappings['rowDimension']['rowIndex'] = function ($key, $value) {
+        $this->mappings['rowDimension']['rowIndex'] = function ($key, $value)
+        {
             $this->mappings['rowDimension']['__object']($key)->setRowIndex($value);
         };
-        $this->mappings['rowDimension']['visible'] = function ($key, $value) {
+        $this->mappings['rowDimension']['visible'] = function ($key, $value)
+        {
             $this->mappings['rowDimension']['__object']($key)->setVisible($value);
         };
-        $this->mappings['rowDimension']['xfIndex'] = function ($key, $value) {
+        $this->mappings['rowDimension']['xfIndex'] = function ($key, $value)
+        {
             $this->mappings['rowDimension']['__object']($key)->setXfIndex($value);
         };
-        $this->mappings['rowDimension']['zeroHeight'] = function ($key, $value) {
+        $this->mappings['rowDimension']['zeroHeight'] = function ($key, $value)
+        {
             $this->mappings['rowDimension']['__object']($key)->setZeroHeight($value);
         };
-        $this->mappings['sheetState'] = function ($value) {
+        $this->mappings['sheetState'] = function ($value)
+        {
             $this->object->setSheetState($value);
         };
-        $this->mappings['showGridlines'] = function ($value) {
+        $this->mappings['showGridlines'] = function ($value)
+        {
             $this->object->setShowGridlines($value);
         };
-        $this->mappings['tabColor'] = function ($value) {
+        $this->mappings['tabColor'] = function ($value)
+        {
             $this->object->getTabColor()->setRGB($value);
         };
-        $this->mappings['zoomScale'] = function ($value) {
+        $this->mappings['zoomScale'] = function ($value)
+        {
             $this->object->getSheetView()->setZoomScale($value);
         };
     }
@@ -259,7 +313,7 @@ 
                 $this->documentWrapper->getObject()->createSheet()->setTitle($index);
             }
             $this->object = $this->documentWrapper->getObject()->setActiveSheetIndexByName($index);
-        }  else {
+        } else {
             // create new sheet without a name
             $this->documentWrapper->getObject()->createSheet();
             $this->object = $this->documentWrapper->getObject()->setActiveSheetIndex(0);