http://opendata.kedirikab.go.id/dataset/3782/csv/download_excel?p=dataset%2F3782%2Fcsv%2Fdownload_excel

Method
GET
HTTP Status
500
IP
172.16.25.100
Profiled on
Token
d726b9

Exceptions

OutOfMemoryError

HTTP 500 Internal Server Error

Error: Allowed memory size of 134217728 bytes exhausted (tried to allocate 10485760 bytes)

Exception

Symfony\Component\ErrorHandler\Error\ OutOfMemoryError

in vendor/phpoffice/phpspreadsheet/src/PhpSpreadsheet/Collection/Cells.php (line 395)
  1.             $this->storeCurrentCell();
  2.         }
  3.         $column = 0;
  4.         $row = '';
  5.         sscanf($cellCoordinate, '%[A-Z]%d', $column, $row);
  6.         $this->index[$cellCoordinate] = (--$row * self::MAX_COLUMN_ID) + Coordinate::columnIndexFromString((string) $column);
  8.         $this->currentCoordinate = $cellCoordinate;
  9.         $this->currentCell = $cell;
  10.         $this->currentCellIsDirty = true;
in vendor/phpoffice/phpspreadsheet/src/PhpSpreadsheet/Worksheet/Worksheet.php -> add (line 1401)
  1.      */
  2.     public function createNewCell($coordinate): Cell
  3.     {
  4.         [$column, $row, $columnString] = Coordinate::indexesFromString($coordinate);
  5.         $cell = new Cell(null, DataType::TYPE_NULL, $this);
  6.         $this->cellCollection->add($coordinate, $cell);
  8.         // Coordinates
  9.         if ($column > $this->cachedHighestColumn) {
  10.             $this->cachedHighestColumn = $column;
  11.         }
in vendor/phpoffice/phpspreadsheet/src/PhpSpreadsheet/Worksheet/Worksheet.php -> createNewCell (line 1289)
  2.         /** @var Worksheet $sheet */
  3.         [$sheet, $finalCoordinate] = $this->getWorksheetAndCoordinate($cellAddress);
  4.         $cell = $sheet->cellCollection->get($finalCoordinate);
  6.         return $cell ?? $sheet->createNewCell($finalCoordinate);
  7.     }
  9.     /**
  10.      * Get the correct Worksheet and coordinate from a coordinate that may
  11.      * contains reference to another sheet or a named range.
in vendor/phpoffice/phpspreadsheet/src/PhpSpreadsheet/Worksheet/Worksheet.php -> getCell (line 3019)
  1.                         $this->getCell($currentColumn . $startRow)->setValue($cellValue);
  2.                     }
  3.                 } else {
  4.                     if ($cellValue != $nullValue) {
  5.                         // Set cell value
  6.                         $this->getCell($currentColumn . $startRow)->setValue($cellValue);
  7.                     }
  8.                 }
  9.                 ++$currentColumn;
  10.             }
  11.             ++$startRow;
Worksheet->fromArray() in src/Controller/Frontend/DatasetController.php (line 363)
  1.                 $sheet->getStyle($cols . '2:' . $cols . (count($dataset) + 1))->applyFromArray($styleBorder);
  2.                 $cols++;
  3.             }
  4.         }
  6.         $sheet->fromArray($dataset, null, 'A2');
  8.         header('Content-Type: application/vnd.ms-excel');
  9.         header('Content-Disposition: attachment; filename="' . substr($publikasi->getJudul(), 0, 30) . '.' . $tipe . '"');
  11.         if ($tipe == 'xlsx') {
in vendor/symfony/http-kernel/HttpKernel.php -> downloadExcel (line 163)
  1.         $this->dispatcher->dispatch($event, KernelEvents::CONTROLLER_ARGUMENTS);
  2.         $controller = $event->getController();
  3.         $arguments = $event->getArguments();
  5.         // call controller
  6.         $response = $controller(...$arguments);
  8.         // view
  9.         if (!$response instanceof Response) {
  10.             $event = new ViewEvent($this, $request, $type, $response);
  11.             $this->dispatcher->dispatch($event, KernelEvents::VIEW);
in vendor/symfony/http-kernel/HttpKernel.php -> handleRaw (line 75)
  1.     {
  2.         $request->headers->set('X-Php-Ob-Level', (string) ob_get_level());
  4.         $this->requestStack->push($request);
  5.         try {
  6.             return $this->handleRaw($request, $type);
  7.         } catch (\Exception $e) {
  8.             if ($e instanceof RequestExceptionInterface) {
  9.                 $e = new BadRequestHttpException($e->getMessage(), $e);
  10.             }
  11.             if (false === $catch) {
in vendor/symfony/http-kernel/Kernel.php -> handle (line 202)
  1.         $this->boot();
  2.         ++$this->requestStackSize;
  3.         $this->resetServices = true;
  5.         try {
  6.             return $this->getHttpKernel()->handle($request, $type, $catch);
  7.         } finally {
  8.             --$this->requestStackSize;
  9.         }
  10.     }
Kernel->handle() in public/index.php (line 20)
  1.     Debug::enable();
  2. }
  4. $kernel = new Kernel($_SERVER['APP_ENV'], (bool) $_SERVER['APP_DEBUG']);
  5. $request = Request::createFromGlobals();
  6. $response = $kernel->handle($request);
  7. $response->send();
  8. $kernel->terminate($request, $response);
{main}() in public/index.php (line 1)
  1. <?php
  3. use App\Kernel;
  4. use Symfony\Component\Dotenv\Dotenv;
  5. use Symfony\Component\ErrorHandler\Debug;

Stack Trace

OutOfMemoryError 
Symfony\Component\ErrorHandler\Error\OutOfMemoryError:
Error: Allowed memory size of 134217728 bytes exhausted (tried to allocate 10485760 bytes)

  at vendor/phpoffice/phpspreadsheet/src/PhpSpreadsheet/Collection/Cells.php:395
  at PhpOffice\PhpSpreadsheet\Collection\Cells->add()
     (vendor/phpoffice/phpspreadsheet/src/PhpSpreadsheet/Worksheet/Worksheet.php:1401)
  at PhpOffice\PhpSpreadsheet\Worksheet\Worksheet->createNewCell()
     (vendor/phpoffice/phpspreadsheet/src/PhpSpreadsheet/Worksheet/Worksheet.php:1289)
  at PhpOffice\PhpSpreadsheet\Worksheet\Worksheet->getCell()
     (vendor/phpoffice/phpspreadsheet/src/PhpSpreadsheet/Worksheet/Worksheet.php:3019)
  at PhpOffice\PhpSpreadsheet\Worksheet\Worksheet->fromArray()
     (src/Controller/Frontend/DatasetController.php:363)
  at App\Controller\Frontend\DatasetController->downloadExcel()
     (vendor/symfony/http-kernel/HttpKernel.php:163)
  at Symfony\Component\HttpKernel\HttpKernel->handleRaw()
     (vendor/symfony/http-kernel/HttpKernel.php:75)
  at Symfony\Component\HttpKernel\HttpKernel->handle()
     (vendor/symfony/http-kernel/Kernel.php:202)
  at App\Kernel->handle()
     (public/index.php:20)
  at {main}()