private static Range GetSpecialCells(Range selectedRange, XlCellType type) { try { return(selectedRange.SpecialCells(type)); } catch { return(null); } }
private static Range GetSpecialCells(Range selectedRange, XlCellType type) { try { return selectedRange.SpecialCells(type); } catch { return null; } }
public static bool SpecialCellsExists(ListObject table, XlCellType cellType) { try { long cnt = 0; cnt = table.DataBodyRange.SpecialCells(cellType).Rows.Row; return(true); } catch { return(false); } }
public Range SpecialCells(XlCellType Type, object Value) { throw new NotImplementedException(); }
/// <summary>返回一个 Range 对象,该对象代表与指定类型和值匹配的所有单元格。 /// </summary> /// <param name="Type">要包含的单元格。</param> /// <param name="Value">如果 Type 为 xlCellTypeConstants 或 xlCellTypeFormulas,则该参数可用于确定结果中应包含哪几类单元格。将这些值相加可使此方法返回多种类型的单元格。默认情况下,将选择所有常量或公式,无论类型如何。</param> public Range SpecialCells(XlCellType Type, object Value = null) { _objaParameters = new object[2] { Type, Value == null ? System.Type.Missing : Value }; return new Range(_objRange.GetType().InvokeMember("SpecialCells", BindingFlags.InvokeMethod, null, _objRange, _objaParameters)); }