提供解析Excel数据导入数据库思路 这里用的是TP3.2框架
Excel格式
HTML部分
<div class="wrap js-check-wrap" id="vueContainer" v-cloak>
<div class="ant-card">
<div class="ant-card-body">
<div class="table-actions">
<button class="btn btn-primary" @click="add()">
入库导入</button>
</div>
</div>
</div>
<!-- 入库文件上传 -->
<div id="lianxi" style="display: none;">
<div class="form-horizontal" style="margin-top: 20px;">
<fieldset>
<div class="control-group">
<label class="control-label">文件*</label>
<div class="controls">
<input type="file" id="file" accept=".excel,.csv,.xls,.xlsx" @change="add_posttext">
</div>
</div>
</fieldset>
<div class="form-actions" style="margin-bottom: 0;margin-top: 0;">
<button type="button" class="btn btn-primary" @click="add_post">{:L('ADD')}</button>
<a class="btn" href="javascript:;" @click="closeop">{:L('CLOSE')}</a>