Handsontable Widget for Yii2

A minimalist Excel-like grid widget for Yii2 based on Handsontable.

[]() []() []()

Installation

The preferred way to install this extension is through composer.

Either run

php composer.phar require --prefer-dist "himiklab/yii2-handsontable-widget" "*"

or add

"himiklab/yii2-handsontable-widget" : "*"

to the require section of your application's composer.json file.

Usage

use himiklab\handsontable\HandsontableWidget;

<?= HandsontableWidget::widget([
    'settings' => [
        'data' => [
            ['A1', 'B1', 'C1'],
            ['A2', 'B2', 'C2'],
        ],
        'colHeaders' => true,
        'rowHeaders' => true,
    ]
]) ?>

or with ActiveRecord

in view:

use himiklab\handsontable\HandsontableWidget;

<?= HandsontableWidget::widget([
    'requestUrl' => 'hts',
    'isRemoteChange' => true,
]); ?>

in controller:

use app\models\Page;
use himiklab\handsontable\actions\HandsontableActiveAction;

public function actions()
{
    return [
        'hts' => [
            'class' => HandsontableActiveAction::className(),
            'model' => Page::className(),
            'isChangeable' => true,
        ],
    ];
}