How to import and export an excel file to database in Cakephp3

[Ivy]

How to import and export an excel file to database in Cakephp3

[Ivy]

I’m pretty hopeless and plz if someone can help . Many thanks ~

[Diego]

To export:

Where to put phpexcel lib and how use it in cakephp 3 x

composer.json "require": { "box/spout" : "dev-master" } composer update Controller: use Box\Spout\Writer\WriterFactory; use Box\Spout\Common\Type; public function xlsxSpout($id = null) { $user = $this->Users->get($id); $fileName = 'spreadsheet.xlsx'; $writer = WriterFactory::create(Type::XLSX); // for XLSX files //$writer = WriterFactory::create(Type::CSV); // for CSV files //$writer->openToFile($full…

To import you can use the box/spout too just check api example
http://opensource.box.com/spout/getting-started/#reader