关于excel外接里range.find方法的使用
因为要做个校验,不符合条件的自动填充为橙红色
rowRange.FormatConditions.Add(Excel.XlFormatConditionType.xlExpression, Type.Missing, nnn);
rowRange.FormatConditions[1].Interior.Color = Color.OrangeRed;
rowRange.FormatConditions[1].StopIfTrue = false;
然后用range.find查找
workSheet.Application.FindFormat.Interior.Color = Color.OrangeRed;
Excel.Range r_cell = workSheet.Cells[3, 1];
r_cell.Select();
workSheet.ListObjects[1].AutoFilter.ShowAllData();
Excel.Range find_range = range.Find("", r_cell, Type.Missing, Excel.XlLookAt.xlPart, Excel.XlSearchOrder.xlByRows, Excel.XlSearchDirection.xlNext, Type.Missing, Type.Missing, true);
然后程序填充颜色的单元格是找不到的,但是手动在excel表里填充颜色的单元格可以找到,求大神解惑