将 XLSX 文件导入 PHP 数组

Import an XLSX file into a PHP array

提问by ddfgdfdfgdfgdfgfdgfdgdg

Is it possible to import each line of an XLSX file to a row in a PHP array?

是否可以将 XLSX 文件的每一行导入 PHP 数组中的一行？

回答by billynoah

You can use PHPExcel which is available here: https://phpexcel.codeplex.com/releases/view/119187

您可以使用此处提供的 PHPExcel：https://phpexcel.codeplex.com/releases/view/119187

Here is what I use to read either xlsor xlsxto an array:

这是我用来读取xls或读取xlsx数组的内容：

require_once('/path/to/PHPExcel.php');

$filename = "example.xlsx";
$type = PHPExcel_IOFactory::identify($filename);
$objReader = PHPExcel_IOFactory::createReader($type);
$objPHPExcel = $objReader->load($filename);

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

print_r($worksheets);

回答by coderama

I use this:

我用这个：

include 'simplexlsx.class.php';
$xlsx = @(new SimpleXLSX('myFile.xlsx'));
$data =  $xlsx->rows();

You can simplexslx from here.

你可以从这里simplexslx 。

UPDATE

更新

Apparently the link above doesn't work anymore. You can now use this. (Thanks @Basti)

显然上面的链接不再起作用了。您现在可以使用此. （感谢@Basti）

回答by ns16

Problem can be solved using PHPExcellibrary:

问题可以使用PHPExcel库解决：

$data = [];

$type = PHPExcel_IOFactory::identify($filepath);
$objReader = PHPExcel_IOFactory::createReader($type);

$objPHPExcel = $objReader->load($filepath);

$rowIterator = $objPHPExcel->getActiveSheet()->getRowIterator();
foreach($rowIterator as $row){
    $cellIterator = $row->getCellIterator();
    foreach ($cellIterator as $cell) {
        $data[$row->getRowIndex()][$cell->getColumn()] = $cell->getCalculatedValue();
    }
}

where $filepath - path to your xls or xlsx file.

其中 $filepath - xls 或 xlsx 文件的路径。