Create Validation Rules for Columns using Aspose cells

Hi,


I am creating a small utility to Export and Import data using Aspose cells to Excel.

When the user exports data to Excel I want to add Validations Rules for Existing cells of Columns and if user enters new row then new cells also have Validation Rules.



Thanks,
Chandra

Hi,


Thanks for your query.

Well, you may apply Data Validation (all types are supported as per MS Excel) to your desired cells or range of cells via Aspose.Cells APIs, see the document for your complete reference:

Thank you.