Read an Excel file, then transform it into an HTML form

xiaoxiao2021-03-06  66

<%

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 "

" While Xlsheet.cells (i, 1) <> ""

Response.write "

" response.write "
" & xlsheet.cells (i, 1) & "" response.write "& xlsheet.cells (i, 2) &" "response.write" "& xlsheet.cells (i, 3) & "" response.write "" i = i 1

Wend response.write "" set xlsheet = Nothing set xlbook = nothing xlapp.quit%>

转载请注明原文地址:https://www.9cbs.com/read-111099.html

New Post(0)
CopyRight © 2020 All Rights Reserved
Processed: 0.042, SQL: 9