Question

ASP如何读取EXCEL指定单元格的数据

最好有代码，额

Answer 1

读取整个EXCEL可以，单个的单元格... 关注！

Answer 2

'读取x行y列
set Conn=Server.CreateObject("ADODB.Connection")
set rs=Server.CreateObject("ADODB.Recordset")

strConn="Provider=Microsoft.Jet.OLEDB.4.0;Data Source="+Server.MapPath("1.xls")+";Extended Properties='Excel 8.0;HDR=no;IMEX=1'"
Conn.Open strConn
sql="SELECT * FROM [data$]"
rs.Open sql,Conn,1,1
if not rs.eof then
rs.move x
response.Write rs(y-1)
end if
rs.Close
Conn.Close
set rs = Nothing
set Conn = Nothing