php如何导入在网页上导出的excel

最新推荐文章于 2022-11-11 11:28:20 发布

weixin_33747129

最新推荐文章于 2022-11-11 11:28:20 发布

阅读量220

点赞数

文章标签： php

原文链接：https://my.oschina.net/sskill/blog/1586542

版权

为什么80%的码农都做不了架构师？>>>

<?php
require_once('Classes'.DIRECTORY_SEPARATOR.'PHPExcel.php');

// Tell PHPExcel to load this file and make its best guess as to its type.
$objPHPExcel = PHPExcel_IOFactory::load($_FILES['file']['tmp_name']);

require_once('Classes'.DIRECTORY_SEPARATOR.'PHPExcel.php');

// Tell PHPExcel that you will be loading a file.
$objReader = PHPExcel_IOFactory::createReaderForFile($_FILES['file']['tmp_name']);

// Set your options.
$objReader->setReadDataOnly(true);

// Tell PHPExcel to load this file and make its best guess as to its type.
$objPHPExcel = @$objReader->load($_FILES['file']['tmp_name']);

foreach ($objPHPExcel->getWorksheetIterator() as $worksheet) {
        $worksheets[] = $worksheet->toArray();
    }

foreach($worksheets as $sheet) {

    foreach($sheet as $row) {
        print_r($row);
    }

}

转载于:https://my.oschina.net/sskill/blog/1586542