public function getArryFile($paramFile)
{
$pathDefault = '/var/www/backup/ExternalData/default_format/';
$pathImport = '/var/www/backup/ExternalData/import_salespo/';
$fileData = $paramFile != '' ? $pathImport . $paramFile : $pathDefault . 'default_import_salespo.xlsx';
//$fileName='/var/www/backup/ExternalData/import_gudang/'.$fileData;
$config = '';
//$data = \moonland\phpexcel\Excel::import($fileName, $config);
$data = \moonland\phpexcel\Excel::widget(['id' => 'export-salespo-id', 'mode' => 'import', 'fileName' => $fileData, 'setFirstRecordAsKeys' => true, 'setIndexSheetByName' => true, 'getOnlySheet' => 'STOCK-SALESPO']);
//print_r($data);
$aryDataProvider = new ArrayDataProvider(['allModels' => $data, 'pagination' => ['pageSize' => 1000]]);
//return Spinner::widget(['preset' => 'medium', 'align' => 'center', 'color' => 'blue','hidden'=>false]);
return $aryDataProvider;
}
public function getArryFile($paramFile)
{
$fileData = $paramFile != '' ? $paramFile : 'default_import_sales.xlsx';
$fileName = Yii::$app->basePath . '/web/upload/sales_import/' . $fileData;
$config = '';
//$data = \moonland\phpexcel\Excel::import($fileName, $config);
$data = \moonland\phpexcel\Excel::widget(['id' => 'export', 'mode' => 'import', 'fileName' => $fileName, 'setFirstRecordAsKeys' => true, 'setIndexSheetByName' => true, 'getOnlySheet' => 'IMPORT FORMAT STOCK']);
//print_r($data);
$aryDataProvider = new ArrayDataProvider(['allModels' => $data, 'pagination' => ['pageSize' => 1000]]);
//return Spinner::widget(['preset' => 'medium', 'align' => 'center', 'color' => 'blue','hidden'=>false]);
return $aryDataProvider;
}
<?php use app\models\Bukutamu; // export data only one worksheet. $allModels = Bukutamu::find()->all(); \moonland\phpexcel\Excel::widget(['models' => $allModels, 'mode' => 'export', 'columns' => ['nama', 'pesan', 'tanggal']]);