Module Import alias Assign NameStore Call AttributeLoad NameLoad attr Str Assign NameStore Call AttributeLoad NameLoad attr Assign NameStore Call AttributeLoad NameLoad attr Assign NameStore Call AttributeLoad NameLoad attr Assign NameStore Call AttributeLoad NameLoad attr Assign NameStore Call AttributeLoad NameLoad attr Assign NameStore Call AttributeLoad NameLoad attr Assign NameStore Call AttributeLoad NameLoad attr Assign NameStore Call AttributeLoad NameLoad attr Assign NameStore Call AttributeLoad NameLoad attr Dict Str Str Str Str Assign NameStore Call AttributeLoad NameLoad attr Dict Str Str Str Str Assign NameStore ListLoad ListLoad Num Num Num Num Num Num Num Num Num Num ListLoad Num Num Num Num Num Num Num Num Num Num ListLoad Num Num Num Num Num Num Num Num Num Num ListLoad Num Num Num Num Num Num Num Num Num Num ListLoad Num Num Num Num Num Num Num Num Num Num ListLoad Num Num Num Num Num Num Num Num Num Num ListLoad Num Num Num Num Num Num Num Num Num Num ListLoad Num Num Num Num Num Num Num Num Num Num ListLoad Num Num Num Num Num Num Num Num Num Num ListLoad Num Num Num Num Num Num Num Num Num Num Assign NameStore Str Expr Call AttributeLoad NameLoad attr Str NameLoad For TupleStore NameStore NameStore Call NameLoad NameLoad body Expr Call AttributeLoad NameLoad attr BinOpAdd NameLoad Num Num NameLoad Expr Call AttributeLoad NameLoad attr Str Dict Str Str Str Str Str Str Num NameLoad Expr Call AttributeLoad NameLoad attr Str Dict Str Str Str Str Str Str Num NameLoad Assign NameStore Str Expr Call AttributeLoad NameLoad attr Str NameLoad For TupleStore NameStore NameStore Call NameLoad NameLoad body Expr Call AttributeLoad NameLoad attr BinOpAdd NameLoad Num Num NameLoad Expr Call AttributeLoad NameLoad attr Str Dict Str Str Str Str Str Str Str Num Num NameLoad Expr Call AttributeLoad NameLoad attr Str Dict Str Str Str Str Str Str Str Num Num NameLoad Assign NameStore Str Expr Call AttributeLoad NameLoad attr Str NameLoad For TupleStore NameStore NameStore Call NameLoad NameLoad body Expr Call AttributeLoad NameLoad attr BinOpAdd NameLoad Num Num NameLoad Expr Call AttributeLoad NameLoad attr Str Dict Str Str Str NameLoad Expr Call AttributeLoad NameLoad attr Str Dict Str Str Str NameLoad Assign NameStore Str Expr Call AttributeLoad NameLoad attr Str NameLoad For TupleStore NameStore NameStore Call NameLoad NameLoad body Expr Call AttributeLoad NameLoad attr BinOpAdd NameLoad Num Num NameLoad Expr Call AttributeLoad NameLoad attr Str Dict Str Str Str Str Str NameLoad Expr Call AttributeLoad NameLoad attr Str Dict Str Str Str Str Str NameLoad Assign NameStore Str Expr Call AttributeLoad NameLoad attr Str NameLoad For TupleStore NameStore NameStore Call NameLoad NameLoad body Expr Call AttributeLoad NameLoad attr BinOpAdd NameLoad Num Num NameLoad Expr Call AttributeLoad NameLoad attr Str Dict Str Str Str Str Str NameLoad Expr Call AttributeLoad NameLoad attr Str Dict Str Str Str Str Str NameLoad Assign NameStore Str Expr Call AttributeLoad NameLoad attr Str NameLoad For TupleStore NameStore NameStore Call NameLoad NameLoad body Expr Call AttributeLoad NameLoad attr BinOpAdd NameLoad Num Num NameLoad Expr Call AttributeLoad NameLoad attr Str Dict Str Str Str Str Str Str Str Num NameLoad Str Expr Call AttributeLoad NameLoad attr Str Dict Str Str Str Str Str Str Str Num NameLoad Str Assign NameStore Str Assign NameStore Call NameLoad Num Num Expr Call AttributeLoad NameLoad attr Str NameLoad Expr Call AttributeLoad NameLoad attr Str Str Expr Call AttributeLoad NameLoad attr Str Str Expr Call AttributeLoad NameLoad attr Str Str For TupleStore NameStore NameStore Call NameLoad NameLoad body Expr Call AttributeLoad NameLoad attr BinOpAdd NameLoad Num Num NameLoad Expr Call AttributeLoad NameLoad attr BinOpAdd NameLoad Num Num NameLoad Expr Call AttributeLoad NameLoad attr BinOpAdd NameLoad Num Num NameLoad Expr Call AttributeLoad NameLoad attr Str Dict Str Str Expr Call AttributeLoad NameLoad attr Str Dict Str Str Expr Call AttributeLoad NameLoad attr Str Dict Str Str Assign NameStore Str Assign NameStore Call NameLoad Num Num Expr Call AttributeLoad NameLoad attr Str NameLoad Expr Call AttributeLoad NameLoad attr Str Str Expr Call AttributeLoad NameLoad attr Str Str Expr Call AttributeLoad NameLoad attr Str Str For TupleStore NameStore NameStore Call NameLoad NameLoad body Expr Call AttributeLoad NameLoad attr BinOpAdd NameLoad Num Num NameLoad Expr Call AttributeLoad NameLoad attr BinOpAdd NameLoad Num Num NameLoad Expr Call AttributeLoad NameLoad attr BinOpAdd NameLoad Num Num NameLoad Expr Call AttributeLoad NameLoad attr Str Dict Str Str Str Str Str Str Expr Call AttributeLoad NameLoad attr Str Dict Str Str Str Str Str Str Str Str Expr Call AttributeLoad NameLoad attr Str Dict Str Str Str Str Expr Call AttributeLoad NameLoad attr
N/A N/A xlsxwriter N/A workbook N/A N/A xlsxwriter Workbook conditional_format.xlsx N/A worksheet1 N/A N/A workbook add_worksheet N/A worksheet2 N/A N/A workbook add_worksheet N/A worksheet3 N/A N/A workbook add_worksheet N/A worksheet4 N/A N/A workbook add_worksheet N/A worksheet5 N/A N/A workbook add_worksheet N/A worksheet6 N/A N/A workbook add_worksheet N/A worksheet7 N/A N/A workbook add_worksheet N/A worksheet8 N/A N/A workbook add_worksheet N/A format1 N/A N/A workbook add_format N/A bg_color font_color #FFC7CE #9C0006 N/A format2 N/A N/A workbook add_format N/A bg_color font_color #C6EFCE #006100 N/A data N/A N/A 34 72 38 30 75 48 75 66 84 86 N/A 6 24 1 84 54 62 60 3 26 59 N/A 28 79 97 13 85 93 93 22 5 14 N/A 27 71 40 17 18 79 90 93 29 47 N/A 88 25 33 23 67 1 59 79 47 36 N/A 24 100 20 88 29 33 38 54 54 88 N/A 6 57 88 28 10 26 37 7 41 48 N/A 52 78 1 96 26 45 47 33 96 36 N/A 60 54 81 66 81 90 80 93 12 55 N/A 70 5 46 14 71 19 66 36 41 21 N/A caption Cells with values >= 50 are in light red. Values < 50 are in light green. N/A N/A N/A worksheet1 write A1 caption N/A N/A row row_data N/A enumerate data N/A N/A N/A N/A worksheet1 write_row N/A row 2 1 row_data N/A N/A N/A worksheet1 conditional_format B3:K12 N/A type criteria value format cell >= 50 format1 N/A N/A N/A worksheet1 conditional_format B3:K12 N/A type criteria value format cell < 50 format2 N/A caption Values between 30 and 70 are in light red. Values outside that range are in light green. N/A N/A N/A worksheet2 write A1 caption N/A N/A row row_data N/A enumerate data N/A N/A N/A N/A worksheet2 write_row N/A row 2 1 row_data N/A N/A N/A worksheet2 conditional_format B3:K12 N/A type criteria minimum maximum format cell between 30 70 format1 N/A N/A N/A worksheet2 conditional_format B3:K12 N/A type criteria minimum maximum format cell not between 30 70 format2 N/A caption Duplicate values are in light red. Unique values are in light green. N/A N/A N/A worksheet3 write A1 caption N/A N/A row row_data N/A enumerate data N/A N/A N/A N/A worksheet3 write_row N/A row 2 1 row_data N/A N/A N/A worksheet3 conditional_format B3:K12 N/A type format duplicate format1 N/A N/A N/A worksheet3 conditional_format B3:K12 N/A type format unique format2 N/A caption Above average values are in light red. Below average values are in light green. N/A N/A N/A worksheet4 write A1 caption N/A N/A row row_data N/A enumerate data N/A N/A N/A N/A worksheet4 write_row N/A row 2 1 row_data N/A N/A N/A worksheet4 conditional_format B3:K12 N/A type criteria format average above format1 N/A N/A N/A worksheet4 conditional_format B3:K12 N/A type criteria format average below format2 N/A caption Top 10 values are in light red. Bottom 10 values are in light green. N/A N/A N/A worksheet5 write A1 caption N/A N/A row row_data N/A enumerate data N/A N/A N/A N/A worksheet5 write_row N/A row 2 1 row_data N/A N/A N/A worksheet5 conditional_format B3:K12 N/A type value format top 10 format1 N/A N/A N/A worksheet5 conditional_format B3:K12 N/A type value format bottom 10 format2 N/A caption Cells with values >= 50 are in light red. Values < 50 are in light green. Non-contiguous ranges. N/A N/A N/A worksheet6 write A1 caption N/A N/A row row_data N/A enumerate data N/A N/A N/A N/A worksheet6 write_row N/A row 2 1 row_data N/A N/A N/A worksheet6 conditional_format B3:K6 N/A type criteria value format multi_range cell >= 50 format1 B3:K6 B9:K12 N/A N/A N/A worksheet6 conditional_format B3:K6 N/A type criteria value format multi_range cell < 50 format2 B3:K6 B9:K12 N/A caption Examples of color scales and data bars. Default colors. N/A data N/A range 1 13 N/A N/A N/A worksheet7 write A1 caption N/A N/A N/A worksheet7 write B2 2 Color Scale N/A N/A N/A worksheet7 write D2 3 Color Scale N/A N/A N/A worksheet7 write F2 Data Bars N/A N/A row row_data N/A enumerate data N/A N/A N/A N/A worksheet7 write N/A row 2 1 row_data N/A N/A N/A worksheet7 write N/A row 2 3 row_data N/A N/A N/A worksheet7 write N/A row 2 5 row_data N/A N/A N/A worksheet7 conditional_format B3:B14 N/A type 2_color_scale N/A N/A N/A worksheet7 conditional_format D3:D14 N/A type 3_color_scale N/A N/A N/A worksheet7 conditional_format F3:F14 N/A type data_bar N/A caption Examples of color scales and data bars. Modified colors. N/A data N/A range 1 13 N/A N/A N/A worksheet8 write A1 caption N/A N/A N/A worksheet8 write B2 2 Color Scale N/A N/A N/A worksheet8 write D2 3 Color Scale N/A N/A N/A worksheet8 write F2 Data Bars N/A N/A row row_data N/A enumerate data N/A N/A N/A N/A worksheet8 write N/A row 2 1 row_data N/A N/A N/A worksheet8 write N/A row 2 3 row_data N/A N/A N/A worksheet8 write N/A row 2 5 row_data N/A N/A N/A worksheet8 conditional_format B3:B14 N/A type min_color max_color 2_color_scale #FF0000 #00FF00 N/A N/A N/A worksheet8 conditional_format D3:D14 N/A type min_color mid_color max_color 3_color_scale #C5D9F1 #8DB4E3 #538ED5 N/A N/A N/A worksheet8 conditional_format F3:F14 N/A type bar_color data_bar #63C384 N/A N/A N/A workbook close