导入导出excel---20181029（85%）

最新推荐文章于 2024-03-25 19:51:18 发布

方梦妍

最新推荐文章于 2024-03-25 19:51:18 发布

阅读量165

点赞数 1

分类专栏：日常日记

本文链接：https://blog.csdn.net/qq_25846287/article/details/83506788

版权

日常日记专栏收录该内容

5 篇文章 0 订阅

订阅专栏

①表单提交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