如何直接調(diào)用Excel數(shù)據(jù)？
發(fā)表時(shí)間：2024-01-26 來(lái)源：明輝站整理相關(guān)軟件相關(guān)文章人氣：
[摘要]<%@language=vbscript %> <% Set exlApp = server.CreateObject("Excel.Application") strsource = "e:\excel\sample.xls" '...
<%@language=vbscript %>
<%
Set exlApp = server.CreateObject("Excel.Application")
strsource = "e:\excel\sample.xls"
' 數(shù)據(jù)庫(kù)位置
Set exlstock = exlApp.Workstocks.Open(strsource)
Set exlsheet = exlstock.Worksheets(1)
i=1
response.write "<table cellpadding=0 cellspacing=0 border=1 width=500>"
while exlsheet.cells(i,1)<>""
response.write "<tr>"
response.write " <td height=20 align=center width=100>" & xlsheet.Cells(i, 1) & "</td>"
response.write " <td height=20 align=center width=200>" & xlsheet.Cells(i, 2) & "</td>"
response.write " <td height=20 align=center width=200>" & xlsheet.Cells(i, 3) & "</td>"
response.write "</tr>"
i=i+1
wend
response.write "</table>"
set xlsheet=nothing
set xlstock=nothing
xlApp.quit
%>
