import images that are referenced in excel

[boudgeau]

currently I am facing an issue with this requirement , I need to upload an excel sheet that should update/create/delete my products model, image name for each record is included in the excel and images are put on a public folder on the web with the exact name, how can I import the products to the model from this excel same time import images into media model?
anyone has the best practice for this?
Help is much appreciated.

[patrickbrouwers]

We currently don't have a short cut for getting an image from a cell, so you'll have to use phpspreadsheet directly via our event hook system.

E.g. you could use the beforeSheet event and already store all images in there + keep a list of file names per row. Then inside the import method, you could refer to those images.

Example of reading images with phpspreadsheet: https://github.com/rajaramtt/phpspreadsheet-Reading-Images-from-an-Excel-File/blob/master/index.php#L25