Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- public function importExcel($function = null)
- {
- if ($this->upload_file()) {
- Price::deleteAll();
- if ($function) {
- $this->onImportRow = $function;
- }
- //$reader = \PHPExcel_IOFactory::createReader( /*$this->defaultFormat*/ );
- $objPHPExcel = \PHPExcel_IOFactory::load($this->_uploaded_file->tempName);
- $objWorksheet = $objPHPExcel->getActiveSheet();
- $highestRow = $objWorksheet->getHighestRow();
- $result = [];
- $foo = [];
- foreach ($objWorksheet->getRowIterator() as $i => $row) {
- $cellIterator = $row->getCellIterator();
- $cellIterator->setIterateOnlyExistingCells(false);
- $row = [];
- foreach ($cellIterator as $cell) $row[] = $cell->getValue();
- $foo = [$row[0] => $row[4]];
- if (!array_key_exists($row[0], $result)) {
- $result = array_merge($result, $foo);
- }
- }
- foreach ($objWorksheet->getRowIterator() as $i => $row) {
- $cellIterator = $row->getCellIterator();
- $cellIterator->setIterateOnlyExistingCells(false);
- $row = [];
- foreach ($cellIterator as $cell) $row[] = $cell->getValue();
- \yii\helpers\VarDumper::dump($row, 9, 9);
- $this->_current_row = $i;
- if ($this->import_row([
- 'row' => $row,
- 'index' => $i,
- 'max_row' => $highestRow
- ])
- ) {
- } else {
- break;
- }
- }
- }
- }
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement