1
Vote

Where not working for cells

description

I've been playing with this for a while and I cant seem to find any way to get the where to work on a cell.
 
Example:
Action method2 = () =>
        {
            using (XlsWorkbook book = new XlsWorkbook(fil))
            {
                using (XlsWorksheet sheet = book.Worksheets[0])
                {
                    var cells = from c in sheet.Cells
                                where c.Text != null
                                select c;
 
                    foreach(var cell in cells) Console.WriteLine(cell.Text);
                }
            }
        };
 
 
I've tried:
 
c.Row < 100
c.Column <20
c.Text.Contains("[some text]")
c.Text.equals("[some text]")
 
and other variations.

comments