def download_excel(req, header, data):
if "delete" in data:
return excel([[]])
try:
klass, title, func = header.split(";")
data = [[h for h in header.split("|")]] + [[l for l in evalFunc(klass, func)]]
except:
data = [[h]] + [[l] for l in eval(data)]
return excel(data)
def question_xls(req, section_pk, question_pk):
sect = get_object_or_404(Section, pk=section_pk)
ques = get_object_or_404(Question, pk=question_pk)
def __row(answer):
sub = answer.submission
return [
answer.normalized, sub.reported_by, sub.location, sub.submitted
]
return excel([["Answer", "Reporter", "Location", "Date"]] +
[__row(ans) for ans in ques.answers.all()])
def question_xls(req, section_pk, question_pk):
sect = get_object_or_404(Section, pk=section_pk)
ques = get_object_or_404(Question, pk=question_pk)
def __row(answer):
sub = answer.submission
return [
answer.normalized,
sub.reported_by,
sub.location,
sub.submitted
]
return excel(
[["Answer", "Reporter", "Location", "Date"]] +
[__row(ans) for ans in ques.answers.all()])
def CreateResultSet(req,header,data,exceldata,title,breadcrumbs):
resultset = {}
dataset_count = len(data)
object_data = {}
list_data = [] #list-i-fy excel data
for c in object_data:
od = object_data[c]
h = header[c]
for i in range(0,len(od)):
resultset["header_col%s_%s"%(c,i)] = h[i]
resultset["data_col%s_%s"%(c,i)] = paginated(req,od[i],prefix="data_col%s_%s"%(c,i)),
resultset["column_count%s_%s"] = (c,len(od))
resultset["column_count"] = len(object_data)
resultset["excel"] = excel(list_data)
resultset["title"] = title
resultset["breadcrumbs"] = breadcrumbs
return resultset
def export_xls(req, type):
header = Nutrition.header()
data = parsedata(Nutrition.objects.all(),header)
return excel(
[header] + data)
