# php导入 ``` <pre class="calibre29">``` <span class="token1"><</span><span class="token1">?</span>php <span class="token">//导入PHPExcel类库</span> <span class="token4">import</span><span class="token3">(</span><span class="token2">"Vendor.PHPExcel.PHPExcel"</span><span class="token3">)</span><span class="token3">;</span> $PHPExcel <span class="token1">=</span> <span class="token5">new</span> <span class="token4"><span class="token3">\</span>PHPExcel</span><span class="token3">(</span><span class="token3">)</span><span class="token3">;</span> <span class="token">//如果excel文件后缀名为.xls，导入这个类</span> <span class="token4">import</span><span class="token3">(</span><span class="token2">"Org.Util.PHPExcel.Reader.Excel5"</span><span class="token3">)</span><span class="token3">;</span> <span class="token">//如果excel文件后缀名为.xlsx，导入这下类</span> <span class="token">//import("Org.Util.PHPExcel.Reader.Excel2007");</span> <span class="token">//$PHPReader=new \PHPExcel_Reader_Excel2007();</span> $PHPReader <span class="token1">=</span> <span class="token5">new</span> <span class="token4"><span class="token3">\</span>PHPExcel_Reader_Excel5</span><span class="token3">(</span><span class="token3">)</span><span class="token3">;</span> <span class="token">//载入文件</span> $PHPExcel <span class="token1">=</span> $PHPReader<span class="token1">-</span><span class="token1">></span><span class="token4">load</span><span class="token3">(</span>$filename<span class="token3">)</span><span class="token3">;</span> <span class="token">//获取表中的第一个工作表，如果要获取第二个，把0改为1，依次类推</span> $currentSheet <span class="token1">=</span> $PHPExcel<span class="token1">-</span><span class="token1">></span><span class="token4">getSheet</span><span class="token3">(</span><span class="token6">2</span><span class="token3">)</span><span class="token3">;</span> <span class="token">//获取总列数</span> $allColumn <span class="token1">=</span> $currentSheet<span class="token1">-</span><span class="token1">></span><span class="token4">getHighestColumn</span><span class="token3">(</span><span class="token3">)</span><span class="token3">;</span> <span class="token">//获取总行数</span> $allRow <span class="token1">=</span> $currentSheet<span class="token1">-</span><span class="token1">></span><span class="token4">getHighestRow</span><span class="token3">(</span><span class="token3">)</span><span class="token3">;</span> <span class="token1">++</span>$allColumn<span class="token3">;</span> <span class="token">//循环获取表中的数据，$currentRow表示当前行，从哪行开始读取数据，索引值从0开始</span> <span class="token5">for</span> <span class="token3">(</span>$currentRow <span class="token1">=</span> <span class="token6">1</span><span class="token3">;</span> $currentRow <span class="token1"><=</span> $allRow<span class="token3">;</span> $currentRow<span class="token1">++</span><span class="token3">)</span> <span class="token3">{</span> <span class="token">//从哪列开始，A表示第一列</span> <span class="token5">for</span> <span class="token3">(</span>$currentColumn <span class="token1">=</span> <span class="token2">'A'</span><span class="token3">;</span> $currentColumn <span class="token1">!=</span> $allColumn<span class="token3">;</span> $currentColumn<span class="token1">++</span><span class="token3">)</span> <span class="token3">{</span> <span class="token">//数据坐标</span> $address <span class="token1">=</span> $currentColumn <span class="token3">.</span> $currentRow<span class="token3">;</span> <span class="token">//读取到的数据，保存到数组$arr中</span> $arr<span class="token3">[</span>$currentRow<span class="token3">]</span><span class="token3">[</span>$currentColumn<span class="token3">]</span> <span class="token1">=</span> <span class="token3">(</span>string<span class="token3">)</span>$currentSheet<span class="token1">-</span><span class="token1">></span><span class="token4">getCell</span><span class="token3">(</span>$address<span class="token3">)</span><span class="token1">-</span><span class="token1">></span><span class="token4">getValue</span><span class="token3">(</span><span class="token3">)</span><span class="token3">;</span> <span class="token3">}</span> <span class="token3">}</span> ``` ```