Excel sheets saved as XML files that can be read by .NET

  • Thread starter Thread starter nabil Elibiary
  • Start date Start date
N

nabil Elibiary

I tried sheets sved by Excel 2002 (XP) but the schema is
not acceptable by .Net.
If I use ReadXML(FilePath, ignorSchema or AUTO, it fails
to read the Excel XML file into the dataset.
Do you have any suggestions, and is Excel 2003 address
this issue?
 
Nabil said:
I tried sheets sved by Excel 2002 (XP) but the schema is
not acceptable by .Net.
If I use ReadXML(FilePath, ignorSchema or AUTO, it fails
to read the Excel XML file into the dataset.
Do you have any suggestions, and is Excel 2003 address
this issue?
Click to expand...

When you save a workbook in XML format you are saving almost all the
information about the workbook, including names, styles, numberformats,
alignment, colour, ...

Excel 2003 Professional does provide the ability to just save nomimated
data in XML format. It is probably what you are looking for.

Bill Manville
MVP - Microsoft Excel, Oxford, England
No email replies please - reply in newsgroup
 
Back
Top