How come ?
 

Hi group,
I'm programming in VSTO but my questions have to do with Excel XML.
1. I would like to be able to import .xml into multiple tables on a
spreadsheet without having to create a list (I would rather create one XML
range or multiple XML ranges). The list function is nice but having to import
data into a list only actually detracts from the breadth of what xml could /
should be.

2. If the lists mentioned above do not contain data in all rows or only have
data for a few rows then the lists is truncated when I import the .xml data
back into that map. This is not how I intend to use my tables.

3. Not all my table have column headings. Why am I forced to have them. If
my table does not have them then headings are created anyway with 'Column1'
ect.

4. My tables have color formating - when I import .xml data back into a
table and only partial rows are filled then not only does the list truncate
but the color is lost.

I would really love to use XML. How can I overcome some of these
shortcomings??
Any suggestions?? I have only been researching Excel XML for a few days and
have read as much as I can find on the subject. Is there some information
that I am missing that would allow me to treat XML as any other kind of data
and be able to use it how I want??

Dave