Hello,
AutoFilter autoFilter = worksheet.AutoFilter;autoFilter.Range = “E2:E” + worksheet.Cells.MaxDataRow;
autoFilter.AddFilter(0, “”);
Hello,
AutoFilter autoFilter = worksheet.AutoFilter;autoFilter.Range = “E2:E” + worksheet.Cells.MaxDataRow;
autoFilter.AddFilter(0, “”);
Hi,
Thank you!
Perhaps I should be more clear on what I am trying to accomplish.
Hi,
I have attached a sample Excel file that was built from my previous process, which used Excel Interop. I have removed any sensitive data, and have removed a lot of the rows to make it easier for you to look at.
//Apply VLOOKUP for blank Common NamesExcel.Range range = worksheet.UsedRange;
range.AutoFilter(5, “=”, Excel.XlAutoFilterOperator.xlAnd, Type.Missing, true);Excel.Range filteredRange = range.SpecialCells(Excel.XlCellType.xlCellTypeVisible);
//Iterate the rows in the filtered range
foreach (Excel.Range row in filteredRange.Rows)
{
if (row.Cells[5].Value == “”)
row.Cells[5].FormulaR1C1 = “=VLOOKUP(RC[15],‘Common Name For IT’!C[-3]:C[-1],3,FALSE)”;
}//Clear AutoFilter on the Common Name field
range.AutoFilter(5);
Hi,
Excellent, thank you very much, this method worked for me!
Hi,