#NEWLINE# def test_create_file( self ) : #NEWLINE# #INDENT# 'Test the creation of an XlsxWriter file with error bars.' #NEWLINE# workbook = Workbook ( self . got_filename ) #NEWLINE# worksheet = workbook . add_worksheet ( ) #NEWLINE# chart = workbook . add_chart ( { #NEWLINE# #INDENT# 'type' : 'stock' , #NEWLINE# #UNINDENT# } ) #NEWLINE# date_format = workbook . add_format ( { #NEWLINE# #INDENT# 'num_format' : 14 , #NEWLINE# #UNINDENT# } ) #NEWLINE# chart . axis_ids = [ 45470848 , 45472768 ] #NEWLINE# data = [ [ 39083 , 39084 , 39085 , 39086 , 39087 ] , [ 27.2 , 25.03 , 19.05 , 20.34 , 18.5 ] , [ 23.49 , 19.55 , 15.12 , 17.84 , 16.34 ] , [ 25.45 , 23.05 , 17.32 , 20.45 , 17.34 ] ] #NEWLINE# for row in range ( 5 ) : #NEWLINE# #INDENT# worksheet . write ( row , 0 , data [ 0 ] [ row ] , date_format ) #NEWLINE# worksheet . write ( row , 1 , data [ 1 ] [ row ] ) #NEWLINE# worksheet . write ( row , 2 , data [ 2 ] [ row ] ) #NEWLINE# worksheet . write ( row , 3 , data [ 3 ] [ row ] ) #NEWLINE# #UNINDENT# worksheet . set_column ( 'A:D' , 11 ) #NEWLINE# chart . add_series ( { #NEWLINE# #INDENT# 'categories' : '=Sheet1!$A$1:$A$5' , #NEWLINE# 'values' : '=Sheet1!$B$1:$B$5' , #NEWLINE# 'y_error_bars' : { #NEWLINE# #INDENT# 'type' : 'standard_error' , #NEWLINE# #UNINDENT# } , #NEWLINE# #UNINDENT# } ) #NEWLINE# chart . add_series ( { #NEWLINE# #INDENT# 'categories' : '=Sheet1!$A$1:$A$5' , #NEWLINE# 'values' : '=Sheet1!$C$1:$C$5' , #NEWLINE# 'y_error_bars' : { #NEWLINE# #INDENT# 'type' : 'standard_error' , #NEWLINE# #UNINDENT# } , #NEWLINE# #UNINDENT# } ) #NEWLINE# chart . add_series ( { #NEWLINE# #INDENT# 'categories' : '=Sheet1!$A$1:$A$5' , #NEWLINE# 'values' : '=Sheet1!$D$1:$D$5' , #NEWLINE# 'y_error_bars' : { #NEWLINE# #INDENT# 'type' : 'standard_error' , #NEWLINE# #UNINDENT# } , #NEWLINE# #UNINDENT# } ) #NEWLINE# worksheet . insert_chart ( 'E9' , chart ) #NEWLINE# workbook . close ( ) #NEWLINE# self . assertExcelEqual ( )