It looks to me like you're making it way more complex than it needs to be. I have recently worked on a project that required users to copy data from excel that is being read as a XML spreadsheet via the clipboard, that is then sent through a parser and transformed into a tabular format.

I found the XML Spreadsheet Reference invaluable:

One thing you should be aware of and that I think is the cause of your problems is that the ss:Index isn't zero based (Column 1 = Index 1).

It should really be as simple as looping over the rows and then their cells and keeping track of a cells' index. You might also want to check whether the required cell does have a child data element.

More Query from same tag