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 export_xls(req, type): header = Nutrition.header() data = parsedata(Nutrition.objects.all(),header) return excel( [header] + 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 #SHOULD GO IN NUTRITION VIEW def statsoverview(locations): now = datetime.datetime.now() days = 1000 #OPTIMIZE data = [] lenl= [] for l in locations: d_ids = [d.id for d in l.descendants(True)]