A
adamryanlee
Hello, how can I bind the Excel Worksheet As AxSpreadsheet Data Source?
A
Alvin Bruney [ASP.NET MVP]
The two cannot mix, what are you trying to do functionally?
--
Regards,
Alvin Bruney [MVP ASP.NET]
[Shameless Author plug]
The O.W.C. Black Book, 2nd Edition
Exclusively on www.lulu.com/owc $19.99
--
Regards,
Alvin Bruney [MVP ASP.NET]
[Shameless Author plug]
The O.W.C. Black Book, 2nd Edition
Exclusively on www.lulu.com/owc $19.99
J
jtz
if you develop with asp,you can extract the data from worksheet and content
the data in a table,then use spreadsheet's htmlURL attribute get the data.
first,in the data.asp,write code as
conn="Provider=Microsoft.Jet.OLEDB.4.0;Jet OLEDB
atabase Password=;Extended
properties=Excel 8.0;Data Source="&server.mappath(worksheetPath)
set rs=server.createobject("adodb.recordset")
rs.open "select * from tablename",conn,0,1
response.write("<table>")
while not rs.eof
response.write("<tr><td>"&rs(field1)&"</td>><td>"&rs(field2)&"</td></tr>")
rs.movenext
wend
response.write("</table>")
then in the output.htm,use HtmlURL to get the data .
spreadsheet1.htmlURL="data.asp"
the data in a table,then use spreadsheet's htmlURL attribute get the data.
first,in the data.asp,write code as
conn="Provider=Microsoft.Jet.OLEDB.4.0;Jet OLEDB
atabase Password=;Extendedproperties=Excel 8.0;Data Source="&server.mappath(worksheetPath)
set rs=server.createobject("adodb.recordset")
rs.open "select * from tablename",conn,0,1
response.write("<table>")
while not rs.eof
response.write("<tr><td>"&rs(field1)&"</td>><td>"&rs(field2)&"</td></tr>")
rs.movenext
wend
response.write("</table>")
then in the output.htm,use HtmlURL to get the data .
spreadsheet1.htmlURL="data.asp"