Index: dialin/utils/nv_ops_utils.py =================================================================== diff -u -rb9a0dd1c65e089b0e7a7ddb83cf2b2669ef3049a -r1c507eb2cac4a66d8d0fd567b8eed90374c1d809 --- dialin/utils/nv_ops_utils.py (.../nv_ops_utils.py) (revision b9a0dd1c65e089b0e7a7ddb83cf2b2669ef3049a) +++ dialin/utils/nv_ops_utils.py (.../nv_ops_utils.py) (revision 1c507eb2cac4a66d8d0fd567b8eed90374c1d809) @@ -196,7 +196,10 @@ for spec in dialin_record[group][hardware]: cell_value = self.excel_ops.get_cell_value(self._excel_workbook, self._record_name, row, col) - if 'crc' not in spec and 'time' not in spec: + # Check if the cell value is not none. If it is none, it cannot be converted to a number + # like float or integer + is_cell_value_valid = True if cell_value is not None else False + if 'crc' not in spec and 'time' not in spec and is_cell_value_valid: temp_buffer.append(struct.pack(dialin_record[group][hardware][spec][0], cell_value)) if dialin_record[group][hardware][spec][1] != cell_value: is_value_different = True @@ -209,7 +212,7 @@ date_time = self.get_current_date_time(epoch_time) self.excel_ops.write_to_excel(self._excel_workbook, self._record_name, row, col, date_time) - elif 'time' in spec and isinstance(cell_value, str): + elif 'time' in spec and isinstance(cell_value, str) and is_cell_value_valid: epoch_time = self.get_date_time_in_epoch(cell_value) dialin_record[group][hardware][spec][1] = epoch_time @@ -228,7 +231,11 @@ for spec in dialin_record[group][hardware]: cell_value = self.excel_ops.get_cell_value(self._excel_workbook, self._record_name, row, col) - dialin_record[group][hardware][1] = cell_value + # Check if the cell value is not none. If it is none, it cannot be converted to a number + # like float or integer + is_cell_value_valid = True if cell_value is not None else False + if is_cell_value_valid: + dialin_record[group][hardware][1] = cell_value temp_buffer.clear() row += 1 row += 1