繁体中文
设为首页
加入收藏
当前位置:ASP技术首页 >> ASP基础 >> 如何直接调用Excel数据?

如何直接调用Excel数据?

2006-07-15 08:00:00  作者:  来源:互联网  浏览次数:0  文字大小:【】【】【
简介:
关键字:直接 数据 如何 Excel

<%@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 ""

while exlsheet.cells(i,1)<>""

response.write "

"

response.write "

"

response.write "

"

response.write "

"

response.write "

"

i=i+1

wend

response.write "

" & xlsheet.Cells(i, 1) & " " & xlsheet.Cells(i, 2) & " " & xlsheet.Cells(i, 3) & "
"

set xlsheet=nothing

set xlstock=nothing

xlApp.quit

%>

责任编辑:admin
相关文章