Wiki

Clone wiki

Aspose for VSTO / 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 Cells collection 
            Cells cells = objSheet.Cells;

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

            //Create a Cells 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.SeachOrderByRows = true;

            findOptions.LookInType = LookInType.Values;

            //Find the cell with 0 value
            Cell cell = cells.Find(textToFind, null, findOptions);

            Console.WriteLine(cell.StringValue);
        }

Download

Updated