How to add list dropdown validation type for a cell.

[amfazlani]

Thank you for this great gem! I had a quick question about how to add a list data type inside a cell for example where user can only select from a, b, and c and its a dropdown list.

[amfazlani]

Hi, just following up on this question as it is very important to the feature I am building. I have been trying to look through the docs of libxlsxwriter and have found this https://libxlsxwriter.github.io/data_validate_8c-example.html

worksheet_write_string(worksheet,
                           CELL("A13"),
                           "Select a value from a drop down list",
                           NULL);

    char *list[] = {"open", "high", "close", NULL};

    data_validation->validate   = LXW_VALIDATION_TYPE_LIST;
    data_validation->value_list = list;

    worksheet_data_validation_cell(worksheet, CELL("B13"), data_validation);

But it doesnt seem to have that method on the Libxlsxwriter module. Would you be able to show me a workaround to add a dropdown list in a cell? Thank you.