使用simplexls类v0.4运行PHP v.3.10,加载电子表格后,维度(即行和列计数)将关闭。
这些行确实包含列标题,但即使电子表格中有数据,所有数据行都是空的。
以下是输出的小样本,用于说明。你知道为什么我没有得到任何实际的细胞数据吗?
Array
(
[0] => cheyco.xlsx
)
Sheets count is: 7
i = 1:
Dimensions(1) returns:
Array
(
[0] => 4
[1] => 5
)
Rows(1) returns:
Array
(
[0] => Array
(
[0] => Facility Code
[1] => Site ID
[2] => Name
[3] => Description
)
[1] => Array
(
[0] =>
)
[2] => Array
(
[2] =>
)
)
i = 2:
Dimensions(2) returns:
Array
(
[0] => 5
[1] => 29
)
Rows(2) returns:
Array
(
[0] => Array
(
[0] => Unit Code
[1] => Facility Code
[2] => Type (I,E,O)
[3] => Name
[4] => Description
)
[1] => Array
(
[0] =>
[1] =>
[3] =>
)
[2] => Array
(
[0] =>
[1] =>
[3] =>
)
[3] => Array
(
[0] =>
[1] =>
[3] =>
)
[4] => Array
(
[0] =>
[1] =>
[3] =>
)
[5] => Array
(
[0] =>
[1] =>
[3] =>
)
[6] => Array
(
[0] =>
[1] =>
[3] =>
)
[7] => Array
(
[0] =>
[1] =>
[3] =>
)
原来SimpleXLS无法读取更新的.xlsx格式。以以前的.xls格式保存文档解决了此问题。