majiameng / spreadsheet-php

src/Gateways/Import.php

Spacing +2 added lines, -2 removed lines

@@ -30,9 +30,9 @@
      * @return $this
      * @throws Exception
      */
-    public function initWorkSheet($filename='')
+    public function initWorkSheet($filename = '')
     {
-        if(!empty($filename)){
+        if (!empty($filename)) {
             $this->setFileName($filename);
         }
         $this->loadFile($this->fileName);

src/Connector/Gateway.php

Spacing +11 added lines, -11 removed lines

@@ -44,8 +44,8 @@ 
      * @author: Tinymeng <666@majiameng.com>
      * @time: 2022/4/24 17:35
      */
-    protected function cellName($columnIndex){
-        $columnIndex =(int)$columnIndex+1;
+    protected function cellName($columnIndex) {
+        $columnIndex = (int) $columnIndex + 1;
         static $indexCache = [];
 
         if (!isset($indexCache[$columnIndex])) {
@@ -54,7 +54,7 @@ 
             do {
                 $characterValue = ($indexValue % 26) ?: 26;
                 $indexValue = ($indexValue - $characterValue) / 26;
-                $base26 = chr($characterValue + 64) . ($base26 ?: '');
+                $base26 = chr($characterValue + 64).($base26 ?: '');
             } while ($indexValue > 0);
             $indexCache[$columnIndex] = $base26;
         }
@@ -67,10 +67,10 @@ 
      * @param string
      * @return mixed
      */
-    protected function formatValue($v){
-        if($this->format === false) return $v;
-        if(is_numeric($v) && strlen($v)===10){
-            $v = date($this->format_date,$v);//时间戳转时间格式
+    protected function formatValue($v) {
+        if ($this->format === false) return $v;
+        if (is_numeric($v) && strlen($v) === 10) {
+            $v = date($this->format_date, $v); //时间戳转时间格式
         }
         return $v;
     }
@@ -80,9 +80,9 @@ 
      * @param $lastCell
      * @return array
      */
-    protected function getCellName($lastCell){
+    protected function getCellName($lastCell) {
         $cellName = array();
-        for($i='A'; $i!=$lastCell; $i++) {
+        for ($i = 'A'; $i != $lastCell; $i++) {
             $cellName[] = $i;
         }
         $cellName[] = $i++;
@@ -96,7 +96,7 @@ 
      * @return array|string|string[]
      * @throws PhpSpreadsheetException
      */
-    protected function verifyFile($path, $verifyFile = true, $zip = null){
+    protected function verifyFile($path, $verifyFile = true, $zip = null) {
         if ($verifyFile && preg_match('~^data:image/[a-z]+;base64,~', $path) !== 1) {
             // Check if a URL has been passed. https://stackoverflow.com/a/2058596/1252979
             if (filter_var($path, FILTER_VALIDATE_URL)) {
@@ -143,7 +143,7 @@ 
      * @return $this
      * @throws \PhpOffice\PhpSpreadsheet\Exception
      */
-    public function selectWorkSheet($sheetIndex=0)
+    public function selectWorkSheet($sheetIndex = 0)
     {
         $this->workSheet = $this->spreadSheet->getSheet($sheetIndex);
         return $this;

src/Excel/TWorkSheet.php

Spacing +101 added lines, -101 removed lines

@@ -12,7 +12,7 @@ 
 use tinymeng\tools\exception\StatusCode;
 use tinymeng\tools\exception\TinymengException;
 
-trait TWorkSheet{
+trait TWorkSheet {
 
     /**
      * sheet名称
@@ -45,7 +45,7 @@ 
      * 文件信息
      * @var array
      */
-    private $fileTitle=[];
+    private $fileTitle = [];
 
 
     /**
@@ -98,7 +98,7 @@ 
      * @param $data
      * @return $this
      */
-    public function setData($data){
+    public function setData($data) {
         $this->data = $data;
         return $this;
     }
@@ -107,7 +107,7 @@ 
      * @param $data
      * @return $this
      */
-    public function getData(){
+    public function getData() {
         return $this->data;
     }
 
@@ -123,7 +123,7 @@ 
         $this->fileTitle = [];
         $this->data = [];
         $this->field = [];
-        if($this->freezePane) $this->workSheet->freezePane($this->freezePane); //冻结窗格
+        if ($this->freezePane) $this->workSheet->freezePane($this->freezePane); //冻结窗格
     }
 
     /**
@@ -133,10 +133,10 @@ 
      * @throws TinymengException
      * @throws \PhpOffice\PhpSpreadsheet\Exception
      */
-    public function setWorkSheetData($titleConfig,$data)
+    public function setWorkSheetData($titleConfig, $data)
     {
         $this->titleConfig = $titleConfig;
-        if(isset($titleConfig['title_row']) || isset($titleConfig['group_left'])){
+        if (isset($titleConfig['title_row']) || isset($titleConfig['group_left'])) {
             /**
              * $titleConfig = [
              *       'title_row'=>1,
@@ -146,14 +146,14 @@ 
              *       ],
              *  ];
              */
-            $this->title_row = $titleConfig['title_row']??1;
-            $this->group_left = $titleConfig['group_left']??[];
-            $titleData = $titleConfig['title']??[];
+            $this->title_row = $titleConfig['title_row'] ?? 1;
+            $this->group_left = $titleConfig['group_left'] ?? [];
+            $titleData = $titleConfig['title'] ?? [];
             // 新增：读取mergeColumns配置
             if (isset($titleConfig['mergeColumns'])) {
                 $this->mergeColumns = $titleConfig['mergeColumns'];
             }
-        }else{
+        } else {
             /**
              *  $titleConfig = [
              *       '姓名'=>'name',
@@ -163,33 +163,33 @@ 
         }
         // 根据字段映射方式处理 title
         if ($this->fieldMappingMethod === ConstCode::FIELD_MAPPING_METHOD_FIELD_CORRESPONDING_NAME) {
-            $this->fileTitle = array_flip($titleData);// 字段对应名称方式 - 需要将键值对调
-        }else{
-            $this->fileTitle = $titleData;// 名称对应字段方式 - 保持原样
+            $this->fileTitle = array_flip($titleData); // 字段对应名称方式 - 需要将键值对调
+        } else {
+            $this->fileTitle = $titleData; // 名称对应字段方式 - 保持原样
         }
         $this->data = $data;
 
         /** 设置第一行格式 */
-        if(!empty($this->mainTitle)){
+        if (!empty($this->mainTitle)) {
             $this->excelHeader();
-            $this->_row ++;//当前行数
+            $this->_row++; //当前行数
         }
 
         /** 设置表头 **/
         $this->excelTitle();
 
         /** 获取列表里所有字段 **/
-        foreach ($this->fileTitle as $key => $val){
-            if(is_array($val)){
-                foreach ($val as $k => $v){
+        foreach ($this->fileTitle as $key => $val) {
+            if (is_array($val)) {
+                foreach ($val as $k => $v) {
                     $this->field[] = $v;
                 }
-            }else{
+            } else {
                 $this->field[] = $val;
             }
         }
         /** 查询结果赋值 **/
-        if(!empty($this->data)){
+        if (!empty($this->data)) {
             $this->excelSetValue();
         }
         // 新增：应用全表样式
@@ -206,42 +206,42 @@ 
      * @author: Tinymeng <666@majiameng.com>
      * @time: 2022/2/22 11:43
      */
-    public function excelSetValue(){
-        if(!empty($this->titleConfig['data_start_row'])){
+    public function excelSetValue() {
+        if (!empty($this->titleConfig['data_start_row'])) {
             $this->_row = $this->titleConfig['data_start_row'];
         }
 
-        if(empty($this->group_left)){ //判断左侧是否分组
+        if (empty($this->group_left)) { //判断左侧是否分组
             $rowStart = $this->_row;
-            foreach ($this->data as $key => $val){
+            foreach ($this->data as $key => $val) {
                 $this->excelSetCellValue($val);
             }
             // 新增：处理mergeColumns自动合并
             if (!empty($this->mergeColumns)) {
                 $this->autoMergeColumns($rowStart, $this->_row - 1);
             }
-        }else{   //根据设置分组字段进行分组
+        } else {   //根据设置分组字段进行分组
             /** 数据分组 **/
             $data = [];
             $group_left_count = count($this->group_left);
-            if($group_left_count == 1){
-                foreach ($this->data as $k => $v){
+            if ($group_left_count == 1) {
+                foreach ($this->data as $k => $v) {
                     $data[$v[$this->group_left[0]]][] = $v;
                 }
-                foreach ($data as $k =>$v){
+                foreach ($data as $k =>$v) {
                     $data[$k] = [
                         'data' => $v,
                         'count' => count($v)
                     ];
                 }
                 $this->excelGroupLeft($data, $group_left_count);
-            }elseif($group_left_count == 2){
+            }elseif ($group_left_count == 2) {
                 foreach ($this->data as $v) {
                     $data[$v[$this->group_left[0]]][$v[$this->group_left[1]]][] = $v;
                 }
                 $this->data = $this->arrayCount($data);
                 $this->excelGroupLeft($this->data, $group_left_count);
-            }else{
+            } else {
                 throw new TinymengException(StatusCode::COMMON_PARAM_INVALID,
                     '左侧分组过多，导出失败！'
                 );
@@ -253,9 +253,9 @@ 
      * @return void
      * @throws \PhpOffice\PhpSpreadsheet\Exception
      */
-    public function excelHeader(){
+    public function excelHeader() {
         $row = 1;
-        if(!empty($this->mainTitle)){
+        if (!empty($this->mainTitle)) {
             $this->workSheet->setCellValue('A'.$row, $this->mainTitle);
         }
 
@@ -270,36 +270,36 @@ 
         }
 
         // 使用实际的标题列数来合并单元格
-        $this->workSheet->mergeCells('A'.$row.':'.$this->cellName($titleCount-1).$row);
+        $this->workSheet->mergeCells('A'.$row.':'.$this->cellName($titleCount - 1).$row);
     }
 
     /**
      * @return void
      * @throws \PhpOffice\PhpSpreadsheet\Exception
      */
-    private function excelTitle(){
-        if(isset($this->titleConfig['title_show']) && $this->titleConfig['title_show']===false){
+    private function excelTitle() {
+        if (isset($this->titleConfig['title_show']) && $this->titleConfig['title_show'] === false) {
             return;
         }
-        if(!empty($this->titleConfig['title_start_row'])){
+        if (!empty($this->titleConfig['title_start_row'])) {
             $this->_row = $this->titleConfig['title_start_row'];
         }
 
         $_merge = $this->cellName($this->_col);
         foreach ($this->fileTitle as $key => $val) {
-            if(!empty($this->titleHeight)) {
-                $this->workSheet->getRowDimension($this->_col)->setRowHeight($this->titleHeight);//行高度
+            if (!empty($this->titleHeight)) {
+                $this->workSheet->getRowDimension($this->_col)->setRowHeight($this->titleHeight); //行高度
             }
             $rowName = $this->cellName($this->_col);
-            $this->workSheet->getStyle($rowName . $this->_row)->getAlignment()->setWrapText(true);//自动换行
+            $this->workSheet->getStyle($rowName.$this->_row)->getAlignment()->setWrapText(true); //自动换行
             if (is_array($val)) {
                 $num = 1;
                 $_cols = $this->_col;
                 foreach ($val as $k => $v) {
-                    $this->workSheet->setCellValue($this->cellName($_cols) . ($this->_row+1), $k);
-                    if(!empty($this->titleWidth)) {
+                    $this->workSheet->setCellValue($this->cellName($_cols).($this->_row + 1), $k);
+                    if (!empty($this->titleWidth)) {
                         $this->workSheet->getColumnDimension($this->cellName($_cols))->setWidth($this->titleWidth); //列宽度
-                    }else{
+                    } else {
                         $this->workSheet->getColumnDimension($this->cellName($_cols))->setAutoSize(true); //自动计算宽度
                     }
                     if ($num < count($val)) {
@@ -308,23 +308,23 @@ 
                     }
                     $_cols++;
                 }
-                $this->workSheet->mergeCells($_merge . $this->_row.':' . $this->cellName($this->_col) .$this->_row);
-                $this->workSheet->setCellValue($_merge . $this->_row, $key);//设置值
+                $this->workSheet->mergeCells($_merge.$this->_row.':'.$this->cellName($this->_col).$this->_row);
+                $this->workSheet->setCellValue($_merge.$this->_row, $key); //设置值
             } else {
                 if ($this->title_row != 1) {
-                    $this->workSheet->mergeCells($rowName . $this->_row.':' . $rowName . ($this->_row + $this->title_row - 1));
+                    $this->workSheet->mergeCells($rowName.$this->_row.':'.$rowName.($this->_row + $this->title_row - 1));
                 }
-                $this->workSheet->setCellValue($rowName . $this->_row, $key);//设置值
-                if(!empty($this->titleWidth)){
+                $this->workSheet->setCellValue($rowName.$this->_row, $key); //设置值
+                if (!empty($this->titleWidth)) {
                     $this->workSheet->getColumnDimension($rowName)->setWidth($this->titleWidth); //列宽度
-                }else{
+                } else {
                     $this->workSheet->getColumnDimension($rowName)->setAutoSize(true); //自动计算宽度
                 }
             }
             $this->_col++;
             $_merge = $this->cellName($this->_col);
         }
-        $this->_row += $this->title_row;//当前行数
+        $this->_row += $this->title_row; //当前行数
     }
 
     /**
@@ -335,63 +335,63 @@ 
     private function excelSetCellValue($val)
     {
         //设置单元格行高
-        if(!empty($this->height)){
+        if (!empty($this->height)) {
             $this->workSheet->getRowDimension($this->_row)->setRowHeight($this->height);
         }
         $_lie = 0;
-        foreach ($this->field as $v){
+        foreach ($this->field as $v) {
             $rowName = $this->cellName($_lie);
 
-            if(strpos($v,'.') !== false){
-                $v = explode('.',$v);
+            if (strpos($v, '.') !== false) {
+                $v = explode('.', $v);
                 $content = $val;
-                for ($i=0;$i<count($v);$i++){
-                    $content = $content[$v[$i]]??'';
+                for ($i = 0; $i < count($v); $i++) {
+                    $content = $content[$v[$i]] ?? '';
                 }
-            }elseif($v == '_id'){
-                $content = $this->_row-$this->title_row;//自增序号列
-            }else{
-                $content = ($val[$v]??'');
+            }elseif ($v == '_id') {
+                $content = $this->_row - $this->title_row; //自增序号列
+            } else {
+                $content = ($val[$v] ?? '');
             }
-            if(is_array($content) && isset($content['type']) && isset($content['content'])){
-                if($content['type'] == 'image'){
+            if (is_array($content) && isset($content['type']) && isset($content['content'])) {
+                if ($content['type'] == 'image') {
                     $path = $this->verifyFile($content['content']);
                     $drawing = new \PhpOffice\PhpSpreadsheet\Worksheet\Drawing();
                     $drawing->setPath($path);
-                    if(!empty($content['height'])) {
+                    if (!empty($content['height'])) {
                         $drawing->setHeight($content['height']);
                     }
-                    if(!empty($content['width'])) {
-                        $drawing->setWidth($content['width']);//只设置高，宽会自适应，如果设置宽后，高则失效
+                    if (!empty($content['width'])) {
+                        $drawing->setWidth($content['width']); //只设置高，宽会自适应，如果设置宽后，高则失效
                     }
-                    if(!empty($content['offsetX'])) {
-                        $drawing->setOffsetX($content['offsetX']);//设置X方向偏移量
+                    if (!empty($content['offsetX'])) {
+                        $drawing->setOffsetX($content['offsetX']); //设置X方向偏移量
                     }
-                    if(!empty($content['offsetY'])) {
-                        $drawing->setOffsetY($content['offsetY']);//设置Y方向偏移量
+                    if (!empty($content['offsetY'])) {
+                        $drawing->setOffsetY($content['offsetY']); //设置Y方向偏移量
                     }
 
                     $drawing->setCoordinates($rowName.$this->_row);
                     $drawing->setWorksheet($this->workSheet);
                 }
-            }elseif(is_array($content) && isset($content['formula'])){
+            }elseif (is_array($content) && isset($content['formula'])) {
                 // 新增：支持 ['formula' => '公式'] 写法
                 $this->workSheet->setCellValueExplicit($rowName.$this->_row, $content['formula'], \PhpOffice\PhpSpreadsheet\Cell\DataType::TYPE_FORMULA);
-            }else {
-                $content = $this->formatValue($content);//格式化数据
-                if (is_numeric($content)){
-                    if($this->autoDataType && strlen($content)<11){
-                        $this->workSheet->setCellValueExplicit($rowName.$this->_row, $content,DataType::TYPE_NUMERIC);
-                    }else{
-                        $this->workSheet->setCellValueExplicit($rowName.$this->_row, $content,DataType::TYPE_STRING2);
+            } else {
+                $content = $this->formatValue($content); //格式化数据
+                if (is_numeric($content)) {
+                    if ($this->autoDataType && strlen($content) < 11) {
+                        $this->workSheet->setCellValueExplicit($rowName.$this->_row, $content, DataType::TYPE_NUMERIC);
+                    } else {
+                        $this->workSheet->setCellValueExplicit($rowName.$this->_row, $content, DataType::TYPE_STRING2);
                     }
-                }else{
-                    $this->workSheet->setCellValueExplicit($rowName.$this->_row, $content,DataType::TYPE_STRING2);
+                } else {
+                    $this->workSheet->setCellValueExplicit($rowName.$this->_row, $content, DataType::TYPE_STRING2);
                 }
             }
-            $_lie ++;
+            $_lie++;
         }
-        $this->_row ++;
+        $this->_row++;
     }
 
     /**
@@ -404,22 +404,22 @@ 
     {
         // 获取分组字段在field中的实际位置
         $group_field_positions = [];
-        foreach($this->group_left as $group_field){
+        foreach ($this->group_left as $group_field) {
             $position = array_search($group_field, $this->field);
-            if($position !== false){
+            if ($position !== false) {
                 $group_field_positions[] = $position;
             }
         }
 
-        if(empty($group_field_positions)){
+        if (empty($group_field_positions)) {
             throw new TinymengException(StatusCode::COMMON_PARAM_INVALID, '分组字段未在标题中定义');
         }
 
         $group_start = $this->_row;
-        foreach ($data as $key => $val){
+        foreach ($data as $key => $val) {
             // 第一级分组的合并单元格
             $rowName = $this->cellName($group_field_positions[0]); // 使用第一个分组字段的实际位置
-            $coordinate = $rowName.$this->_row.':'.$rowName.($this->_row+$val['count']-1);
+            $coordinate = $rowName.$this->_row.':'.$rowName.($this->_row + $val['count'] - 1);
             $this->workSheet->mergeCells($coordinate);
             $this->workSheet->setCellValue($rowName.$this->_row, $key);
 
@@ -431,27 +431,27 @@ 
                     $colIdx = array_search($field, $this->field);
                     if ($colIdx !== false) {
                         $colLetter = $this->cellName($colIdx);
-                        $this->workSheet->mergeCells($colLetter.$this->_row.':'.$colLetter.($this->_row+$val['count']-1));
+                        $this->workSheet->mergeCells($colLetter.$this->_row.':'.$colLetter.($this->_row + $val['count'] - 1));
                         // 取本组第一个数据的值
                         $this->workSheet->setCellValue($colLetter.$this->_row, $val['data'][0][$field] ?? '');
                     }
                 }
             }
             
-            if($group_left_count == 1){
-                foreach ($val['data'] as $dataRow){
+            if ($group_left_count == 1) {
+                foreach ($val['data'] as $dataRow) {
                     $this->excelSetCellValue($dataRow);
                 }
-            }else{
+            } else {
                 $sub_group_start = $this->_row;
                 $rowName = $this->cellName($group_field_positions[1]); // 使用第二个分组字段的实际位置
                 
-                foreach ($val['data'] as $k => $v){
-                    $coordinate = $rowName.$sub_group_start.':'.$rowName.($sub_group_start+$v['count']-1);
+                foreach ($val['data'] as $k => $v) {
+                    $coordinate = $rowName.$sub_group_start.':'.$rowName.($sub_group_start + $v['count'] - 1);
                     $this->workSheet->mergeCells($coordinate);
                     $this->workSheet->setCellValue($rowName.$sub_group_start, $k);
                     
-                    foreach ($v['data'] as $data){
+                    foreach ($v['data'] as $data) {
                         $this->excelSetCellValue($data);
                     }
                     
@@ -470,13 +470,13 @@ 
      * @param array $data 二维数组原始数据
      * @return array
      */
-    private function arrayCount($data=[])
+    private function arrayCount($data = [])
     {
-        foreach ($data as $key => $val){
+        foreach ($data as $key => $val) {
             $num = 0;
-            foreach ($val as $k => $v){
+            foreach ($val as $k => $v) {
                 $sub_num = count($v);
-                $num = $num+$sub_num;
+                $num = $num + $sub_num;
                 $val[$k] = [
                     'count' => $sub_num,
                     'data' => $v
@@ -505,10 +505,10 @@ 
             $lastValue = null;
             $mergeStart = $rowStart;
             for ($row = $rowStart; $row <= $rowEnd; $row++) {
-                $cellValue = $this->workSheet->getCell($colLetter . $row)->getValue();
+                $cellValue = $this->workSheet->getCell($colLetter.$row)->getValue();
                 if ($lastValue !== null && $cellValue !== $lastValue) {
                     if ($row - $mergeStart > 1) {
-                        $this->workSheet->mergeCells($colLetter . $mergeStart . ':' . $colLetter . ($row - 1));
+                        $this->workSheet->mergeCells($colLetter.$mergeStart.':'.$colLetter.($row - 1));
                     }
                     $mergeStart = $row;
                 }
@@ -516,7 +516,7 @@ 
             }
             // 处理最后一组
             if ($rowEnd - $mergeStart + 1 > 1) {
-                $this->workSheet->mergeCells($colLetter . $mergeStart . ':' . $colLetter . $rowEnd);
+                $this->workSheet->mergeCells($colLetter.$mergeStart.':'.$colLetter.$rowEnd);
             }
         }
     }
@@ -532,7 +532,7 @@ 
         $endCol = $this->cellName(count($this->field) - 1);
         $startRow = 1;
         $endRow = $this->_row - 1;
-        $cellRange = $startCol . $startRow . ':' . $endCol . $endRow;
+        $cellRange = $startCol.$startRow.':'.$endCol.$endRow;
         $this->workSheet->getStyle($cellRange)->applyFromArray($this->sheetStyle);
     }
 

Braces +31 added lines, -20 removed lines

@@ -123,7 +123,10 @@ 
         $this->fileTitle = [];
         $this->data = [];
         $this->field = [];
-        if($this->freezePane) $this->workSheet->freezePane($this->freezePane); //冻结窗格
+        if($this->freezePane) {
+            $this->workSheet->freezePane($this->freezePane);
+        }
+        //冻结窗格
     }
 
     /**
@@ -153,7 +156,7 @@ 
             if (isset($titleConfig['mergeColumns'])) {
                 $this->mergeColumns = $titleConfig['mergeColumns'];
             }
-        }else{
+        } else{
             /**
              *  $titleConfig = [
              *       '姓名'=>'name',
@@ -164,7 +167,7 @@ 
         // 根据字段映射方式处理 title
         if ($this->fieldMappingMethod === ConstCode::FIELD_MAPPING_METHOD_FIELD_CORRESPONDING_NAME) {
             $this->fileTitle = array_flip($titleData);// 字段对应名称方式 - 需要将键值对调
-        }else{
+        } else{
             $this->fileTitle = $titleData;// 名称对应字段方式 - 保持原样
         }
         $this->data = $data;
@@ -184,7 +187,7 @@ 
                 foreach ($val as $k => $v){
                     $this->field[] = $v;
                 }
-            }else{
+            } else{
                 $this->field[] = $val;
             }
         }
@@ -220,7 +223,7 @@ 
             if (!empty($this->mergeColumns)) {
                 $this->autoMergeColumns($rowStart, $this->_row - 1);
             }
-        }else{   //根据设置分组字段进行分组
+        } else{   //根据设置分组字段进行分组
             /** 数据分组 **/
             $data = [];
             $group_left_count = count($this->group_left);
@@ -235,13 +238,13 @@ 
                     ];
                 }
                 $this->excelGroupLeft($data, $group_left_count);
-            }elseif($group_left_count == 2){
+            } elseif($group_left_count == 2){
                 foreach ($this->data as $v) {
                     $data[$v[$this->group_left[0]]][$v[$this->group_left[1]]][] = $v;
                 }
                 $this->data = $this->arrayCount($data);
                 $this->excelGroupLeft($this->data, $group_left_count);
-            }else{
+            } else{
                 throw new TinymengException(StatusCode::COMMON_PARAM_INVALID,
                     '左侧分组过多，导出失败！'
                 );
@@ -299,7 +302,7 @@ 
                     $this->workSheet->setCellValue($this->cellName($_cols) . ($this->_row+1), $k);
                     if(!empty($this->titleWidth)) {
                         $this->workSheet->getColumnDimension($this->cellName($_cols))->setWidth($this->titleWidth); //列宽度
-                    }else{
+                    } else{
                         $this->workSheet->getColumnDimension($this->cellName($_cols))->setAutoSize(true); //自动计算宽度
                     }
                     if ($num < count($val)) {
@@ -317,7 +320,7 @@ 
                 $this->workSheet->setCellValue($rowName . $this->_row, $key);//设置值
                 if(!empty($this->titleWidth)){
                     $this->workSheet->getColumnDimension($rowName)->setWidth($this->titleWidth); //列宽度
-                }else{
+                } else{
                     $this->workSheet->getColumnDimension($rowName)->setAutoSize(true); //自动计算宽度
                 }
             }
@@ -348,9 +351,9 @@ 
                 for ($i=0;$i<count($v);$i++){
                     $content = $content[$v[$i]]??'';
                 }
-            }elseif($v == '_id'){
+            } elseif($v == '_id'){
                 $content = $this->_row-$this->title_row;//自增序号列
-            }else{
+            } else{
                 $content = ($val[$v]??'');
             }
             if(is_array($content) && isset($content['type']) && isset($content['content'])){
@@ -374,18 +377,18 @@ 
                     $drawing->setCoordinates($rowName.$this->_row);
                     $drawing->setWorksheet($this->workSheet);
                 }
-            }elseif(is_array($content) && isset($content['formula'])){
+            } elseif(is_array($content) && isset($content['formula'])){
                 // 新增：支持 ['formula' => '公式'] 写法
                 $this->workSheet->setCellValueExplicit($rowName.$this->_row, $content['formula'], \PhpOffice\PhpSpreadsheet\Cell\DataType::TYPE_FORMULA);
-            }else {
+            } else {
                 $content = $this->formatValue($content);//格式化数据
                 if (is_numeric($content)){
                     if($this->autoDataType && strlen($content)<11){
                         $this->workSheet->setCellValueExplicit($rowName.$this->_row, $content,DataType::TYPE_NUMERIC);
-                    }else{
+                    } else{
                         $this->workSheet->setCellValueExplicit($rowName.$this->_row, $content,DataType::TYPE_STRING2);
                     }
-                }else{
+                } else{
                     $this->workSheet->setCellValueExplicit($rowName.$this->_row, $content,DataType::TYPE_STRING2);
                 }
             }
@@ -427,7 +430,9 @@ 
             if (!empty($this->mergeColumns)) {
                 foreach ($this->mergeColumns as $field) {
                     // 跳过分组字段本身
-                    if (in_array($field, $this->group_left)) continue;
+                    if (in_array($field, $this->group_left)) {
+                        continue;
+                    }
                     $colIdx = array_search($field, $this->field);
                     if ($colIdx !== false) {
                         $colLetter = $this->cellName($colIdx);
@@ -442,7 +447,7 @@ 
                 foreach ($val['data'] as $dataRow){
                     $this->excelSetCellValue($dataRow);
                 }
-            }else{
+            } else{
                 $sub_group_start = $this->_row;
                 $rowName = $this->cellName($group_field_positions[1]); // 使用第二个分组字段的实际位置
                 
@@ -497,10 +502,14 @@ 
      */
     private function autoMergeColumns($rowStart, $rowEnd)
     {
-        if ($rowEnd <= $rowStart) return;
+        if ($rowEnd <= $rowStart) {
+            return;
+        }
         foreach ($this->mergeColumns as $fieldName) {
             $colIdx = array_search($fieldName, $this->field);
-            if ($colIdx === false) continue;
+            if ($colIdx === false) {
+                continue;
+            }
             $colLetter = $this->cellName($colIdx);
             $lastValue = null;
             $mergeStart = $rowStart;
@@ -526,7 +535,9 @@ 
      */
     private function applySheetStyle()
     {
-        if (empty($this->sheetStyle)) return;
+        if (empty($this->sheetStyle)) {
+            return;
+        }
         // 计算数据区范围
         $startCol = 'A';
         $endCol = $this->cellName(count($this->field) - 1);

example/export_load_file.php

Spacing +10 added lines, -10 removed lines

@@ -15,7 +15,7 @@ 
 $startRow = 4;
 $titleConfig = [
     'title_show' => true,
-    'data_start_row' => $startRow,  // 内容开始行数
+    'data_start_row' => $startRow, // 内容开始行数
     'group_left' => ['id'], // 以id分组
     'mergeColumns' => ['meeting_name', 'time'], // 需要自动合并的字段
     'title' => [
@@ -94,18 +94,18 @@ 
 
 $data[] = [
     'id' => '合计',
-    'price' => ['formula' => '=SUM(E'.$startRow.':E'.($startRow+count($data)-1).')'],
+    'price' => ['formula' => '=SUM(E'.$startRow.':E'.($startRow + count($data) - 1).')'],
 ];
 
 // 配置参数
 $config = [
-    'horizontalCenter' => true,               // 是否居中
-    'titleHeight' => 22,                      // 定义表头行高
-    'titleWidth' => 20,                       // 定义表头列宽
-    'height' => 22,                           // 定义数据行高
-    'autoFilter' => false,                     // 开启自动筛选
-    'freezePane' => false,                    // 冻结窗格（首行首列）
-    'fieldMappingMethod' => ConstCode::FIELD_MAPPING_METHOD_NAME_CORRESPONDING_FIELD,  // 名称对应字段方式
+    'horizontalCenter' => true, // 是否居中
+    'titleHeight' => 22, // 定义表头行高
+    'titleWidth' => 20, // 定义表头列宽
+    'height' => 22, // 定义数据行高
+    'autoFilter' => false, // 开启自动筛选
+    'freezePane' => false, // 冻结窗格（首行首列）
+    'fieldMappingMethod' => ConstCode::FIELD_MAPPING_METHOD_NAME_CORRESPONDING_FIELD, // 名称对应字段方式
     // 更多样式请查询 https://phpspreadsheet.readthedocs.io/en/latest/topics/recipes/#styling-cells
     'sheetStyle' => [
         'font' => [
@@ -118,7 +118,7 @@ 
     ],
 ];
 
-$complexFormat = function($sheet) use ($startRow,$data) {
+$complexFormat = function($sheet) use ($startRow, $data) {
     $endRow = $startRow + count($data) - 1;
     $cellRange = "A{$startRow}:E{$endRow}";
 

example/export_group.php

Spacing +23 added lines, -23 removed lines

@@ -13,12 +13,12 @@ 
  * 注意：分组字段必须在title中定义
  */
 $titleConfig = [
-    'title_row' => 2,  // 表头行号
-    'group_left' => ['user_id', 'day'],  // 左侧分组字段，最多支持两级分组
+    'title_row' => 2, // 表头行号
+    'group_left' => ['user_id', 'day'], // 左侧分组字段，最多支持两级分组
     'title' => [
         'ID' => 'id',
-        '用户ID' => 'user_id',    // 分组字段1
-        '结算日期' => 'day',      // 分组字段2
+        '用户ID' => 'user_id', // 分组字段1
+        '结算日期' => 'day', // 分组字段2
         '订单编号' => 'order_sn',
         '下单时间' => 'create_time',
     ]
@@ -30,43 +30,43 @@ 
 $data = [
     [
         'id' => '1',
-        'user_id' => '1000',      // 第一组用户
-        'day' => '20220101',      // 第一天
+        'user_id' => '1000', // 第一组用户
+        'day' => '20220101', // 第一天
         'order_sn' => '20180101465464',
         'create_time' => '1687140376',
     ],
     [
         'id' => '2',
-        'user_id' => '1000',      // 第一组用户
-        'day' => '20220101',      // 第一天
+        'user_id' => '1000', // 第一组用户
+        'day' => '20220101', // 第一天
         'order_sn' => '20180101465465',
         'create_time' => '1687140377',
     ],
     [
         'id' => '3',
-        'user_id' => '1000',      // 第一组用户
-        'day' => '20220102',      // 第二天
+        'user_id' => '1000', // 第一组用户
+        'day' => '20220102', // 第二天
         'order_sn' => '20180102465466',
         'create_time' => '1687140378',
     ],
     [
         'id' => '4',
-        'user_id' => '1001',      // 第二组用户
-        'day' => '20220101',      // 第一天
+        'user_id' => '1001', // 第二组用户
+        'day' => '20220101', // 第一天
         'order_sn' => '20180101465467',
         'create_time' => '1687140379',
     ],
     [
         'id' => '5',
-        'user_id' => '1000',      // 第二组用户
-        'day' => '20220101',      // 第一天
+        'user_id' => '1000', // 第二组用户
+        'day' => '20220101', // 第一天
         'order_sn' => '20180101465468',
         'create_time' => '1687140379',
     ],
     [
         'id' => '6',
-        'user_id' => '1001',      // 第二组用户
-        'day' => '20220101',      // 第一天
+        'user_id' => '1001', // 第二组用户
+        'day' => '20220101', // 第一天
         'order_sn' => '20180101465469',
         'create_time' => '1687140379',
     ],
@@ -74,13 +74,13 @@ 
 
 // 配置参数
 $config = [
-    'horizontalCenter' => true,               // 是否居中
-    'titleHeight' => 22,                      // 定义表头行高
-    'titleWidth' => 20,                       // 定义表头列宽
-    'height' => 22,                           // 定义数据行高
-    'autoFilter' => true,                     // 开启自动筛选
-    'freezePane' => false,                    // 冻结窗格（首行首列）
-    'fieldMappingMethod' => ConstCode::FIELD_MAPPING_METHOD_NAME_CORRESPONDING_FIELD,  // 名称对应字段方式
+    'horizontalCenter' => true, // 是否居中
+    'titleHeight' => 22, // 定义表头行高
+    'titleWidth' => 20, // 定义表头列宽
+    'height' => 22, // 定义数据行高
+    'autoFilter' => true, // 开启自动筛选
+    'freezePane' => false, // 冻结窗格（首行首列）
+    'fieldMappingMethod' => ConstCode::FIELD_MAPPING_METHOD_NAME_CORRESPONDING_FIELD, // 名称对应字段方式
 ];
 
 // 创建导出实例并设置数据

example/export_complex_format.php

Spacing +10 added lines, -10 removed lines

@@ -13,8 +13,8 @@ 
  * 注意：分组字段必须在title中定义
  */
 $titleConfig = [
-    'title_row' => 2,  // 表头占用行数
-    'title_start_row' => null,  // 表头开始行数
+    'title_row' => 2, // 表头占用行数
+    'title_start_row' => null, // 表头开始行数
     'group_left' => ['id'], // 以id分组
     'mergeColumns' => ['meeting_name', 'time'], // 需要自动合并的字段
     'title' => [
@@ -97,13 +97,13 @@ 
 
 // 配置参数
 $config = [
-    'horizontalCenter' => true,               // 是否居中
-    'titleHeight' => 22,                      // 定义表头行高
-    'titleWidth' => 20,                       // 定义表头列宽
-    'height' => 22,                           // 定义数据行高
-    'autoFilter' => false,                     // 开启自动筛选
-    'freezePane' => false,                    // 冻结窗格（首行首列）
-    'fieldMappingMethod' => ConstCode::FIELD_MAPPING_METHOD_NAME_CORRESPONDING_FIELD,  // 名称对应字段方式
+    'horizontalCenter' => true, // 是否居中
+    'titleHeight' => 22, // 定义表头行高
+    'titleWidth' => 20, // 定义表头列宽
+    'height' => 22, // 定义数据行高
+    'autoFilter' => false, // 开启自动筛选
+    'freezePane' => false, // 冻结窗格（首行首列）
+    'fieldMappingMethod' => ConstCode::FIELD_MAPPING_METHOD_NAME_CORRESPONDING_FIELD, // 名称对应字段方式
     // 更多样式请查询 https://phpspreadsheet.readthedocs.io/en/latest/topics/recipes/#styling-cells
     'sheetStyle' => [
         'font' => [
@@ -126,7 +126,7 @@ 
 
     // 第2行：导出时间
     $sheet->mergeCells('A2:E2');
-    $sheet->setCellValue('A2', '导出时间：' . date('Y-m-d'));
+    $sheet->setCellValue('A2', '导出时间：'.date('Y-m-d'));
     $sheet->getStyle('A2')->getFont()->setSize(10)->getColor()->setRGB('888888');
     $sheet->getStyle('A2')->getAlignment()->setHorizontal(\PhpOffice\PhpSpreadsheet\Style\Alignment::HORIZONTAL_RIGHT);