ASPÎÞ·¨¹Ø±ÕµÄEXCEL - Web ¿ª·¢ / ASP
¸½¼þµØÖ·http://download.csdn.net/source/2341319
ÓÉÓÚÕâÀï²»ÄÜÉÏ´«¸½¼þ£¬Ö»ÄÜ·ÅÔÚÕâÀïÁË
VB code:
<%
strAddr = Server.MapPath(".")
Set objFSO = CreateObject("Scripting.FileSystemObject")
Set f = objFSO.GetFile(strAddr&"\1.xls")
if f.attributes<>0 then
f.attributes = 0
end if
Set Excel_File = CreateObject("Excel.Application")
Excel_File.AutomationSecurity=3
Set Excel_WorkBook=Excel_File.Workbooks.open(strAddr&"\1.xls")
Set Excel_Sheet = Excel_WorkBook.Worksheets(1)
'Excel_Sheet.Range("A1" , "A2" ).EntireRow.Delete
'Excel_Sheet.Rows(UsedRange.Rows.count).Delete
If objFSO.FileExists(strAddr&"\Excel\1.xls") Then
objFSO.DeleteFile strAddr&"\Excel\1.xls",True
End If
Set objFSO = Nothing
Excel_WorkBook.SaveAs strAddr&"\Excel\1.xls"
Excel_WorkBook.Save
Excel_File.DisplayAlerts = False
Excel_WorkBook.Close
Excel_WorkBook.Close
Excel_File.Quit
Excel_File.Quit
Set Excel_Sheet = Nothing
Set Excel_WorkBook = Nothing
Set Excel_File = Nothing
%>
Âé·³¸÷λ¸ßÊÖ¸ø¿´¿´ÎªÊ²Ã´ÁË
ûÈË»áô
ÔÚ
If objFSO.File
Ïà¹ØÎÊ´ð£º
´ó¼ÒºÃ!ÎÒÊÇÒ»¸öѧÉú,ÏÖÔÚÊÇѧASPµÄ²»ÖªµÀÔõô»ØÊÂ,ÎÒ×Ô¼ºÊÇÓÃCMS×ö¹ýÍøÕ¾ ´úÂëÒ²ÄÜ¿´¶®Ò»µã ÏÖÔÚÏëÂò±¾Êé,Ïë·¨Óкܶà,¾ÍÊÇÏëÂòASPµÄ ÓÖ¿´µ½´ó¼Ò˵ASPÒÔºóûÓÐNETǰ¾°ºÃ,ÎÒÓÖÏëÔÙÈ¥Âò±¾ASP.NETµÄ ÎÒÖªµÀÓÐÕâÑùµÄÏë·¨ ......
ÎÒÓÐÁ½¸ödropdownlist¶¼°óºÃÁËÖµ£¬ÏëÑ¡ÖÐÒ»¸ödropdownlistÖеÄÖµ£¬È»ºóÔÚÁíÒ»¸ödropdownlistÖÐÑ¡ÖÐÏàÓ¦µÄÒ»Ïî¡£
²»ÊÇ´Óа󶨵ڶþ¸ödropdownlist£¬ÊÇÔÚÒѾ°óºÃµÄÖµµ±ÖÐÑ¡ÖÐÒ»¸ö¡£
ÎÒÏëÓÃjsд
ÇóÖú
Äã¿ÉÒÔ°Ñdrop ......
¹ØÓÚÍøÕ¾°²È«µÄÎÊÌ⣡
ÎÒÁ˽⵽µÄÍøÕ¾°²È«ÎÊÌâ°üÀ¨£º
sql×¢Èë©¶´ºÍ±©¿â©¶´»¹ÓÐÉÏ´«Â©¶´
³ýÁËÕâЩ»¹ÓÐÆäËûµÄ©¶´Ã´£¿
×¢Èë©¶´¿ÉÒÔͨ¹ý¹ýÂËÀ´·ÀÖ¹
±©¿â©¶´Ôõô·ÀÖ¹
»¹ÓÐÈËÉÏ´«µÄľÂíÊÇ.gif
ÕâÖÖ©¶´Ôõôȥ± ......
ÎÒ×î½ü×öÁËÒ»¸öÍøÕ¾ÊǹØÓÚ²úƷչʾµÄ ~ Õû¸öÍøÕ¾Í¼Æ¬¶¼Õ¼ÓÃÁËÒ»´ó°ë
ÕâÑùµÄ»°·ÃÎÊËٶȾͷdz£Âý ÓÐʲô°ì·¨¿ÉÒÔ½â¾öÂð£¿
Âé·³´ó¼Ò¶à¶à¸øµãÒâ¼û £¡ ÓÐʲô¾¡¹Ü˵
3Q´ó¼Ò
htmlÒ³Ãæ.
Õâ¸ö,¼ÈÈ»Ö÷Ò ......
ÀàËÆÌÔ±¦Ò³ÃæÉϵÄ
http://www.taobao.com/
×îºÃÓÐÔ´Âë »òÕß˵µÄÏêϸµã лл ~
ʲô½Ð¶¯Ì¬¹ã¸æ£¿
²»Ã÷°×
µ¯³öÒ»¸ö¿ò£¿
ÀûÓÃJsÎļþ°É£¬°Ñ¹ã¸æÉú³Éjs
aspx:
<%@ Page Language="C#" AutoEventWi ......