Feature request: workbook_add_vba_project() about libxlsxwriter HOT 5 CLOSED

+1

from libxlsxwriter.

Since I've had a few requests about this I've added a note about making donations to prioritize this feature.

from libxlsxwriter.

I've pushed an initial version of this to master. You will have to use the Python vba_extract utility (installed with xlsxwriter) for now.

Here is an example:

#include "xlsxwriter.h"

int main() {

    lxw_workbook  *workbook  = new_workbook("test_macro01.xlsm");
    lxw_worksheet *worksheet = workbook_add_worksheet(workbook, NULL);

    workbook_add_vba_project(workbook, "vbaProject01.bin");

    worksheet_write_number(worksheet, CELL("A1"), 123 , NULL);

    return workbook_close(workbook);
}

from libxlsxwriter.

Added docs and an example file.

from libxlsxwriter.

Added in version 0.8.7. See https://libxlsxwriter.github.io/working_with_macros.html

from libxlsxwriter.