<st@jpa.co.jp> wrote in message
news:1128590688.362457.48470@g49g2000cwa.googlegroups.com...
> Hi,
>
> I've a routine that exports a DB query to Excel by building an
> XmlDocument and saving to a XmlTextWriter.
>
> The function works but new lines don't show up, i.e. significant
> whitespace is cut. I've tried adding WriteAttributeString("xml",
> "space", null, "preserve") to the XmlTextWriter just prior to save, but
> that results in the error: "Index was outside the bounds of the array."
>
> Can anyone assist?
>
> Many thanks,
>
> Simon Lane
>