phpexcel reader插件 导入数据入库问题

Question

为什么我每次上传都会多出一行空行数据啊
，数据库总会多来一行空数据。我应该要在哪里做处理，怎么处理呢？我试过调都没能解决

Answer 1

It should be that when phpexcel reads it, it reads an empty row. Before splicing the SQL statement and executing the SQL, you should judge whether the field is empty. If every field in the entire row (or some required fields) If it is empty, continue

Answer 2

Print$data->sheet[0]['rownumber s'], check the actual number of rows read by the code in excel