#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# chart1 = workbook . add_chart ( { #NEWLINE# #INDENT# 'type' : 'column' , #NEWLINE# #UNINDENT# } ) #NEWLINE# chart2 = workbook . add_chart ( { #NEWLINE# #INDENT# 'type' : 'scatter' , #NEWLINE# #UNINDENT# } ) #NEWLINE# chart1 . axis_ids = [ 81267328 , 81297792 ] #NEWLINE# chart2 . axis_ids = [ 81267328 , 81297792 ] #NEWLINE# chart2 . axis2_ids = [ 89510656 , 84556032 ] #NEWLINE# data = [ [ 2 , 3 , 4 , 5 , 6 ] , [ 20 , 25 , 10 , 10 , 20 ] , [ 5 , 10 , 15 , 10 , 5 ] ] #NEWLINE# worksheet . write_column ( 'A1' , data [ 0 ] ) #NEWLINE# worksheet . write_column ( 'B1' , chart1 [ 1 ] ) #NEWLINE# worksheet . write_column ( 'C1' , data [ 2 ] ) #NEWLINE# chart1 . add_series ( { #NEWLINE# #INDENT# 'categories' : '=Sheet1!$A$1:$A$5' , #NEWLINE# 'values' : '=Sheet1!$B$1:$B$5' , #NEWLINE# #UNINDENT# } ) #NEWLINE# chart2 . add_series ( { #NEWLINE# #INDENT# 'categories' : '=Sheet1!$A$1:$A$5' , #NEWLINE# 'values' : '=Sheet1!$C$1:$C$5' , #NEWLINE# 'y2_axis' : 1 , #NEWLINE# #UNINDENT# } ) #NEWLINE# chart1 . combine ( chart2 ) #NEWLINE# worksheet . insert_chart ( 'E9' , chart1 ) #NEWLINE# workbook . close ( ) #NEWLINE# self . assertExcelEqual ( )