ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   XML File Opened In Excel is Missing Header Row (https://www.excelbanter.com/excel-discussion-misc-queries/193894-xml-file-opened-excel-missing-header-row.html)

Shelly Noll

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?


All times are GMT +1. The time now is 02:40 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com