i have some rules or formula you can say which i want to put on workbook
e.g IF(ExistsIn(@value,string(@dataList)),true,false)
The above one rule which i want to put on the workbook, can you please help me in that ?
@Amrinder_Singh
It seems those functions in your formula are custom functions, such as “ExsitsIn”, “string”. You may just use them as they are when setting the formula to cell:
Cell cell = ...;
cell.Formula = "=IF(ExistsIn(@value,string(@dataList)),true,false)";
For your reference, please see Manage formulas of Excel files|Documentation (aspose.com).
Because you use custom functions in your formula, if you need the formula to be calculated by Aspose.Cells, you should implement your custom calculation engine for them. For your reference, please see Implement Custom Calculation Engine to extend the Default Calculation Engine of Aspose.Cells|Documentation.