1. _toString() 是PHP自帶的魔術(shù)方法永淌，把對象強(qiáng)制轉(zhuǎn)換為string
<?php
$dir = dirname(__FILE__); //找出當(dāng)前腳本所在路徑
// 比如當(dāng)前文件所在目錄是： D:\1WWW\yui890\syh 粪般，則 $dir = D:\1WWW\yui890\syh
//利用php讀取excel數(shù)據(jù)
require $dir.'\PHPExcel-1.8\Classes\PHPExcel\IOFactory.php';
$filename = $dir.'\list.xls';
$objPHPExcelReader = PHPExcel_IOFactory::load($filename); //加載excel文件
foreach($objPHPExcelReader->getWorksheetIterator() as $sheet) //循環(huán)讀取sheet
{
foreach ($sheet->getRowIterator() as $row) //逐行處理
{
if ($row->getRowIndex() < 2) //確定從哪一行開始讀取
{
continue;
}
foreach ($row->getCellIterator() as $cell) //逐列讀取
{
$data = $cell->getValue(); //獲取cell中數(shù)據(jù)
if($data instanceof PHPExcel_RichText) $data = $data->__toString(); // 這一行最關(guān)鍵２齑俊Ｑ肀：肿馈衰抑！
//var_dump($data);
echo $data;
}
echo '<br/>';
}
}
百度網(wǎng)盤：PHPExcel-1.8.zip【官網(wǎng)下載的】
http://pan.baidu.com/s/1jHK84g2
來源：http://blog.csdn.net/s390124971/article/details/52911042
http://blog.csdn.net/helencoder/article/details/48541633
