Hi,
I have managed to sort out a lot that I asked about in my last post.
What I am now trying to do, I just read the first row, column 1 to 9, define that each of these cells contain specific data. After this I am then trying to class these particular cells as headers, then when I move on to look through more rows, If they don't contain this specific data, but still contain a value then still read it but it returns not as a header. By doing this I am using it to define if the cells contain either a header or another value. Hope this makes sense.
The code I have come up with is simple but I don't know how to go around to define if its a header or not.
I have managed to sort out a lot that I asked about in my last post.
What I am now trying to do, I just read the first row, column 1 to 9, define that each of these cells contain specific data. After this I am then trying to class these particular cells as headers, then when I move on to look through more rows, If they don't contain this specific data, but still contain a value then still read it but it returns not as a header. By doing this I am using it to define if the cells contain either a header or another value. Hope this makes sense.
The code I have come up with is simple but I don't know how to go around to define if its a header or not.
C#:
If (!string.IsNullOrEmtpy(colValue))
isBlankRow = false;
If (!IsHeadingValue(colValue))
isHeadingRow = false;