#NEWLINE# def _generate_for_subfolder( self , sid ) : #NEWLINE# #INDENT# ' Generate report for a subfolder.\n\n        :param sid: The subfolder id; assumed valid\n        ' #NEWLINE# name = self . _sanitise_sheetname ( uni ( Folders . id_to_name ( sid ) ) ) #NEWLINE# ws = self . workbook . add_worksheet ( name ) #NEWLINE# fmt = self . formats #NEWLINE# ws . write ( 'A1' , 'Dossier report' , fmt [ 'title' ] ) #NEWLINE# ws . write ( 'A2' , ( '%s | %s' % ( uni ( self . folder_name ) , fmt ) ) ) #NEWLINE# ws . set_column ( 'A:A' , 37 ) #NEWLINE# ws . set_column ( 'B:B' , 37 ) #NEWLINE# ws . set_column ( 'C:C' , 37 ) #NEWLINE# ws . set_column ( 'D:D' , 8 ) #NEWLINE# ws . set_column ( 'E:E' , 30 ) #NEWLINE# ws . set_column ( 'F:F' , 37 ) #NEWLINE# ws . write ( 'A4' , 'Id' , fmt [ 'header' ] ) #NEWLINE# ws . write ( 'B4' , 'URL' , fmt [ 'header' ] ) #NEWLINE# ws . write ( 'C4' , 'Subtopic Id' , fmt [ 'header' ] ) #NEWLINE# ws . write ( 'D4' , 'Type' , fmt [ 'header' ] ) #NEWLINE# ws . write ( 'E4' , 'Content' , fmt [ 'header' ] ) #NEWLINE# ws . write ( 'F4' , 'Image URL' , fmt [ 'header' ] ) #NEWLINE# row = 4 #NEWLINE# for i in subtopics ( self . store , self . folders , self . folder_id , sid , self . user ) : #NEWLINE# #INDENT# Item . construct ( self , i ) . generate_to ( ws , row ) #NEWLINE# row += 1