[XSL-LIST Mailing List Archive Home] [By Thread] [By Date] [Recent Entries] [Reply To This Message] RE: Trouble with Excel spreadsheet using VB.NET to ge
Cheryl, did anyone respond to your query? If this is .NET, you may have to simply take a few more steps. Explicitly create an XmlWriter with an XmlWriterSettings object (http://msdn.microsoft.com/en-us/library/system.xml.xmlwritersettings_members (VS.80).aspx), and make sure that the OmitXmlDeclaration property is set to false. It's not clear to me how much control you have over the XML generation; I hope you have complete control. If so, please investigate XmlTextWriter.WriteProcessingInstruction Method (http://msdn.microsoft.com/en-us/library/system.xml.xmltextwriter.writeproces singinstruction(VS.80).aspx). Sorry about the broken URLs... -----Original Message----- From: Hewitt, Cheryl [mailto:Cheryl.Hewitt@xxxxxxxxxxxxxxxxxxx] Sent: Thursday, May 01, 2008 4:34 PM To: xsl-list@xxxxxxxxxxxxxxxxxxxxxx Subject: Trouble with Excel spreadsheet using VB.NET to generate the XML I trying to create an Excel spreadsheet using VB.NET to generate the XML. The application queries a SQL database dependent on user selections via a form with the results being output to Excel. The issue I am having is that the generated xml does not have the following code at the top: <?xml version="1.0"?> <?mso-application progid="Excel.Sheet"?> This is the generated xml I am getting: <Workbook xmlns:msxsl="urn:schemas-microsoft-com:xslt"
|
PURCHASE STYLUS STUDIO ONLINE TODAY!Purchasing Stylus Studio from our online shop is Easy, Secure and Value Priced! Download The World's Best XML IDE!Accelerate XML development with our award-winning XML IDE - Download a free trial today! Subscribe in XML format
|