recipe xlsx an comments

Fredo70

Hi
I am trying to insert comments in an Excel sheet.
I analysed a file and found that the comments are in two files:
xl/threadedComments/threadedComment1.xml
and
xl/comments1.xml
I can add the XML code and the files seems to be ok. But Excel wont show the comment. It removes it automatically in xl/comments1.xml.
Further I found that a comment has an attribute shapeId.

<comment ref="A1" authorId="0" shapeId="0" xr:uid="{AD9B68F3-9264-4B43-BE6B-2456B4FCB508}">
...
</comment>

The shapeId references a shape in the file xl/drawings/vmlDrawing1.vml. This file is not XML. So I cannot manipulate it with the helpers.
Or is there a way to manipulate this file?
Or am I doing something completely wrong and there is another possibility?
I'm afraid you say I have to program my own helper :-)

Many thanks

Fredo70

I've done it. It's a little bit complicated, though. So I'd be happy to explain it in detail here, but only if anyone's interested.

In a nutshell:
I simply generated the whole vml. This thread helped me: https://stackoverflow.com/questions/3494856/how-to-add-a-comment-to-a-cell-in-excel-2007-using-the-open-xml-sdk-2-0/20740684

Then I had to feed the files xl/comments1.xml, xl/persons/person.xml and xl/threadedComments/threadedComment1.xml with appropriate data.