Sorry if this is in the wrong forum I wasn't sure which section to put this Q in.<br />
I s it possiblew to produce an excel workbook as a webpage/site?<!--content-->well kind of. you can save it as an html page an dit will write all the html for you as the page looks. I don't recommend this as it will write some crappy code and you just have to edit it when you done. other than that you can't load it into a webpage with just regular html, you have to use some form of serverside language like php or ASP<!--content-->It depends what you want to do, Lucy.<br />
You can save a spreadsheet as HTML in Excel.<br />
You can open an Excel spreadsheet from Internet Explorer:<br />
<br />
window.objXL = new ActiveXObject("Excel.Application");<br />
objXL.Visible = true;<br />
window.objXL.Workbooks.Open("http://someplace.com/sample.XLS")<br />
var cell32 = window.objXL.Cells(3,2).Value;<br />
alert("cell[3,2] = " + cell32)<br />
<br />
<br />
There are also new things for Internet Explorer called Office Web Components, which can embed an excel spreadsheet into an HTML page, provided the client PC is running Microsoft Office.<br />
<!-- m --><a class="postlink" href="http://www.4guysfromrolla.com/webtech/022801-1.shtml">http://www.4guysfromrolla.com/webtech/022801-1.shtml</a><!-- m --><!--content-->
I s it possiblew to produce an excel workbook as a webpage/site?<!--content-->well kind of. you can save it as an html page an dit will write all the html for you as the page looks. I don't recommend this as it will write some crappy code and you just have to edit it when you done. other than that you can't load it into a webpage with just regular html, you have to use some form of serverside language like php or ASP<!--content-->It depends what you want to do, Lucy.<br />
You can save a spreadsheet as HTML in Excel.<br />
You can open an Excel spreadsheet from Internet Explorer:<br />
<br />
window.objXL = new ActiveXObject("Excel.Application");<br />
objXL.Visible = true;<br />
window.objXL.Workbooks.Open("http://someplace.com/sample.XLS")<br />
var cell32 = window.objXL.Cells(3,2).Value;<br />
alert("cell[3,2] = " + cell32)<br />
<br />
<br />
There are also new things for Internet Explorer called Office Web Components, which can embed an excel spreadsheet into an HTML page, provided the client PC is running Microsoft Office.<br />
<!-- m --><a class="postlink" href="http://www.4guysfromrolla.com/webtech/022801-1.shtml">http://www.4guysfromrolla.com/webtech/022801-1.shtml</a><!-- m --><!--content-->