CSDN博客

img aspczlover

读取一个EXCEL的文件,然后将其转化成HTML的表格

发表于2004/10/2 4:57:00  589人阅读

<%

Set xlApp = server.CreateObject("Excel.Application")

strsource = "c:/test.xls"

Set xlbook = xlApp.Workbooks.Open(strsource)
Set xlsheet = xlbook.Worksheets(1)

i=1
response.write "<table cellpadding=0 cellspacing=0 border=1 width=500>"
while xlsheet.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 xlbook=nothing
xlApp.quit %>

阅读全文
0 0

相关文章推荐

img
取 消
img