Velocity Reviews - Computer Hardware Reviews

Velocity Reviews > Newsgroups > Programming > XML > Open XML in excel problem

Reply
Thread Tools

Open XML in excel problem

 
 
dermot_o_loughlin@yahoo.com
Guest
Posts: n/a
 
      06-09-2005
Hi all,

I have a problem opening xml in excel. If there are 2 or more rows in
the xml document it opens up fine in excel and shows headers. If there
is only 1 row in the xml document the headers do not get shown. Here is
some example xml:

1 Row
=====

<?xml version="1.0" standalone="yes"?>
<NewDataSet>
<Table>
<PropertyOwner_Id>232</PropertyOwner_Id>
<Propertyowner_MaritalStatus>Not
Known</Propertyowner_MaritalStatus>
<Propertyowner_FolioNumbers />
</Table>
</NewDataSet>

2 Rows
======

<?xml version="1.0" standalone="yes"?>
<NewDataSet>
<Table>
<PropertyOwner_Id>317</PropertyOwner_Id>
<Propertyowner_MaritalStatus>Not
Known</Propertyowner_MaritalStatus>
<Propertyowner_FolioNumbers />
</Table>
<Table>
<PropertyOwner_Id>318</PropertyOwner_Id>
<Propertyowner_MaritalStatus>Not
Known</Propertyowner_MaritalStatus>
<Propertyowner_FolioNumbers />
</Table>
</NewDataSet>

Any Ideas,
Dermot.

 
Reply With Quote
 
 
 
Reply

Thread Tools

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are Off


Similar Threads
Thread Thread Starter Forum Replies Last Post
Not able to display color in excel not able to display color in excel using xml sed_y XML 0 02-15-2012 09:46 PM
Re: Open an Excel File in Excel, not HTML viza HTML 0 07-07-2008 11:04 PM
Problem with Excel reports ::::Excel 2003 Migration To Excel 2007 =?Utf-8?B?c2hhc2hhbmsga3Vsa2Fybmk=?= ASP .Net 15 10-24-2007 01:34 PM
Different results parsing a XML file with XML::Simple (XML::Sax vs. XML::Parser) Erik Wasser Perl Misc 5 03-05-2006 10:09 PM
Excel open automatically without giving a dialog box option to Open/Save/Cancel using filesys.create eddie wang ASP General 0 10-03-2003 04:05 PM



Advertisments