exel

from excel_response import ExcelResponse


def excelview(request,id_comp):
    comp = Competition.objects.get(id=id_comp)
    entrys=Entry.objects.filter(competition=comp)
    competitor=Competitor.objects.none()
    for i in range(len(entrys)):
        s=Competitor.objects.filter(entry=entrys[i])
        competitor=competitor|s
    people = competitor.values('surname','name','date','gender','kod_id','region__name','region__kod','comand__name','city__name','city__kod')
    return ExcelResponse(people)