score:0
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: http://msdn.microsoft.com/en-us/library/office/aa140066(v=office.10).aspx
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.
Source: stackoverflow.com
Related Query
- Reading values from xml file with Linq
- Reading XML file with Linq
- I need to save the XML file using linq with xml code in C#
- Reading from a XML file with LINQ
- Reading an XML File With Linq
- twice reading xml file with linq
- How to read XML file using System.IO.Stream with LINQ
- Reading an XML document with Linq
- Make file IO with LINQ more efficient with large numbers of small XML files?
- C# Reading XML with LINQ
- Query XML file with LINQ in C#
- C# Parsing simple XML file with LINQ
- Reading Xml file using LINQ in C#
- Trying to read xml file with LINQ
- reading CDATA with linq to xml
- Read last n elements of an XML file with Linq XDocument
- Cannot access to a specific block of XML file with Linq
- C# Reading and Summarizing Text File with LINQ
- Name cannot begin with the '1' character, hexadecimal value 0x31. while reading from an xml file
- How to Parse an XML file with Linq Lambda from Given Key
- Easy way to flatten XML file with LINQ
- Find object in XML file with LINQ
- Reading XML with XDocument and LINQ Descendant Confusion
- Parsing xml file with linq
- Reading a XML file using linq
- Reading a complex XML file using linq
- Reading Text file with Linq with 2 patterns
- Use for loop when writing a XML file with LINQ
- C# Reading multiple elements with same name using LINQ to XML
- NullReferenceException while saving XML File with Linq
More Query from same tag
- Dynamic XML Sorting using LINQ
- Where Clause and sending 2 unmatched params to a custom Method
- Returning subset of dictionary with a complex type as a key with Linq
- Converting nested loop to LINQ statement
- how to reach a class's property in LINQ
- SQL Server version of Oracle's CONNECT BY in LINQ to show hierachy
- How to find similar objects in a collection
- How to load left parts of Uris using Linq in c#
- How to build a filter with LINQ
- Check if string value is a word
- How can I calculate an integral?
- LINQ lookup if table column contains value and return list of objects
- Using LINQ to populate a collection from a property that has n elements
- NHibernate Linq where clause for 3 level tables
- c# linq search an EntityObject values from an IQueryable list
- Linq group by and count
- Code First CTP: Multiple PKs or FKs
- Need help using Linq to transform a list into a different list
- How to get list of keys in a dictionary with group by value with using LinQ
- Linq equivalent to ColumnName = @Param or @Param IS NULL
- Merge classes based on a property using Linq
- How to creat a new list from existing list with elements which contains the same id in Linq to object?
- NHibernate left join with linq
- Using LINQ to get a distinct list of Parameters from a list of objects
- Using Linq, how can I obtain a list of column names from a GridView? From a DataTable?
- Select node values and select the max value
- Is it possible to join an unrelated table in an EF Core Include query
- Get string representation of a Linq To Objects Query
- C# Data Transformation on Single Object
- TimeSpan difference between elements in List
