C++ (Cpp) worksheet_write_url示例

示例#1

文件： test_hyperlink18.c 项目： douuubt/libxlsxwriter

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);
}

示例#2

文件： test_escapes07.c 项目： JanX2/libxlsxwriter

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);
}

示例#3

文件： test_hyperlink16.c 项目： douuubt/libxlsxwriter

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);
}

示例#4

文件： test_escapes04.c 项目： JanX2/libxlsxwriter

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);
}

示例#5

文件： test_hyperlink01.c 项目： JanX2/libxlsxwriter

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);
}

示例#6

文件： test_hyperlink07.c 项目： jmcnamara/libxlsxwriter

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);
}

示例#7

文件： test_hyperlink17.c 项目： JanX2/libxlsxwriter

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);
}

示例#8

文件： test_hyperlink10.c 项目： JanX2/libxlsxwriter

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);
}