[XSL-LIST Mailing List Archive Home] [By Thread] [By Date] [Recent Entries] [Reply To This Message]

Programatically Generate Well-Formed XML with .NET

Subject: Programatically Generate Well-Formed XML with .NET
From: "Ronnie Royston" <rhroyston@xxxxxxxxx>
Date: Fri, 27 Jun 2008 11:21:54 -0500
 Programatically Generate Well-Formed XML with .NET
I hope this isn't too far off topic...

I'm using VBA to write a file with a .xml extension on to my
harddrive.  Basically, I'm using the Range.Text method in Excel VBA as
the selector and a stream output method to write out a text file.  The
problem is that it is not consistently writing well-formed XML.  After
running my crummy program, a browser often chokes on the result with

"Whitespace is not allowed at this location. Error processing resource
'file:///C:/Saxon/bin/mySkus.xml'. Line 58, Position..."

here is a copy/paste of my line 58.
<sku quantity="1" description="XMediusFAX Express Server 50 Users & 2
Channels *Server Supplied by Benchmark">XM-EXP-50</sku>

I don't see anything wrong with it?  I've tried using VBA's
StrConv(string, conversion) where the conversion is set to VBUnicode
but that just adds spaces to all my text and makes matters worse.

Is there a way to ensure that my xmlWriter subroutine creates
well-formed XML?  Maybe I should be using something from the MSXML
library instead?

Thank you.

- Ronnie Royston

Current Thread

PURCHASE STYLUS STUDIO ONLINE TODAY!

Purchasing Stylus Studio from our online shop is Easy, Secure and Value Priced!

Buy Stylus Studio Now

Download The World's Best XML IDE!

Accelerate XML development with our award-winning XML IDE - Download a free trial today!

Don't miss another message! Subscribe to this list today.
Email
First Name
Last Name
Company
Subscribe in XML format
RSS 2.0
Atom 0.3
Site Map | Privacy Policy | Terms of Use | Trademarks
Free Stylus Studio XML Training:
W3C Member
Stylus Studio® and DataDirect XQuery ™are products from DataDirect Technologies, is a registered trademark of Progress Software Corporation, in the U.S. and other countries. © 2004-2013 All Rights Reserved.