View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Shelly Noll Shelly Noll is offline
external usenet poster
 
Posts: 1
Default XML File Opened In Excel is Missing Header Row

I have a vb.net console app that creates an XML file with a corresponding
XSD. My users open the file in Excel 2007 or Excel 2003. If the XML file
only has 1 record, the header row does not appear in the spreadsheet. When I
have more than one record, the spreadsheet is perfect. Is there some way to
configure the XSD or XML file to force Excel to show the header row?