[XSL-LIST Mailing List Archive Home]
[By Thread]
[By Date]
[xsl] RE: Trouble with Excel spreadsheet using VB.NET to generate the XML
Subject: [xsl] RE: Trouble with Excel spreadsheet using VB.NET to generate the XML From: Tony Nassar <tnassar@xxxxxxxxxxxxxxxx> Date: Tue, 6 May 2008 13:05:05 -0700 |
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: [xsl] 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"
Current Thread |
---|
|
<- Previous | Index | Next -> |
---|---|---|
[xsl] Trouble with Excel spreadshee, Hewitt, Cheryl | Thread | [xsl] RE: Trouble with Excel spread, Hewitt, Cheryl |
Re: [xsl] function-available return, Michael Müller-Hille | Date | Re: [xsl] function-available return, Manfred Staudinger |
Month |
Keywords