laravel5.4 importing information from an Excel table into a database

1. First in the need to import the file, this process can be done with the file upload function in Laravel,

For more information, please refer to Laravel document http://laravelacademy.org/post/6885.htm, no more file uploads here.

2. Assume that the table to be imported into the database is now under storage Test.xls

Public Function Daoru ()
{

$filePath = ' storage/'. Iconv (' UTF-8 ', ' GBK ', ' test '). '. xls ';
$ret = [];
Excel::load ($filePath, function ($reader) {
$data = $reader->all ();
$daily = [];
foreach ($data as $sheet = = $dataItem) {
foreach ($dataItem as $ik = = $item) {
if ($sheet = = 0) {
foreach ($item as $i) {
$daily [$ik] = $i;
}
}
}
}

Here $daily is a two-dimensional array, example: $daily [$h] [$m]

Where $daily[$h] represents a row of a table, where you can write a function,

Use a double loop to add data to the database
});
echo "Success"

}

laravel5.4 importing information from an Excel table into a database