Download the PHP package kesha-dev/yii2-phpexcel-fix without Composer
On this page you can find all versions of the php package kesha-dev/yii2-phpexcel-fix. It is possible to download/install these versions without Composer. Possible dependencies are resolved automatically.
Informations about the package yii2-phpexcel-fix
Yii2 PHP Excel
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 'Xls','Xlsx','Xml','Ods','Slk','Gnumeric','Csv', and 'Html'.
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
- Adding footer params for columns in exporting data.