"Wendy Spray" <sprayw2@lincoln.ac.nz> wrote in message
news:%23rNzjZbpEHA.2636@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
>
>
>

"Daniel Sharp" <daniel@sharp.com> wrote in message
news:OxDdGQdpEHA.1272@TK2MSFTNGP09.phx.gbl...
> connect to excel by ado.net, then export to xml from dataset
>
> regards
> daniel #
>
> "Wendy Spray" <sprayw2@lincoln.ac.nz> wrote in message
> news:%23rNzjZbpEHA.2636@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
> >
> >
> >
>
>