vsto获取excel 中特殊的单元格

    Range rngAll = worksheet.UsedRange.SpecialCells(XlCellType.xlCellTypeAllValidation);
                foreach (Range range in rngAll.Cells)
                {

}


#region 程序集 Microsoft.Office.Interop.Excel, Version=15.0.0.0, Culture=neutral, PublicKeyToken=71e9bce111e9429c
// C:\Program Files (x86)\Microsoft Visual Studio\Shared\Visual Studio Tools for Office\PIA\Office15\Microsoft.Office.Interop.Excel.dll
#endregion

namespace Microsoft.Office.Interop.Excel
{
    //
    // 摘要:
    //     Specifies the type of cells.
    public enum XlCellType
    {
        //
        // 摘要:
        //     Cells having the same validation criteria
        xlCellTypeSameValidation = -4175,
        //
        // 摘要:
        //     Cells having validation criteria
        xlCellTypeAllValidation = -4174,
        //
        // 摘要:
        //     Cells having the same format
        xlCellTypeSameFormatConditions = -4173,
        //
        // 摘要:
        //     Cells of any format
        xlCellTypeAllFormatConditions = -4172,
        //
        // 摘要:
        //     Cells containing notes
        xlCellTypeComments = -4144,
        //
        // 摘要:
        //     Cells containing formulas
        xlCellTypeFormulas = -4123,
        //
        // 摘要:
        //     Cells containing constants
        xlCellTypeConstants = 2,
        //
        // 摘要:
        //     Empty cells
        xlCellTypeBlanks = 4,
        //
        // 摘要:
        //     The last cell in the used range
        xlCellTypeLastCell = 11,
        //
        // 摘要:
        //     All visible cells
        xlCellTypeVisible = 12
    }
}