output.txt

# source data files: http://spreadsheet_reader.drop.bakatrouble.pw/

/home/bakatrouble/.virtualenvs/sandbox/bin/python3 /home/bakatrouble/dev/sandbox/q.py
=== XLS ===
Тестов, Тест, Тестович, test, [email protected]
Иванов, Иван, Иванович, test2, [email protected]

=== CSV ===
Тестов, Тест, Тестович, test, [email protected]
Иванов, Иван, Иванович, test2, [email protected]

spreadsheet_reader.py

def csv_read():
    import csv
    with open('data.csv', encoding='cp1251') as f:
        reader = csv.reader(f, delimiter=';', quotechar='"')
        next(reader)
        for row in reader:
            last_name = row[0]
            first_name = row[1]
            father_name = row[2]
            group = row[3]
            email = row[4]
            print(f'{last_name}, {first_name}, {father_name}, {group}, {email}')


def xls_read():
    import xlrd
    book = xlrd.open_workbook('data.xls')
    sheet = book.sheet_by_index(0)
    for i in range(1, sheet.nrows):
        row = sheet.row(i)
        last_name = row[0].value
        first_name = row[1].value
        father_name = row[2].value
        group = row[3].value
        email = row[4].value
        print(f'{last_name}, {first_name}, {father_name}, {group}, {email}')


if __name__ == '__main__':
    print('=== XLS ===')
    xls_read()
    print('\n=== CSV ===')
    csv_read()