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Óû§ä¯ÀÀÔòÏÔʾÁíÍâÒ»ÕÅͼƬ  ......
ÇëÎÊÏÂÄܲ»ÄÜÔÙwindows϶¨ÆÚÇå¿ÕmysqlÒ»¸ö±íÖеÄÈ«²¿Êý¾Ý£¬ÓÃPHPʵÏÖ£¡
лл¸÷λÁË
¾Í±ÈÈçÒ»¸öÐÇÆÚÇå¿ÕÒ»´Î
±ÈÈçÿ¸öÐÇÆÚÁùÁãµãÇå¿ÕÒ»´Î£¡
ллÁË
¼Æ»®ÈÎÎñ...php....sql...truncate....OK
Äã¾ÍÕâ½ÓÔÚҳà ......
µ±ÎÒÓÃPHPÏÂÔØ·þÎñÆ÷ÉϵÄwavÒôÀÖÎļþʱ£¬wavÎļþÄܹ»ÏÂÔØÏÂÀ´£¬²¢ÇÒ´óСÏàͬ£¬µ«ÊÇÈ´²»Äܲ¥·Å¡£µ«ÈôÊÇͨ¹ýÎļþ·þÎñÆ÷¿½±´µ½±¾µØ£¬ÊÇ¿ÉÒÔ²¥·Å¸ÃÎļþµÄ£¬²»ÖªµÀÈçºÎÔÒò¡£Í¨¹ýMD5sum¼ì²â£¬¸ÃÎļþÏÂÔØºóÒѸı䣬²»ÖªµÀÔ ......
Ôڲɼ¯Ò»¸öÒ³ÃæµÄʱºòͨ³£¶¼ÊÇʹÓÃfile_get_contents($url)
²»¹ý·µ»ØµÄ½á¹ûÓÐʱºò»á²»È«
Èç¹ûÔÚhtmlÖÐʹÓà document.ready,ÔÚÒ³Ãæ×¼±¸ºÃºó£¬Ê¹ÓÃajax¶ÁÈ¡±ðÒ»²¿·ÖµÄÊý¾Ý
ÔÙͨ¹ýÐÞ¸Ähtml±êÇ©µÄÄÚÈÝ£¬¾Í²¿·ÖµÄÊý¾Ý¾ ......
µÃµ½¿Í»§¶ËIPÀÏÎÊÌâÁË£¬µ«Õâ´Î»·¾³Óе㲻һÑù£¨ ¿Í»§ÊÇÕâÑùµÄ»·¾³Ã»°ì·¨£¬ËµBTµÄÇëÆ®¹ý :) £©¡£
win2k3¸Ãϵͳ£¨Ï³ÆÏµÍ³A£©ÉÏ×°ÁËVMware Server£¬VMÏÂÓиöwin2k3ϵͳ(ϳÆÏµÍ³B)¡£
ϵͳA£ºÖ±½ÓÁ¬½Ó¹«Íø¡£Óй«ÍøI ......