ExcelBanter - Build workbook by xml

ExcelBanter (https://www.excelbanter.com/)

- Excel Programming (https://www.excelbanter.com/excel-programming/)

- - Build workbook by xml (https://www.excelbanter.com/excel-programming/390244-build-workbook-xml.html)

nay

Build workbook by xml

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

[email protected][_2_]

Build workbook by xml

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

All times are GMT +1. The time now is 02:47 PM.