code: def parse(self):
          
  
          wb = load_workbook(self.getInputFile())
          sheet = wb.worksheets[0]
  
          sample_id = None
          cnt = 0
          for row in sheet.rows:
  
              # sampleid is only present in first row of each sample.
              # any rows above the first sample id are ignored.
              if row[1].value:
                  sample_id = row[1].value
              if not sample_id:
                  continue
  
              # If no keyword is present, this row is skipped.
              if len(row) < 7 or not isinstance(row[6].value, basestring):
                  continue
              # keyword is stripped of non-word characters
              keyword = re.sub(r"\W", "", row[6].value)
  
              # result is floatable or error
              result = row[4].value
              try:
                  float(result)
              except ValueError:
                  self.log(
                      "Error in sample '" + sample_id + "': " + "Result for '" +
                      keyword + "' is not a number " + "(" + result + ").")
                  continue
  
              # Compose dict for importer.  No interim values, just a result.
              rawdict = {
                  'DefaultResult': 'Result',
                  'Result': result,
              }
              result = rawdict[rawdict['DefaultResult']]
              column_name = rawdict['DefaultResult']
              cnt += 1
              result = self.get_result(column_name, result, cnt)
              rawdict[rawdict['DefaultResult']] = result
              self._addRawResult(sample_id,
                                 values={keyword: rawdict},
                                 override=False)
          return True
docs: parse the data