Aspose Cells for Java. Performance comparision: Filter vs Sort

Aspose.Cells Product Family
1

I have an excel sheet with a column which contains TRUE or FALSE as values in 1 of the columns.
I need only the rows with FALSE.

So instead of traversing the whole sheet, I can either filter on that column where value=FALSE, or I can sort that column in Ascending order so that the FALSE value rows come first.

What I am confused is, in Aspose Cells for Java, which method is less time consuming, filter or sort?

Since my data is huge, I need to select the approach which takes lesser time.

2

@sandipanghosh111,

You can use any of the approaches as both of these are efficient. However, data filtering approach should be little better as it includes less number of comparisons as compared to sorting method. You can further verify the faster approach by checking, with Java code, the number of seconds consumed while processing your template file. If you find performance issues with any approach then let us know with sample code and template file and we will check it on our end.