We're sorry Aspose doesn't work properply without JavaScript enabled.

Free Support Forum - aspose.com

Filtering rows using Data Validation


I attached sample sheet.

My requirement is when I select any value, the corresponding row of that value should be visible

or shown .

Please suggest if it is possible in excel and please provide the sample code.


Hi Jack,

Thanks for your posting and considering Aspose.Cells.

It is only possible with Macros and VBA coding in Microsoft Excel. You will have to create macros which could hide or show your rows based on the selected values. You should take help from internet to know how you could create such a macro.

As for Aspose.Cells, it cannot let you create or inject or modify new or existing macros, so we are afraid, this feature is not supported by Aspose.Cells.