(worksheet)
return rows, source, translation, occurrence, context
:return: the rows and the index for expected columns
:return: the rows and the index for expected columns
: return : the rows and the index for expected columns
def _parse_excel_sheet(worksheet):
        """
        :return: the rows and the index for expected columns
        """
        rows = [row for row in worksheet.iter_rows()]
        headers = [cell.value for cell in rows[0]]
        source = headers.index('source')
        translation = headers.index('translation')
        occurrence = headers.index('occurrence') if 'occurrence' in headers else None
        context = headers.index('context') if 'context' in headers else None
        return rows, source, translation, occurrence, context
def _parse_excel_sheet ( worksheet ) : rows = [ row for row in worksheet . iter_rows ( ) ] headers = [ cell . value for cell in rows [ 0 ] ] source = headers . index ( 'source' ) translation = headers . index ( 'translation' ) occurrence = headers . index ( 'occurrence' ) if 'occurrence' in headers else None context = headers . index ( 'context' ) if 'context' in headers else None return rows , source , translation , occurrence , context