problems with dataset writexml and Excel 2002

  • Thread starter Thread starter Bernie Yaeger
  • Start date Start date
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
 
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
 
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
 
Back
Top