View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Rico Rico is offline
external usenet poster
 
Posts: 4
Default Excel rejects XSD from Visual Studio DataSet Designer

Excel 2003 & 2007, Visual Studio Team System 2008 SP1

Excel is supposed to be able to read XSD files and if the user maps the XSD
to a workbook they should be able to read and write XML data as defined by
the XSD.

Visual Studio has a DSL called the DataSet designer which creates XSD files
along with strongly typed classes to represent them.

Make a simple table in the Dataset Designer that contains one column, Excel
can read the XSD (and data in XML file) but it can not export the data.

How do I get data conforming to my XSD in and out of Excel, I have posted
this question to several groups without a reply.

Thank you.