Hello, how can I bind the Excel Worksheet As AxSpreadsheet Data Source?
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 ------------------------------------------------------- wrote in message news:81a2cc8f-dabc-4b71-9781-dcd72db312b5@w1g2000prd.googlegroups.com... > Hello, how can I bind the Excel Worksheet As AxSpreadsheet Data Source?
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:Database 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"
