<ol
class
=
"dp-c"
>
<li
class
=
"alt"
><span><span
class
=
"keyword"
>
require_once
</span><span> </span><span
class
=
"string"
>
'phpexcel/Classes/PHPExcel/IOFactory.php'
</span><span>; </span></span></li>
<li><span><span
class
=
"keyword"
>
require_once
</span><span> </span><span
class
=
"string"
>
'phpexcel/Classes/PHPExcel/Reader/Excel5.php'
</span><span>; </span></span></li>
<li
class
=
"alt"
><span><span
class
=
"vars"
>
$objReader
</span><span> = PHPExcel_IOFactory::createReader(</span><span
class
=
"string"
>
'Excel5'
</span><span>);</span><span
class
=
"comment"
>
<li><span><span
class
=
"vars"
>
$objPHPExcel
</span><span> = </span><span
class
=
"vars"
>
$objReader
</span><span>->load(</span><span
class
=
"vars"
>
$filename
</span><span>); </span><span
class
=
"comment"
>
<li
class
=
"alt"
><span><span
class
=
"vars"
>
$sheet
</span><span> = </span><span
class
=
"vars"
>
$objPHPExcel
</span><span>->getSheet(0); </span></span></li>
<li><span><span
class
=
"vars"
>
$highestRow
</span><span> = </span><span
class
=
"vars"
>
$sheet
</span><span>->getHighestRow(); </span><span
class
=
"comment"
>
<li
class
=
"alt"
><span><span
class
=
"vars"
>
$highestColumn
</span><span> = </span><span
class
=
"vars"
>
$sheet
</span><span>->getHighestColumn(); </span><span
class
=
"comment"
>
<li><span><span
class
=
"vars"
>
$k
</span><span> = 0; </span></span></li>
<li
class
=
"alt"
><span><span
class
=
"comment"
>
<li><span> <span
class
=
"keyword"
>
for
</span><span>(</span><span
class
=
"vars"
>
$j
</span><span>=2;</span><span
class
=
"vars"
>
$j
</span><span><span
class
=
"vars"
>
$highestRow
</span><span>;</span><span
class
=
"vars"
>
$j
</span><span>++) </span></span></span></li>
<li
class
=
"alt"
><span> { </span></li>
<li><span> <span
class
=
"vars"
>
$a
</span><span> = </span><span
class
=
"vars"
>
$objPHPExcel
</span><span>->getActiveSheet()->getCell(</span><span
class
=
"string"
>
"A"
</span><span>.</span><span
class
=
"vars"
>
$j
</span><span>)->getValue();</span><span
class
=
"comment"
>
<li
class
=
"alt"
><span> <span
class
=
"vars"
>
$b
</span><span> = </span><span
class
=
"vars"
>
$objPHPExcel
</span><span>->getActiveSheet()->getCell(</span><span
class
=
"string"
>
"B"
</span><span>.</span><span
class
=
"vars"
>
$j
</span><span>)->getValue();</span><span
class
=
"comment"
>
<li><span> <span
class
=
"vars"
>
$sql
</span><span> = </span><span
class
=
"string"
>
"INSERT INTO table VALUES("
</span><span>.</span><span
class
=
"vars"
>
$a
</span><span>.</span><span
class
=
"string"
>
","
</span><span>.</span><span
class
=
"vars"
>
$b
</span><span>.</span><span
class
=
"string"
>
")"
</span><span>; </span></span></li>
<li
class
=
"alt"
><span> mysql_query(<span
class
=
"vars"
>
$sql
</span><span>); </span></span></li>
<li><span> } </span></li>
</ol>