Search Direction in Excel

Aspose.Cells Product Family
1

Hi,

Is there any directly based search funtionality in Aspose?
Ex: Previous or Next (Ms Excel)

-Balaji RJ

2

No. We will add the functionality in the future release.

3

@rjbalaji79,
Aspose.Excel is replaced by an advanced product Aspose.Cells that contains this feature. You can find or search data with a variety of options similar to MS Excel. Here is an example where FindOptions property SearchBackward is set to true to find data backward from the end.

// For complete examples and data files, please go to https://github.com/aspose-cells/Aspose.Cells-for-.NET
// Instantiate the workbook object
Workbook workbook = new Workbook();
Worksheet ws = workbook.Worksheets[0];
ws.Cells["A1"].PutValue("Data 1");
ws.Cells["A2"].PutValue("Data 4");
ws.Cells["A3"].PutValue("Data 3");
ws.Cells["A4"].PutValue("Data 4");
ws.Cells["A5"].PutValue("Data 5");
ws.Cells["A6"].PutValue("Data 6");

// Get Cells collection
Cells cells = workbook.Worksheets[0].Cells;
// Instantiate FindOptions Object
FindOptions findOptions = new FindOptions();
// Set searching properties
findOptions.SearchBackward = true;
findOptions.SeachOrderByRows = true;

// Set the lookintype, you may specify, values, formulas, comments etc.
findOptions.LookInType = LookInType.Values;

// Set the lookattype, you may specify Match entire content, endswith, starwith etc.
findOptions.LookAtType = LookAtType.EntireContent;

// Find the cell with value
Cell cell = cells.Find("Data 4", ws.Cells["A6"], findOptions);
if (cell != null)
{
Console.WriteLine("Name of the cell containing the value: " + cell.Name);
}
else
{
Console.WriteLine("Record not found ");
}

You can find more information about copying and moving worksheets here:
Find or Search Data

Download the latest trial version here:
Aspose.Cells for .NET (Latest Version)

Download a complete runnable solution here to test a variety of features of this product.