we are using Aspose.Excel to transfer data from Excel Sheets to database tables.
We are now coping with Excel errors in individual cells. Our aim is to abort database loading if any of the cells contains an Excel error, like one of these (if you know of any other, pls tell me!):
Which is the best way to find if a cell has an error?
Should we use StringValue property of Cell objects to find if a cell has one of these errors?
if (cell.StringValue == “#REF!” || cell.StringValue = “DIV/0!” || (…) )
Thank you for help,