problems with dataset writexml and Excel 2002

B

Bernie Yaeger

I'm trying to use dataset.writexml in order to be able to open the results
quickly and efficiently in Excel (Excel 2002). While the output .xml file
appears ok, it does a few crazy things inside Excel:
1. there is an extra column when there is a numeric column. For example, I
have a rowid column and it appears, but so does a 'rowid/agg' column
2. the file is readonly in Excel

Are these problems a writexml problem or an Excel problem? Any ideas how to
overcome this?

Thanks for any help.

Bernie Yaeger
 
C

Cor

Hi Bernie,

Why not (open) the xml file in your IDE, than you can examine what it has
made.
(It has two views an XML view and a table view)

Cor
 
B

Bernie Yaeger

Hi Cor,

I have looked at the created file - xmlwrite creates a perfectly formed .xml
file.

I have opened other .xml files in Excel - they all open the same way - the
problem is clearly with Excel 2002, not vb .net.

Thanks for your help, as always,

Bernie
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

using writexml in vb .net and numeric columns in excel 4
dataset WriteXML question 1
DataSet WriteXML and XMLValidatingReader 3
WriteXML and xmlns attribute 4
serialize DataSet and use WriteXml 0
Problem with WriteXml in DataSet 3
Howto specify which DataTables of a DataSet will be stored with WriteXml? 3
Problems with DATASET.WriteXml: I get two files (XML and XSD) 3

Top