php°ÑÍøÒ³Êý¾Ýµ¼Èëµ½ExcelµÄÎÊÌâ
¸Õ²Å¿´µ½Õâ¸öÍøÕ¾µÄ³É¼¨²éÑ¯Ò³Ãæ http://www.bjzx.sdedu.net/Cjcx/yxxs.asp µ¼³öΪExcelÖ®ºó£¬¸ñʽ·Ç³£µÄƯÁÁ£¬ËÙ¶ÈÒ²¿ì£¬¾¡¹ÜÊÇasp°æµÄ¡£
ÇëÎÊ£¬Èç¹ûÊý¾ÝµÄÐÐÊýºÍÁÐÊý¿É±äµÄ»°£¬ÈçºÎÓÃphpÊä³ö´ø¸ñʽµÄExcelÎļþÄØ£¿Óмòµ¥µÄ´úÂë·¶ÀýÂð£¿Ð»Ð»£¡
aspÖÐûÓÐphpexcel£¬ËùÒÔ²»¿¼ÂÇÕâ¸ö¶«¶«¡£
http://www.codeplex.com/PHPExcel/
phpÊä³ö´ø¸ñʽµÄExcelÎļþ->ÓÃËû°É£¬Ö»ÓÐÏë²»µ½£¬Ã»ÓÐ×ö²»µ½¡£
PHPExcel¹¦ÄÜÇ¿´ó£¬Ìå»ý¾Þ´ó£¬Âé·³¾Þ´ó
ÎÒÒ²ÍÆ¼öphpexcel ,Spreadsheet Ò²²»´í¡£¡£
phpexcelÊÇÓÃÔÚºÏÊʵĵط½£¬²»ÊÇËùÓеط½¶¼ÐèÒªËû¡£
phpexcelÔõôÓ𡣬ÎÒÒ²²»»á£¬ÎÒÒ²Ïëµ¼³ö£¬ÏÂÔØµ¼³ö ±í¡£
ºÃ¶«Î÷,²»¹ýÎĵµÔÚÄÄÀï?
¼ÈÈ»asp¶¼ÄÜʵÏÖµÄÕâôÍêÃÀ£¬ÎÒÏëphpÓ¦¸ÃÓв»ÓÃphpexcelµÄ¼òµ¥°ì·¨À´ÊµÏÖÊä³ö´ø¸ñʽµÄExcelÎļþ°É¡£ÄÄλÀÏʦÄÜÖ¸µãÒ»ÏÂÄØ£¿Ð»ÁËÏÈ¡«¡«¡«¡«¡«
º¹ËÀ,這個²»難°É,Èç¹ûÖ»ÒªÏë導³öEXCEL±íµÄ話...
PHP code:
header("Content-type:application/xls");
header("Content-Disposition:attachment;filename=test.xls");
$a=array(array('a','1'),array('b','2'));
foreach($a as $b){
$b1[] = implode("\t",$b);
}
echo implode("\n",$b1);
¿ÉÄÜÊÇÎÒû±íÊöÇå³þ£¬ÎÒÊÇÏëÒªÓÃPHPʵÏÖÀàËÆÒ»Â¥ÄǸöÍøÒ³µ¼³ö´ø¸ñʽµÄExcelÎļþ£¨ÀýÈ磬ºÏ²¢µ¥Ôª¸ñ£¬±í¸ñ±í¿ò£¬µ¥Ôª¸ñÊý¾Ý¾ÓÖУ©£¬µ«ÊÇÓÖ²»ÏëÓÃPHPExcel¡£
Ïà¹ØÎÊ´ð£º
µ±ÎÒÓÃPHPÏÂÔØ·þÎñÆ÷ÉϵÄwavÒôÀÖÎļþʱ£¬wavÎļþÄܹ»ÏÂÔØÏÂÀ´£¬²¢ÇÒ´óСÏàͬ£¬µ«ÊÇÈ´²»Äܲ¥·Å¡£µ«ÈôÊÇͨ¹ýÎļþ·þÎñÆ÷¿½±´µ½±¾µØ£¬ÊÇ¿ÉÒÔ²¥·Å¸ÃÎļþµÄ£¬²»ÖªµÀÈçºÎÔÒò¡£Í¨¹ýMD5sum¼ì²â£¬¸ÃÎļþÏÂÔØºóÒѸı䣬²»ÖªµÀÔ ......
´úÂëÈçÏ£º
function uc_get_user($username, $isuid=0) {
$return = call_user_func(UC_API_FUNC, 'user', 'get_user', array('username'=>$username, 'isuid'=>$isuid));
return UC_CONNECT == 'mysql' ......
ÎÒ¸ÕѧϰphpÇëÎÊ£¬Èç¹ûÎÒ°ÑphpÎļþÉÏ´«ÖÁ·þÎñÆ÷ºó£¬ÀýÈçhttp://www.****.com/cast.phpÕâ¸öÎļþ»á²»»á±»±ðÈËÏÂÔØ»ò¸´Öư¢£¿
¿ÉÒÔ±»ÏÂÔØ£¬Ò²¿ÉÒÔ²»±»ÏÂÔØ£¬¿´web·þÎñÆ÷¶Ô¸ÃÎļþȨÏÞµÄÅäÖÃ
¿´Äã¶ÔÎļþȨÏÞµÄÉèÖÃ
......
PHP code:
$date = '2009-12-25';
$ptn = '/([\d]{4})[- \/](0?[\d]|1[0-2])[-\/ ](0?[\d]|[1-2][\d]|3[0-1])/';
if (preg_match($ptn,$date,$out))
{
print_r($out);exit();
}
½á¹ûΪ:
PHP code:
......