Find Specific Word Occurrence

VSTO Excel

Excel.Application excelApp = Application;

//Specify the template Excel file path.

string myPath = "List All Worksheets in a Workbook.xls";

//Open the Excel file.

Microsoft.Office.Interop.Excel.Workbook ThisWorkbook = excelApp.Workbooks.Open(myPath, Missing.Value, Missing.Value,
      Missing.Value, Missing.Value,
      Missing.Value, Missing.Value,
      Missing.Value, Missing.Value,
      Missing.Value, Missing.Value,
      Missing.Value, Missing.Value,
      Missing.Value, Missing.Value);

Excel.Worksheet Worksheet = ThisWorkbook.Worksheets["Sheet1"];

findNow(Worksheet, "test");

//Save the file.

excelApp.ActiveWorkbook.Save();

excelApp.Quit();

Aspose.Cells

static void Main(string[] args)
{
    //Instantiate a new Workbook.
    Workbook workbook = new Workbook();

    //Specify the template Excel file path.
    string myPath = "Book1.xls";

    //Open the Excel file.
    workbook.Open(myPath);

    //Get the first sheet.
    Aspose.Cells.Worksheet objSheet = workbook.Worksheets["Sheet1"];

    findNow(objSheet, "test");

    workbook.Save(myPath);
}

private static void findNow(Worksheet objSheet, string textToFind)
{
    //Get the Cells collection
    Cells cells = objSheet.Cells;

    //Instantiate FindOptions object
    FindOptions findOptions = new FindOptions();

    //Create a cell area
    CellArea ca = new CellArea();
    ca.StartRow = 8;
    ca.StartColumn = 2;
    ca.EndRow = 17;
    ca.EndColumn = 13;

    //Set cells area for find options
    findOptions.SetRange(ca);

    //Set searching properties
    findOptions.SearchNext = true;
    findOptions.SearchOrderByRows = true;
    findOptions.LookInType = LookInType.Values;

    //Find the cell with the specified value
    Cell cell = cells.Find(textToFind, null, findOptions);
    Console.WriteLine(cell.StringValue);
}

Download Sample Code

• Github
• Sourceforge
• Bitbucket