Feature request: worksheet_write_comment() about libxlsxwriter HOT 10 CLOSED

I would be willing to look into this feature. I need this to process my excel files. Let me know if I can help.

from libxlsxwriter.

Let me know if I can help.

Thanks for the offer. Libxlsxwriter is mainly a port of the Python and Perl libraries that I wrote. I have the tests, docs and an API so in general I don't need help.

What I do need is time to work on it and I've had even less of that recently than usual.

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.

+1

from libxlsxwriter.

can libxlsxwriter support the function of write_comments now ?

from libxlsxwriter.

@sevenyang2019 No. This issue would be closed if it was completed or updated if there was some progress.

from libxlsxwriter.

The initial version of comment support is available on the "vml" branch. You can now add comments to libxlsxwriter cells as follows:

#include "xlsxwriter.h"

int main() {

    lxw_workbook  *workbook  = workbook_new("comments1.xlsx");
    lxw_worksheet *worksheet = workbook_add_worksheet(workbook, NULL);

    worksheet_write_string( worksheet, 0, 0, "Hello" , NULL);

    worksheet_write_comment(worksheet, 0, 0, "This is a comment");

    return workbook_close(workbook);
}

And get output like this:

It only works when lxw_workbook_options constant_memory = LXW_FALSE (which is the default).

I'll be adding more options and documentation in the next week or so but if anyone is feeling brave and would like to try it let me know how you get on.

The eventual functionality will be like XlsxWriter: https://xlsxwriter.readthedocs.io/working_with_cell_comments.html

from libxlsxwriter.

I've added some additional functionality, more tests, and merged this up to master. Docs and further examples to be added. Note, please don't use the vml branch anymore since it has an issue.

from libxlsxwriter.

The final version of this feature is now on master with docs and examples if anyone wants to try it. I will push it out to the packagers in the next few days.

from libxlsxwriter.

Upstream in version 0.92/0.93.

from libxlsxwriter.