- <?php
- require_once 'Excel/reader.php';
- $data = new Spreadsheet_Excel_Reader();
- $data->setOutputEncoding('gb2312');//CP1251
- //$data->setOutputEncoding('utf-8');//CP1251
- $data->read('test.xls');
- error_reporting(E_ALL ^ E_NOTICE);
- for ($i = 1; $i <= $data->sheets[0]['numRows']; $i++) {
- for ($j = 1; $j <= $data->sheets[0]['numCols']; $j++) {
- $str[$i][]="\"".$data->sheets[0]['cells'][$i][$j]."\",";
- }
- }
- //array_shift($str);array_shift($str);
- for($v=0;$v<count($str);$v++)
- {
- if($data->hanzi($str[$v][0]))continue;
- print_r($str[$v]);
- echo "<br />";
- }
- ?>
- <?php
- require_once 'Excel/reader.php';
- $data = new Spreadsheet_Excel_Reader();
- //$data->setOutputEncoding('gbk');//此处设置编码,一般都是gbk模式
- $data->setOutputEncoding('utf-8');//此处设置编码,一般都是gbk模
- $data->read('test.xls');//文件路径
- error_reporting(E_ALL ^ E_NOTICE);
- //这里我就只循环输出excel文件的内容了,要入库,只要把输出的地方,写一段mysql语句即可~
- for ($i = 1; $i <= $data->sheets[0]['numRows']; $i++) {
- for ($j = 1; $j <= $data->sheets[0]['numCols']; $j++) {
- echo "\"".$data->sheets[0]['cells'][$i][$j]."\",";
- }
- echo "n";
- }
- ?>
- <?php
- require_once 'Excel/reader.php';
- $data = new Spreadsheet_Excel_Reader();
- $data->setOutputEncoding('gb2312');//CP1251
- //$data->setOutputEncoding('utf-8');//CP1251
- $data->read('test.xls');
- error_reporting(E_ALL ^ E_NOTICE);
- $con = mysql_connect("localhost","root","123");
- mysql_select_db("db_shop",$con);
- mysql_query("set names gbk");
- 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表数据【13个字段】插入到mysql中,根据你的excel表字段的多少,改写以下代码吧!
- $sql = "INSERT INTO tb_shangpin VALUES('".
- " "."','".
- $data->sheets[0]['cells'][$i][1]."','".
- $data->sheets[0]['cells'][$i][2]."','".
- $data->sheets[0]['cells'][$i][3]."','".
- $data->sheets[0]['cells'][$i][4]."','".
- $data->sheets[0]['cells'][$i][5]."','".
- $data->sheets[0]['cells'][$i][6]."','".
- $data->sheets[0]['cells'][$i][7]."','".
- $data->sheets[0]['cells'][$i][8]."','".
- $data->sheets[0]['cells'][$i][9]."','".
- $data->sheets[0]['cells'][$i][10]."','".
- $data->sheets[0]['cells'][$i][11]."','".
- $data->sheets[0]['cells'][$i][12]."','".
- $data->sheets[0]['cells'][$i][13]."')";
- $sql.'<br />';
- $res = mysql_query($sql);
- if($res)
- {
- echo "插入数据成功!";
- }
- }
- ?>
转载于:https://blog.51cto.com/heyohsmm/1189383