Undefined index: Sheet1

[Zubair-Iftikhar]

Laravel: "5.8.*"
Maatwebsite Excel: "^3.1"

ProductsImportJob.php

$importable = new ProductsImport();
$importable->import($filePath);

File is available & can accessible.
"E:\\workspace\\sites\\abc\\public\\storage\\imported/sXsC4E0nxOnSdtKnVUX5xq1wRhmi9T1BkA9VB2eh.xlsx"
ProductImport.php

class ProductsImport implements ToCollection, WithChunkReading, WithHeadingRow, WithEvents, ShouldQueue
{
    use  Importable, RegistersEventListeners;

    protected $batchSize = 10;

    public function collection(Collection $products)
    {
        foreach ($products as $product) {
            $property_list = $product['property_list'] ?? null;
        }


    }

    public static function afterImport(AfterImport $event)
    {
        ProductList::where('status', ProductListEnum::IN_PROGRESS)->update([
            'status' => ProductListEnum::DELETED,
            'deletedAt' => Carbon::now(),
        ]);
    }

    public function chunkSize(): int
    {
        return $this->batchSize;
    }

[2021-03-09 10:48:06] local.ERROR: Undefined index: Sheet1 {"exception":"[object] (ErrorException(code: 0): Undefined index: Sheet1 at E:\\workspace\\sites\\dropshipping\\vendor\\maatwebsite\\excel\\src\\ChunkReader.php:55)
[stacktrace]
#0 E:\\workspace\\sites\\dropshipping\\vendor\\maatwebsite\\excel\\src\\ChunkReader.php(55): Illuminate\\Foundation\\Bootstrap\\HandleExceptions->handleError(8, 'Undefined index...', 'E:\\\\workspace\\\\si...', 55, Array)
#1 E:\\workspace\\sites\\dropshipping\\vendor\\maatwebsite\\excel\\src\\Reader.php(103): Maatwebsite\\Excel\\ChunkReader->read(Object(App\\Imports\\ProductsImport), Object(Maatwebsite\\Excel\\Reader), Object(Maatwebsite\\Excel\\Files\\LocalTemporaryFile))
#2 E:\\workspace\\sites\\dropshipping\\vendor\\maatwebsite\\excel\\src\\Excel.php(146): Maatwebsite\\Excel\\Reader->read(Object(App\\Imports\\ProductsImport), 'E:\\\\workspace\\\\si...', 'Xlsx', NULL)
#3 E:\\workspace\\sites\\dropshipping\\vendor\\maatwebsite\\excel\\src\\Concerns\\Importable.php(39): Maatwebsite\\Excel\\Excel->import(Object(App\\Imports\\ProductsImport), 'E:\\\\workspace\\\\si...', NULL, 'Xlsx')
#4 E:\\workspace\\sites\\dropshipping\\app\\Jobs\\ProductListImport.php(49): App\\Imports\\ProductsImport->import('E:\\\\workspace\\\\si...')
#5 [internal function]: App\\Jobs\\ProductListImport->handle()
#6 E:\\workspace\\sites\\dropshipping\\vendor\\laravel\\framework\\src\\Illuminate\\Container\\BoundMethod.php(32): call_user_func_array(Array, Array)
#7 E:\\workspace\\sites\\dropshipping\\vendor\\laravel\\framework\\src\\Illuminate\\Container\\BoundMethod.php(90): Illuminate\\Container\\BoundMethod::Illuminate\\Container\\{closure}()
#8 E:\\workspace\\sites\\dropshipping\\vendor\\laravel\\framework\\src\\Illuminate\\Container\\BoundMethod.php(34): Illuminate\\Container\\BoundMethod::callBoundMethod(Object(Illuminate\\Foundation\\Application), Array, Object(Closure))
#9 E:\\workspace\\sites\\dropshipping\\vendor\\laravel\\framework\\src\\Illuminate\\Container\\Container.php(576): Illuminate\\Container\\BoundMethod::call(Object(Illuminate\\Foundation\\Application), Array, Array, NULL)
#10 E:\\workspace\\sites\\dropshipping\\vendor\\laravel\\framework\\src\\Illuminate\\Bus\\Dispatcher.php(94): Illuminate\\Container\\Container->call(Array)
#11 E:\\workspace\\sites\\dropshipping\\vendor\\laravel\\framework\\src\\Illuminate\\Pipeline\\Pipeline.php(128): Illuminate\\Bus\\Dispatcher->Illuminate\\Bus\\{closure}(Object(App\\Jobs\\ProductListImport))
#12 E:\\workspace\\sites\\dropshipping\\vendor\\laravel\\framework\\src\\Illuminate\\Pipeline\\Pipeline.php(104): Illuminate\\Pipeline\\Pipeline->Illuminate\\Pipeline\\{closure}(Object(App\\Jobs\\ProductListImport))
#13 E:\\workspace\\sites\\dropshipping\\vendor\\laravel\\framework\\src\\Illuminate\\Bus\\Dispatcher.php(98): Illuminate\\Pipeline\\Pipeline->then(Object(Closure))
#14 E:\\workspace\\sites\\dropshipping\\vendor\\laravel\\framework\\src\\Illuminate\\Queue\\CallQueuedHandler.php(49): Illuminate\\Bus\\Dispatcher->dispatchNow(Object(App\\Jobs\\ProductListImport), false)
#15 E:\\workspace\\sites\\dropshipping\\vendor\\laravel\\framework\\src\\Illuminate\\Queue\\Jobs\\Job.php(88): Illuminate\\Queue\\CallQueuedHandler->call(Object(Illuminate\\Queue\\Jobs\\DatabaseJob), Array)
#16 E:\\workspace\\sites\\dropshipping\\vendor\\laravel\\framework\\src\\Illuminate\\Queue\\Worker.php(337): Illuminate\\Queue\\Jobs\\Job->fire()
#17 E:\\workspace\\sites\\dropshipping\\vendor\\laravel\\framework\\src\\Illuminate\\Queue\\Worker.php(283): Illuminate\\Queue\\Worker->process('database', Object(Illuminate\\Queue\\Jobs\\DatabaseJob), Object(Illuminate\\Queue\\WorkerOptions))
#18 E:\\workspace\\sites\\dropshipping\\vendor\\laravel\\framework\\src\\Illuminate\\Queue\\Worker.php(118): Illuminate\\Queue\\Worker->runJob(Object(Illuminate\\Queue\\Jobs\\DatabaseJob), 'database', Object(Illuminate\\Queue\\WorkerOptions))
#19 E:\\workspace\\sites\\dropshipping\\vendor\\laravel\\framework\\src\\Illuminate\\Queue\\Console\\WorkCommand.php(102): Illuminate\\Queue\\Worker->daemon('database', 'default', Object(Illuminate\\Queue\\WorkerOptions))
#20 E:\\workspace\\sites\\dropshipping\\vendor\\laravel\\framework\\src\\Illuminate\\Queue\\Console\\WorkCommand.php(86): Illuminate\\Queue\\Console\\WorkCommand->runWorker('database', 'default')
#21 [internal function]: Illuminate\\Queue\\Console\\WorkCommand->handle()
#22 E:\\workspace\\sites\\dropshipping\\vendor\\laravel\\framework\\src\\Illuminate\\Container\\BoundMethod.php(32): call_user_func_array(Array, Array)
#23 E:\\workspace\\sites\\dropshipping\\vendor\\laravel\\framework\\src\\Illuminate\\Container\\BoundMethod.php(90): Illuminate\\Container\\BoundMethod::Illuminate\\Container\\{closure}()
#24 E:\\workspace\\sites\\dropshipping\\vendor\\laravel\\framework\\src\\Illuminate\\Container\\BoundMethod.php(34): Illuminate\\Container\\BoundMethod::callBoundMethod(Object(Illuminate\\Foundation\\Application), Array, Object(Closure))
#25 E:\\workspace\\sites\\dropshipping\\vendor\\laravel\\framework\\src\\Illuminate\\Container\\Container.php(576): Illuminate\\Container\\BoundMethod::call(Object(Illuminate\\Foundation\\Application), Array, Array, NULL)
#26 E:\\workspace\\sites\\dropshipping\\vendor\\laravel\\framework\\src\\Illuminate\\Console\\Command.php(183): Illuminate\\Container\\Container->call(Array)
#27 E:\\workspace\\sites\\dropshipping\\vendor\\symfony\\console\\Command\\Command.php(255): Illuminate\\Console\\Command->execute(Object(Symfony\\Component\\Console\\Input\\ArgvInput), Object(Illuminate\\Console\\OutputStyle))
#28 E:\\workspace\\sites\\dropshipping\\vendor\\laravel\\framework\\src\\Illuminate\\Console\\Command.php(170): Symfony\\Component\\Console\\Command\\Command->run(Object(Symfony\\Component\\Console\\Input\\ArgvInput), Object(Illuminate\\Console\\OutputStyle))
#29 E:\\workspace\\sites\\dropshipping\\vendor\\symfony\\console\\Application.php(1009): Illuminate\\Console\\Command->run(Object(Symfony\\Component\\Console\\Input\\ArgvInput), Object(Symfony\\Component\\Console\\Output\\ConsoleOutput))
#30 E:\\workspace\\sites\\dropshipping\\vendor\\symfony\\console\\Application.php(273): Symfony\\Component\\Console\\Application->doRunCommand(Object(Illuminate\\Queue\\Console\\WorkCommand), Object(Symfony\\Component\\Console\\Input\\ArgvInput), Object(Symfony\\Component\\Console\\Output\\ConsoleOutput))
#31 E:\\workspace\\sites\\dropshipping\\vendor\\symfony\\console\\Application.php(149): Symfony\\Component\\Console\\Application->doRun(Object(Symfony\\Component\\Console\\Input\\ArgvInput), Object(Symfony\\Component\\Console\\Output\\ConsoleOutput))
#32 E:\\workspace\\sites\\dropshipping\\vendor\\laravel\\framework\\src\\Illuminate\\Console\\Application.php(90): Symfony\\Component\\Console\\Application->run(Object(Symfony\\Component\\Console\\Input\\ArgvInput), Object(Symfony\\Component\\Console\\Output\\ConsoleOutput))
#33 E:\\workspace\\sites\\dropshipping\\vendor\\laravel\\framework\\src\\Illuminate\\Foundation\\Console\\Kernel.php(133): Illuminate\\Console\\Application->run(Object(Symfony\\Component\\Console\\Input\\ArgvInput), Object(Symfony\\Component\\Console\\Output\\ConsoleOutput))
#34 E:\\workspace\\sites\\dropshipping\\artisan(37): Illuminate\\Foundation\\Console\\Kernel->handle(Object(Symfony\\Component\\Console\\Input\\ArgvInput), Object(Symfony\\Component\\Console\\Output\\ConsoleOutput))
#35 {main}
"} 

[patrickbrouwers]

phpspreadsheet 1.17 has a bug, you'll have to lock the version to 1.16 until they release the fix

[Zubair-Iftikhar]

i'm using ur package maatwebsite/excel 3.1?how to lock the phpspreadsheet version to 1.16
Remember 3.0 also using phpspreadsheet 1.17

[patrickbrouwers]

put phpspreadsheet as dependency in your composer.json and set the version to ^1.16.0

[Zubair-Iftikhar]

issue only With Chunk Reading in laravel 5.8.i've tested on latest Laravel it's working fine...

[patrickbrouwers]

Yes it's only with chunk reading