Smrf.NodeXL.ExcelTemplate.DynamicFilterUtil.ColumnShouldBeExcluded C# (CSharp) Method

    ColumnShouldBeExcluded
    (
        ListColumn oColumn
    )
    {
        Debug.Assert(oColumn != null);

        switch (oColumn.Name)
        {
            case CommonTableColumnNames.ID:

                // It makes no sense to filter on the NodeXL-generated ID
                // column.

                return (true);

            default:

                break;
        }

        Range oColumnData = oColumn.DataBodyRange;

        // Exclude columns with no data or with an empty first data cell.

        if (
            oColumnData == null
            ||
            oColumnData.Rows.Count < 1
            ||
            !(oColumnData.Cells[1, 1] is Range)
            ||
            ( (Range)oColumnData.Cells[1, 1] ).get_Value(Missing.Value) == null
            )
        {
            return (true);
        }

        return (false);
    }