Hi,
I am retrieving results from worksheet via WorksheetRow object. Iam getting values for particular columns via WorksheetRow.GetValue<T>(col) method for each particular column of worksheet, I don't find any way how to check that the value of that particular really exists before retrieve its value with GetValue(col) method.
If I try to Call GetValue for column where no value exists ReferenceNull exception is thrown.
I managed to establish workaroud with catching this exception, but I want to avoid exception throwing so, that I don't call GetValue if I know that value is not present.
I know how to check presence of particular attribute via Attributes property of underlaying WorksheetRow.ObjectItem object, but I don't want to retrieve call WorksheetRow.ObjectItem if not necessary (due to speed) if I necessary attributes are already loaded in Worksheet.columns.
In short: How to avoid throwing Exception in call of GetValue<bool>(column) in code below (There is NO option that value of attribute in column "column" always exists).
I am retrieving results from worksheet via WorksheetRow object. Iam getting values for particular columns via WorksheetRow.GetValue<T>(col) method for each particular column of worksheet, I don't find any way how to check that the value of that particular really exists before retrieve its value with GetValue(col) method.
If I try to Call GetValue for column where no value exists ReferenceNull exception is thrown.
I managed to establish workaroud with catching this exception, but I want to avoid exception throwing so, that I don't call GetValue if I know that value is not present.
I know how to check presence of particular attribute via Attributes property of underlaying WorksheetRow.ObjectItem object, but I don't want to retrieve call WorksheetRow.ObjectItem if not necessary (due to speed) if I necessary attributes are already loaded in Worksheet.columns.
In short: How to avoid throwing Exception in call of GetValue<bool>(column) in code below (There is NO option that value of attribute in column "column" always exists).
case AttributeType.Boolean:
return context.contextRow.GetValue<bool>(column);