PHPExcel

/**
* 读取excel
*/
public function index()
{
$fileName = 'USCA';
$fileContent = '';
ini_set('memory_limit','3072M'); // 临时设置最大内存占用为3G
set_time_limit(0); // 设置脚本最大执行时间 为0 永不过期
require __DIR__ . '/../Common/Excel/PHPExcel/IOFactory.php';
$uploadfile = "D:/tel/$fileName.xlsx";
$reader = PHPExcel_IOFactory::createReader('Excel2007'); // 读取 excel 文档
$PHPExcel = $reader->load($uploadfile); // 文档名称
$sheet = $PHPExcel->getSheet(0);
$highestRow = $sheet->getHighestRow(); // 取得总行数
$highestColumn = $sheet->getHighestColumn(); // 取得总列数

// 获取一行的数据
for ($row = 1; $row <= $highestRow; $row++){
// Read a row of data into an array
$rowData = $sheet->rangeToArray('A' . $row . ':' . $highestColumn . $row, NULL, TRUE, FALSE);
if (count($rowData) >0) {
$rowData = $rowData[0];
foreach ($rowData as $key => $value) {
$str = preg_replace('/[^0-9]+/','',$value);
$str = trim($str);
if ( strlen( $str) > 5) {
// $arr = explode("-",$str);
// if (count($arr) > 1) {
// $str = preg_replace('/[^0-9]+/','',$arr[0]);
// echo "INSERT into t_au(tel) VALUE($str);";
// $str = preg_replace('/[^0-9]+/','',$arr[1]);
// echo "INSERT into t_au(tel) VALUE($str);";
// }else{
$fileContent .= "INSERT into t_$fileName(tel) VALUE($str);";
// }
}
}
}
}
self::addFile($fileName,$fileContent);
}

public function addFile($fileName,$content)
{

$myfile = fopen("d:/tel/$fileName.sql", "a") or die("Unable to open file!");//这个是在c盘根目录生成文件
fwrite($myfile, $content);//写入内容,可以写多次哦,不过没啥意义,因为你拼接好字符串,一次写入就行了
fclose($myfile);//关闭该操作
}