如何直接调用Excel数据?

发表于:2007-06-30来源:作者:点击数: 标签:
%@language= vb script % % Set exlApp = server.CreateObject(Excel.Application) strsource = e:\excel\sample.xls @# 数据库 位置 Set exlstock = exlApp.Workstocks.Open(strsource) Set exlsheet = exlstock.Worksheets(1) i=1 response.write table cel
<%@language=vbscript %>
<%
Set exlApp = server.CreateObject("Excel.Application")
strsource = "e:\excel\sample.xls"
@# 数据库位置
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
%>

原文转自:http://www.ltesting.net