ASP Ôõô ²Ù×÷ EXCEL£¬¶ÁÈ¡ ºÍ дÈë - Web ¿ª·¢ / ASP
Çë½Ì¸÷λ´óÏÀ£º
ASP Ôõô ²Ù×÷ EXCEL£¬¶ÁÈ¡ ºÍ дÈë
×îºÃÓдúÂë
ûÓÐÈ˰¡£¿
»¹ÊÇ·ÖÉÙ°¡£¿
ÕâЩ×ÊÁÏÓðٶÈgoogleһϾÍÊÇÒ»´ó¶Ñ¡£¡£ Ëæ±ãÕÒ¸öÀ´Ñо¿Ï¾ÍÄܵõ½×Ô¼ºµÄ½á¹û
±ÈÈçÕâ¸ö£ºhttp://tieba.baidu.com/f?kz=6668708
ÎÒÒ²°Ù¶Ègoogle¹ý£¬µ«ÊÇÓдíÎó
¸Õ²ÅÔÚ·þÎñÆ÷Éϰ²×°ÁËOffice µÄExcelºó£¬¾Í¿ÉÒÔÁË£¬
лл
ÆäʵºÜÏëÖªµÀ Excel.Application ÊÇÒýÓõÄÄĸö ³ÌÐò¼¯
¸úAccess²î²»¶àµÄ,Ö»²»¹ý±íÓÃ[]À¨ÆðÀ´
ÓÃExcel.ApplicationµÄÊÇVBA,ASPÖ±½Ó¿ÉÒÔÓÃODBC¡¢ADO·ÃÎÊExcel.
<%@ LANGUAGE= "VBSCRIPT " %>
<%option explicit%>
<HTML>
<HEAD>
<meta content= "text/html; charset=gb2312 " http-equiv= "Content-Type ">
<TITLE> Éú³ÉEXCELÎļþ </TITLE>
</HEAD>
<body>
<a href= "dbtoexcel.asp?act=make "> Éú³ÉEXCELÎļþ </a>
<hr size=1 align=left width=300px>
<%
if Request( "act ") = " " then
Response.Write "Éú³ÉEXCELÎļþ "
else
dim conn,strconn
strconn= "driver={SQL Server};ser
Ïà¹ØÎÊ´ð£º
http://www.zgjhjy.com/Test/PrimaryTest/Index.aspx
¾ÍÊÇÀàËÆÒÔÉϵÄÔÚÏß²âÊÔϵͳ£¬ÐèÒªÓÐÒ»¸öºǫ́µÄ£¬ÓïÑÔÊÇaspµÄ£¬Êý¾Ý¿âÊÇaccessµÄ£¬»¹ÐèÒªÄÜÔÚºǫ́¶ÔÐÅÏ¢½øÐÐÌíɾ¸Ä²éµÄ¡£Ð»Ð»¸÷λÁË¡£¡£¡£
³ÌÐòÕæµÄºÜ¶à£¬²»Öª ......
1.asp.net×öµÄÒ»¸ö´ðÌâÒ³Ãæ£¬ÈçºÎʵʱÏÞʱºó×Ô¶¯Ìá½»£¬Çë´ó¼Ò¸øµã˼·
ÏÞʱµÄʱ¼äÐÅÏ¢´æ·ÅÔÚÊý¾Ý¿âÖÐ
2.Èç¹û´ðÌâʱ¼äÉèÖõĽϳ¤£¬ÈçºÎ·½Ê½session³¬Ê±ºóÒ³ÃæÎÞЧ
лл
ÓÃjs·½·¨À´¿ØÖÆ
»Ø¸´ÄÚÈÝÌ«¶ÌÁË¡£¡£
js ......
´ó¼ÒºÃ£¬ÎÒÏÖÔÚÓÐÒ»¸öÓÃaspдµÄÁÄÌìÊÒ£¬ÏÖÔÚµÄÏëÌí¼ÓÒ»¸ö¹¦ÄÜ£¬¾ÍÊǵ±ÓÐÈËÉÏÏßµÄʱºò£¬·¢³öÌáʾ£¬±ÈÈçÉùÒôÏìһϣ¬ÏÖÔÚÏëÓÃjavaʵÏÖÕâ¸ö¹¦ÄÜ£¬ÇëÎÊ´ó¼ÒÔõôʵÏÖ£¿
ллÁË£¬ÎÒ»á¼Ó·ÖµÄ
aspºÍjavaÕûºÏµ½Ò»ÆðÈ¥£¿ºÎ±Ø ......
sqlserverµÄÊý¾Ý¿â£¬×Ö¶ÎÊÇimageÀàÐ͵ġ£Ôõôд´úÂ룬ÔÚÒ³ÃæÖеã»÷¡°ÏÂÔØ¡±¾ÍÄÜ´ò¿ªÄǸöÏÂÔØ¶Ô»°¿ò£¿
PS£ºOracleLob ÔÚsqlserverÀïÊÇʲô£¿
Response.Redirect("test.jpg")
ÒýÓÃ
Response.Redirect( ......
¸÷λºÃ£¬ÎÒ¸Õ°ÑÒ»¸öASPÍøÕ¾ÉèÖúÃÁË£¬Ò²ÄÜÕý³£·ÃÎÊ¡£µ«ÊÇÔÚÎÒ±¾»úÉϲ»ÄÜ´ò¿ªadmin\login.asp,ËùÒÔÎÞ·¨ÊµÏÖºǫ́¹ÜÀí¡££¨´íÎóÌáʾÎÞ·¨ÕÒµ½ÍøÒ³£¬´úÂë404£¬ÎҵIJÙ×÷ϵͳÊÇwin2000 server)
µ«ÊÇÆæ¹ÖµÄÊÇÔÚ¾ÖÓòÍøµÄÆäËû» ......