loop through nested datagrid export to excel

[ehaze]

I have a datagrid that is setup like this:

Header row

row

row

New Table

row

row

row

Basically a datagrid with parent a child relationship. I can export the primary table, but the nested child table is inserted into a single cell in Excel. How would you export the datagrid and maintain the correct layout?

My failed attempt:

<script type="text/javascript">
      function NewTime() {
        // Get the Query String values and split them out into the vals array
        var vals = new Object();
        var qs = location.search.substring(1, location.search.length);
        var args = qs.split("&");
        for (var i=0; i < args.length; i++) {
            var nameVal = args[i].split("=");
            var temp = unescape(nameVal[1]).split('+');
            nameVal[1] = temp.join(' ');
            vals[nameVal[0]] = nameVal[1];
        }
        var issueID = vals["ID"];
        //use this to bring up the pretty pop up
        NewItem2(event,"[URL unfurl="true"]http://sharepointed.com/Lists/ListNotes/NewForm.aspx?AccNum="[/URL] + issueID);
    }
</script>

http://www.sharepointed.com/

 

[ggriffit]

have you looked at [URL unfurl="true"]http://www.greggriffiths.org/webdev/both/excel/[/url] which covers a few options to use Javascript and ActiveX options among others.

Greg Griffiths
Livelink Certified Developer & ECM Global Star Champion 2005 & 2006

http://www.greggriffiths.org/livelink/