thinkPHPå®ç°å°excelå¯¼å ¥å°æ°æ®åºä¸çæ¹æ³ä½å¦ä¸ï¼
PHPExcelæ件å¯ç¹å»æ¤å¤æ¬ç«ä¸è½½ã
è¿é使ç¨çæ¯thinkphpæ¡æ¶ç3.1çæ¬,ä¸è½½å¥½å缩å ,æ¡æ¶ä¸çextendä¸çvendoræ件夹ä¸æ°å»ºä¸ä¸ªå为PHPExcelçæ件夹,æclasseséé¢çå 容æ¾å°éé¢
ä¸é¢æ¯å端页é¢
æ示:æå¨æµè¯çæ¶åéå°æ¥éexception 'PHPExcel_Reader_Exception' with message 'The filename
åå æ¯ç±äºexcelçæ件åç¼å¯è½ä¸å,æçæ件åç¼æ¯xlsx,ç¶åç»æä»å¦å为äºxlsçæ件,å°±å¯ä»¥äº
<html>
<head>
</head>
<body>
<form action="{pigcms::U('Jdb/abcdefgwulisuibian')}" method="post" enctype="multipart/form-data">
<input type="file" name="import"/>
<input type="hidden" name="table" value="tablename"/>
<input type="submit" value="å¯¼å ¥"/>
</form>
</body>
</html>
ä¸é¢æ¯phpç
function abcdefgwulisuibianuplod(){
$this->display();//æ¾ç¤ºé¡µé¢
}
function abcdefgwulisuibian(){
if (!empty($_FILES)) {
import("@.ORG.UploadFile");
$config=array(
'allowExts'=>array('xlsx','xls'),
'savePath'=>'./Public/upload/',
'saveRule'=>'time',
);
$upload = new UploadFile($config);
if (!$upload->upload()) {
$this->error($upload->getErrorMsg());
} else {
$info = $upload->getUploadFileInfo();
}
vendor("PHPExcel.PHPExcel");
$file_name=$info[0]['savepath'].$info[0]['savename'];
$objReader = PHPExcel_IOFactory::createReader('Excel5');
$objPHPExcel = $objReader->load($file_name,$encode='utf-8');
$sheet = $objPHPExcel->getSheet(0);
$highestRow = $sheet->getHighestRow(); // åå¾æ»è¡æ°
$highestColumn = $sheet->getHighestColumn(); // åå¾æ»åæ°
for($i=2;$i<=$highestRow;$i++)//è¿ä¸ªå°æ¹æ ¹æ®éè¦,ä¸è¬ç¬¬ä¸è¡æ¯å称,æ以ä»ç¬¬äºè¡å¼å§å¾ªç¯,ä¹å¯ä»¥ä»ç¬¬ä¸è¡å¼å§
{
$data['lianjieid'] = $objPHPExcel->getActiveSheet()->getCell("A".$i)->getValue();//æ°æ®åºå段åexcelåç¸å¯¹åº
$data['yaoqingma'] = $objPHPExcel->getActiveSheet()->getCell("B".$i)->getValue();
$data['dlmima']= $objPHPExcel->getActiveSheet()->getCell("C".$i)->getValue();
$data['ljdizhi']= $objPHPExcel->getActiveSheet()->getCell("D".$i)->getValue();
M('jdb')->add($data);//æå ¥æ°æ®åº
}
$this->success('å¯¼å ¥æåï¼');
}else
{
$this->error("请éæ©ä¸ä¼ çæ件");
}
}