如题所述
ç¨PHPExcelï¼PHPExcelæ¯ç¸å½å¼ºå¤§ç MS Office Excel ææ¡£çæç±»åºã
ä½ ä¸å®çå®/ç½æç¨åºå ä¸/è½½ä¸æ¥ï¼éé¢æ PHPExcel çç¨åºãè¿æ30个å®ä¾ç¨åºåä¸ä¸ªææ¡£ã
çä¸ä¸å ¶ä¸çå¼åææ¡£ä½ å°±ä¼ç¨äºã
读åï¼è¿æ®µå¨å¼åææ¡£éæçï¼å¨13页ï¼ï¼
require_once '../Classes/PHPExcel/IOFactory.php';
$objReader = PHPExcel_IOFactory::createReader('Excel2007');
$objReader->setReadDataOnly(true);
$objPHPExcel = $objReader->load("test.xlsx");
$objWorksheet = $objPHPExcel->getActiveSheet();
echo '<table>' . "\n";
foreach ($objWorksheet->getRowIterator() as $row) {
echo '<tr>' . "\n";
$cellIterator = $row->getCellIterator();
$cellIterator->setIterateOnlyExistingCells(false);
foreach ($cellIterator as $cell) {
echo '<td>' . $cell->getValue() . '</td>' . "\n";
}
echo '</tr>' . "\n";
}
echo '</table>' . "\n";
?>
ä½ ä¸å®çå®/ç½æç¨åºå ä¸/è½½ä¸æ¥ï¼éé¢æ PHPExcel çç¨åºãè¿æ30个å®ä¾ç¨åºåä¸ä¸ªææ¡£ã
çä¸ä¸å ¶ä¸çå¼åææ¡£ä½ å°±ä¼ç¨äºã
读åï¼è¿æ®µå¨å¼åææ¡£éæçï¼å¨13页ï¼ï¼
require_once '../Classes/PHPExcel/IOFactory.php';
$objReader = PHPExcel_IOFactory::createReader('Excel2007');
$objReader->setReadDataOnly(true);
$objPHPExcel = $objReader->load("test.xlsx");
$objWorksheet = $objPHPExcel->getActiveSheet();
echo '<table>' . "\n";
foreach ($objWorksheet->getRowIterator() as $row) {
echo '<tr>' . "\n";
$cellIterator = $row->getCellIterator();
$cellIterator->setIterateOnlyExistingCells(false);
foreach ($cellIterator as $cell) {
echo '<td>' . $cell->getValue() . '</td>' . "\n";
}
echo '</tr>' . "\n";
}
echo '</table>' . "\n";
?>
温馨提示:答案为网友推荐,仅供参考
第1个回答 2015-05-11
你插入数据的时候 add($info[$k]);而不是add($info);追问
我试过了!这样就加不进去了
$info[$k]['day3'] = $v['14'];
$result = M('Score')->add($info[$k]);
你有联系方式吗?
你先不忙入库 先把$info[$k]打印出来看看,结构对没有
foreach($excleData as $k=>$v){
//... ...
$info['day3']=$v['14'];
$result=M('Score')->add($info[$k]);
dump(M()->getLastsql());
exit;
}
看看sql ,数据库里面有记录只是没数据 应该是你$info[$k]的结构格式有问题