coping with empty excel cells in the xml document

[Wendy Spray]

Hi
I have an xml document that has been created from an excel spreadsheet. In
the s/s there are some empty cells however these are not captured in the xml
file. All that is added is for the cell after where the empty cell should
be, it has an extra attribute: "ss:Index="6", where it is the 6th cell in
the row, and cell 5 had no entry.

I'm wanting to pick out a particular cell from a particular column however
just iterating through the cells is going to give me invalid values where
there should have been empty cells.

Does anyone know how to handle this?

I've tried checking to see if there are attributes, and if there are if the
name is "ss:Index" and comparing the value of this attribute to a loop
counter i've created however this is very fiddly and long winded.

Thanks
Wend

[Daniel Sharp]

connect to excel by ado.net, then export to xml from dataset

regards
daniel #

"Wendy Spray" <sp*****@lincoln.ac.nz> wrote in message
news:%2****************@TK2MSFTNGP09.phx.gbl...

Hi
I have an xml document that has been created from an excel spreadsheet. In the s/s there are some empty cells however these are not captured in the xml file. All that is added is for the cell after where the empty cell should
be, it has an extra attribute: "ss:Index="6", where it is the 6th cell in
the row, and cell 5 had no entry.

I'm wanting to pick out a particular cell from a particular column however
just iterating through the cells is going to give me invalid values where
there should have been empty cells.

Does anyone know how to handle this?

I've tried checking to see if there are attributes, and if there are if the name is "ss:Index" and comparing the value of this attribute to a loop
counter i've created however this is very fiddly and long winded.

Thanks
Wend

[wenz]

Thanks Daniel.
I created the dataset and viewed it in a datagrid and all the null cells
were there fine.
I then saved it to xml using the WriteXml command. The resulting xml file
though doesn't have the extra empty nodes in it. All that is different is
the tags have changed from "Data" to the actual heading for the column.
Am I missing something or is this as good as it gets?

Wend

"Daniel Sharp" <da****@sharp.com> wrote in message
news:Ox**************@TK2MSFTNGP09.phx.gbl...

connect to excel by ado.net, then export to xml from dataset

regards
daniel #

"Wendy Spray" <sp*****@lincoln.ac.nz> wrote in message
news:%2****************@TK2MSFTNGP09.phx.gbl...

Hi
I have an xml document that has been created from an excel spreadsheet.

In

the s/s there are some empty cells however these are not captured in the

xml

file. All that is added is for the cell after where the empty cell should be, it has an extra attribute: "ss:Index="6", where it is the 6th cell in the row, and cell 5 had no entry.

I'm wanting to pick out a particular cell from a particular column however just iterating through the cells is going to give me invalid values where there should have been empty cells.

Does anyone know how to handle this?

I've tried checking to see if there are attributes, and if there are if

the

name is "ss:Index" and comparing the value of this attribute to a loop
counter i've created however this is very fiddly and long winded.

Thanks
Wend