Hi,
Situation to solve:
My application supports importing data from a well-defined Excel file. The workbook may come via the web but ultimately gets imported via a windows app. Due to this it is virtually 100% guranteed any external links will not work. However only certain bits of data are actually extracted from the workbook (and inserted into database) therefore as long as none of the data from the cells I'm interested in comes from cells whose data is from an external link my app shouldn't care.
I see through searching the Aspose.Cells forum that it's possible to check for External Links via Workbook.Worksheets.ExternalLinks. However all this appears to do is tell me that there are external links in the workbook, is there no way to tell if a particular cells value is the result of data from an external link?
If not then the only solution would be to refuse to import from a workbook that had external links, not amazingly bad, but trying to explain such things to clients is hard.
Bye,
Peter