Download the PHP package bluehe/yii2-phpexcel without Composer

On this page you can find all versions of the php package bluehe/yii2-phpexcel. 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 yii2-phpexcel

Yii2 PHP Excel

Latest Stable Version Total Downloads Latest Unstable Version License

Exporting PHP to Excel or Importing Excel to PHP. Excel Widget for generate Excel File or for load Excel File.

Property

string $mode is an export mode or import mode. valid value are 'export' and 'import'

boolean $isMultipleSheet for set the export excel with multiple sheet.

array $properties for set property on the excel object.

array $models Model object or DataProvider object with much data.

array $columns to get the attributes from the model, this valid value only the exist attribute on the model. If this is not set, then all attribute of the model will be set as columns.

array $headers to set the header column on first line. Set this if want to custom header. If not set, the header will get attributes label of model attributes.

string|array $fileName is a name for file name to export or import. Multiple file name only use for import mode, not work if you use the export mode.

string $savePath is a directory to save the file or you can blank this to set the file as attachment.

string $format for excel to export. Valid value are 'Excel5', 'Excel2007', 'Excel2003XML', '00Calc', 'Gnumeric'.

array $style for all excel.

boolean|array $headerTitle to set the header title row on the fitst line.

boolean|array $firstTitle to set the first title row on the fitst line.

boolean $setFirstTitle to set the title column on the first line. The columns will have a header on the first line.

boolean $asAttachment to set the file excel to download mode.

boolean $setFirstRecordAsKeys to set the first record on excel file to a keys of array per line. If you want to set the keys of record column with first record, if it not set, the header with use the alphabet column on excel.

boolean $setIndexSheetByName to set the sheet index by sheet name or array result if the sheet not only one

string $getOnlySheet is a sheet name to getting the data. This is only get the sheet with same name.

array|Formatter $formatter the formatter used to format model attribute values into displayable texts. This can be either an instance of [[Formatter]] or an configuration array for creating the [[Formatter]] instance. If this property is not set, the "formatter" application component will be used.

Installation

The preferred way to install this extension is through composer.

Either run

or add

to the require section of your composer.json file.

Usage

Exporting Data

Exporting data into an excel file.

New Feature for exporting data, you can use this if you familiar yii gridview. That is same with gridview data column. Columns in array mode valid params are 'attribute', 'header', 'format', 'value', and footer (TODO). Columns in string mode valid layout are 'attribute:format:header:footer(TODO)'.

Importing Data

Import file excel and return into an array.

Result example from the code on the top :

TODO


All versions of yii2-phpexcel with dependencies

PHP Build Version
Package Version
Requires yiisoft/yii2 Version *
phpoffice/phpexcel Version *
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 bluehe/yii2-phpexcel contains the following files

Loading the files please wait ....