majiameng / spreadsheet-php

src/Gateways/Export.php

Spacing +23 added lines, -23 removed lines

@@ -33,7 +33,7 @@ 
     /**
      * __construct
      */
-    public function __construct($config=[]){
+    public function __construct($config = []) {
         $this->setConfig($config);
 
         $this->spreadSheet = new Spreadsheet();
@@ -46,7 +46,7 @@ 
      * @param $config
      * @return $this
      */
-    public function setConfig($config){
+    public function setConfig($config) {
         foreach ($config as $key => $value) {
             if (property_exists($this, $key)) {
                 $this->$key = $value;
@@ -64,7 +64,7 @@ 
     {
         /** 实例化定义默认excel **/
         $this->spreadSheet->getProperties()->setCreator($this->creator)->setLastModifiedBy($this->creator);
-        if($this->horizontalCenter){
+        if ($this->horizontalCenter) {
             $this->spreadSheet->getDefaultStyle()->getAlignment()->setHorizontal(Alignment::HORIZONTAL_CENTER); //默认水平居中
             $this->spreadSheet->getDefaultStyle()->getAlignment()->setVertical(Alignment::VERTICAL_CENTER); //默认垂直居中
             $this->spreadSheet->getDefaultStyle()->getAlignment()->setHorizontal(Alignment::VERTICAL_CENTER); //默认垂直居中
@@ -77,19 +77,19 @@ 
      * @return $this
      * @throws \PhpOffice\PhpSpreadsheet\Exception
      */
-    public function createWorkSheet($sheetName="Worksheet")
+    public function createWorkSheet($sheetName = "Worksheet")
     {
         $this->sheetName = $sheetName;
         /** @var workSheet */
         $this->workSheet = $this->greateWorkSheet($sheetName);
-        if($this->workSheet == null){
-            if($this->sheetCount==1){
+        if ($this->workSheet == null) {
+            if ($this->sheetCount == 1) {
                 $this->workSheet = $this->spreadSheet->getActiveSheet();
-            }else{
+            } else {
                 $this->workSheet = $this->spreadSheet->createSheet();
             }
-            $this->sheetCount += 1;//总sheet数量
-            $this->workSheet->setTitle($sheetName);//设置sheet名称
+            $this->sheetCount += 1; //总sheet数量
+            $this->workSheet->setTitle($sheetName); //设置sheet名称
         }
 
         /** 初始化当前workSheet */
@@ -115,13 +115,13 @@ 
     public function generate()
     {
         /** 开启自动筛选 **/
-        if($this->autoFilter){
+        if ($this->autoFilter) {
             $this->spreadSheet->getActiveSheet()->setAutoFilter(
                 $this->spreadSheet->getActiveSheet()->calculateWorksheetDimension()
             );
         }
         //文件存储
-        if(empty($this->fileName)){
+        if (empty($this->fileName)) {
             $this->getFileName($this->sheetName);
         }
         return $this;
@@ -132,8 +132,8 @@ 
      * @param $file_name
      * @return string
      */
-    private function getFileName($sheetName){
-        $this->fileName = $sheetName.'_'.date('Y-m-d').'_'.rand(111,999).'.xlsx';
+    private function getFileName($sheetName) {
+        $this->fileName = $sheetName.'_'.date('Y-m-d').'_'.rand(111, 999).'.xlsx';
         return $this->fileName;
     }
 
@@ -143,18 +143,18 @@ 
      * @return void
      * @throws ExceptionAlias
      */
-    public function download($filename=''){
-        if(empty($filename)){
+    public function download($filename = '') {
+        if (empty($filename)) {
             $filename = $this->fileName;
-        }else{
+        } else {
             $filename = $this->getFileName($filename);
         }
 
         /** 输出下载 **/
-        ob_end_clean();//清除缓冲区,避免乱码
-        header( 'Access-Control-Allow-Headers:responsetype,content-type,usertoken');
-        header( 'Access-Control-Allow-Methods:GET,HEAD,PUT,POST,DELETE,PATCH');
-        header( 'Access-Control-Allow-Origin:*');
+        ob_end_clean(); //清除缓冲区,避免乱码
+        header('Access-Control-Allow-Headers:responsetype,content-type,usertoken');
+        header('Access-Control-Allow-Methods:GET,HEAD,PUT,POST,DELETE,PATCH');
+        header('Access-Control-Allow-Origin:*');
         header('Content-Type: application/vnd.ms-excel');
         header('Content-Disposition: attachment;filename="'.$filename);
         header('Cache-Control: max-age=0');
@@ -171,12 +171,12 @@ 
      * @return string
      * @throws ExceptionAlias
      */
-    public function save($filename='',$pathName=''): string
+    public function save($filename = '', $pathName = ''): string
     {
         $pathName = $this->getPathName($pathName);
-        if(empty($filename)){
+        if (empty($filename)) {
             $filename = $this->fileName;
-        }else{
+        } else {
             $filename = $this->getFileName($filename);
         }
         FileTool::mkdir($pathName);

src/Util/TConfig.php

Spacing +4 added lines, -4 removed lines

@@ -7,7 +7,7 @@ 
  */
 namespace tinymeng\spreadsheet\Util;
 
-trait TConfig{
+trait TConfig {
 
     /**
      * 文件创建者
@@ -244,13 +244,13 @@ 
      */
     private function getPathName($pathName)
     {
-        if(!empty($pathName)){
+        if (!empty($pathName)) {
             return $pathName;
         }
-        if($this->pathName){
+        if ($this->pathName) {
             return $this->pathName;
         }
-        $pathName = dirname( dirname(dirname(SPREADSHEET_ROOT_PATH))).DIRECTORY_SEPARATOR."public".DIRECTORY_SEPARATOR."export".DIRECTORY_SEPARATOR.date('Ymd').DIRECTORY_SEPARATOR;
+        $pathName = dirname(dirname(dirname(SPREADSHEET_ROOT_PATH))).DIRECTORY_SEPARATOR."public".DIRECTORY_SEPARATOR."export".DIRECTORY_SEPARATOR.date('Ymd').DIRECTORY_SEPARATOR;
         return $pathName;
     }
 

src/TSpreadSheet.php

Spacing +4 added lines, -4 removed lines

@@ -28,17 +28,17 @@ 
      * @return mixed
      * @throws \Exception
      */
-    protected static function init($gateway, $config=[])
+    protected static function init($gateway, $config = [])
     {
         $gateway = StringTool::uFirst($gateway);
-        $class = __NAMESPACE__ . '\\Gateways\\' . $gateway;
+        $class = __NAMESPACE__.'\\Gateways\\'.$gateway;
         if (class_exists($class)) {
             $configFile = SPREADSHEET_ROOT_PATH."/config/TSpreadSheet.php";
             if (!file_exists($configFile)) {
                 return false;
             }
             $baseConfig = require $configFile;
-            $app = new $class(array_replace_recursive($baseConfig,$config));
+            $app = new $class(array_replace_recursive($baseConfig, $config));
             if ($app instanceof GatewayInterface) {
                 return $app;
             }
@@ -55,7 +55,7 @@ 
      * @param $config
      * @return mixed
      */
-    public static function __callStatic($gateway, $config=[])
+    public static function __callStatic($gateway, $config = [])
     {
         return self::init($gateway, ...$config);
     }

tests/ExportTest.php

Spacing +1 added lines, -1 removed lines

@@ -26,7 +26,7 @@
 
     public function testSaveFile()
     {
-        $pathName = __DIR__ . '/tmp/';
+        $pathName = __DIR__.'/tmp/';
         $fileName = $this->export->save('TestSheet', $pathName);
         $this->assertTrue(file_exists($fileName));
         unlink($fileName);

src/Util/ConstCode.php

Spacing +3 added lines, -3 removed lines

@@ -7,7 +7,7 @@
  */
 namespace tinymeng\spreadsheet\Util;
 
-class ConstCode{
-    const FIELD_MAPPING_METHOD_FIELD_CORRESPONDING_NAME = 1;//字段对应名称
-    const FIELD_MAPPING_METHOD_NAME_CORRESPONDING_FIELD = 2;//名称对应字段
+class ConstCode {
+    const FIELD_MAPPING_METHOD_FIELD_CORRESPONDING_NAME = 1; //字段对应名称
+    const FIELD_MAPPING_METHOD_NAME_CORRESPONDING_FIELD = 2; //名称对应字段
 }

example/import.php

Spacing +3 added lines, -3 removed lines

@@ -24,14 +24,14 @@
 //    ->initWorkSheet($filename);//读取并初始化表格内容数据
 
 //2. 读取带图片并初始化表格内容数据
-$path = './uploads/imgs/'.date('Ymd', time());//excel中图片本地存储路径
+$path = './uploads/imgs/'.date('Ymd', time()); //excel中图片本地存储路径
 $TSpreadSheet = TSpreadSheet::import()
     ->initWorkSheet($filename)//读取并初始化表格内容数据
-    ->setRelativePath($path)->setImagePath($path);// 设置将excel中图片本地存储
+    ->setRelativePath($path)->setImagePath($path); // 设置将excel中图片本地存储
 
 //3. 设置title对应字段,获取表格内容
 $data = $TSpreadSheet->setTitle($title)->getExcelData();
-var_dump($data);die;
+var_dump($data); die;
 /**
  * array(3) {
  * [0]=>

example/export.php

Spacing +17 added lines, -17 removed lines

@@ -45,11 +45,11 @@ 
         'create_time'=>'1687140376',
         'image'=>[
             'type'=>'image',
-            'content'=>'http://static.majiameng.com/main/img/portrait.jpg',//网络图片确保存在
+            'content'=>'http://static.majiameng.com/main/img/portrait.jpg', //网络图片确保存在
             'height'=>100,
 //            'width'=>100,//只设置高，宽会自适应，如果设置宽后，高则失效
         ],
-    ],[
+    ], [
         'id'=>'2',
         'order_sn'=>'20190101465464',
         'user_id'=>'1000',
@@ -57,16 +57,16 @@ 
         'create_time'=>'1687140376',
         'image'=>[
             'type'=>'image',
-            'content'=>'./text.png',//本地图片确保存在
+            'content'=>'./text.png', //本地图片确保存在
             'height'=>100,
         ],
-    ],[
+    ], [
         'id'=>'3',
         'order_sn'=>'20200101465464',
         'user_id'=>'1000',
         'day'=>'20220101',
         'create_time'=>'1687140376',
-    ],[
+    ], [
         'id'=>'4',
         'order_sn'=>'20210101465464',
         'user_id'=>'1001',
@@ -76,12 +76,12 @@ 
 ];
 $TSpreadSheet = TSpreadSheet::export()
     //创建一个sheet，设置sheet表头，并给表格赋值
-    ->createWorkSheet($sheetName)->setWorkSheetData($title,$data);
+    ->createWorkSheet($sheetName)->setWorkSheetData($title, $data);
 //    ->createWorkSheet($sheetName1)->setWorkSheetData($title1,$data1);//如果多个sheet可多次创建
 
 //文件存储本地
 $path = $TSpreadSheet->generate()->save($filename);
-echo '生成excel路径：'.$path;exit();
+echo '生成excel路径：'.$path; exit();
 //生成excel路径：E:\spreadsheet-php\example\public\export\20240402\export_demo_2024-04-02_351.xlsx
 
 //这样直接输出到浏览器中下载
@@ -89,16 +89,16 @@ 
 
 //配置参数可以通过配置文件在初始化时传入
 $config = [
-    'pathName'=>null,                       //文件存储位置
-    'fileName'=>null,                       //文件名称
-    'horizontalCenter'=>true,               //是否居中
-    'titleHeight'=>null,                    //定义表头行高,常用22
-    'titleWidth'=>null,                     //定义表头列宽(未设置则自动计算宽度),常用20
-    'height'=>null,                         //定义数据行高,常用22
-    'autoFilter'=>false,                    //自动筛选(是否开启)
-    'autoDataType'=>true,                   //自动适应文本类型
-    'freezePane'=>false,                    //冻结窗格（要冻结的首行首列"B2"，false不开启）
-    'fieldMappingMethod'=>ConstCode::FIELD_MAPPING_METHOD_NAME_CORRESPONDING_FIELD,//字段映射方式
+    'pathName'=>null, //文件存储位置
+    'fileName'=>null, //文件名称
+    'horizontalCenter'=>true, //是否居中
+    'titleHeight'=>null, //定义表头行高,常用22
+    'titleWidth'=>null, //定义表头列宽(未设置则自动计算宽度),常用20
+    'height'=>null, //定义数据行高,常用22
+    'autoFilter'=>false, //自动筛选(是否开启)
+    'autoDataType'=>true, //自动适应文本类型
+    'freezePane'=>false, //冻结窗格（要冻结的首行首列"B2"，false不开启）
+    'fieldMappingMethod'=>ConstCode::FIELD_MAPPING_METHOD_NAME_CORRESPONDING_FIELD, //字段映射方式
 ];
 $TSpreadSheet = TSpreadSheet::export($config);
 //配置参数也可以后期赋值

config/TSpreadSheet.php

Spacing +12 added lines, -12 removed lines

@@ -1,22 +1,22 @@
 <?php
 use \tinymeng\spreadsheet\Util\ConstCode;
 return [
-    'creator'=>'tinymeng',                  //文件创建者
-    'pathName'=>null,                       //文件存储位置
-    'fileName'=>null,                       //文件名称
-    'horizontalCenter'=>true,               //是否居中
-    'titleHeight'=>null,                    //定义表头行高,常用22
-    'titleWidth'=>null,                     //定义表头列宽(未设置则自动计算宽度),常用20
-    'height'=>null,                         //定义数据行高,常用22
-    'autoFilter'=>false,                    //自动筛选(是否开启)
-    'autoDataType'=>true,                   //自动适应文本类型
-    'freezePane'=>false,                    //冻结窗格（要冻结的首行首列"B2"，false不开启）
+    'creator'=>'tinymeng', //文件创建者
+    'pathName'=>null, //文件存储位置
+    'fileName'=>null, //文件名称
+    'horizontalCenter'=>true, //是否居中
+    'titleHeight'=>null, //定义表头行高,常用22
+    'titleWidth'=>null, //定义表头列宽(未设置则自动计算宽度),常用20
+    'height'=>null, //定义数据行高,常用22
+    'autoFilter'=>false, //自动筛选(是否开启)
+    'autoDataType'=>true, //自动适应文本类型
+    'freezePane'=>false, //冻结窗格（要冻结的首行首列"B2"，false不开启）
     /**
      * 字段映射方式
      * ConstCode::FIELD_MAPPING_METHOD_FIELD_CORRESPONDING_NAME = 1;//字段对应名称
      * ConstCode::FIELD_MAPPING_METHOD_NAME_CORRESPONDING_FIELD = 2;//名称对应字段
      */
     'fieldMappingMethod'=>ConstCode::FIELD_MAPPING_METHOD_NAME_CORRESPONDING_FIELD,
-    'mainTitleLine'=>false,                 //主标题行是否显示
-    'mainTitle'=>'',                        //主标题名称，默认为sheet的名称
+    'mainTitleLine'=>false, //主标题行是否显示
+    'mainTitle'=>'', //主标题名称，默认为sheet的名称
 ];

src/Excel/SpreadSheet.php

Spacing +26 added lines, -26 removed lines

@@ -12,7 +12,7 @@ 
 use PhpOffice\PhpSpreadsheet\Worksheet\Drawing;
 use tinymeng\tools\FileTool;
 
-trait SpreadSheet{
+trait SpreadSheet {
 
     /**
      * sheet名称
@@ -29,7 +29,7 @@ 
      * 文件信息
      * @var array
      */
-    private $fileTitle=[];
+    private $fileTitle = [];
 
     /**
      * 标题占用行数
@@ -90,7 +90,7 @@ 
      */
     public $image_path = '/images';
 
-    public function setTitle($title){
+    public function setTitle($title) {
         $this->title = $title;
         $this->getTitleFields();
         return $this;
@@ -100,7 +100,7 @@ 
      * @param $value
      * @return $this
      */
-    public function setRelativePath($value){
+    public function setRelativePath($value) {
         $this->relative_path = $value;
         return $this;
     }
@@ -109,7 +109,7 @@ 
      * @param $value
      * @return $this
      */
-    public function setImagePath($value){
+    public function setImagePath($value) {
         $this->image_path = $value;
         return $this;
     }
@@ -121,40 +121,40 @@ 
      * @author: Tinymeng <666@majiameng.com>
      * @time: 2022/2/22 11:30
      */
-    public function getExcelData(){
+    public function getExcelData() {
         /* 循环读取每个单元格的数据 */
         $result = [];
-        $dataRow = $this->titleFieldsRow+1;
+        $dataRow = $this->titleFieldsRow + 1;
 
         //行数循环
-        for ($row = $dataRow; $row <= $this->rowCount; $row++){
-            $rowFlog = false;//行是否有内容（过滤空行）
+        for ($row = $dataRow; $row <= $this->rowCount; $row++) {
+            $rowFlog = false; //行是否有内容（过滤空行）
             //列数循环 , 列数是以A列开始
             $data = [];
-            foreach ($this->cellName as $column){
+            foreach ($this->cellName as $column) {
                 $cell = $this->workSheet->getCell($column.$row);
                 $value = trim($cell->getFormattedValue());
-                if(isset($this->title_fields[$column])){
+                if (isset($this->title_fields[$column])) {
                     $data[$this->title_fields[$column]] = $value;
-                    if(!empty($value)) $rowFlog = true;//有内容
+                    if (!empty($value)) $rowFlog = true; //有内容
                 }
             }
-            if($rowFlog) $result[] = $data;
+            if ($rowFlog) $result[] = $data;
         }
 
         /*
          * 读取表格图片数据
          * (如果为空右击图片转为浮动图片)
          */
-        $image_filename_prefix = time().rand(100,999).$this->sheet;
+        $image_filename_prefix = time().rand(100, 999).$this->sheet;
         foreach ($this->workSheet->getDrawingCollection() as $drawing) {
             /**@var $drawing Drawing* */
             list($column, $row) = Coordinate::coordinateFromString($drawing->getCoordinates());
-            $image_filename = "/{$image_filename_prefix}-" . $drawing->getCoordinates();
+            $image_filename = "/{$image_filename_prefix}-".$drawing->getCoordinates();
             $image_suffix = $this->saveImage($drawing, $image_filename);
-            $image_name = ltrim($this->relative_path, '/') . "{$image_filename}.{$image_suffix}";
-            if(isset($this->title_fields[$column])) {
-                $result[$row-($this->titleFieldsRow+1)][$this->title_fields[$column]] = $image_name;
+            $image_name = ltrim($this->relative_path, '/')."{$image_filename}.{$image_suffix}";
+            if (isset($this->title_fields[$column])) {
+                $result[$row - ($this->titleFieldsRow + 1)][$this->title_fields[$column]] = $image_name;
             }
         }
         return $result;
@@ -166,7 +166,7 @@ 
      * @author: Tinymeng <666@majiameng.com>
      * @time: 2022/2/22 11:30
      */
-    public function getTitle(){
+    public function getTitle() {
         return $this->title;
     }
 
@@ -176,21 +176,21 @@ 
      * @author: Tinymeng <666@majiameng.com>
      * @time: 2022/2/22 11:30
      */
-    public function getTitleFields(){
+    public function getTitleFields() {
         $title = $this->getTitle();
 
         $row = $this->titleFieldsRow;
         $titleDataArr = [];
 
-        foreach ($this->cellName as $column){
+        foreach ($this->cellName as $column) {
             $value = trim($this->workSheet->getCell($column.$row)->getValue());
-            if(!empty($value)){
+            if (!empty($value)) {
                 $titleDataArr[$value] = $column;
             }
         }
         $title_fields = [];
         foreach ($title as $key=>$value) {
-            if(isset($titleDataArr[$key])){
+            if (isset($titleDataArr[$key])) {
                 $title_fields[$titleDataArr[$key]] = $value;
             }
         }
@@ -220,13 +220,13 @@ 
                 $real_extension = 'jpg';
                 $image_filename .= '.'.$real_extension;
                 $source = imagecreatefromjpeg($drawing->getPath());
-                imagejpeg($source, $this->image_path . $image_filename);
+                imagejpeg($source, $this->image_path.$image_filename);
                 break;
             case 'image/gif':
                 $real_extension = 'gif';
                 $image_filename .= '.'.$real_extension;
                 $source = imagecreatefromgif($drawing->getPath());
-                imagegif($source, $this->image_path . $image_filename);
+                imagegif($source, $this->image_path.$image_filename);
                 break;
             case 'image/png':
                 $real_extension = 'png';
@@ -235,7 +235,7 @@ 
                 // 保持透明度设置
                 imagealphablending($source, false);
                 imagesavealpha($source, true);
-                imagepng($source, $this->image_path . $image_filename);
+                imagepng($source, $this->image_path.$image_filename);
                 break;
             default:
                 throw new Exception('image format error!');