hi guys,

I have built an rss ripper, the point is to bypass technology restrictions when exporting from sharepoint to excel 2003.

My problem i'm using the code below to output data in a nice html tabular format, however when trying to import into excel via web query i get no data returned, i think this is as it isn't real html, i've made a few alterations and am now getting account pulled back - how do i get it to pull all the data ?

code is as follows, also i've put a link at the bottom to w3 so you can get a good idea of the issue:

<%@ Language=VBScript %>
<html>
<head>
<script type="text/javascript" src="loadxmldoc.js"></script>
</head>

<body>
<script type="text/javascript">

function loadXMLDoc()
{
if (window.XMLHttpRequest)
{
xhttp=new XMLHttpRequest();
}
else
{
xhttp=new ActiveXObject("Microsoft.XMLHTTP");
}
xhttp.open("GET","my file path",false);
xhttp.send();
return xhttp.responseXML;
}

xmlDoc=loadXMLDoc("");
uppernum=(xmlDoc.getElementsByTagName( "title" ).length );
accstartnum=2
detstartnum=1
qlow = 0
qhi = 12
//document.write("<table border=1")
</script><table border = 1><tr><script>
z=xmlDoc.getElementsByTagName("description")[detstartnum]
</script><td>Account</td><script>
y=z.childNodes[0];
data_dump = (y.nodeValue);
data_dump = data_dump.replace(/<div><b>/g,"");
data_dump = data_dump.replace(/div>/g,"");
data_dump = data_dump.replace(/b>/g,"");
data_dump = data_dump.replace(/</g,"");
data_dump = data_dump.replace(/\n/g,"");
data_dump = data_dump.replace(/\//g,"");
data_array = data_dump.split(":");
array_pos = 0
while (array_pos < data_array.length)
{
if (array_pos%2)
{
document.write ("<td>" + data_array[array_pos] + "</td>");
array_pos+=1;
}
else
{
array_pos+=1;
}
}
document.write("</tr>")
while (accstartnum < uppernum)
{
document.write("<tr>")
x=xmlDoc.getElementsByTagName("title")[accstartnum]
y=x.childNodes[0];
acc = (y.nodeValue);
z=xmlDoc.getElementsByTagName("description")[detstartnum]
y=z.childNodes[0];
data_dump = (y.nodeValue);
data_dump = data_dump.replace(/<div><b>/g,"");
data_dump = data_dump.replace(/div>/g,"");
data_dump = data_dump.replace(/b>/g,"");
data_dump = data_dump.replace(/</g,"");
data_dump = data_dump.replace(/\n/g,"");
data_dump = data_dump.replace(/\//g,"");
data_array = data_dump.split(":");
array_pos = 1
document.write("<td>" + acc + "</td>")
while (array_pos < data_array.length)
{
if (array_pos%2)
{
array_pos+=1;
}
else
{
document.write ("<td>" + data_array[array_pos] + "</td>")
array_pos+=1;
}
}
accstartnum+=1;
detstartnum+=1;
document.write("</tr>")
}
</script></table><script>


//url = document.location.href;
//urll = url.split("?");
//if (urll.length == 0)
// {
// document.self.location.replace("http://midevsso.gcf-uk.gcf.capital.ge.com/Development/rssreader.asp?reload=1");
// }

</script>
</body>
</html>





if you have excel 2003 you can get an idea of the issue by trying to import the table here:
http://www.w3schools.com/XML/tryit.a..._display_table