PHP 基础:PHPEXCEL 使用说明
下面的主要为大家介绍基于 PHPEXCEL 实现的,供大家参考下
首先是使用 PHP Reader 读取 Excle
内容:
复制代码 代码如下:
require
("");
$file
= "D:\\datas.xlsx";
if
(!
file_exists
(
$file
)){
die
("no file found in {$file}");
}
$datasReader
= PHPExcel_IOFactory::load(
$file
);
$sheets
=
$datasReader
->getAllSheets();
//
如果有多个工作簿
$countSheets
=
count
(
$sheets
);
$sheetsinfo
=
array
();
$sheetData
=
array
();
if
(
$countSheets
==1){
$sheet
=
$sheets
[0];
$sheetsinfo
["rows"] =
$sheet
->getHighestRow();
$sheetsinfo
["column"] = PHPExcel_Cell::columnIndexFromString(
$sheet
->getHighestColumn());
for
(
$row
=1;
$row
<=
$sheetsinfo
["rows"];
$row
++){
for
(
$column
=0;
$column
<
$sheetsinfo
["column"];
$column
++){
$sheetData
[
$column
][
$row
] =
$sheet
->getCellByColumnAndRow(
$column
,
$row
)->getValue();
}
}
}
else
{
foreach
(
$sheets
as
$key
=>
$sheet
)
{
$sheetsinfo
[
$key
]["rows"] =
$sheet
->getHighestRow();
$sheetsinfo
[
$key
]["column"] = PHPExcel_Cell::columnIndexFromString(
$sheet
-
>getHighestColumn());
for
(
$row
=1;
$row
<=
$sheetsinfo
[
$key
]["rows"];
$row
++){
for
(
$column
=0;
$column
<
$sheetsinfo
[
$key
]["column"];
$column
++){
$sheetData
[
$key
][
$column
][
$row
] =
$sheet
->getCellByColumnAndRow(
$column
,
$row
)-
>getValue();
}
}
}
}
echo
"<pre>";