def export_xls(directory, filehandle, language, as_template): wb = xlwt.Workbook(encoding='utf-8') ws = wb.add_sheet(directory.title[:30]) fieldmap = get_map(directory) write_title(fieldmap, ws, language, directory) if not as_template: items = catalog.children(directory, fieldmap.typename) write_objects(items, fieldmap, ws, 1) wb.save(filehandle)
def export_xls(directory, filehandle, language, as_template, fieldmap=None): wb = xlwt.Workbook(encoding='utf-8') ws = wb.add_sheet(directory.title[:30]) fieldmap = fieldmap or get_map(directory) write_title(fieldmap, ws, language, directory) if not as_template: items = catalog.children(directory, fieldmap.typename) write_objects(items, fieldmap, ws, 1) wb.save(filehandle)
def write_objects(objects, fieldmap, worksheet, row, writeparent=None): ws = worksheet startrow = row for obj in objects: write = lambda r: write_object(obj, fieldmap, worksheet, r, writeparent) for childmap in fieldmap.children: children = catalog.children(obj, childmap.typename) if children: row += write_objects(children, childmap, ws, row, write) else: write(row) row += 1 if not fieldmap.children: write(row) row += 1 return row - startrow
def write_objects(objects, fieldmap, worksheet, row, writeparent=None): ws = worksheet startrow = row for obj in objects: write = lambda r: write_object( obj, fieldmap, worksheet, r, writeparent ) for childmap in fieldmap.children: children = catalog.children(obj, childmap.typename) if children: row += write_objects(children, childmap, ws, row, write) else: write(row) row += 1 if not fieldmap.children: write(row) row += 1 return row - startrow