{"id":12287,"date":"2019-07-17T09:24:20","date_gmt":"2019-07-17T00:24:20","guid":{"rendered":"https:\/\/elleneast.com\/?p=12287"},"modified":"2019-12-06T18:39:40","modified_gmt":"2019-12-06T09:39:40","slug":"%e3%80%90vb-net%e3%80%91closedxml%ef%bc%9a%e3%82%b3%e3%83%a1%e3%83%b3%e3%83%88","status":"publish","type":"post","link":"https:\/\/elleneast.com\/?p=12287","title":{"rendered":"\u3010VB.NET\u3011ClosedXML\uff1a\u30b3\u30e1\u30f3\u30c8"},"content":{"rendered":"[include-page id=\u201d11760\u2033]\n<\/p>\n<div class=\"memo \">\n<div class=\"memo_ttl dfont\"> \u30b3\u30e1\u30f3\u30c8\u3068\u30e1\u30e2\u306e\u540d\u79f0\u306b\u3064\u3044\u3066<\/div>\n<p>&nbsp;<\/p>\n<p><a href=\"https:\/\/elleneast.com\/wp\/wp-content\/uploads\/programming_topics\/ClosedXML\/comment.png\"><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-12579 bigshadow\" src=\"https:\/\/elleneast.com\/wp\/wp-content\/uploads\/programming_topics\/ClosedXML\/comment.png\" alt=\"\" width=\"333\" height=\"394\" srcset=\"https:\/\/elleneast.com\/wp\/wp-content\/uploads\/programming_topics\/ClosedXML\/comment.png 333w, https:\/\/elleneast.com\/wp\/wp-content\/uploads\/programming_topics\/ClosedXML\/comment-254x300.png 254w\" sizes=\"auto, (max-width: 333px) 100vw, 333px\"><\/a><\/p>\n<p>&nbsp;<\/p>\n<p>\u3053\u306e\u8a18\u4e8b\u306e\u57f7\u7b46\u6642\u70b9\u3067\u79c1\uff08\u30a8\u30ec\u30f3\u30fb\u30a4\u30fc\u30b9\u30c8\uff09\u304c\u4f7f\u7528\u3057\u3066\u3044\u308b Excel \u306f Office 365 Solo \u306e\u4e00\u90e8\u3067\u3042\u308a\u3001\u30d0\u30fc\u30b8\u30e7\u30f3\u306f 1906 \u3067\u3059\u3002<\/p>\n<p>&nbsp;<\/p>\n<p>\u3053\u306e\u8a18\u4e8b\u3067\u89e3\u8aac\u3057\u3066\u3044\u308b\u300c\u30b3\u30e1\u30f3\u30c8\u300d\u306f Excel VBA \u3067\u306e Comment \u307e\u305f\u306f Comments \u306b\u76f8\u5f53\u3059\u308b\u3082\u306e\u3067\u3042\u308a\u3001\u3053\u308c\u307e\u3067\u591a\u304f\u306e\u30e6\u30fc\u30b6\u30fc\u304c\u6163\u308c\u89aa\u3057\u3093\u3067\u304d\u305f\u898b\u305f\u76ee\u304c\u9ec4\u8272\u3044\u77e9\u5f62\u306e\u30b3\u30e1\u30f3\u30c8\u306e\u3053\u3068\u3067\u3059\u304c\u3001Excel 1906\uff082019\u5e746\u6708\uff09\u306e UI \u3067\u306f\u540d\u79f0\u304c\u5909\u308f\u3063\u3066\u3057\u307e\u3044\u3001\u300c\u30e1\u30e2\u300d\u3068\u547c\u3076\u3088\u3046\u306b\u306a\u3063\u305f\u3088\u3046\u3067\u3059\u3002<\/p>\n<p>\u305d\u3057\u3066\u3001Excel 1906 \u306e UI \u3067\u300c\u30b3\u30e1\u30f3\u30c8\u300d\u3068\u547c\u3093\u3067\u3044\u308b\u306e\u306f Excel VBA \u3067\u306e CommentThreaded \u307e\u305f\u306f CommentsThreaded \u306b\u76f8\u5f53\u3059\u308b\u3082\u306e\u3067\u3042\u308a\u3001\u591a\u304f\u306e\u30e6\u30fc\u30b6\u30fc\u304c\u6163\u308c\u89aa\u3057\u3093\u3067\u304d\u305f\u898b\u305f\u76ee\u3068\u3082\u7570\u306a\u308b\u3082\u306e\u3067\u3059\u3002<\/p>\n<p>&nbsp;<\/p>\n<p><a href=\"https:\/\/elleneast.com\/wp\/wp-content\/uploads\/programming_topics\/ClosedXML\/ClosedXml_144.png\"><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-12308 bigshadow\" src=\"https:\/\/elleneast.com\/wp\/wp-content\/uploads\/programming_topics\/ClosedXML\/ClosedXml_144.png\" alt=\"\" width=\"277\" height=\"129\"><\/a><\/p>\n<p>&nbsp;<\/p>\n<p><a href=\"https:\/\/elleneast.com\/wp\/wp-content\/uploads\/programming_topics\/ClosedXML\/memo_3.png\"><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-13710 bigshadow\" src=\"https:\/\/elleneast.com\/wp\/wp-content\/uploads\/programming_topics\/ClosedXML\/memo_3.png\" alt=\"\" width=\"661\" height=\"218\" srcset=\"https:\/\/elleneast.com\/wp\/wp-content\/uploads\/programming_topics\/ClosedXML\/memo_3.png 661w, https:\/\/elleneast.com\/wp\/wp-content\/uploads\/programming_topics\/ClosedXML\/memo_3-300x99.png 300w\" sizes=\"auto, (max-width: 661px) 100vw, 661px\"><\/a><\/p>\n<p>&nbsp;<\/p>\n<p><a href=\"https:\/\/elleneast.com\/wp\/wp-content\/uploads\/programming_topics\/ClosedXML\/ClosedXml_139.png\"><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-12290 bigshadow\" src=\"https:\/\/elleneast.com\/wp\/wp-content\/uploads\/programming_topics\/ClosedXML\/ClosedXml_139.png\" alt=\"\" width=\"535\" height=\"354\" srcset=\"https:\/\/elleneast.com\/wp\/wp-content\/uploads\/programming_topics\/ClosedXML\/ClosedXml_139.png 535w, https:\/\/elleneast.com\/wp\/wp-content\/uploads\/programming_topics\/ClosedXML\/ClosedXml_139-300x199.png 300w\" sizes=\"auto, (max-width: 535px) 100vw, 535px\"><\/a><\/p>\n<p>&nbsp;<\/p>\n<p>\u305f\u3060\u3057\u300c\u30e1\u30e2\u300d\u306e\u66f8\u5f0f\u8a2d\u5b9a\u30c0\u30a4\u30a2\u30ed\u30b0\u306b\u306f\u76f8\u5909\u308f\u3089\u305a\u300c\u30b3\u30e1\u30f3\u30c8\u300d\u3068\u8868\u793a\u3055\u308c\u3066\u3044\u305f\u308a\u3057\u307e\u3059\u3002\u3084\u3084\u3053\u3057\u3044\u3067\u3059\u306d\uff01\uff01<\/p>\n<p><a href=\"https:\/\/elleneast.com\/wp\/wp-content\/uploads\/programming_topics\/ClosedXML\/memo_1.png\"><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-13705 bigshadow\" src=\"https:\/\/elleneast.com\/wp\/wp-content\/uploads\/programming_topics\/ClosedXML\/memo_1.png\" alt=\"\" width=\"314\" height=\"475\" srcset=\"https:\/\/elleneast.com\/wp\/wp-content\/uploads\/programming_topics\/ClosedXML\/memo_1.png 314w, https:\/\/elleneast.com\/wp\/wp-content\/uploads\/programming_topics\/ClosedXML\/memo_1-198x300.png 198w\" sizes=\"auto, (max-width: 314px) 100vw, 314px\"><\/a><\/p>\n<p>\u2191\u300c\u30e1\u30e2\u300d\u3068\u547c\u3076\u3088\u3046\u306b\u306a\u3063\u305f\u306f\u305a\u306e\u30aa\u30d6\u30b8\u30a7\u30af\u30c8\u306e\u67a0\u7dda\u4e0a\u3067\u53f3\u30af\u30ea\u30c3\u30af\u3059\u308b\u3068\u3001<br \/>\n\u2193\u300c\u30b3\u30e1\u30f3\u30c8\u300d\u306e\u66f8\u5f0f\u8a2d\u5b9a\u304c\u8868\u793a\u3055\u308c\u308b\u3002<\/p>\n<p><a href=\"https:\/\/elleneast.com\/wp\/wp-content\/uploads\/programming_topics\/ClosedXML\/memo_2.png\"><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-13706 bigshadow\" src=\"https:\/\/elleneast.com\/wp\/wp-content\/uploads\/programming_topics\/ClosedXML\/memo_2.png\" alt=\"\" width=\"527\" height=\"256\" srcset=\"https:\/\/elleneast.com\/wp\/wp-content\/uploads\/programming_topics\/ClosedXML\/memo_2.png 527w, https:\/\/elleneast.com\/wp\/wp-content\/uploads\/programming_topics\/ClosedXML\/memo_2-300x146.png 300w\" sizes=\"auto, (max-width: 527px) 100vw, 527px\"><\/a><\/p>\n<p>&nbsp;<\/p>\n<p>\u3053\u306e\u8a18\u4e8b\u306e\u4e2d\u3067\u306f\u3068\u308a\u3042\u3048\u305a\u5f93\u6765\u901a\u308a\u3001\u9ec4\u8272\u306e\u77e9\u5f62\u306e Comment \/ Comments \u306e\u3053\u3068\u3092\u300c\u30b3\u30e1\u30f3\u30c8\u300d\u3068\u547c\u3076\u3053\u3068\u306b\u3057\u307e\u3059\u3002<\/p>\n<\/p>\n<\/div>\n<div id=\"ez-toc-container\" class=\"ez-toc-v2_0_83 counter-hierarchy ez-toc-counter ez-toc-grey ez-toc-container-direction\">\n<div class=\"ez-toc-title-container\">\n<p class=\"ez-toc-title\" style=\"cursor:inherit\">\u76ee\u6b21<\/p>\n<span class=\"ez-toc-title-toggle\"><a href=\"#\" class=\"ez-toc-pull-right ez-toc-btn ez-toc-btn-xs ez-toc-btn-default ez-toc-toggle\" aria-label=\"Toggle Table of Content\"><span class=\"ez-toc-js-icon-con\"><span class=\"\"><span class=\"eztoc-hide\" style=\"display:none;\">Toggle<\/span><span class=\"ez-toc-icon-toggle-span\"><svg style=\"fill: #999;color:#999\" xmlns=\"http:\/\/www.w3.org\/2000\/svg\" class=\"list-377408\" width=\"20px\" height=\"20px\" viewBox=\"0 0 24 24\" fill=\"none\"><path d=\"M6 6H4v2h2V6zm14 0H8v2h12V6zM4 11h2v2H4v-2zm16 0H8v2h12v-2zM4 16h2v2H4v-2zm16 0H8v2h12v-2z\" fill=\"currentColor\"><\/path><\/svg><svg style=\"fill: #999;color:#999\" class=\"arrow-unsorted-368013\" xmlns=\"http:\/\/www.w3.org\/2000\/svg\" width=\"10px\" height=\"10px\" viewBox=\"0 0 24 24\" version=\"1.2\" baseProfile=\"tiny\"><path d=\"M18.2 9.3l-6.2-6.3-6.2 6.3c-.2.2-.3.4-.3.7s.1.5.3.7c.2.2.4.3.7.3h11c.3 0 .5-.1.7-.3.2-.2.3-.5.3-.7s-.1-.5-.3-.7zM5.8 14.7l6.2 6.3 6.2-6.3c.2-.2.3-.5.3-.7s-.1-.5-.3-.7c-.2-.2-.4-.3-.7-.3h-11c-.3 0-.5.1-.7.3-.2.2-.3.5-.3.7s.1.5.3.7z\"\/><\/svg><\/span><\/span><\/span><\/a><\/span><\/div>\n<nav><ul class='ez-toc-list ez-toc-list-level-1 ' ><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-1\" href=\"https:\/\/elleneast.com\/?p=12287\/#%E3%82%B3%E3%83%A1%E3%83%B3%E3%83%88%E3%81%AE%E8%A1%A8%E7%A4%BA%E7%8A%B6%E6%85%8B\" >\u30b3\u30e1\u30f3\u30c8\u306e\u8868\u793a\u72b6\u614b<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-2\" href=\"https:\/\/elleneast.com\/?p=12287\/#%E3%82%B3%E3%83%A1%E3%83%B3%E3%83%88%E3%81%AE%E4%BD%8D%E7%BD%AE\" >\u30b3\u30e1\u30f3\u30c8\u306e\u4f4d\u7f6e<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-3\" href=\"https:\/\/elleneast.com\/?p=12287\/#%E3%82%B3%E3%83%A1%E3%83%B3%E3%83%88%E3%81%AE%E4%BD%9C%E6%88%90%E8%80%85\" >\u30b3\u30e1\u30f3\u30c8\u306e\u4f5c\u6210\u8005<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-4\" href=\"https:\/\/elleneast.com\/?p=12287\/#%E3%82%B3%E3%83%A1%E3%83%B3%E3%83%88%E3%81%AE%E9%85%8D%E7%BD%AE%EF%BC%88%E3%82%A2%E3%83%A9%E3%82%A4%E3%83%B3%E3%83%A1%E3%83%B3%E3%83%88%EF%BC%89\" >\u30b3\u30e1\u30f3\u30c8\u306e\u914d\u7f6e\uff08\u30a2\u30e9\u30a4\u30f3\u30e1\u30f3\u30c8\uff09<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-5\" href=\"https:\/\/elleneast.com\/?p=12287\/#%E8%89%B2%E3%81%A8%E7%B7%9A\" >\u8272\u3068\u7dda<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-6\" href=\"https:\/\/elleneast.com\/?p=12287\/#%E3%82%B3%E3%83%A1%E3%83%B3%E3%83%88%E3%81%AE%E3%82%B5%E3%82%A4%E3%82%BA\" >\u30b3\u30e1\u30f3\u30c8\u306e\u30b5\u30a4\u30ba<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-7\" href=\"https:\/\/elleneast.com\/?p=12287\/#%E3%82%B3%E3%83%A1%E3%83%B3%E3%83%88%E3%81%AE%E4%BF%9D%E8%AD%B7\" >\u30b3\u30e1\u30f3\u30c8\u306e\u4fdd\u8b77<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-8\" href=\"https:\/\/elleneast.com\/?p=12287\/#%E3%82%B3%E3%83%A1%E3%83%B3%E3%83%88%E3%81%AE%E3%83%97%E3%83%AD%E3%83%91%E3%83%86%E3%82%A3\" >\u30b3\u30e1\u30f3\u30c8\u306e\u30d7\u30ed\u30d1\u30c6\u30a3<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-9\" href=\"https:\/\/elleneast.com\/?p=12287\/#%E3%82%B3%E3%83%A1%E3%83%B3%E3%83%88%E3%81%AE%E4%BD%99%E7%99%BD\" >\u30b3\u30e1\u30f3\u30c8\u306e\u4f59\u767d<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-10\" href=\"https:\/\/elleneast.com\/?p=12287\/#%E3%82%B3%E3%83%A1%E3%83%B3%E3%83%88%E3%81%AE%E4%BB%A3%E6%9B%BF%E3%83%86%E3%82%AD%E3%82%B9%E3%83%88\" >\u30b3\u30e1\u30f3\u30c8\u306e\u4ee3\u66ff\u30c6\u30ad\u30b9\u30c8<\/a><\/li><\/ul><\/nav><\/div>\n<h2 id=\"i-0\"><span class=\"ez-toc-section\" id=\"%E3%82%B3%E3%83%A1%E3%83%B3%E3%83%88%E3%81%AE%E8%A1%A8%E7%A4%BA%E7%8A%B6%E6%85%8B\"><\/span>\u30b3\u30e1\u30f3\u30c8\u306e\u8868\u793a\u72b6\u614b<span class=\"ez-toc-section-end\"><\/span><\/h2>\n<pre class=\"lang:vbnet decode:true \">Dim wb = New XLWorkbook\nDim ws = wb.Worksheets.Add(\"\u30b3\u30e1\u30f3\u30c8\u306e\u8868\u793a\u72b6\u614b\")\n\n'\u30c7\u30d5\u30a9\u30eb\u30c8\u3067\u306f\u30b3\u30e1\u30f3\u30c8\u306f\u975e\u8868\u793a\u3067\u3059\nws.Cell(\"A1\").SetValue(\"\u975e\u8868\u793a\u30b3\u30e1\u30f3\u30c8\u3042\u308a\").Comment.AddText(\"\u975e\u8868\u793a\")\n\n'\u30b3\u30e1\u30f3\u30c8\u3092\u8868\u793a\u3057\u305f\u72b6\u614b\u3067\u8ffd\u52a0\u3057\u307e\u3059\nws.Cell(\"A2\").Comment.SetVisible.AddText(\"\u8868\u793a\")\n\n'\u4e0a\u8a18\u30b3\u30e1\u30f3\u30c8\u306e ZOrder \u306f\u305d\u308c\u305e\u308c 1 \u3068 2 \u3067\u3059\n'\u3053\u3053\u3067\u306f ZOrder \u3092\u660e\u793a\u7684\u306b\u6307\u5b9a\u3057\u307e\u3059\nws.Cell(\"A3\").Comment.SetZOrder(5).SetVisible().AddText(\"\u6700\u524d\u9762\")\n\n'A3 \u306e\u30b3\u30e1\u30f3\u30c8\u306e\u4e0b\u306b\u30b3\u30e1\u30f3\u30c8\u3092\u8ffd\u52a0\u3059\u308b\u306b\u306f\n'A3 \u306e\u30b3\u30e1\u30f3\u30c8\u306e ZOrder \u3088\u308a\u3082\u5c0f\u3055\u306a\u5024\u3092\u6307\u5b9a\u3057\u307e\u3059\nws.Cell(\"A4\").Comment.SetZOrder(4).SetVisible().AddText(\"\u80cc\u9762\")\nws.Cell(\"A4\").Comment.Style.Alignment.SetVertical(XLDrawingVerticalAlignment.Bottom)\n\n'\u4e0b\u8a18\u306e\u3088\u3046\u306b\u3057\u3066\u3059\u3079\u3066\u306e\u30b3\u30e1\u30f3\u30c8\u3092\u8868\u793a\u3055\u305b\u308b\u3053\u3068\u304c\u3067\u304d\u307e\u3059\n'ws.CellsUsed(True, Function(c) c.HasComment).ToList.ForEach(Sub(c) c.Comment.SetVisible)\n\n'\u30b3\u30f3\u30c6\u30f3\u30c4\u306b\u5408\u308f\u305b\u3066\u5217\u5e45\u3092\u8abf\u6574\n'\uff08\u65e5\u672c\u8a9e\u306e\u30b3\u30f3\u30c6\u30f3\u30c4\u306b\u5bfe\u3057\u3066 AdjustToContents \u3092\u4f7f\u3046\u5834\u5408\u3001\u65e5\u672c\u8a9e\u30d5\u30a9\u30f3\u30c8\u3092\u8a2d\u5b9a\u3057\u3066\u304a\u304b\u306a\u3044\u3068\u6b63\u3057\u304f\u52d5\u4f5c\u3057\u306a\u3044\uff09\nws.Style.Font.FontName = \"\u6e38\u30b4\u30b7\u30c3\u30af\";\nws.Columns.AdjustToContents\n\nwb.SaveAs(\"D:\\test\\CommentsVisibility.xlsx\")<\/pre>\n<p><a href=\"https:\/\/elleneast.com\/wp\/wp-content\/uploads\/programming_topics\/ClosedXML\/ClosedXml_140.png\"><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-12299 bigshadow\" src=\"https:\/\/elleneast.com\/wp\/wp-content\/uploads\/programming_topics\/ClosedXML\/ClosedXml_140.png\" alt=\"\" width=\"349\" height=\"189\" srcset=\"https:\/\/elleneast.com\/wp\/wp-content\/uploads\/programming_topics\/ClosedXML\/ClosedXml_140.png 349w, https:\/\/elleneast.com\/wp\/wp-content\/uploads\/programming_topics\/ClosedXML\/ClosedXml_140-300x162.png 300w\" sizes=\"auto, (max-width: 349px) 100vw, 349px\"><\/a><\/p>\n<h2 id=\"i-1\"><span class=\"ez-toc-section\" id=\"%E3%82%B3%E3%83%A1%E3%83%B3%E3%83%88%E3%81%AE%E4%BD%8D%E7%BD%AE\"><\/span>\u30b3\u30e1\u30f3\u30c8\u306e\u4f4d\u7f6e<span class=\"ez-toc-section-end\"><\/span><\/h2>\n<pre class=\"lang:vbnet decode:true\">Dim wb = New XLWorkbook\nDim ws = wb.Worksheets.Add(\"\u30b3\u30e1\u30f3\u30c8\u306e\u4f4d\u7f6e\")\n\nws.Columns.Width = 10\n\nws.Cell(\"A1\").Comment.AddText(\"\u30b3\u30e1\u30f3\u30c8\u3092\u4ed8\u3051\u308b\u306b\u306f\u5909\u306a\u4f4d\u7f6e\u3067\u3059\u304c\u2026\")\nWith ws.Cell(\"A1\").Comment.Position\n  .SetColumn(3) '\uff13\u5217\u76ee\u304b\u3089\u958b\u59cb\n  .SetColumnOffset(5) '\uff13\u5217\u76ee\u306e\u4e2d\u592e\u304b\u3089\u958b\u59cb\n  .SetRow(5) '\uff15\u884c\u76ee\u304b\u3089\u958b\u59cb\n  .SetRowOffset(7.5) '\uff15\u884c\u76ee\u306e\u4e2d\u592e\u304b\u3089\u958b\u59cb\nEnd With\n\n'\u3059\u3079\u3066\u306e\u30b3\u30e1\u30f3\u30c8\u3092\u8868\u793a\nws.CellsUsed(True, Function(c) c.HasComment).ToList.ForEach(Sub(c) c.Comment.SetVisible)\n\nwb.SaveAs(\"D:\\test\\CommentsPosition.xlsx\")<\/pre>\n<p><a href=\"https:\/\/elleneast.com\/wp\/wp-content\/uploads\/programming_topics\/ClosedXML\/ClosedXml_141.png\"><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-12302 bigshadow\" src=\"https:\/\/elleneast.com\/wp\/wp-content\/uploads\/programming_topics\/ClosedXML\/ClosedXml_141.png\" alt=\"\" width=\"410\" height=\"221\" srcset=\"https:\/\/elleneast.com\/wp\/wp-content\/uploads\/programming_topics\/ClosedXML\/ClosedXml_141.png 410w, https:\/\/elleneast.com\/wp\/wp-content\/uploads\/programming_topics\/ClosedXML\/ClosedXml_141-300x162.png 300w\" sizes=\"auto, (max-width: 410px) 100vw, 410px\"><\/a><\/p>\n<h2 id=\"i-2\"><span class=\"ez-toc-section\" id=\"%E3%82%B3%E3%83%A1%E3%83%B3%E3%83%88%E3%81%AE%E4%BD%9C%E6%88%90%E8%80%85\"><\/span>\u30b3\u30e1\u30f3\u30c8\u306e\u4f5c\u6210\u8005<span class=\"ez-toc-section-end\"><\/span><\/h2>\n<pre class=\"lang:vbnet decode:true\">Dim wb = New XLWorkbook\nDim ws = wb.Worksheets.Add(\"Signatures\")\n\n'\u30c7\u30d5\u30a9\u30eb\u30c8\u3067\u306f\u30b3\u30e1\u30f3\u30c8\u306e\u4f5c\u6210\u8005\uff08Signature\uff09\u306f Office \u306e\u30e6\u30fc\u30b6\u30fc\u540d\u306b\u306a\u308a\u307e\u3059\n'ws.Cell(\"A2\").Comment.AddSignature.AddText(\"Hello World!\")\n\n'\u30b3\u30e1\u30f3\u30c8\u306e Author \u3092\u6307\u5b9a\u3057\u3066\u30c7\u30d5\u30a9\u30eb\u30c8\u5024\u3092\u4e0a\u66f8\u304d\u3067\u304d\u307e\u3059\nws.Cell(\"A2\").Comment _\n  .SetAuthor(\"\u30a8\u30ec\u30f3\u30fb\u30a4\u30fc\u30b9\u30c8\") _\n  .AddSignature _\n  .AddText(\"Hello World!\")\n\n'\u3059\u3079\u3066\u306e\u30b3\u30e1\u30f3\u30c8\u3092\u8868\u793a\nws.CellsUsed(True, Function(c) c.HasComment).ToList.ForEach(Sub(c) c.Comment.SetVisible)\n\nwb.SaveAs(\"D:\\test\\CommentsSignatures.xlsx\")<\/pre>\n<p><a href=\"https:\/\/elleneast.com\/wp\/wp-content\/uploads\/programming_topics\/ClosedXML\/ClosedXml_143.png\"><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-12305 bigshadow\" src=\"https:\/\/elleneast.com\/wp\/wp-content\/uploads\/programming_topics\/ClosedXML\/ClosedXml_143.png\" alt=\"\" width=\"294\" height=\"145\"><\/a><\/p>\n<h2 id=\"i-3\"><span class=\"ez-toc-section\" id=\"%E3%82%B3%E3%83%A1%E3%83%B3%E3%83%88%E3%81%AE%E9%85%8D%E7%BD%AE%EF%BC%88%E3%82%A2%E3%83%A9%E3%82%A4%E3%83%B3%E3%83%A1%E3%83%B3%E3%83%88%EF%BC%89\"><\/span>\u30b3\u30e1\u30f3\u30c8\u306e\u914d\u7f6e\uff08\u30a2\u30e9\u30a4\u30f3\u30e1\u30f3\u30c8\uff09<span class=\"ez-toc-section-end\"><\/span><\/h2>\n<pre class=\"lang:vbnet decode:true \">Dim wb = New XLWorkbook\nDim ws = wb.Worksheets.Add(\"\u30b3\u30e1\u30f3\u30c8\u306e\u914d\u7f6e\")\n\n'\u30b3\u30f3\u30c6\u30f3\u30c4\u306b\u30d5\u30a3\u30c3\u30c8\u3059\u308b\u3088\u3046\u306b\u81ea\u52d5\u7684\u306b\u30b3\u30e1\u30f3\u30c8\u306e\u30b5\u30a4\u30ba\u3092\u8abf\u6574\nws.Cell(\"A1\").Comment.Style.Alignment.SetAutomaticSize\nws.Cell(\"A1\").Comment.AddText(\"\u306a\u3093\u3060\u304b\u7aae\u5c48\u3060\u306d\")\n\n'\u30c7\u30d5\u30a9\u30eb\u30c8\u5024\nws.Cell(\"A3\").Comment _\n  .AddText(\"\u30c7\u30d5\u30a9\u30eb\u30c8\u306e\u914d\u7f6e\uff1a\").AddNewLine _\n  .AddText(\"\u7e26\u4f4d\u7f6e = \u4e0a\u8a70\u3081\").AddNewLine _\n  .AddText(\"\u6a2a\u4f4d\u7f6e = \u5de6\u8a70\u3081\").AddNewLine _\n  .AddText(\"\u65b9\u5411 = \u5de6\u304b\u3089\u53f3\")\n\n'\u914d\u7f6e\u3092\u5909\u3048\u3066\u307f\u308b\nws.Cell(\"A8\").Comment _\n  .AddText(\"\u7e26\u4f4d\u7f6e = \u4e0b\u8a70\u3081\").AddNewLine _\n  .AddText(\"\u6a2a\u4f4d\u7f6e = \u53f3\u8a70\u3081\")\nws.Cell(\"A8\").Comment.Style _\n  .Alignment.SetVertical(XLDrawingVerticalAlignment.Bottom) _\n  .Alignment.SetHorizontal(XLDrawingHorizontalAlignment.Right)\n\n'\u65b9\u5411\u3092\u5909\u3048\u3066\u307f\u308b\nws.Cell(\"D3\").Comment.AddText(\"\u65b9\u5411 = \u4e0b\u304b\u3089\u4e0a\")\nws.Cell(\"D3\").Comment.Style _\n  .Alignment.SetOrientation(XLDrawingTextOrientation.BottomToTop) _\n  .Alignment.SetAutomaticSize\n\nws.Cell(\"E3\").Comment.AddText(\"\u65b9\u5411 = \u4e0a\u304b\u3089\u4e0b\")\nws.Cell(\"E3\").Comment.Style _\n  .Alignment.SetOrientation(XLDrawingTextOrientation.TopToBottom) _\n  .Alignment.SetAutomaticSize\n\nws.Cell(\"F3\").Comment.AddText(\"\u65b9\u5411 = \u7e26\u66f8\u304d\")\nws.Cell(\"F3\").Comment.Style _\n  .Alignment.SetOrientation(XLDrawingTextOrientation.Vertical) _\n  .Alignment.SetAutomaticSize\n\n'\u3059\u3079\u3066\u306e\u30b3\u30e1\u30f3\u30c8\u3092\u8868\u793a\nws.CellsUsed(True, Function(c) c.HasComment).ToList.ForEach(Sub(c) c.Comment.SetVisible)\n\nwb.SaveAs(\"D:\\test\\CommentsAlignment.xlsx\")<\/pre>\n<p><a href=\"https:\/\/elleneast.com\/wp\/wp-content\/uploads\/programming_topics\/ClosedXML\/ClosedXml_145.png\"><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-12311 bigshadow\" src=\"https:\/\/elleneast.com\/wp\/wp-content\/uploads\/programming_topics\/ClosedXML\/ClosedXml_145.png\" alt=\"\" width=\"567\" height=\"299\" srcset=\"https:\/\/elleneast.com\/wp\/wp-content\/uploads\/programming_topics\/ClosedXML\/ClosedXml_145.png 567w, https:\/\/elleneast.com\/wp\/wp-content\/uploads\/programming_topics\/ClosedXML\/ClosedXml_145-300x158.png 300w\" sizes=\"auto, (max-width: 567px) 100vw, 567px\"><\/a><\/p>\n<h2 id=\"i-4\"><span class=\"ez-toc-section\" id=\"%E8%89%B2%E3%81%A8%E7%B7%9A\"><\/span>\u8272\u3068\u7dda<span class=\"ez-toc-section-end\"><\/span><\/h2>\n<pre class=\"lang:vbnet decode:true \">Dim wb = New XLWorkbook\nDim ws = wb.Worksheets.Add(\"\u30b3\u30e1\u30f3\u30c8\u306e\u8272\u3068\u7dda\")\n\nws.Cell(\"A2\").Comment _\n  .AddText(\"\u30ab\u30e9\u30d5\u30eb\u306a\") _\n  .AddText(\"\u30b3\u30e1\u30f3\u30c8\").SetBold().SetFontColor(XLColor.Red) _\n  .AddText(\"\u306b\u306a\u308a\u307e\u3057\u305f\uff01\")\n\nWith ws.Cell(\"A2\").Comment.Style\n  .ColorsAndLines.SetFillColor(XLColor.RichCarmine) '\u5857\u308a\u3064\u3076\u3057\u306e\u8272\n  .ColorsAndLines.SetFillTransparency(0.25) '\u5857\u308a\u3064\u3076\u3057\u306e\u4e0d\u900f\u660e\u5ea6 25%\uff08\u900f\u660e\u5ea675%\uff09\n  .ColorsAndLines.SetLineColor(XLColor.Blue) '\u7dda\u306e\u8272\n  .ColorsAndLines.SetLineTransparency(0.75) '\u7dda\u306e\u4e0d\u900f\u660e\u5ea6 75%\uff08\u900f\u660e\u5ea625%\uff09\n  .ColorsAndLines.SetLineDash(XLDashStyle.LongDash) '\u7dda\u306e\u30b9\u30bf\u30a4\u30eb\n  .ColorsAndLines.SetLineStyle(XLLineStyle.ThickBetweenThin) '\u5b9f\u7dda\uff0f\u70b9\u7dda\n  .ColorsAndLines.SetLineWeight(7.5) '\u7dda\u306e\u592a\u3055\nEnd With\n\n'\u3059\u3079\u3066\u306e\u30b3\u30e1\u30f3\u30c8\u3092\u8868\u793a\nws.CellsUsed(True, Function(c) c.HasComment).ToList.ForEach(Sub(c) c.Comment.SetVisible)\n\nwb.SaveAs(\"D:\\test\\CommentsColorsAndLines.xlsx\")<\/pre>\n<p><a href=\"https:\/\/elleneast.com\/wp\/wp-content\/uploads\/programming_topics\/ClosedXML\/ClosedXml_146.png\"><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-12314 bigshadow\" src=\"https:\/\/elleneast.com\/wp\/wp-content\/uploads\/programming_topics\/ClosedXML\/ClosedXml_146.png\" alt=\"\" width=\"325\" height=\"147\" srcset=\"https:\/\/elleneast.com\/wp\/wp-content\/uploads\/programming_topics\/ClosedXML\/ClosedXml_146.png 325w, https:\/\/elleneast.com\/wp\/wp-content\/uploads\/programming_topics\/ClosedXML\/ClosedXml_146-300x136.png 300w\" sizes=\"auto, (max-width: 325px) 100vw, 325px\"><\/a><\/p>\n<h2 id=\"i-5\"><span class=\"ez-toc-section\" id=\"%E3%82%B3%E3%83%A1%E3%83%B3%E3%83%88%E3%81%AE%E3%82%B5%E3%82%A4%E3%82%BA\"><\/span>\u30b3\u30e1\u30f3\u30c8\u306e\u30b5\u30a4\u30ba<span class=\"ez-toc-section-end\"><\/span><\/h2>\n<pre class=\"lang:vbnet decode:true \">Dim wb = New XLWorkbook\nDim ws = wb.Worksheets.Add(\"\u30b3\u30e1\u30f3\u30c8\u306e\u30b5\u30a4\u30ba\")\n\n'comment.Style.Size.Automatic(SetAutomaticSize) \u306f\n'comment.Style.Alignment.AutomaticSize \u3068\u540c\u3058\u3082\u306e\u3067\u3059\u3002\n'Excel \u306e UI \u3067\u306f\u30b3\u30e1\u30f3\u30c8\u30b5\u30a4\u30ba\u306e\u81ea\u52d5\u8abf\u6574\u30aa\u30d7\u30b7\u30e7\u30f3\u306f\n'\uff3b\u914d\u7f6e\uff3d\u30bf\u30d6\u306b\u3042\u308a\u307e\u3059\u304c\uff08.Alignment.AutomaticSize\uff09\n'\uff3b\u30b5\u30a4\u30ba\uff3d\u30bf\u30d6\u306e\u4e0b\u306b\u3042\u308b\u307b\u3046\u304c\u81ea\u7136\u306a\u306e\u3067\n'.Size.AutomaticSize \u30d7\u30ed\u30d1\u30c6\u30a3\u3092\u7528\u610f\u3057\u307e\u3057\u305f\u3002\nws.Cell(\"A2\").Comment.AddText(\"\u306a\u3093\u304b\u7aae\u5c48\u3060\u3088\u306d\")\nws.Cell(\"A2\").Comment.Style.Size.SetAutomaticSize\n\nws.Cell(\"A4\").Comment.AddText(\"\u30b5\u30a4\u30ba\u3092\u5909\u3048\u3066\u307f\u307e\u3059\")\nWith ws.Cell(\"A4\").Comment.Style\n    '\u5358\u4f4d\u306f\uff08\u884c\u306e\u9ad8\u3055\u306e\u5358\u4f4d\u3068\u540c\u3058\u304f\uff09\u30dd\u30a4\u30f3\u30c8\n    .Size.SetHeight(30) \n    '\u5358\u4f4d\u306f\uff08\u5217\u306e\u5e45\u306e\u5358\u4f4d\u3068\u540c\u3058\u304f\uff09\"0\" \u3092\u8868\u793a\u3067\u304d\u308b\u6570\n    '\uff08\u305f\u3068\u3048\u3070 3 \u3092\u6307\u5b9a\u3057\u305f\u5834\u5408\u306f \"000\" \u3068\u540c\u3058\u5e45\uff09\n    .Size.SetWidth(30)  \nEnd With\n'\u306a\u304a\u3001\u65e5\u672c\u8a9e\u7248Excel\u306e\uff3b\u30b3\u30e1\u30f3\u30c8\u306e\u66f8\u5f0f\u8a2d\u5b9a\uff3d\u30c0\u30a4\u30a2\u30ed\u30b0\u306e\n'\uff3b\u30b5\u30a4\u30ba\uff3d\u30bf\u30d6\u3067\u306f\u3001\u30c7\u30d5\u30a9\u30eb\u30c8\u306e\u5358\u4f4d\u304c cm \u306b\u306a\u3063\u3066\u3044\u308b\u3068\u601d\u3044\u307e\u3059\u3002\n\n'\u3059\u3079\u3066\u306e\u30b3\u30e1\u30f3\u30c8\u3092\u8868\u793a\nws.CellsUsed(True, Function(c) c.HasComment).ToList.ForEach(Sub(c) c.Comment.SetVisible)\n\nwb.SaveAs(\"D:\\test\\CommentsSize.xlsx\")<\/pre>\n<p><a href=\"https:\/\/elleneast.com\/wp\/wp-content\/uploads\/programming_topics\/ClosedXML\/ClosedXml_147.png\"><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-12317 bigshadow\" src=\"https:\/\/elleneast.com\/wp\/wp-content\/uploads\/programming_topics\/ClosedXML\/ClosedXml_147.png\" alt=\"\" width=\"440\" height=\"167\" srcset=\"https:\/\/elleneast.com\/wp\/wp-content\/uploads\/programming_topics\/ClosedXML\/ClosedXml_147.png 440w, https:\/\/elleneast.com\/wp\/wp-content\/uploads\/programming_topics\/ClosedXML\/ClosedXml_147-300x114.png 300w\" sizes=\"auto, (max-width: 440px) 100vw, 440px\"><\/a><\/p>\n<h2 id=\"i-6\"><span class=\"ez-toc-section\" id=\"%E3%82%B3%E3%83%A1%E3%83%B3%E3%83%88%E3%81%AE%E4%BF%9D%E8%AD%B7\"><\/span>\u30b3\u30e1\u30f3\u30c8\u306e\u4fdd\u8b77<span class=\"ez-toc-section-end\"><\/span><\/h2>\n<pre class=\"lang:vbnet decode:true \">Dim wb = New XLWorkbook\nDim ws = wb.Worksheets.Add(\"\u30b3\u30e1\u30f3\u30c8\u306e\u4fdd\u8b77\")\n\nWith ws.Cell(\"A1\").Comment\n    .SetVisible.AddText(\"(*^\u25bd^*)\")\n    With .Style\n        .Protection.SetLocked(False) '\u30ed\u30c3\u30af\u306e\u89e3\u9664\n        .Protection.SetLockText(False) '\u6587\u5b57\u5217\u306e\u30ed\u30c3\u30af\u306e\u89e3\u9664\n    End With\nEnd With\n\nwb.SaveAs(\"D:\\test\\CommentsProtection.xlsx\")<\/pre>\n<p><a href=\"https:\/\/elleneast.com\/wp\/wp-content\/uploads\/programming_topics\/ClosedXML\/ClosedXml_148.png\"><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-12320 bigshadow\" src=\"https:\/\/elleneast.com\/wp\/wp-content\/uploads\/programming_topics\/ClosedXML\/ClosedXml_148.png\" alt=\"\" width=\"480\" height=\"479\" srcset=\"https:\/\/elleneast.com\/wp\/wp-content\/uploads\/programming_topics\/ClosedXML\/ClosedXml_148.png 480w, https:\/\/elleneast.com\/wp\/wp-content\/uploads\/programming_topics\/ClosedXML\/ClosedXml_148-150x150.png 150w, https:\/\/elleneast.com\/wp\/wp-content\/uploads\/programming_topics\/ClosedXML\/ClosedXml_148-300x300.png 300w, https:\/\/elleneast.com\/wp\/wp-content\/uploads\/programming_topics\/ClosedXML\/ClosedXml_148-125x125.png 125w, https:\/\/elleneast.com\/wp\/wp-content\/uploads\/programming_topics\/ClosedXML\/ClosedXml_148-160x160.png 160w\" sizes=\"auto, (max-width: 480px) 100vw, 480px\"><\/a><\/p>\n<h2 id=\"i-7\"><span class=\"ez-toc-section\" id=\"%E3%82%B3%E3%83%A1%E3%83%B3%E3%83%88%E3%81%AE%E3%83%97%E3%83%AD%E3%83%91%E3%83%86%E3%82%A3\"><\/span>\u30b3\u30e1\u30f3\u30c8\u306e\u30d7\u30ed\u30d1\u30c6\u30a3<span class=\"ez-toc-section-end\"><\/span><\/h2>\n<pre class=\"lang:vbnet decode:true \">Dim wb = New XLWorkbook\nDim ws = wb.Worksheets.Add(\"\u30b3\u30e1\u30f3\u30c8\u306e\u30d7\u30ed\u30d1\u30c6\u30a3\")\n\n'\u30bb\u30eb\u306b\u5408\u308f\u305b\u3066\u79fb\u52d5\u3084\u30b5\u30a4\u30ba\u5909\u66f4\u3092\u3059\u308b\nws.Cell(\"A1\").Comment.Style.Properties.Positioning = XLDrawingAnchor.MoveAndSizeWithCells\n'\u30bb\u30eb\u306b\u5408\u308f\u305b\u3066\u79fb\u52d5\u3059\u308b\u304c\u30b5\u30a4\u30ba\u5909\u66f4\u306f\u3057\u306a\u3044\nws.Cell(\"A2\").Comment.Style.Properties.Positioning = XLDrawingAnchor.MoveWithCells\n'\u30bb\u30eb\u306b\u5408\u308f\u305b\u3066\u79fb\u52d5\u3084\u30b5\u30a4\u30ba\u5909\u66f4\u3092\u3057\u306a\u3044\nws.Cell(\"A3\").Comment.Style.Properties.Positioning = XLDrawingAnchor.Absolute\n\nwb.SaveAs(\"D:\\test\\CommentsProperties.xlsx\")<\/pre>\n<p><a href=\"https:\/\/elleneast.com\/wp\/wp-content\/uploads\/programming_topics\/ClosedXML\/ClosedXml_149.png\"><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-12323 bigshadow\" src=\"https:\/\/elleneast.com\/wp\/wp-content\/uploads\/programming_topics\/ClosedXML\/ClosedXml_149.png\" alt=\"\" width=\"480\" height=\"479\" srcset=\"https:\/\/elleneast.com\/wp\/wp-content\/uploads\/programming_topics\/ClosedXML\/ClosedXml_149.png 480w, https:\/\/elleneast.com\/wp\/wp-content\/uploads\/programming_topics\/ClosedXML\/ClosedXml_149-150x150.png 150w, https:\/\/elleneast.com\/wp\/wp-content\/uploads\/programming_topics\/ClosedXML\/ClosedXml_149-300x300.png 300w, https:\/\/elleneast.com\/wp\/wp-content\/uploads\/programming_topics\/ClosedXML\/ClosedXml_149-125x125.png 125w, https:\/\/elleneast.com\/wp\/wp-content\/uploads\/programming_topics\/ClosedXML\/ClosedXml_149-160x160.png 160w\" sizes=\"auto, (max-width: 480px) 100vw, 480px\"><\/a><\/p>\n<h2 id=\"i-8\"><span class=\"ez-toc-section\" id=\"%E3%82%B3%E3%83%A1%E3%83%B3%E3%83%88%E3%81%AE%E4%BD%99%E7%99%BD\"><\/span>\u30b3\u30e1\u30f3\u30c8\u306e\u4f59\u767d<span class=\"ez-toc-section-end\"><\/span><\/h2>\n<pre class=\"lang:vbnet decode:true \">Dim wb = New XLWorkbook\nDim ws = wb.Worksheets.Add(\"\u30b3\u30e1\u30f3\u30c8\u306e\u4f59\u767d\")\n\nws.Cell(\"A2\").Comment _\n  .SetVisible _\n  .AddText(\"\u3080\u304b\u3057\u3001\u3080\u304b\u3057\u3001\u3042\u308b\u6240\u306b\u304a\u3058\u3044\u3055\u3093\u3068\u304a\u3070\u3042\u3055\u3093\u304c\u4f4f\u3093\u3067\u3044\u307e\u3057\u305f\u3002\").AddNewLine _\n  .AddText(\"\u304a\u3058\u3044\u3055\u3093\u306f\u5c71\u3078\u3057\u3070\u5208\u308a\u306b\u3001\u304a\u3070\u3042\u3055\u3093\u306f\u5ddd\u3078\u6d17\u6fef\u306b\u884c\u304d\u307e\u3057\u305f\u3002\").AddNewLine _\n  .AddText(\"\u304a\u3070\u3042\u3055\u3093\u304c\u5ddd\u3067\u6d17\u6fef\u3092\u3057\u3066\u3044\u308b\u3068\u5927\u304d\u306a\u6843\u304c\u6d41\u308c\u3066\u304d\u307e\u3057\u305f\u3002\")\n\nws.Cell(\"A2\").Comment.Style _\n  .Margins.SetAll(0.25) _\n  .Size.SetAutomaticSize\n\nwb.SaveAs(\"D:\\test\\CommentsMargins.xlsx\")<\/pre>\n<p><a href=\"https:\/\/elleneast.com\/wp\/wp-content\/uploads\/programming_topics\/ClosedXML\/ClosedXml_150.png\"><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-12326 bigshadow\" src=\"https:\/\/elleneast.com\/wp\/wp-content\/uploads\/programming_topics\/ClosedXML\/ClosedXml_150.png\" alt=\"\" width=\"529\" height=\"173\" srcset=\"https:\/\/elleneast.com\/wp\/wp-content\/uploads\/programming_topics\/ClosedXML\/ClosedXml_150.png 529w, https:\/\/elleneast.com\/wp\/wp-content\/uploads\/programming_topics\/ClosedXML\/ClosedXml_150-300x98.png 300w\" sizes=\"auto, (max-width: 529px) 100vw, 529px\"><\/a><\/p>\n<h2 id=\"i-9\"><span class=\"ez-toc-section\" id=\"%E3%82%B3%E3%83%A1%E3%83%B3%E3%83%88%E3%81%AE%E4%BB%A3%E6%9B%BF%E3%83%86%E3%82%AD%E3%82%B9%E3%83%88\"><\/span>\u30b3\u30e1\u30f3\u30c8\u306e\u4ee3\u66ff\u30c6\u30ad\u30b9\u30c8<span class=\"ez-toc-section-end\"><\/span><\/h2>\n<pre class=\"lang:vbnet decode:true \">Dim wb = New XLWorkbook\nDim ws = wb.Worksheets.Add(\"\u30b3\u30e1\u30f3\u30c8\u306e\u4ee3\u66ff\u30c6\u30ad\u30b9\u30c8\")\n\nws.Cell(\"A1\").Comment.Style.Web.AlternateText = \"\u5fc5\u8981\u306a\u5834\u5408\u306f\u4ee3\u66ff\u30c6\u30ad\u30b9\u30c8\u3092\u8a2d\u5b9a\u3059\u308b\"\n\nwb.SaveAs(\"D:\\test\\CommentsAlternativeText.xlsx\")<\/pre>\n<p><a href=\"https:\/\/elleneast.com\/wp\/wp-content\/uploads\/programming_topics\/ClosedXML\/ClosedXml_151.png\"><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-12328 bigshadow\" src=\"https:\/\/elleneast.com\/wp\/wp-content\/uploads\/programming_topics\/ClosedXML\/ClosedXml_151.png\" alt=\"\" width=\"480\" height=\"479\" srcset=\"https:\/\/elleneast.com\/wp\/wp-content\/uploads\/programming_topics\/ClosedXML\/ClosedXml_151.png 480w, https:\/\/elleneast.com\/wp\/wp-content\/uploads\/programming_topics\/ClosedXML\/ClosedXml_151-150x150.png 150w, https:\/\/elleneast.com\/wp\/wp-content\/uploads\/programming_topics\/ClosedXML\/ClosedXml_151-300x300.png 300w, https:\/\/elleneast.com\/wp\/wp-content\/uploads\/programming_topics\/ClosedXML\/ClosedXml_151-125x125.png 125w, https:\/\/elleneast.com\/wp\/wp-content\/uploads\/programming_topics\/ClosedXML\/ClosedXml_151-160x160.png 160w\" sizes=\"auto, (max-width: 480px) 100vw, 480px\"><\/a><\/p>\n<p>&nbsp;<\/p>\n<p><a href=\"https:\/\/elleneast.com\/?cat=90\">\u300c\u3010VB.NET\u3011ClosedXML \u306e\u4f7f\u3044\u65b9\u300d\u306e\u4e00\u89a7\u3092\u8868\u793a<\/a><\/p>\n","protected":false},"excerpt":{"rendered":"<p>[include-page id=\u201d11760\u2033] \u30b3\u30e1\u30f3\u30c8\u306e\u8868\u793a\u72b6\u614b Dim wb = New XLWorkbook Dim ws = wb.Worksheets.Add(&#8220;\u30b3\u30e1\u30f3\u30c8\u306e\u8868\u793a\u72b6\u614b&#8221;) &#8216;\u30c7\u30d5\u30a9\u30eb\u30c8\u3067\u306f\u30b3\u30e1 &#8230; <\/p>\n","protected":false},"author":1,"featured_media":2656,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_monsterinsights_skip_tracking":false,"_monsterinsights_sitenote_active":false,"_monsterinsights_sitenote_note":"","_monsterinsights_sitenote_category":0,"footnotes":""},"categories":[90],"tags":[],"class_list":{"0":"post-12287","1":"post","2":"type-post","3":"status-publish","4":"format-standard","5":"has-post-thumbnail","7":"category-closedxml"},"_links":{"self":[{"href":"https:\/\/elleneast.com\/index.php?rest_route=\/wp\/v2\/posts\/12287","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/elleneast.com\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/elleneast.com\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/elleneast.com\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/elleneast.com\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=12287"}],"version-history":[{"count":3,"href":"https:\/\/elleneast.com\/index.php?rest_route=\/wp\/v2\/posts\/12287\/revisions"}],"predecessor-version":[{"id":15166,"href":"https:\/\/elleneast.com\/index.php?rest_route=\/wp\/v2\/posts\/12287\/revisions\/15166"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/elleneast.com\/index.php?rest_route=\/wp\/v2\/media\/2656"}],"wp:attachment":[{"href":"https:\/\/elleneast.com\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=12287"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/elleneast.com\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=12287"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/elleneast.com\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=12287"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}