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´úÂë
¿ÉÒÔʵÏÖÒÔϹ¦ÄÜ
Õë¶Ô²»Í¬µÄä¯ÀÀÆ÷ÏÔʾ²»Í¬µÄͼƬ
¾ÍÊÇÓÐÒ»ÕÅͼƬ£¬Ö»Ïë¸øie6Óû§¿´µ½
Èç¹ûie7¡¢chrome¡¢firefoxÓû§ä¯ÀÀÔòÏÔʾÁíÍâÒ»ÕÅͼƬ  ......
ÔÚ¹úÍâµÄ¿Õ¼ä£¬ÆäËüµÄphpÕ¾µã¶¼Õý³££¬¿ÉÖ»ÓÐ×î½ü½¨µÄÕâ¸öÕ¾µã£¬Ö»ÒªÒ»ä¯ÀÀphpÎļþ¾Í³öÏÖÏÂÔØÌáʾ£¬ÏÂÔØÏÂÀ´µÄÎļþ¶¼ÊÇ´øÓÐphpÔ´Â룬¸÷λ·¹ýµÄ£¬°ï°ïÎÒ£¬¿´¿´Ê²Ã´ÔÒò£¬ÏÈлÁË¡£
¿Õ¼ä²»Ö§³Ö¡£
»òÕßÄãµÄÕ˺ÅûÓп ......
ÎÒ¸ÕѧϰphpÇëÎÊ£¬Èç¹ûÎÒ°ÑphpÎļþÉÏ´«ÖÁ·þÎñÆ÷ºó£¬ÀýÈçhttp://www.****.com/cast.phpÕâ¸öÎļþ»á²»»á±»±ðÈËÏÂÔØ»ò¸´Öư¢£¿
¿ÉÒÔ±»ÏÂÔØ£¬Ò²¿ÉÒÔ²»±»ÏÂÔØ£¬¿´web·þÎñÆ÷¶Ô¸ÃÎļþȨÏÞµÄÅäÖÃ
¿´Äã¶ÔÎļþȨÏÞµÄÉèÖÃ
......
ÒѾÐÞ¸ÄÁË
£¨1£©PHP.iniÖеÄpost_max_size ºÍupload_max_filesize£¬²¢ÇÒ±£Ö¤ÁËǰÕß´óÓÚºóÕß
£¨2£©Windows\System32\inetsvr\MetaBase.xmlÖеÄAspMaxRequestEntityAllowed
ÐÞ¸ÄÍê±Ïºó£¬ÖØÐÂÆô¶¯ÁËIIS·þÎñ£¬²¢ÇÒ¼Æ ......