Retrieving the reference formula of a range

Aspose.Cells Product Family
1

Hi,

My excel file contains many named cells (Insert->New->Define).

Is it possible to retrieve the formula (Excel "reference" field) in order to check the consistency of the formula.

My objective is to check if a named range is still valid (as the referenced cells may have been deleted in the meantime).

Thanks,

Omid.

2

Hi Omid,

You can try to use Excel.Worksheets.Names collection to get those defined names.

3

Excellent, it works pretty well.

Thanks,

Omid.