XML to Array

[Antoine]

Dear all,

 

I couldn't find anything with the search option on this site with XML. So I am asking it again, so please don't fire me if it is allready posted okay ? :)

 

We (me and my collegue) have a problem. Since Excel is one hell of a disaster to deploy to other programs. We want to use XML sheets. Since in Excel you can export them to XML format.

 

But what is an easy way to read 4 worksheets. In 4 different array's ?

 

With excel we used the direct cast option:

xlsBook = xlsApp.Workbooks.Open(FilePath & "ConfigFile.xls")
Dim xlsSheet As Excel.Worksheet = xlsBook.Worksheets("Graphics_IDList")
xlsRng = xlsSheet.Range(xlsSheet.UsedRange.Columns.Address)
BMSArray = DirectCast(xlsRng.Value, Object(,))

 

Is something like this also possible with XML ? Or does anybody know a better or other solution ?

 

Thanks in advance !

Regards,

Antoine

 

[edit]

I'm working with VB.NET 2003

[/edit]

Edited January 24, 2005 by Antoine