int main() { lxw_workbook *workbook = new_workbook("test_hyperlink18.xlsx"); lxw_worksheet *worksheet = workbook_add_worksheet(workbook, NULL); worksheet_write_url(worksheet, CELL("A1"), "http://google.com/00000000001111111111222222222233333333334444444444555555555566666666666777777777778888888888999999999990000000000111111111122222222223333333333444444444455555555556666666666677777777777888888888899999999999000000000011111111112222222222x", NULL); /* This longer url should be ignored. */ worksheet_write_url(worksheet, CELL("A1"), "http://google.com/00000000001111111111222222222233333333334444444444555555555566666666666777777777778888888888999999999990000000000111111111122222222223333333333444444444455555555556666666666677777777777888888888899999999999000000000011111111112222222222xy", NULL); return workbook_close(workbook); }
int main() { lxw_workbook *workbook = workbook_new("test_escapes07.xlsx"); lxw_worksheet *worksheet = workbook_add_worksheet(workbook, NULL); worksheet_write_url(worksheet, CELL("A1"), "http://example.com/!\"$%&'( )*+,-./0123456789:;<=>?@ABCDEFGHIJKLMNOPQRSTUVWXYZ[\\]^_`abcdefghijklmnopqrstuvwxyz{|}~", NULL); return workbook_close(workbook); }
int main() { lxw_workbook *workbook = new_workbook("test_hyperlink16.xlsx"); lxw_worksheet *worksheet = workbook_add_worksheet(workbook, NULL); worksheet_write_url(worksheet, CELL("B2"), "external:./subdir/blank.xlsx", NULL); return workbook_close(workbook); }
int main() { lxw_workbook *workbook = workbook_new("test_escapes04.xlsx"); lxw_worksheet *worksheet = workbook_add_worksheet(workbook, NULL); worksheet_write_url(worksheet, CELL("A1"), "http://www.perl.com/?a=1&b=2" , NULL); return workbook_close(workbook); }
int main() { lxw_workbook *workbook = workbook_new("test_hyperlink01.xlsx"); lxw_worksheet *worksheet = workbook_add_worksheet(workbook, NULL); worksheet_write_url(worksheet, CELL("A1"), "http://www.perl.org/" , NULL); return workbook_close(workbook); }
int main() { lxw_workbook *workbook = workbook_new("test_hyperlink07.xlsx"); lxw_worksheet *worksheet = workbook_add_worksheet(workbook, NULL); worksheet_write_url_opt(worksheet, CELL("A1"), "external:\\\\VBOXSVR\\share\\foo.xlsx", NULL, "J:\\foo.xlsx", NULL); worksheet_write_url( worksheet, CELL("A3"), "external:foo.xlsx" , NULL); return workbook_close(workbook); }
int main() { lxw_workbook *workbook = workbook_new("test_hyperlink17.xlsx"); lxw_worksheet *worksheet = workbook_add_worksheet(workbook, NULL); /* URL with whitespace. */ worksheet_write_url(worksheet, CELL("A1"), "http://google.com/some link", NULL); return workbook_close(workbook); }
int main() { lxw_workbook *workbook = workbook_new("test_hyperlink10.xlsx"); lxw_worksheet *worksheet = workbook_add_worksheet(workbook, NULL); lxw_format *format = workbook_add_format(workbook); format_set_underline(format, LXW_UNDERLINE_SINGLE); format_set_font_color(format, LXW_COLOR_RED); worksheet_write_url(worksheet, CELL("A1"), "http://www.perl.org/", format); return workbook_close(workbook); }