phpexcel（1）

http://www.pkwind.com/insight-into-application-of-php-classes-phpexcel/ （这个是phpexcel的教程）
http://phpexcel.codeplex.com/ （官网下载phpexcel最新的）
http://www.tudou.com/programs/view/RCyUlHQ4NWg/ (视频教程5分钟以后有讲phpexcel你们可以快进)

1、 $dir = ECMS_PATH."d\\file\\".date("Ym")."\\";

$randfilename=randstr(10);
$newpath = $public_r['newsurl']."d/file/".date("Ym")."/".$randfilename;
echo "Path: ".$newpath;

$sql="INSERT INTO `phome_ecms_files` (`id`, `classid`, `onclick`, `newspath`, `keyboard`, `keyid`, `userid`, `username`, `ztid`, `checked`, `istop`, `truetime`, `ismember`, `dokey`, `userfen`, `isgood`, `titlefont`, `titleurl`, `filename`, `groupid`, `newstempid`, `plnum`, `firsttitle`, `isqf`, `totaldown`, `title`, `newstime`, `titlepic`, `closepl`, `havehtml`, `lastdotime`, `haveaddfen`, `infopfen`, `infopfennum`, `votenum`, `stb`, `copyids`, `ttid`, `infotags`, `ispic`, `files`, `giveuser`) VALUES (Null, 71, 0, '2011-08-23', '', '', ".$user[userid].", '".$user[username]."', '', 1, 0, ".time().", 1, 0, 0, 0, '', '', '1', 0, 0, 0, 0, 0, 0, '".$user[username]."提交的明细', ".time().", '', 0, 1, ".time().", 0, 0, 0, 0, '1', '', 0, '', 0, '".$newpath."', '".$user[userid]."');";
$empire->query($sql);

//附件上传目录
make_dir($dir);

$num=$empire->gettotal("select count(*) as total from phome_ecms_mingxi where userid=".$user[userid]." and ismember=1");
if($num==0){
    echo '没有可生成数据!';
    exit;
    }
$sql=  $empire->query("select * from phome_ecms_mingxi where userid=".$user[userid]." and ismember=1 order by id asc");

?>