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 Num Str Expr Call AttributeLoad NameLoad attr Str Num Expr Call AttributeLoad NameLoad attr Num Num Expr Call AttributeLoad NameLoad attr Num Num Assign NameStore Str Assign NameStore Str Expr Call AttributeLoad NameLoad attr Str NameLoad NameLoad Expr Call AttributeLoad NameLoad attr Str NameLoad Expr Call AttributeLoad NameLoad attr Str Num Expr Call AttributeLoad NameLoad attr Num Num Expr Call AttributeLoad NameLoad attr Num Num Assign NameStore Str Assign NameStore Str Expr Call AttributeLoad NameLoad attr Str NameLoad NameLoad Expr Call AttributeLoad NameLoad attr Str NameLoad Dict Str NameLoad Assign NameStore Str Expr Call AttributeLoad NameLoad attr Str NameLoad NameLoad Expr Call AttributeLoad NameLoad attr Str NameLoad Expr Call AttributeLoad NameLoad attr Str Num Expr Call AttributeLoad NameLoad attr Num Num Expr Call AttributeLoad NameLoad attr Num Num Expr Call AttributeLoad NameLoad attr Num Num Expr Call AttributeLoad NameLoad attr Assign NameStore Str Assign NameStore Str Expr Call AttributeLoad NameLoad attr Str NameLoad NameLoad Expr Call AttributeLoad NameLoad attr Str NameLoad Dict Str Num Assign NameStore Str Expr Call AttributeLoad NameLoad attr Str NameLoad NameLoad Expr Call AttributeLoad NameLoad attr Str NameLoad Assign NameStore Str Expr Call AttributeLoad NameLoad attr Str NameLoad NameLoad Expr Call AttributeLoad NameLoad attr Str NameLoad Dict Str NameLoad Expr Call AttributeLoad NameLoad attr Str Num Expr Call AttributeLoad NameLoad attr Num Num Expr Call AttributeLoad NameLoad attr Num Num Expr Call AttributeLoad NameLoad attr Num Num Expr Call AttributeLoad NameLoad attr Num Num Expr Call AttributeLoad NameLoad attr Assign NameStore Str Assign NameStore Str Expr Call AttributeLoad NameLoad attr Str NameLoad NameLoad Expr Call AttributeLoad NameLoad attr Str NameLoad Assign NameStore Str Expr Call AttributeLoad NameLoad attr Str NameLoad NameLoad Expr Call AttributeLoad NameLoad attr Str NameLoad Dict Str Num Assign NameStore Str Expr Call AttributeLoad NameLoad attr Str NameLoad NameLoad Expr Call AttributeLoad NameLoad attr Str NameLoad Dict Str Num Assign NameStore Str Expr Call AttributeLoad NameLoad attr Str NameLoad NameLoad Expr Call AttributeLoad NameLoad attr Str NameLoad Dict Str Str Num Num Assign NameStore Str Expr Call AttributeLoad NameLoad attr Str NameLoad NameLoad Expr Call AttributeLoad NameLoad attr Str NameLoad Dict Str Str Num Num Expr Call AttributeLoad NameLoad attr Str Num Expr Call AttributeLoad NameLoad attr Num Num Expr Call AttributeLoad NameLoad attr Num Num Expr Call AttributeLoad NameLoad attr Num Num Expr Call AttributeLoad NameLoad attr Num Num Expr Call AttributeLoad NameLoad attr Assign NameStore Str Assign NameStore Str Expr Call AttributeLoad NameLoad attr Str NameLoad NameLoad Expr Call AttributeLoad NameLoad attr Str NameLoad Assign NameStore Str Expr Call AttributeLoad NameLoad attr Str NameLoad NameLoad Expr Call AttributeLoad NameLoad attr Str NameLoad Dict Str Str Assign NameStore Str Expr Call AttributeLoad NameLoad attr Str NameLoad NameLoad Expr Call AttributeLoad NameLoad attr Str NameLoad Dict Str Str Num Num Assign NameStore Str Expr Call AttributeLoad NameLoad attr Str NameLoad NameLoad Expr Call AttributeLoad NameLoad attr Str NameLoad Dict Str Str Num Num Expr Call AttributeLoad NameLoad attr Str Num Expr Call AttributeLoad NameLoad attr Num Num Expr Call AttributeLoad NameLoad attr Num Num Expr Call AttributeLoad NameLoad attr Num Num Expr Call AttributeLoad NameLoad attr Assign NameStore Str Assign NameStore Str Expr Call AttributeLoad NameLoad attr Str NameLoad NameLoad Expr Call AttributeLoad NameLoad attr Str NameLoad Dict Str Str Assign NameStore Str Expr Call AttributeLoad NameLoad attr Str NameLoad NameLoad Expr Call AttributeLoad NameLoad attr Str NameLoad Assign NameStore Str Expr Call AttributeLoad NameLoad attr Str NameLoad NameLoad Expr Call AttributeLoad NameLoad attr Str NameLoad Dict Str Str Expr Call AttributeLoad NameLoad attr Str Num Expr Call AttributeLoad NameLoad attr Num Num Expr Call AttributeLoad NameLoad attr Num Num Expr Call AttributeLoad NameLoad attr Num Num Assign NameStore Str Assign NameStore Str Assign NameStore Str Assign NameStore Str Expr Call AttributeLoad NameLoad attr NameLoad NameLoad NameLoad Expr Call AttributeLoad NameLoad attr NameLoad NameLoad Assign NameStore Str Assign NameStore Str Assign NameStore Str Expr Call AttributeLoad NameLoad attr NameLoad NameLoad NameLoad Expr Call AttributeLoad NameLoad attr NameLoad NameLoad Dict Str NameLoad Expr Call AttributeLoad NameLoad attr Str Num Expr Call AttributeLoad NameLoad attr Num Num Expr Call AttributeLoad NameLoad attr Assign NameStore Str Assign NameStore Str Expr Call AttributeLoad NameLoad attr Str NameLoad NameLoad Expr Call AttributeLoad NameLoad attr Str NameLoad Assign NameStore Str Expr Call AttributeLoad NameLoad attr Str NameLoad NameLoad Expr Call AttributeLoad NameLoad attr Str NameLoad Expr Call AttributeLoad NameLoad attr
N/A N/A xlsxwriter N/A workbook N/A N/A xlsxwriter Workbook comments2.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 text_wrap N/A N/A workbook add_format N/A text_wrap valign 1 top N/A N/A N/A worksheet1 set_column C:C 25 N/A N/A N/A worksheet1 set_row 2 50 N/A N/A N/A worksheet1 set_row 5 50 N/A cell_text Hold the mouse over this cell to see the comment. N/A comment This is a comment. N/A N/A N/A worksheet1 write C3 cell_text text_wrap N/A N/A N/A worksheet1 write_comment C3 comment N/A N/A N/A worksheet2 set_column C:C 25 N/A N/A N/A worksheet2 set_row 2 50 N/A N/A N/A worksheet2 set_row 5 50 N/A cell_text This cell comment is visible. N/A comment Hello. N/A N/A N/A worksheet2 write C3 cell_text text_wrap N/A N/A N/A worksheet2 write_comment C3 comment N/A visible True N/A cell_text This cell comment isn't visible (the default). N/A N/A N/A worksheet2 write C6 cell_text text_wrap N/A N/A N/A worksheet2 write_comment C6 comment N/A N/A N/A worksheet3 set_column C:C 25 N/A N/A N/A worksheet3 set_row 2 50 N/A N/A N/A worksheet3 set_row 5 50 N/A N/A N/A worksheet3 set_row 8 50 N/A N/A N/A worksheet3 show_comments N/A cell_text This cell comment is visible, explicitly. N/A comment Hello. N/A N/A N/A worksheet3 write C3 cell_text text_wrap N/A N/A N/A worksheet3 write_comment C3 comment N/A visible 1 N/A cell_text This cell comment is also visible because of show_comments(). N/A N/A N/A worksheet3 write C6 cell_text text_wrap N/A N/A N/A worksheet3 write_comment C6 comment N/A cell_text However, we can still override it locally. N/A N/A N/A worksheet3 write C9 cell_text text_wrap N/A N/A N/A worksheet3 write_comment C9 comment N/A visible False N/A N/A N/A worksheet4 set_column C:C 25 N/A N/A N/A worksheet4 set_row 2 50 N/A N/A N/A worksheet4 set_row 5 50 N/A N/A N/A worksheet4 set_row 8 50 N/A N/A N/A worksheet4 set_row 15 50 N/A N/A N/A worksheet4 show_comments N/A cell_text This cell comment is default size. N/A comment Hello. N/A N/A N/A worksheet4 write C3 cell_text text_wrap N/A N/A N/A worksheet4 write_comment C3 comment N/A cell_text This cell comment is twice as wide. N/A N/A N/A worksheet4 write C6 cell_text text_wrap N/A N/A N/A worksheet4 write_comment C6 comment N/A x_scale 2 N/A cell_text This cell comment is twice as high. N/A N/A N/A worksheet4 write C9 cell_text text_wrap N/A N/A N/A worksheet4 write_comment C9 comment N/A y_scale 2 N/A cell_text This cell comment is scaled in both directions. N/A N/A N/A worksheet4 write C16 cell_text text_wrap N/A N/A N/A worksheet4 write_comment C16 comment N/A x_scale y_scale 1.2 0.8 N/A cell_text This cell comment has width and height specified in pixels. N/A N/A N/A worksheet4 write C19 cell_text text_wrap N/A N/A N/A worksheet4 write_comment C19 comment N/A width height 200 20 N/A N/A N/A worksheet5 set_column C:C 25 N/A N/A N/A worksheet5 set_row 2 50 N/A N/A N/A worksheet5 set_row 5 50 N/A N/A N/A worksheet5 set_row 8 50 N/A N/A N/A worksheet5 set_row 11 50 N/A N/A N/A worksheet5 show_comments N/A cell_text This cell comment is in the default position. N/A comment Hello. N/A N/A N/A worksheet5 write C3 cell_text text_wrap N/A N/A N/A worksheet5 write_comment C3 comment N/A cell_text This cell comment has been moved to another cell. N/A N/A N/A worksheet5 write C6 cell_text text_wrap N/A N/A N/A worksheet5 write_comment C6 comment N/A start_cell E4 N/A cell_text This cell comment has been moved to another cell. N/A N/A N/A worksheet5 write C9 cell_text text_wrap N/A N/A N/A worksheet5 write_comment C9 comment N/A start_row start_col 8 4 N/A cell_text This cell comment has been shifted within its default cell. N/A N/A N/A worksheet5 write C12 cell_text text_wrap N/A N/A N/A worksheet5 write_comment C12 comment N/A x_offset y_offset 30 12 N/A N/A N/A worksheet6 set_column C:C 25 N/A N/A N/A worksheet6 set_row 2 50 N/A N/A N/A worksheet6 set_row 5 50 N/A N/A N/A worksheet6 set_row 8 50 N/A N/A N/A worksheet6 show_comments N/A cell_text This cell comment has a different color. N/A comment Hello. N/A N/A N/A worksheet6 write C3 cell_text text_wrap N/A N/A N/A worksheet6 write_comment C3 comment N/A color green N/A cell_text This cell comment has the default color. N/A N/A N/A worksheet6 write C6 cell_text text_wrap N/A N/A N/A worksheet6 write_comment C6 comment N/A cell_text This cell comment has a different color. N/A N/A N/A worksheet6 write C9 cell_text text_wrap N/A N/A N/A worksheet6 write_comment C9 comment N/A color #CCFFCC N/A N/A N/A worksheet7 set_column C:C 30 N/A N/A N/A worksheet7 set_row 2 50 N/A N/A N/A worksheet7 set_row 5 50 N/A N/A N/A worksheet7 set_row 8 50 N/A author N/A cell C3 N/A cell_text Move the mouse over this cell and you will see 'Cell commented by (blank)' in the status bar at the bottom N/A comment Hello. N/A N/A N/A worksheet7 write cell cell_text text_wrap N/A N/A N/A worksheet7 write_comment cell comment N/A author Python N/A cell C6 N/A cell_text Move the mouse over this cell and you will see 'Cell commented by Python' in the status bar at the bottom N/A N/A N/A worksheet7 write cell cell_text text_wrap N/A N/A N/A worksheet7 write_comment cell comment N/A author author N/A N/A N/A worksheet8 set_column C:C 25 N/A N/A N/A worksheet8 set_row 2 80 N/A N/A N/A worksheet8 show_comments N/A cell_text The height of this row has been adjusted explicitly using set_row(). The size of the comment box is adjusted accordingly by XlsxWriter. N/A comment Hello. N/A N/A N/A worksheet8 write C3 cell_text text_wrap N/A N/A N/A worksheet8 write_comment C3 comment N/A cell_text The height of this row has been adjusted by Excel due to the text wrap property being set. Unfortunately this means that the height of the row is unknown to XlsxWriter at run time and thus the comment box is stretched as well.

Use set_row() to specify the row height explicitly to avoid this problem. N/A N/A N/A worksheet8 write C6 cell_text text_wrap N/A N/A N/A worksheet8 write_comment C6 comment N/A N/A N/A workbook close