Build workbook by xml

[Nay]

Hi
I had a legacy component that was created in vb6.0 and built an excel 2003
workbook by by xml document with that comply the excel 2003 schma.

I upgraded it with th VS2005 wizard to vb.net(so It uses the interop of
DomDocument and not system.xml classes)
The problem is that now white spaces are not preserved(eventhogh I set it
explicitlly), and excel can not handle long xml lines

Thanks, Nay

 

[gimme_this_gimme_that]

Put the long lines in CDATA brackets and see if that helps