Download the PHP package uranum/yii2-excel-exchange without Composer

On this page you can find all versions of the php package uranum/yii2-excel-exchange. 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?

Example code of uranum/yii2-excel-exchange

Informations about the package yii2-excel-exchange

Yii 2 Excel Data Exchanger

After installing this package you will be able to export data from DB to an excel2007 file and upload the data back again. The package is a module that you need to register in the config file in the module section. The module has a widget that you can use with different AR models in the usual way (for widgets). In the widget's config you need to specify the model name you want to import/export. Other optional properties are listed below.

If the exporting model has a related table the file will have an additional sheet for every table even the ones which don’t have a model. The data in these additional sheets helps to handle related columns. This sheets will be ignored in importing.

Required fields are highlighted in the excel file.

Note! One file is used for all models! The new exporting will overwrite existing file.

Required fields

There is a feature to backup the table before importing.

Export

Export

Import

Import

Installation

The preferred way to install this extension is through composer.

Either run

or add

to the require section of your composer.json file.

In config, modules section

How to use

In view (for example, index.php)

Widget's properties

string $mainModelName - the name of the model for export/import. It's mandatory property.

string $fileNameFrom - path to a file for export/import. Default is 'uploads/export.xlsx'. The folder must be exist!

string $notNullColumnColor - a value of the color for required columns. Default is 'FFDECC'

string $nameOfReserveTable - prefix for the copied table. Default is 'archive_'

string $backupUrl - url for backup action. Default is 'excel/default/backup'. You can create your own controller with it's actions and change the urls here.

string $uploadUrl - url for upload action. Default is 'excel/default/upload'

string $importUrl - url for import action. Default is 'excel/default/import'

string $exportUrl - url for export action. Default is 'excel/default/export'

integer $columnWidthOfStringType - a value of the column's width that has string type. Default is 35

integer $columnWidthOfTextType - a value of the column's width that has text type. Default is 50

integer $columnWidthDefault - a value of the other column's width. Default is 15

string $modalId - a value of the Modal id. Default is 'excelImportModal'

string $fileInputId - a value of the fileInput field id. Default is 'uploadFile'

string $exportBtnClass is the part of css bootstrap class. Default is 'ExcelExchanger::COLOR_SUCCESS'

string $uploadBtnClass is the part of css bootstrap class. Default is 'ExcelExchanger::COLOR_SUCCESS'

string $uploadDataBtnClass is the part of css bootstrap class. Default is 'ExcelExchanger::COLOR_SUCCESS'

string $importPopupBtnClass is the part of css bootstrap class. Default is 'ExcelExchanger::COLOR_DANGER'

string $panelColorClass is the part of css bootstrap class. Default is 'ExcelExchanger::COLOR_DEFAULT'

string $fileInputColorClass is the part of css bootstrap class. Default is 'ExcelExchanger::COLOR_WARNING'

All versions of yii2-excel-exchange with dependencies

PHP Build Version
Package Version
Requires php Version ^7.0.0
yiisoft/yii2 Version ~2.0
yiisoft/yii2-bootstrap 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 uranum/yii2-excel-exchange contains the following files

Loading the files please wait ....