Asp½«²éѯ½á¹ûµ¼³öµ½excelÀï
ÊÇOfficeµÄOWC°æ±¾ÎÊÌâ¡£2000£¬2002XP£¬2003¸÷²»Ïàͬ£¬¼ÓÈëOfficeµÄ°æ±¾¼ì²é¼´¿É£¬ÍêÕû´úÂëÈçÏ£º
<script language="javascript">
function exportExcel(atblData,dirPath)
{
//alert(dirPath);
if (typeof(atblData)=="undefined"||typeof(atblData)=="unknow")
{
alert("ûÓÐÊý¾Ý¿ÉÒÔµ¼³ö£¡");
return;
}
var mysheet;
var off2000=false;
var off2002xp=false;
var off2003=false;
//office2003
try {
mysheet=new ActiveXObject("OWC11.Spreadsheet");
off2003=true;
}
catch(e) { }
//office2002-xp
if(!off2003)
{
try {
mysheet=new ActiveXObject("OWC10.Spreadsheet");
off2002xp=true;
}
catch(e) {}
}
//office 2000
&
Ïà¹ØÎĵµ£º
ĬÈÏÇé¿öÏ£¬ÔÚÒ³»Ø·¢µ½·þÎñÆ÷ʱ¡¢Ò³³õʼ»¯Ö®ºó£¨¼´ÊÓͼ״̬ºÍ»Ø·¢Êý¾ÝÒÑ´¦ÀíÖ®ºó£©ºÍµ÷ÓÃʼþ´¦Àí´úÂë֮ǰ£¬ASP.NET ÑéÖ¤¿Ø¼þ½«×Ô¶¯Ö´ÐÐÑéÖ¤¡£Èç¹ûä¯ÀÀÆ÷Ö§³Ö¿Í»§¶Ë½Å±¾£¬¿Ø¼þÒ²¿ÉÒÔÔÚä¯ÀÀÆ÷ÖÐÖ´ÐÐÑéÖ¤¡£
µ«ÊÇ£¬ÓÐʱÄú¿ÉÄÜÐèÒªÒÔ±à³Ì·½Ê½Ö´ÐÐÑéÖ¤¡£ÔÚÒÔÏÂÇé¿öÏ£¬Äú¿ÉÄÜÐèҪͨ¹ý±à³ÌÀ´½ ......
±¾ÑÝÁ·Í¨¹ýʹÓôúÂëе÷ͬһҳÉϵÄÁ½¸ö²Ëµ¥£¬ÑÝʾÈçºÎÒÔ±à³Ì·½Ê½Ê¹Óà ASP.NET Menu ¿Ø¼þ¡£
¿ÉÒÔʹÓà ASP.NET Menu ¿Ø¼þÎªÍøÕ¾´´½¨µ¼º½²Ëµ¥¡£ÔÚ±¾ÑÝÁ·ÖУ¬½«¿¼²ì ASP.NET Menu ¿Ø¼þµÄ±à³Ì·½Ã棬²¢´´½¨Á½¸öÐͬ¹¤×÷µÄ²Ëµ¥£¬ËüÃǶ¼°ó¶¨µ½Í¬Ò»¸ö Web.sitemap Îļþ¡£µÚÒ»¸ö²Ëµ¥ÊǾ²Ì¬ÏÔʾµÄÀà±ð£¨Èç²úÆ·¡¢·þÎñºÍÖ§³Ö£©²Ëµ¥¡£Ë ......
¡¡¡¡ÔÚ±àдASP³ÌÐòµÄʱºò£¬Í¨³£¶¼»áÓõ½<!--#include virtual|file="path/filename"-->°ÑÒ»¶ÎÏà¶Ô¶ÀÁ¢µÄÎļþ´úÂëǶÌ×µ½µ±Ç°Ò³ÃæÖÐÀ´¡£ÔÚʵ¼ÊµÄʹÓÃÖкܶàÈ˶Ô"file"ºÍ"virtual"µÄʹÓò»Ì«Àí½â£¬µ¼ÖÂÒ³ÃæÖ´ÐеÄʱºò»á³öÏÖ´íÎó¡£Ï־͸ÃÎÊÌâ×÷Ò»¸ö¼òÊö¡£
¡¡¡¡Ê¹ÓÃ"file"µÄʱºò£¬µÈºÅºóÃæÊ¹ÓõÄÊÇÏà¶Ô·¾¶¡£ËùνÏà¶ ......
dataurl=Server.MapPath("menutree.mdb")'Êý¾Ý¿âµØÖ·
dim conn,strQuery,rs
set conn = server.CreateObject("adodb.connection")
conn.Open "PROVIDER=MICROSOFT.JET.OLEDB.4.0;DATA SOURCE="&dataurl
strQuery="select * from menufun"
set rs=server.createobject("adodb.recordset")
rs.open strQuery,conn,1 ......
Login ¿Ø¼þÊÇÒ»ÖÖ¸´ºÏ¿Ø¼þ£¬ÌṩÁ˵Ǽ´°ÌåµÄËùÓг£ÓÃÓû§½çÃæ (UI) ÔªËØ¡£¸Ã¿Ø¼þ±»Ä£¿é»¯£¬¿É·Ö±ð×Ô¶¨Òåÿ¸ö²¿¼þ¡£ÕâЩ²¿¼þ°üÀ¨“Óû§Ãû”ºÍ“ÃÜÂë”Îı¾¿ò¡¢“Ìá½»”°´Å¥¡¢ÓÃÓÚ´´½¨ÐÂÓû§µÄ°´Å¥¡¢“¼ÇסÎÒ”¸´Ñ¡¿òºÍÓû§µÄ°ïÖúÐÅÏ¢¡£Äú¿ ......