①表单提交excel
<form method="post" action="acapply_save.php?action=import" enctype="multipart/form-data">
<h3>导入Excel表:</h3>
<input type="file" name="importfile" />
<input type="submit" value="导入" />
</form>
②move_uploaded_file($_FILES['name']['tmp_name'],$path);
③下载PHPExcel包
下面的代码为导入:(与度娘上搜索的应该差不多)
$objReader = new PHPExcel_Reader_Excel5();
$objPHPExcel = $objReader->load($path);
//$sheetData = $objPHPExcel->getActiveSheet()->toArray(null,true,true,true);
$sheet = $objPHPExcel->getSheet();
$highestRow = $sheet->getHighestRow();
$highestColumn = $sheet->getHighestColumn();
$data = array();
for($j=2;$j<=$highestRow;$j++){
for($k='A';$k<=$highestColumn;$k++){
$data[$j] = $objPHPExcel->getActiveSheet()->getCell("$k$j")->getValue();
}
}
下面的代码为导出:
$table = '';
$table .= "<table>
<thead>
<tr>
<th class='name'>名称</th>
<th class='name'>入库日期</th>
<th class='name'>入库库位</th>
<th class='name'>供货商</th>
<th class='name'>入库人</th>
<th class='name'>数量</th>
<th class='name'>单价</th>
</tr>
</thead>
<tbody>";
foreach ($innerdata as $v) {
$table .= "<tr>
<td class='name'>{$v['goods_name']}</td>
<td class='name'>{$v['add_date']}</td>
<td class='name'>{$v['storage_name']}</td>
<td class='name'>{$v['supplier_name']}</td>
<td class='name'>{$v['real_name']}</td>
<td class='name'>{$v['num']}</td>
<td class='name'>{$v['price']}</td>
</tr>";
}
$table .= "</tbody>
</table>";
//通过header头控制输出excel表格
header("Pragma: public");
header("Expires: 0");
header("Cache-Control:must-revalidate, post-check=0, pre-check=0");
header("Content-Type:application/force-download");
header("Content-Type:application/vnd.ms-execl");
header("Content-Type:application/octet-stream");
header("Content-Type:application/download");;
header('Content-Disposition:attachment;filename="入库明细表.xls"');
header("Content-Transfer-Encoding:binary");
echo $table;
}
//来自:php导出excel最简单的办法,无需phpexcel
//转载:http://www.thinkphp.cn/topic/49428.html