管理杂谈OA答疑ERP答疑教程搜索

asp读取excel中的数据



<%@language=vbscript %>
<%


set xlapp = server.createobject("excel.application")


strsource = "c:\excel\stock1.xls"
' 数据库位置
set xlstock = xlapp.workstocks.open(strsource)
set xlsheet = xlstock.worksheets(1)


i=1
response.write ""
while xlsheet.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
%>


更多精彩文章浏览...
点击右上角图标分享到朋友圈
官方网站:http://www.clicksun.cn
咨询热线:400-186-1886
服务邮箱:service@clicksun.cn