当我使用PHPExcel类阅读ods文件(xls和xlsx都可以),并且两个单元格在一起并包含相同的数据时,第二个单元格会变为空白。这是一个bug吗?以下是我的代码:
<?php
set_include_path(get_include_path() . PATH_SEPARATOR . '../../Librerias/phpexcel/Classes/');
include 'PHPExcel/IOFactory.php';
$input_fileName = dirname(__FILE__) . '/bug.ods';
$input_file_type = PHPExcel_IOFactory::identify($input_fileName);
$reader = PHPExcel_IOFactory::createReader($input_file_type);
$reader->setReadDataOnly(true);
$objPHPExcel = $reader->load($input_fileName);
$objPHPExcel->setActiveSheetIndex(0);
$rowIterator = $objPHPExcel->getActiveSheet()->getRowIterator();
$array_data = array();
foreach($rowIterator as $row){
$cellIterator = $row->getCellIterator();
$cellIterator->setIterateOnlyExistingCells(false);
$rowIndex = $row->getRowIndex ();
foreach ($cellIterator as $cell) {
$array_data[$rowIndex][$cell->getColumn()] = $cell->getCalculatedValue();
}
}
echo '<pre>' ; print_r($array_data); echo '</pre>' ;
?>
这是与bug.ods相关的内容。
| A | B | C | D | E | F
-----------------------------------------------
1 | 1 | 1 | 2 | 2 | 3 | 3
2 | 2 | 2 | 1 | 1 | 3 | 3
3 | 3 | 3 | 1 | 1 | 2 | 2
4 | a | a | b | b | c | c
5 | b | b | a | a | c | c
6 | c | c | a | a | b | b
...这里是print_r输出结果。
Array
(
[1] => Array
(
[A] => 1
[B] =>
[C] => 2
[D] =>
[E] => 3
)
[2] => Array
(
[A] => 2
[B] =>
[C] => 1
[D] =>
[E] => 3
)
[3] => Array
(
[A] => 3
[B] =>
[C] => 1
[D] =>
[E] => 2
)
[4] => Array
(
[A] => a
[B] =>
[C] => b
[D] =>
[E] => c
)
[5] => Array
(
[A] => b
[B] =>
[C] => a
[D] =>
[E] => c
)
[6] => Array
(
[A] => c
[B] =>
[C] => a
[D] =>
[E] => b
)
)
我做错了什么吗?还是有bug吗?
有什么想法?