We have an application in which we automate a huge business process through excel seets and we are usign Aspose Cells for the Java. We have a requirement in which - given a cell we should be able to find all the ranges the cell is part of? The only way I could think of is to find all the ranges in the given worksheet and check if the given cell is part of the range. But I would think this may not be a very efficient way of doing this. Is there a better way of doing this, something like (NamedRange cells.getAssociatedRanes()), which I can use. Any pointer that you can provide on this will be of much help.
Thanks and Best Regards,