Download the PHP package tdy/execl without Composer

On this page you can find all versions of the php package tdy/execl. It is possible to download/install these versions without Composer. Possible dependencies are resolved automatically.

FAQ

After the download, you have to make one include require_once('vendor/autoload.php');. After that you have to import the classes with use statements.

Example:
If you use only one package a project is not needed. But if you use more then one package, without a project it is not possible to import the classes with use statements.

In general, it is recommended to use always a project to download your libraries. In an application normally there is more than one library needed.
Some PHP packages are not free to download and because of that hosted in private repositories. In this case some credentials are needed to access such packages. Please use the auth.json textarea to insert credentials, if a package is coming from a private repository. You can look here for more information.

  • Some hosting areas are not accessible by a terminal or SSH. Then it is not possible to use Composer.
  • To use Composer is sometimes complicated. Especially for beginners.
  • Composer needs much resources. Sometimes they are not available on a simple webspace.
  • If you are using private repositories you don't need to share your credentials. You can set up everything on our site and then you provide a simple download link to your team member.
  • Simplify your Composer build process. Use our own command line tool to download the vendor folder as binary. This makes your build process faster and you don't need to expose your credentials for private repositories.
Please rate this library. Is it a good library?

Informations about the package execl

DTY PHP EXECL 增强扩展

使用方法

composer require tdy/execl

use Tdy\Execl\Import;

$filePath="execl表格.xlsx";

 `$obj= new Import($filePath);  //实例对象
  $data=$obj->setField("a,b,c,d,e,f,g,h,i,j,k") //获取指定单元格
  ->setImagePath(true)  //设置获取图片资源路径
  ->setThead_row(1)     //指定表头行数
  ->setMax_row(2)       //指定读取数据行数
  ->setFieldAlias(['a'=>'name',"b"=>"description",'c'=>"meta_title","d"=>'price']) //字段别名
  ->getData();`  //获取的数据

SET方法

设置读取最大列记录 eg:a到z

$obj->setMax_column("z");

设置读取的最大行记录 eg:10 只读取10 行记录

$obj->setMax_row(10);

设置读取指定的列字段

$obj->setField("a,b,c,d,e,f,g,z");

设置列字段别名

$obj->setFieldAlias(['a'=>'field1',"b"=>"field2",'e'=>"field3"]);

设置表头所占行数

$obj->setThead_row(2)

设置execl图片路径 参数为true:获取资源路径 参数为具体路径时:返回本地保存后的路径

$obj->setImagePath(true)

GET 方法

获取隐藏的列字段

$obj->hide_column;

获取表头数据

$obj->$thead_data;

获取图片资源

$obj->imageData

获取数据 可选参数 $title,$therd,$hide_column

$obj->getData();


     (
         [0] => Array
             (
                 [0] => Array
                     (
                         [name] => 产品名称
                         [description] => 同轮播图
                         [meta_title] => 同标题
                         [price] => 5.5
                         [category] => BEACH CANVAS BAG
                         [type] => 82% polyester 18% spandex
                         [pic] => Array
                             (
                                 [0] => Array
                                     (
                                         [file] => zip://E:\wamp\www\CMS\opencart\image\catalog\execl\Book1.xlsx#xl/media/image1.jpeg
                                         [title] => 主图
                                     )

                                 [1] => Array
                                     (
                                         [file] => zip://E:\wamp\www\CMS\opencart\image\catalog\execl\Book1.xlsx#xl/media/image2.jpeg
                                         [title] => 
                                     )

                             )

                         [banner] => Array
                             (
                                 [0] => Array
                                     (
                                         [file] => zip://E:\wamp\www\CMS\opencart\image\catalog\execl\Book1.xlsx#xl/media/image2.jpeg
                                         [title] => 图片xxxxxxx
                                     )

                                 [1] => Array
                                     (
                                         [file] => zip://E:\wamp\www\CMS\opencart\image\catalog\execl\Book1.xlsx#xl/media/image1.jpeg
                                         [title] => 图片二
                                     )

                             )

                         [seo_title] => 同标题
                         [color] => Blue,green,white,yellow
                         [size] => S,M,L
                     )

             )

     )

All versions of execl with dependencies

PHP Build Version
Package Version
Requires php Version >=5.3.0
phpoffice/phpexcel Version ^1.8
Composer command for our command line client (download client) This client runs in each environment. You don't need a specific PHP version etc. The first 20 API calls are free. Standard composer command

The package tdy/execl contains the following files

Loading the files please wait ....