This week's book giveaway is in the Agile and other Processes forum. We're giving away four copies of The Mikado Method and have Ola Ellnestam and Daniel Brolund on-line! See this thread for details.
I am trying to build a function that will take an HTML table on one page and open it in excel in a separate window. The problem I seem to be having is that when I open a new window using the document.open() method, it's seems to open it as a text/html stream. Here is the code I use. Each table has a unique ID. I get the HTML and try to open a new window. The new window still opens as HTML not in EXCEL. The kicker is that if I save the new window as HTML and then open it separately - it WILL open in excel!!! (Must use IE v5.01, and using Java Server Pages) If anyone can help it would be appreciated Troy
Code:
function getTabletoExcel(tableid) {
//find the table by the ID tmpobj=document.all[tableid];
//get the HTML strHtml=tmpobj.outerHTML;
//opens in separate window //still does not open as excel??? excelwindow = window.open("", "EXCEL"); // a window object excelwindow.document.open("application/vnd.ms-excel", "");
//try to set various content types - STILL does not work excelwindow.document.writeln('<%@ page contentType="application/vnd.ms-excel" %>'); excelwindow.document.writeln('<% response.setHeader("Content-Type","application/vnd.ms-excel");%>'); excelwindow.document.writeln('<% response.setContentType("application/vnd.ms-excel");%>');