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));
}
