// Test the _write_font() function. CTEST(styles, write_font13) { char* got; char exp[] = "<font><b/><i/><strike/><outline/><shadow/><u/><vertAlign val=\"superscript\"/><sz val=\"12\"/><color rgb=\"FFFF0000\"/><name val=\"Calibri\"/><family val=\"2\"/><scheme val=\"minor\"/></font>"; FILE* testfile = lxw_tmpfile(NULL); lxw_styles *styles = lxw_styles_new(); lxw_format *format = lxw_format_new(); format_set_bold(format); format_set_italic(format); format_set_font_size(format, 12); format_set_font_color(format, LXW_COLOR_RED); format_set_font_strikeout(format); format_set_font_outline(format); format_set_font_shadow(format); format_set_font_script(format, LXW_FONT_SUPERSCRIPT); format_set_underline(format, LXW_UNDERLINE_SINGLE); styles->file = testfile; _write_font(styles, format, LXW_FALSE); RUN_XLSX_STREQ(exp, got); lxw_styles_free(styles); lxw_format_free(format); }
int main() { lxw_workbook *workbook = workbook_new("test_row_col_format15.xlsx"); lxw_worksheet *worksheet = workbook_add_worksheet(workbook, NULL); lxw_format *italic = workbook_add_format(workbook); format_set_italic(italic); worksheet_set_column(worksheet, 16383, 16383, 8.43, italic); return workbook_close(workbook); }
int main() { lxw_workbook *workbook = workbook_new("test_row_col_format05.xlsx"); lxw_worksheet *worksheet = workbook_add_worksheet(workbook, NULL); lxw_format *bold = workbook_add_format(workbook); format_set_bold(bold); lxw_format *italic = workbook_add_format(workbook); format_set_italic(italic); worksheet_set_column(worksheet, 0, 0, 8.43, bold); worksheet_set_column(worksheet, 2, 2, 8.43, italic); return workbook_close(workbook); }
// Test the _write_font() function. CTEST(styles, write_font03) { char* got; char exp[] = "<font><i/><sz val=\"11\"/><color theme=\"1\"/><name val=\"Calibri\"/><family val=\"2\"/><scheme val=\"minor\"/></font>"; FILE* testfile = lxw_tmpfile(NULL); lxw_styles *styles = lxw_styles_new(); lxw_format *format = lxw_format_new(); format_set_italic(format); styles->file = testfile; _write_font(styles, format, LXW_FALSE); RUN_XLSX_STREQ(exp, got); lxw_styles_free(styles); lxw_format_free(format); }
int main() { lxw_workbook *workbook = new_workbook("test_rich_string04.xlsx"); lxw_worksheet *worksheet = workbook_add_worksheet(workbook, NULL); lxw_format *bold = workbook_add_format(workbook); lxw_format *italic = workbook_add_format(workbook); format_set_bold(bold); format_set_italic(italic); worksheet_write_string(worksheet, CELL("A1"), "Foo", bold); worksheet_write_string(worksheet, CELL("A2"), "Bar", italic); lxw_rich_string_tuple fragment1 = {.format = bold, .string = "abc"}; lxw_rich_string_tuple fragment2 = {.format = italic, .string = "defg"}; lxw_rich_string_tuple *rich_strings[] = {&fragment1, &fragment2, NULL}; worksheet_write_rich_string(worksheet, CELL("A3"), rich_strings, NULL); return workbook_close(workbook); }