ds.WriteXML

  • Thread starter Thread starter Richard Roche
  • Start date Start date
R

Richard Roche

Is there an easy way to avoid the '#agg' columns and
preserve the original column order when writing an XML
file?

ds.writexml("myFile.xml")

I want to import it into Excel and not have the extra #agg
columns and not have the columns sorted alphabetically.

Thanks for any assistance.

-Richard Roche
 
Hi Richard,

I'm currently working on this issue, and will update you as soon as I get
some progress.

Kevin Yu
=======
"This posting is provided "AS IS" with no warranties, and confers no
rights."

--------------------
| Content-Class: urn:content-classes:message
| From: "Richard Roche" <[email protected]>
| Sender: "Richard Roche" <[email protected]>
| Subject: ds.WriteXML
| Date: Mon, 6 Oct 2003 16:26:39 -0700
| Lines: 13
| Message-ID: <[email protected]>
| MIME-Version: 1.0
| Content-Type: text/plain;
| charset="iso-8859-1"
| Content-Transfer-Encoding: 7bit
| X-Newsreader: Microsoft CDO for Windows 2000
| Thread-Index: AcOMYUrlMr2ykWWOQ8yPenLC59nDJg==
| X-MimeOLE: Produced By Microsoft MimeOLE V5.50.4910.0300
| Newsgroups: microsoft.public.dotnet.framework.adonet
| Path: cpmsftngxa06.phx.gbl
| Xref: cpmsftngxa06.phx.gbl microsoft.public.dotnet.framework.adonet:62989
| NNTP-Posting-Host: TK2MSFTNGXA12 10.40.1.164
| X-Tomcat-NG: microsoft.public.dotnet.framework.adonet
|
| Is there an easy way to avoid the '#agg' columns and
| preserve the original column order when writing an XML
| file?
|
| ds.writexml("myFile.xml")
|
| I want to import it into Excel and not have the extra #agg
| columns and not have the columns sorted alphabetically.
|
| Thanks for any assistance.
|
| -Richard Roche
|
|
 
Hi Richard,

This behavior is done by Excel 2002. Because Excel 2002 partially supports
XML, when opening an XML file with Excel 2002, it will be opened as a
Read-Only WorkSheet. Then some #agg columns are added and columns are
sorted alphabetically.

However, in Excel 2003, it will let you choose whether to open it as a
Read-Only WorkSheet or as an XML list. So these two problems can be avoided
in Excel 2003.

Kevin Yu
=======
"This posting is provided "AS IS" with no warranties, and confers no
rights."

--------------------
| Content-Class: urn:content-classes:message
| From: "Richard Roche" <[email protected]>
| Sender: "Richard Roche" <[email protected]>
| Subject: ds.WriteXML
| Date: Mon, 6 Oct 2003 16:26:39 -0700
| Lines: 13
| Message-ID: <[email protected]>
| MIME-Version: 1.0
| Content-Type: text/plain;
| charset="iso-8859-1"
| Content-Transfer-Encoding: 7bit
| X-Newsreader: Microsoft CDO for Windows 2000
| Thread-Index: AcOMYUrlMr2ykWWOQ8yPenLC59nDJg==
| X-MimeOLE: Produced By Microsoft MimeOLE V5.50.4910.0300
| Newsgroups: microsoft.public.dotnet.framework.adonet
| Path: cpmsftngxa06.phx.gbl
| Xref: cpmsftngxa06.phx.gbl microsoft.public.dotnet.framework.adonet:62989
| NNTP-Posting-Host: TK2MSFTNGXA12 10.40.1.164
| X-Tomcat-NG: microsoft.public.dotnet.framework.adonet
|
| Is there an easy way to avoid the '#agg' columns and
| preserve the original column order when writing an XML
| file?
|
| ds.writexml("myFile.xml")
|
| I want to import it into Excel and not have the extra #agg
| columns and not have the columns sorted alphabetically.
|
| Thanks for any assistance.
|
| -Richard Roche
|
|
 
any suggestions on work arounds?

Is there an easy way to make a CSV file?

I want a portable file that could be used by many users
(some of which are Excel).

moving the enterprise to Excel 2003 won't happen over
night.

Thanks for any help.
 
Hi Richard,

I'm afraid that there doesn't seem to be a workaround as Excel 2002 only
partially supports XML. Maybe you can open the XML file in Excel, make some
modification and save it as an xls file. Then distribute it.

Or you can try to post your question under microsoft.public.excel, there
might be some professionals on Excel who might be more helpful.

Kevin Yu
=======
"This posting is provided "AS IS" with no warranties, and confers no
rights."

--------------------
| Content-Class: urn:content-classes:message
| From: "Richard Roche" <[email protected]>
| Sender: "Richard Roche" <[email protected]>
| References: <[email protected]>
<[email protected]>
| Subject: RE: ds.WriteXML
| Date: Tue, 14 Oct 2003 17:19:24 -0700
| Lines: 12
| Message-ID: <[email protected]>
| MIME-Version: 1.0
| Content-Type: text/plain;
| charset="iso-8859-1"
| Content-Transfer-Encoding: 7bit
| X-Newsreader: Microsoft CDO for Windows 2000
| X-MimeOLE: Produced By Microsoft MimeOLE V5.50.4910.0300
| Thread-Index: AcOSsf0YPH4kP2otQ7SCiZIJoNlNdA==
| Newsgroups: microsoft.public.dotnet.framework.adonet
| Path: cpmsftngxa06.phx.gbl
| Xref: cpmsftngxa06.phx.gbl microsoft.public.dotnet.framework.adonet:63662
| NNTP-Posting-Host: TK2MSFTNGXA14 10.40.1.166
| X-Tomcat-NG: microsoft.public.dotnet.framework.adonet
|
| any suggestions on work arounds?
|
| Is there an easy way to make a CSV file?
|
| I want a portable file that could be used by many users
| (some of which are Excel).
|
| moving the enterprise to Excel 2003 won't happen over
| night.
|
| Thanks for any help.
|
|
 
Back
Top