如何使用openxml在excel中插入注释 [英] How to insert comments in excel using openxml

问题描述

任何人都可以解释如何以编程方式向评论单元添加评论，还请提供一个工作示例吗？我尝试创建vml绘图和注释部分，但它不起作用，我得到一个损坏的Excel工作表。

Can anyone please explain how to add comments to cell programatically , Also please provide a working example? I tried by creating the vml drawing and comments part , but it's not working , I'm getting a corrupted excel sheet.

谢谢！

推荐答案

你好Jack9999，

感谢您在MSDN论坛上发帖。

在本期中，您需要在WorksheetPart中创建一个WorksheetCommentsPart和一个VmlDrawingPart，它将发表评论。在WorksheetCommentsPart中有以下层次结构：WorksheetCommentPart-> Commnets-> autors / commentList，autors-> Author，commentList-> comment-> CommentText-> Run-> Text。
Commnet内容文本将在Text节点下。我将邀请一些专家来解决这个问题，他们是vml语言的家庭，可以帮助您解决问题。可能会有一些时间延迟。感谢您的耐心等待。

Hi Jack9999,
Thanks for posting in the MSDN Forum.
In this issue you need create a WorksheetCommentsPart and a VmlDrawingPart in the WorksheetPart which will have comment. in the WorksheetCommentsPart have following hierarchy: WorksheetCommentPart->Commnets->autors/commentList,autors->Author,commentList->comment->CommentText->Run->Text. the Commnet content text will under Text node. I will invovle some experts into this issue who are family with vml language to help you solve your issue. There might be some time delay. Appreciate for your patience.

祝您有个美好的一天，

Tom

这篇关于如何使用openxml在excel中插入注释的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！