Module Import alias ImportFrom alias Import alias Import alias Import alias Import alias ImportFrom alias If CompareGt Call NameLoad AttributeLoad NameLoad attr Num body Assign NameStore Call NameLoad SubscriptLoad AttributeLoad NameLoad attr Index Num Assign NameStore Num orelse Assign NameStore Num Assign NameStore Num If CompareGt Call NameLoad AttributeLoad NameLoad attr Num body Assign NameStore Call NameLoad SubscriptLoad AttributeLoad NameLoad attr Index Num FunctionDef arguments args NameParam NameParam defaults body Expr Str Print BinOpMod Str TupleLoad NameLoad NameLoad decorator_list FunctionDef arguments args defaults body Expr Str Assign NameStore Call NameLoad Assign NameStore Call AttributeLoad NameLoad attr Str Assign NameStore Call AttributeLoad NameLoad attr For NameStore Call NameLoad BinOpFloorDiv NameLoad Num body For NameStore Call NameLoad NameLoad body Expr Call AttributeLoad NameLoad attr BinOpMult NameLoad Num NameLoad BinOpMod Str TupleLoad NameLoad NameLoad For NameStore Call NameLoad NameLoad body Expr Call AttributeLoad NameLoad attr BinOpAdd BinOpMult NameLoad Num Num NameLoad BinOpAdd NameLoad NameLoad Expr Call AttributeLoad NameLoad attr Assign NameStore BinOpSub Call NameLoad NameLoad Expr Call NameLoad Str NameLoad decorator_list FunctionDef arguments args defaults body Expr Str Assign NameStore Call NameLoad Assign NameStore Call AttributeLoad NameLoad attr Str Dict Str NameLoad Assign NameStore Call AttributeLoad NameLoad attr For NameStore Call NameLoad BinOpFloorDiv NameLoad Num body For NameStore Call NameLoad NameLoad body Expr Call AttributeLoad NameLoad attr BinOpMult NameLoad Num NameLoad BinOpMod Str TupleLoad NameLoad NameLoad For NameStore Call NameLoad NameLoad body Expr Call AttributeLoad NameLoad attr BinOpAdd BinOpMult NameLoad Num Num NameLoad BinOpAdd NameLoad NameLoad Expr Call AttributeLoad NameLoad attr Assign NameStore BinOpSub Call NameLoad NameLoad Expr Call NameLoad Str NameLoad decorator_list FunctionDef arguments args defaults body Expr Str Assign NameStore Call NameLoad Assign NameStore Call AttributeLoad AttributeLoad NameLoad attr attr Assign NameStore AttributeLoad NameLoad attr For NameStore Call NameLoad BinOpFloorDiv NameLoad Num body For NameStore Call NameLoad NameLoad body Assign NameStore Call NameLoad BinOpAdd NameLoad Num Assign AttributeStore Call AttributeLoad NameLoad attr BinOpMod Str TupleLoad NameLoad BinOpAdd BinOpMult NameLoad Num Num attr BinOpMod Str TupleLoad NameLoad NameLoad For NameStore Call NameLoad NameLoad body Assign NameStore Call NameLoad BinOpAdd NameLoad Num Assign AttributeStore Call AttributeLoad NameLoad attr BinOpMod Str TupleLoad NameLoad BinOpAdd BinOpMult NameLoad Num Num attr BinOpAdd NameLoad NameLoad Expr Call AttributeLoad NameLoad attr Str Assign NameStore BinOpSub Call NameLoad NameLoad Expr Call NameLoad Str NameLoad decorator_list FunctionDef arguments args defaults body Expr Str Assign NameStore Call NameLoad Assign NameStore Call AttributeLoad AttributeLoad NameLoad attr attr keyword NameLoad Assign NameStore Call AttributeLoad NameLoad attr For NameStore Call NameLoad BinOpFloorDiv NameLoad Num body Assign NameStore ListComp BinOpMod Str TupleLoad NameLoad NameLoad comprehension NameStore Call NameLoad NameLoad Expr Call AttributeLoad NameLoad attr NameLoad Assign NameStore ListComp BinOpAdd NameLoad NameLoad comprehension NameStore Call NameLoad NameLoad Expr Call AttributeLoad NameLoad attr NameLoad Expr Call AttributeLoad NameLoad attr Str Assign NameStore BinOpSub Call NameLoad NameLoad Expr Call NameLoad Str NameLoad decorator_list FunctionDef arguments args defaults body Expr Str Assign NameStore Call NameLoad Assign NameStore Call AttributeLoad NameLoad attr Assign NameStore Call AttributeLoad NameLoad attr Str For NameStore Call NameLoad BinOpFloorDiv NameLoad Num body For NameStore Call NameLoad NameLoad body Expr Call AttributeLoad NameLoad attr BinOpAdd BinOpMult NameLoad Num Num BinOpAdd NameLoad Num BinOpMod Str TupleLoad NameLoad NameLoad For NameStore Call NameLoad NameLoad body Expr Call AttributeLoad NameLoad attr BinOpAdd BinOpMult NameLoad Num Num BinOpAdd NameLoad Num BinOpAdd NameLoad NameLoad Expr Call AttributeLoad NameLoad attr Str Assign NameStore BinOpSub Call NameLoad NameLoad Expr Call NameLoad Str NameLoad decorator_list FunctionDef arguments args defaults body Expr Str Assign NameStore Call NameLoad Assign NameStore Call AttributeLoad NameLoad attr Assign NameStore Call AttributeLoad NameLoad attr Str For NameStore Call NameLoad BinOpFloorDiv NameLoad Num body For NameStore Call NameLoad NameLoad body Expr Call AttributeLoad NameLoad attr BinOpMult NameLoad Num NameLoad BinOpMod Str TupleLoad NameLoad NameLoad For NameStore Call NameLoad NameLoad body Expr Call AttributeLoad NameLoad attr BinOpAdd BinOpMult NameLoad Num Num NameLoad BinOpAdd NameLoad NameLoad Expr Call AttributeLoad NameLoad attr Str Assign NameStore BinOpSub Call NameLoad NameLoad Expr Call NameLoad Str NameLoad decorator_list Print Str Print Str Print BinOpMod Str TupleLoad Str SubscriptLoad AttributeLoad NameLoad attr Slice Num Print BinOpMod Str TupleLoad Str AttributeLoad NameLoad attr Print BinOpMod Str TupleLoad Str AttributeLoad NameLoad attr Print BinOpMod Str TupleLoad Str AttributeLoad NameLoad attr Print BinOpMod Str TupleLoad Str AttributeLoad NameLoad attr Print Str Print Str Print BinOpMod Str NameLoad Print BinOpMod Str NameLoad Print Str Print Str Expr Call NameLoad Expr Call NameLoad Expr Call NameLoad Expr Call NameLoad Expr Call NameLoad Expr Call NameLoad Print Str
N/A N/A sys time clock N/A openpyxl N/A pyexcelerate N/A xlsxwriter N/A xlwt openpyxl.cell get_column_letter N/A N/A N/A len N/A sys argv 1 N/A N/A row_max N/A int N/A N/A sys argv N/A 1 N/A col_max 50 N/A N/A row_max 1000 N/A col_max 50 N/A N/A N/A len N/A sys argv 2 N/A N/A col_max N/A int N/A N/A sys argv N/A 2 print_elapsed_time N/A N/A module_name elapsed N/A N/A N/A  Print module run times in a consistent format.  N/A N/A     %-22s: %6.2f N/A module_name elapsed N/A time_xlsxwriter N/A N/A N/A N/A N/A  Run XlsxWriter in default mode.  N/A start_time N/A clock N/A workbook N/A N/A xlsxwriter Workbook xlsxwriter.xlsx N/A worksheet N/A N/A workbook add_worksheet N/A row N/A range N/A row_max 2 N/A N/A col N/A range col_max N/A N/A N/A N/A worksheet write_string N/A row 2 col N/A Row: %d Col: %d N/A row col N/A col N/A range col_max N/A N/A N/A N/A worksheet write_number N/A N/A row 2 1 col N/A row col N/A N/A N/A workbook close N/A elapsed N/A N/A clock start_time N/A N/A print_elapsed_time xlsxwriter elapsed N/A time_xlsxwriter_optimised N/A N/A N/A N/A N/A  Run XlsxWriter in optimised/constant memory mode.  N/A start_time N/A clock N/A workbook N/A N/A xlsxwriter Workbook xlsxwriter_opt.xlsx N/A constant_memory True N/A worksheet N/A N/A workbook add_worksheet N/A row N/A range N/A row_max 2 N/A N/A col N/A range col_max N/A N/A N/A N/A worksheet write_string N/A row 2 col N/A Row: %d Col: %d N/A row col N/A col N/A range col_max N/A N/A N/A N/A worksheet write_number N/A N/A row 2 1 col N/A row col N/A N/A N/A workbook close N/A elapsed N/A N/A clock start_time N/A N/A print_elapsed_time xlsxwriter (optimised) elapsed N/A time_openpyxl N/A N/A N/A N/A N/A  Run OpenPyXL in default mode.  N/A start_time N/A clock N/A workbook N/A N/A N/A openpyxl workbook Workbook N/A worksheet N/A workbook active N/A row N/A range N/A row_max 2 N/A N/A col N/A range col_max N/A N/A colletter N/A get_column_letter N/A col 1 N/A N/A N/A N/A worksheet cell N/A %s%s N/A colletter N/A N/A row 2 1 value N/A Row: %d Col: %d N/A row col N/A col N/A range col_max N/A N/A colletter N/A get_column_letter N/A col 1 N/A N/A N/A N/A worksheet cell N/A %s%s N/A colletter N/A N/A row 2 2 value N/A row col N/A N/A N/A workbook save openpyxl.xlsx N/A elapsed N/A N/A clock start_time N/A N/A print_elapsed_time openpyxl elapsed N/A time_openpyxl_optimised N/A N/A N/A N/A N/A  Run OpenPyXL in optimised mode.  N/A start_time N/A clock N/A workbook N/A N/A N/A openpyxl workbook Workbook optimized_write True N/A worksheet N/A N/A workbook create_sheet N/A row N/A range N/A row_max 2 N/A N/A string_data N/A N/A Row: %d Col: %d N/A row col N/A col N/A range col_max N/A N/A N/A worksheet append string_data N/A num_data N/A N/A row col N/A col N/A range col_max N/A N/A N/A worksheet append num_data N/A N/A N/A workbook save openpyxl_opt.xlsx N/A elapsed N/A N/A clock start_time N/A N/A print_elapsed_time openpyxl   (optimised) elapsed N/A time_pyexcelerate N/A N/A N/A N/A N/A  Run pyexcelerate in "faster" mode.  N/A start_time N/A clock N/A workbook N/A N/A pyexcelerate Workbook N/A worksheet N/A N/A workbook new_sheet Sheet1 N/A row N/A range N/A row_max 2 N/A N/A col N/A range col_max N/A N/A N/A N/A worksheet set_cell_value N/A N/A row 2 1 N/A col 1 N/A Row: %d Col: %d N/A row col N/A col N/A range col_max N/A N/A N/A N/A worksheet set_cell_value N/A N/A row 2 2 N/A col 1 N/A row col N/A N/A N/A workbook save pyexcelerate.xlsx N/A elapsed N/A N/A clock start_time N/A N/A print_elapsed_time pyexcelerate elapsed N/A time_xlwt N/A N/A N/A N/A N/A  Run xlwt in default mode.  N/A start_time N/A clock N/A workbook N/A N/A xlwt Workbook N/A worksheet N/A N/A workbook add_sheet Sheet1 N/A row N/A range N/A row_max 2 N/A N/A col N/A range col_max N/A N/A N/A N/A worksheet write N/A row 2 col N/A Row: %d Col: %d N/A row col N/A col N/A range col_max N/A N/A N/A N/A worksheet write N/A N/A row 2 1 col N/A row col N/A N/A N/A workbook save xlwt.xls N/A elapsed N/A N/A clock start_time N/A N/A print_elapsed_time xlwt elapsed N/A N/A N/A Versions: N/A N/A     %-12s: %s N/A python N/A N/A sys version N/A 5 N/A N/A     %-12s: %s N/A openpyxl N/A openpyxl __version__ N/A N/A     %-12s: %s N/A pyexcelerate N/A pyexcelerate __version__ N/A N/A     %-12s: %s N/A xlsxwriter N/A xlsxwriter __version__ N/A N/A     %-12s: %s N/A xlwt N/A xlwt __VERSION__ N/A N/A Dimensions: N/A N/A     Rows = %d row_max N/A N/A     Cols = %d col_max N/A N/A Times: N/A N/A time_pyexcelerate N/A N/A time_xlwt N/A N/A time_xlsxwriter_optimised N/A N/A time_xlsxwriter N/A N/A time_openpyxl_optimised N/A N/A time_openpyxl N/A