Adding Data in Data base using EXCEL FILE with SYMFONY3

I had the same issue few months ago. I ended up writing this class with the function getArrayFromCsv(). Using it, all you have to do is to save your excel file as a .csv, then pass the file to the function, and you'll get an array of your data so that you can process them as you wish.

More explained, you can just use str_getcsv php function with some csv content as parameter, or fgetcsv if you pass a resource instance of the csv file.

And then, process your data.

Here is an example of a fixture load() function using that class as dependency; as a way of using it with symfony:

public function load(ObjectManager $manager)
{
    $this->onLoadStart($manager);//A custom processing to initialize the fixture object instance

    $setLineKeys = function ($keysRow) {//A callback to redefine the keys of the obtained array of data

        return $this->setLineKeys($keysRow);
    };

    $clients = CollectionUtil::getArrayFromCsv($this->getFileName(), NULL, NULL, NULL, $setLineKeys);//We read the file and put the data in an array structure

    $noAddress = [];

    foreach ($clients as $clientData) {// We process the array in order to build entities

        foreach ($clientData as $key => &$value) {

            $value = trim($value);
        }

        $client = (new Client())

            ->setName($clientData['name'])

            ->setAbbreviation(substr($clientData['abbreviation'], 0, 6))

            ->setBillable($this->isBillableGuess($clientData))

            ->setSector($this->getSector($clientData, $manager))

            ->setAddress($this->getAddress($clientData))

            ->setAccountingData($this->getAccountingData($clientData))

            ->setSite($this->defaultSite)

            ->setOrganization($this->defaultSite->getOrganization())
        ;

        !$clientData['telephone'] ?:
            $client->addPhone((new Phone($clientData['telephone']))->setPrimary(true))
        ;

        !$clientData['email'] ?:
            $client->addEmail((new Email($clientData['email']))->setPrimary(true))
        ;

        !$clientData['fax'] ?:
            $client->addFax((new Fax($clientData['fax']))->setPrimary(true))
        ;

        if (NULL == $client->getAddress()) {

            $noAddress[$clientData['abbreviation']] = $clientData['name'];
        } else {

            $this->buildCode($client);

            $manager->persist($client);
        }
    }

    $manager->flush();// We persist all the entities we just built.
}