First time poster, long time reader! I am using libxlsxwriter in C.
I want to color rows either green or red and give the columns a different format each (which is either a date, a 2 decimal number or a 7 decimal number, or default.
the problem is that only the later is applied to each sell. so if do:
worksheet_set_column(bla, bla, bla, date_format)
//later in a loop:
worksheet_set_row(bla, bla, bla, green_format).
the cells will only have the green_format but the the date_format
is there a way to apply both? I have a very messy solution where i just make red and green variation of each format, i.e. date_green_format/date_red_format. but that is really messy and i would like to avoid it aat all cost.
Is there a better way? Thanks!
First use worksheet_set_row() and then use worksheet_set_column().
As per the documentation,
Refer: worksheet_set_row()