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
Ïà¹ØÎÊ´ð£º
ÓÐÒ»¸öÀà
class adc
{
dim a,b,c
}
ÈçºÎÔÚÁíÍâÒ»¸öÀàÖÐÈ¡µÃÀà³ÉÔ±¼°³ÉÔ±¸öÊý
class getmenber
{
dim menbers()
function getmenbers(resclass)
'resΪһδ֪Àà
'getmenber ......
C# code:
SqlConnection conn = CsDB.sqlcon();
SqlDataAdapter da = new SqlDataAdapter("select fwCoding from bjmuma_fwCoding where OrderNumber='" + Order + & ......
asp.netÅúÁ¿ÉÏ´«Í¼Æ¬×îºÃÓÐÔ´Â룬ÔÚÏߵȣ¡£¡£¡£¡£¡£¡£¡
Ô´ÂëºÜ³¤µÄ¡£
²Î¿¼
C# code:
HttpFileCollection files = HttpContext.Current.Request.Files;
if (files.Count <= 1)
{
......
¸÷λ´óÏÀ£¬ÎÒѧϰµÄÊÇASP.NET£¬ÏëÖªµÀÏà¹Ø¼¼ÊõÓÐÄÄЩ£¬¾ÍÏñJAVA EEÖÐÓÐstruct sping jsp severlet µÈ£¬ASP.NET»¹ÓÐÄÄЩЩÏà¹Ø¼¼Êõ¡£
http://topic.csdn.net/u/20090914/21/af27de99-f0f3-4cfd-9379-13764f8ec6b1.ht ......
ÏÖÓÐÒ»¸ö±í¸ñ£¬ÓкܶàÐÐÊý×é¡£
ÏëÒªÒ»¸ö½Å±¾£¬¶ÁÈ¡ËùÓÐÐеÄÊý×éºóÊä³ö¡£
Êä³öǰ²»ÏÔʾÕý³£Ë³ÐòµÄ±í¸ñÊý×飬¶øÖ±½ÓÏÔʾ³ö¶ÁÈ¡ºóµÄÊý×é¡£
Â¥Ö÷µÄ±í´ïʵÔÚ³ÉÎÊÌ⣡£¡
ÊDz»ÊÇÕâ¸öÒâ˼£¿
<%
Dim ArrDNA£¨10£¬10£ ......