php½«excelµ¼Èëmysql

£¨×ª×Ôhttp://www.jb51.net/article/20829.htm£©
ÕâÀï½éÉÜÒ»¸öÖ±½Ó½«excelÎļþµ¼ÈëmysqlµÄÀý×Ó¡£ÎÒ»¨ÁËÒ»ÍíÉϵÄʱ¼ä²âÊÔ£¬ÎÞÂÛµ¼Èë¼ò·±Ì嶼²»»á³öÏÖÂÒÂ룬·Ç³£ºÃÓá£
PHP-ExcelReader,ÏÂÔصØÖ·: http://sourceforge.net/projects/phpexcelreader
˵Ã÷£º
²âÊÔ»·¾³£ºMYSQLÊý¾Ý¿â²ÉÓÃutf8±àÂë.µ¼ÈëEXCELÎĵµÊÇxls¸ñʽ,¾­¹ý²âÊÔ£¬xlsx ¸ñʽ[excel 2007]Ò²OK.
ÎÄÖкìÉ«±êעΪÐèҪעÒâµÄµØ·½£¬ÇëÌæ»»³ÉÄãÅäÖúõÄÊý¾Ý£¬ÈçÊý¾Ý¿âÅäÖõȡ£ÔËÐÐhttp://localost/test.phpʵÏÖµ¼Èë¡£
ÒÔÏÂÊÇÎÒÌù³öµÄÏêϸ´úÂ룬ÆäÖÐtest.phpΪÎÒдµÄ²âÊÔÎļþ£¬reader.phpºÍoleread.incÎļþÊÇ´ÓÉÏÃæÌṩµÄÍøÖ·ÖÐÏÂÔصġ£
1. test.php 
require_once './includes/reader.php';
// ExcelFile($filename, $encoding);
$data = new Spreadsheet_Excel_Reader();
// Set output Encoding.
$data->setOutputEncoding('gbk');
//”data.xls”ÊÇÖ¸Òªµ¼Èëµ½mysqlÖеÄexcelÎļþ
$data->read('date.xls');
@ $db = mysql_connect('localhost', 'root', '1234') or
die("Could not connect to database.");//Á¬½ÓÊý¾Ý¿â
mysql_query("set names 'gbk'");//Êä³öÖÐÎÄ
mysql_select_db('wenhuaedu'); //Ñ¡ÔñÊý¾Ý¿â
error_reporting(E_ALL ^ E_NOTICE);
for ($i = 1; $i <= $data->sheets[0]['numRows']; $i++) {
//ÒÔÏÂ×¢Ê͵ÄforÑ­»·´òÓ¡excel±íÊý¾Ý
/*
for ($j = 1; $j <= $data->sheets[0]['numCols']; $j++) {
echo """.$data->sheets[0]['cells'][$i][$j]."",";
}
echo "n";
*/
//ÒÔÏ´úÂëÊǽ«excel±íÊý¾Ý¡¾3¸ö×ֶΡ¿²åÈëµ½mysqlÖУ¬¸ù¾ÝÄãµÄexcel±í×ֶεĶàÉÙ£¬¸ÄдÒÔÏ´úÂë°É£¡
$sql = "INSERT INTO test VALUES('".
$data->sheets[0]['cells'][$i][1]."','".
$data->sheets[0]['cells'][$i][2]."','".
$data->sheets[0]['cells'][$i][3]."')";
echo $sql.'<br />';
$res = mysql_query($sql);
Ìù³öÆäÖаüº¬µÄÎļþ
2¡¢OLERead.php
<?php
define('NUM_BIG_BLOCK_DEPOT_BLOCKS_POS', 0x2c);
define('SMALL_BLOCK_DEPOT_BLOCK_POS', 0x3c);
define('ROOT_START_BLOCK_POS', 0x30);
define('BIG_BLOCK_SIZE', 0x200);
define('SMALL_BLOCK_SIZE', 0x40);
define('EXTENSION_BLOCK_POS', 0x44);
define('NUM_EXTENSION_BLOCK_POS', 0x48);
define(