ASP如何读取excel并列出内的内容

数据库用excelasp页面读取最好能给个实例谢谢！

2025-12-17 14:52:10

推荐回答（1个）

回答1：

<%
set xlApp = server.CreateObject("Excel.Application")
strsource = server.MapPath("xl.xls")
set xlbook = xlApp.WorkBooks.Open(strsource)
set xlsheet = xlbook.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 xlbook = nothing
xlApp.quit
'千万记住要加这一句，否则每运行一次你的机器里就增加一个Excel进程，而且无法释放
'set xlApp = nothing 是不行的
%>