#NEWLINE# def test_create_file( self ) : #NEWLINE# #INDENT# 'Test the creation of a simple XlsxWriter file.' #NEWLINE# workbook = Workbook ( self . got_filename ) #NEWLINE# worksheet = workbook . add_worksheet ( ) #NEWLINE# chart = workbook . add_chart ( { #NEWLINE# #INDENT# 'type' : 'line' , #NEWLINE# #UNINDENT# } ) #NEWLINE# chart . axis_ids = [ 69199744 , 69214976 ] #NEWLINE# data = [ [ 1 , 2 , 3 , 4 , 5 ] , [ 2 , 4 , 6 , 8 , 10 ] , [ 3 , 6 , 9 , 12 , 15 ] ] #NEWLINE# worksheet . write_column ( 'A1' , data [ 0 ] ) #NEWLINE# worksheet . write_column ( 'B1' , data [ 1 ] ) #NEWLINE# worksheet . write_column ( 'C1' , data [ 2 ] ) #NEWLINE# chart . add_series ( { #NEWLINE# #INDENT# 'values' : '=Sheet1!$A$1:$A$5' , #NEWLINE# #UNINDENT# } ) #NEWLINE# chart . add_series ( { #NEWLINE# #INDENT# 'values' : '=Sheet1!$B$1:$B$5' , #NEWLINE# #UNINDENT# } ) #NEWLINE# chart . add_series ( { #NEWLINE# #INDENT# 'values' : '=Sheet1!$C$1:$C$5' , #NEWLINE# #UNINDENT# } ) #NEWLINE# chart . set_legend ( { #NEWLINE# #INDENT# 'font' : { #NEWLINE# #INDENT# 'bold' : 1 , #NEWLINE# 'italic' : 1 , #NEWLINE# 'baseline' : ( - 1 ) , #NEWLINE# #UNINDENT# } , #NEWLINE# #UNINDENT# } ) #NEWLINE# worksheet . insert_chart ( 'E9' , chart ) #NEWLINE# workbook . close ( ) #NEWLINE# self . assertExcelEqual ( )