// For complete examples and data files, please go to https://github.com/aspose-cells/Aspose.Cells-for-.NET // The path to the documents directory. string dataDir = RunExamples.GetDataDir(System.Reflection.MethodBase.GetCurrentMethod().DeclaringType); // Instantiate the workbook object Workbook workbook = new Workbook(dataDir + "book1.xls"); // Get Cells collection Cells cells = workbook.Worksheets[0].Cells; FindOptions opts = new FindOptions(); opts.LookInType = LookInType.Values; opts.LookAtType = LookAtType.EntireContent; // Find the cell with the input integer or double Cell cell1 = cells.Find(205, null, opts); if (cell1 != null) { Console.WriteLine("Name of the cell containing the value: " + cell1.Name); } else { Console.WriteLine("Record not found "); } // Find the cell with the input string Aspose.Cells.Cell cell2 = cells.Find("Items A", null, opts); if (cell2 != null) { Console.WriteLine("Name of the cell containing the value: " + cell2.Name); } else { Console.WriteLine("Record not found "); } // Find the cell containing with the input string opts.LookAtType = LookAtType.Contains; Cell cell3 = cells.Find("Data", null, opts); if (cell3 != null) { Console.WriteLine("Name of the cell containing the value: " + cell3.Name); } else { Console.WriteLine("Record not found "); }