{"id":11859,"date":"2025-12-17T15:19:50","date_gmt":"2025-12-17T06:19:50","guid":{"rendered":"https:\/\/www.moonmile.net\/blog\/?p=11859"},"modified":"2025-12-30T16:29:14","modified_gmt":"2025-12-30T07:29:14","slug":"libreoffice-calc-python-%e3%81%a7%e5%8d%98%e7%a5%a8%ef%bc%88%e8%ab%8b%e6%b1%82%e6%9b%b8%ef%bc%89%e3%82%92%e4%bd%9c%e6%88%90","status":"publish","type":"post","link":"http:\/\/www.moonmile.net\/blog\/archives\/11859","title":{"rendered":"LibreOffice Calc + Python \u3067\u5358\u7968\uff08\u8acb\u6c42\u66f8\uff09\u3092\u4f5c\u6210"},"content":{"rendered":"\n<p>\u624b\u3082\u3068\u306b\u3042\u308b Excel \u3067\u4f5c\u6210\u3057\u305f\u8acb\u6c42\u66f8\u3092 LibreOffice Calc \u306b\u5909\u63db\u3057\u3066\u3044\u304d\u307e\u3059\u3002<\/p>\n\n\n\n<p>\u8acb\u6c42\u66f8\u306e\u3088\u3046\u306a\u5358\u7968\u306f\u3001Word \u3067\u4f5c\u308b\u306e\u304c\u666e\u901a\u3060\u3068\u601d\u3046\u306e\u3067\u3059\u304c\u3001Excel \u306e\u307b\u3046\u304c\u610f\u5916\u3068\u697d\u3060\u3063\u305f\u308a\u3057\u307e\u3059\u3002\u307e\u3042\u3001C# \u3067\u5358\u7968\u3092\u64cd\u4f5c\u3057\u305f\u3068\u304d\u306b Word \u3088\u308a\u3082 Excel \u3067\u30ec\u30a4\u30a2\u30a6\u30c8\u3092\u4f5c\u3063\u305f\u307b\u3046\u304c\u697d\u3060\u3063\u305f\u3068\u3044\u3046\u7406\u7531\u3068\u3001Excel\/Word \u306e\u4e21\u65b9\u306b\u5bfe\u5fdc\u3059\u308b\u306e\u306f\u9762\u5012\u3060\u3063\u305f\u3068\u3044\u3046\u306e\u3082\u5927\u304d\u306a\u7406\u7531\u3067\u3059\u304c\u3001<\/p>\n\n\n\n<ul class=\"wp-block-list\">\n<li>\u6570\u5024\u3084\u6587\u5b57\u5217\u306a\u3069\u3092\u96a0\u3057\u30c7\u30fc\u30bf\u30b7\u30fc\u30c8\u306b\u66f8\u304d\u8fbc\u3093\u3067\u304a\u304f<\/li>\n\n\n\n<li>\u5370\u5237\u7528\u306e\u30b7\u30fc\u30c8\u304b\u3089\u30c7\u30fc\u30bf\u30b7\u30fc\u30c8\u3092\u53c2\u7167\u3055\u305b\u308b<\/li>\n<\/ul>\n\n\n\n<p>\u306e2\u624b\u9806\u306b\u3057\u3066\u304a\u304f\u3068\u30d7\u30ed\u30b0\u30e9\u30e0\u304c\u697d\u306b\u306a\u308a\u307e\u3059\u3002<br>\u3044\u308f\u3086\u308b\u3001\u30d7\u30ed\u30b0\u30e9\u30e0\u304b\u3089\u66f8\u304d\u8fbc\u3080\u30bb\u30eb\u306e\u4f4d\u7f6e\u3092\u56fa\u5b9a\u306b\u3067\u304d\u308b\u5229\u70b9\u304c\u3042\u308a\u307e\u3059\u3002\u5358\u7968\u306e\u30ec\u30a4\u30a2\u30a6\u30c8\u304c\u5909\u308f\u3063\u305f\u3068\u304d\u306f\u3001\u30c7\u30fc\u30bf\u30b7\u30fc\u30c8\u306f\u305d\u306e\u307e\u307e\u306e\u5f62\u5f0f\u306b\u3057\u3066\u3001\u5370\u5237\u7528\u306e\u30b7\u30fc\u30c8\u3092\u5909\u66f4\u3059\u308c\u3070\u3088\u3044\u306e\u3067\u3059\u3002<\/p>\n\n\n\n<h2 class=\"wp-block-heading\">\u5358\u7968\u306e\u30c6\u30f3\u30d7\u30ec\u30fc\u30c8<\/h2>\n\n\n\n<p>\u5370\u5237\u7528\u306e\u30b7\u30fc\u30c8\u3092\u4f5c\u6210\u3057\u3066\u304a\u304d\u307e\u3059\u3002<\/p>\n\n\n\n<figure class=\"wp-block-image size-large\"><a href=\"https:\/\/www.moonmile.net\/blog\/wp-content\/uploads\/2025\/12\/image-48.png\"><img loading=\"lazy\" decoding=\"async\" width=\"951\" height=\"1024\" src=\"https:\/\/www.moonmile.net\/blog\/wp-content\/uploads\/2025\/12\/image-48-951x1024.png\" alt=\"\" class=\"wp-image-11860\" srcset=\"http:\/\/www.moonmile.net\/blog\/wp-content\/uploads\/2025\/12\/image-48-951x1024.png 951w, http:\/\/www.moonmile.net\/blog\/wp-content\/uploads\/2025\/12\/image-48-279x300.png 279w, http:\/\/www.moonmile.net\/blog\/wp-content\/uploads\/2025\/12\/image-48-768x827.png 768w, http:\/\/www.moonmile.net\/blog\/wp-content\/uploads\/2025\/12\/image-48.png 1003w\" sizes=\"auto, (max-width: 951px) 100vw, 951px\" \/><\/a><\/figure>\n\n\n\n<p>\u30c7\u30fc\u30bf\u30b7\u30fc\u30c8\u306f\u3053\u3093\u306a\u611f\u3058\u3067\u3059\u3002\u5370\u5237\u7528\u306e\u30b7\u30fc\u30c8\u304b\u3089 &#8220;=$Data.B1&#8221; \u306e\u3088\u3046\u306b\u53c2\u7167\u3057\u307e\u3059\u3002<\/p>\n\n\n\n<figure class=\"wp-block-image size-full\"><a href=\"https:\/\/www.moonmile.net\/blog\/wp-content\/uploads\/2025\/12\/image-49.png\"><img loading=\"lazy\" decoding=\"async\" width=\"1003\" height=\"642\" src=\"https:\/\/www.moonmile.net\/blog\/wp-content\/uploads\/2025\/12\/image-49.png\" alt=\"\" class=\"wp-image-11861\" srcset=\"http:\/\/www.moonmile.net\/blog\/wp-content\/uploads\/2025\/12\/image-49.png 1003w, http:\/\/www.moonmile.net\/blog\/wp-content\/uploads\/2025\/12\/image-49-300x192.png 300w, http:\/\/www.moonmile.net\/blog\/wp-content\/uploads\/2025\/12\/image-49-768x492.png 768w\" sizes=\"auto, (max-width: 1003px) 100vw, 1003px\" \/><\/a><\/figure>\n\n\n\n<p>\u5370\u5237\u30d7\u30ec\u30d3\u30e5\u30fc\u306f\u3053\u3093\u306a\u611f\u3058\u3002<\/p>\n\n\n\n<figure class=\"wp-block-image size-large\"><a href=\"https:\/\/www.moonmile.net\/blog\/wp-content\/uploads\/2025\/12\/image-50.png\"><img loading=\"lazy\" decoding=\"async\" width=\"951\" height=\"1024\" src=\"https:\/\/www.moonmile.net\/blog\/wp-content\/uploads\/2025\/12\/image-50-951x1024.png\" alt=\"\" class=\"wp-image-11862\" srcset=\"http:\/\/www.moonmile.net\/blog\/wp-content\/uploads\/2025\/12\/image-50-951x1024.png 951w, http:\/\/www.moonmile.net\/blog\/wp-content\/uploads\/2025\/12\/image-50-279x300.png 279w, http:\/\/www.moonmile.net\/blog\/wp-content\/uploads\/2025\/12\/image-50-768x827.png 768w, http:\/\/www.moonmile.net\/blog\/wp-content\/uploads\/2025\/12\/image-50.png 1003w\" sizes=\"auto, (max-width: 951px) 100vw, 951px\" \/><\/a><\/figure>\n\n\n\n<p><\/p>\n\n\n\n<p>\u3072\u3068\u3064\u6ce8\u610f\u3057\u306a\u3044\u3068\u3044\u3051\u306a\u3044\u306e\u306f\u3001\u30bb\u30eb\u306b\u30d5\u30a1\u30f3\u30af\u30b7\u30e7\u30f3\u3092\u5165\u308c\u308b\u3068\u300c0\u300d\u304c\u51fa\u3066\u3057\u307e\u3046\u3053\u3068\u304c\u3042\u308a\u307e\u3059\u3002\u3053\u308c\u306f Excel \u3067\u3082 LibreOffice Calc \u3067\u3082\u3001\u3053\u3093\u306a\u611f\u3058\u3067\u300c\u30bc\u30ed\u5024\u300d\u306e\u30c1\u30a7\u30c3\u30af\u3092\u5916\u3059\u3068\u8868\u793a\u304c\u6d88\u3048\u308b\u3088\u3046\u306b\u306a\u308a\u307e\u3059\u3002<\/p>\n\n\n\n<figure class=\"wp-block-image size-full\"><a href=\"https:\/\/www.moonmile.net\/blog\/wp-content\/uploads\/2025\/12\/image-51.png\"><img loading=\"lazy\" decoding=\"async\" width=\"917\" height=\"647\" src=\"https:\/\/www.moonmile.net\/blog\/wp-content\/uploads\/2025\/12\/image-51.png\" alt=\"\" class=\"wp-image-11863\" srcset=\"http:\/\/www.moonmile.net\/blog\/wp-content\/uploads\/2025\/12\/image-51.png 917w, http:\/\/www.moonmile.net\/blog\/wp-content\/uploads\/2025\/12\/image-51-300x212.png 300w, http:\/\/www.moonmile.net\/blog\/wp-content\/uploads\/2025\/12\/image-51-768x542.png 768w\" sizes=\"auto, (max-width: 917px) 100vw, 917px\" \/><\/a><\/figure>\n\n\n\n<p>\u3067\u3001Excel \u306e\u5834\u5408\u306f\u3053\u308c\u3067\u6d88\u3048\u308b\u306e\u3067\u3059\u304c\u3001LibreOffice Calc \u3067\u306f\u30d0\u30b0\u306a\u306e\u304b\u4ed5\u69d8\u306a\u306e\u304b\u3001\u5370\u5237\u3059\u308b\u3068\u304d\u3084 PDF \u306b\u51fa\u529b\u3059\u308b\u3068\u304d\u306b\u306f\u300c0\u300d\u304c\u51fa\u3066\u3057\u307e\u3044\u307e\u3059\u3002\u3053\u308c\u3001\u304d\u3063\u3068\u30d0\u30b0\u306a\u3093\u3067\u3059\u304c&#8230;\u4ed5\u65b9\u304c\u306a\u3044\u306e\u3067\u3001\u66f8\u5f0f\u3067\u8a2d\u5b9a\u3057\u307e\u3059\u3002<\/p>\n\n\n\n<p>\u3053\u308c\u304c\u7d50\u69cb\u9762\u5012\u3067\u3001\u6587\u5b57\u5217\u306e\u5834\u5408\u3068\u91d1\u984d\u306e\u5834\u5408\u306f\u66f8\u304d\u5206\u3051\u306a\u3044\u3068\u3044\u3051\u307e\u305b\u3093\u3002<\/p>\n\n\n\n<pre class=\"wp-block-preformatted\">\u6587\u5b57\u5217\u306e\u5834\u5408<br>0;-0;;@<br>\u6570\u5024\u306e\u5834\u5408<br>[&gt;0]0;[&lt;0]-0;\"\";@<br>\u91d1\u984d\u306e\u5834\u5408<br>[&gt;0]\"\\\"#,##0;[&lt;0][RED]\"\\-\"#,##0;\"\";@<\/pre>\n\n\n\n<p>\u300c0\u300d\u304c\u8868\u793a\u3055\u308c\u308b\u5834\u5408\u306f\u3001\u3053\u3093\u306a\u611f\u3058\u306b\u306a\u308a\u307e\u3059\u3002<\/p>\n\n\n\n<figure class=\"wp-block-image size-full\"><a href=\"https:\/\/www.moonmile.net\/blog\/wp-content\/uploads\/2025\/12\/image-52.png\"><img loading=\"lazy\" decoding=\"async\" width=\"916\" height=\"422\" src=\"https:\/\/www.moonmile.net\/blog\/wp-content\/uploads\/2025\/12\/image-52.png\" alt=\"\" class=\"wp-image-11864\" srcset=\"http:\/\/www.moonmile.net\/blog\/wp-content\/uploads\/2025\/12\/image-52.png 916w, http:\/\/www.moonmile.net\/blog\/wp-content\/uploads\/2025\/12\/image-52-300x138.png 300w, http:\/\/www.moonmile.net\/blog\/wp-content\/uploads\/2025\/12\/image-52-768x354.png 768w\" sizes=\"auto, (max-width: 916px) 100vw, 916px\" \/><\/a><\/figure>\n\n\n\n<p>\u3053\u308c\u300c\u30bc\u30ed\u5024\u300d\u5916\u305b\u3070\u5927\u4e08\u592b\u306a\u3068\u304d\u3068\u99c4\u76ee\u306a\u3068\u304d\u304c\u3042\u308b\u306e\u3067\u3001LibreOffice \u306e\u30d0\u30fc\u30b8\u30e7\u30f3\u3067\u78ba\u8a8d\u3057\u3066\u304f\u3060\u3055\u3044\u3002\u3061\u3087\u3063\u3068\u4e0d\u5b89\u5b9a\u3063\u307d\u3044\u3067\u3059\u3002<\/p>\n\n\n\n<h2 class=\"wp-block-heading\">Python \u30b3\u30fc\u30c9<\/h2>\n\n\n\n<p>\u4ee5\u4e0b\u306e\u30b3\u30fc\u30c9\u3067\u8acb\u6c42\u66f8\u306e Calc \u30d5\u30a1\u30a4\u30eb\u304c\u751f\u6210\u3055\u308c\u308b\u3088\u3046\u306b\u306a\u308a\u307e\u3059\u3002<\/p>\n\n\n<div class=\"wp-block-syntaxhighlighter-code \"><pre class=\"brush: python; title: ; notranslate\" title=\"\">\nimport uno\nfrom pathlib import Path\n\n# \u30b5\u30fc\u30d0\u30fc\u306e\u8d77\u52d5\n# &amp; &quot;C:\\Program Files\\LibreOffice\\program\\soffice&quot; --accept=&quot;socket,host=localhost,port=2002;urp;&quot; --norestore --nologo\n# PowerShell \u3067\u306e\u8d77\u52d5\n# &amp; &quot;C:\\Program Files\\LibreOffice\\program\\python&quot; .\\calcBill001.py\n\n&quot;&quot;&quot;\n\u8acb\u6c42\u30c6\u30f3\u30d7\u30ec\u30fc\u30c8\uff08.ots\uff09\u3092\u30c6\u30f3\u30d7\u30ec\u30fc\u30c8\u3068\u3057\u3066\u65b0\u898f\u30c9\u30ad\u30e5\u30e1\u30f3\u30c8\u3067\u958b\u304d\u3001Data\u30b7\u30fc\u30c8\u306b\u66f8\u304d\u8fbc\u3093\u3067\u8acb\u6c42\u66f8\u3092\u751f\u6210\u3059\u308b\u30b5\u30f3\u30d7\u30eb\u3002\n\n\u624b\u9806:\n1. \u300c\u8acb\u6c42\u66f8\u30c6\u30f3\u30d7\u30ec\u30fc\u30c8\u300d(bill-template.ots) \u3092\u30c6\u30f3\u30d7\u30ec\u30fc\u30c8\u3068\u3057\u3066\u65b0\u898f\u30c9\u30ad\u30e5\u30e1\u30f3\u30c8\u3092\u958b\u304f\n2. \u30b7\u30fc\u30c8\u540d\u300cData\u300d\u306b\u30b5\u30f3\u30d7\u30eb\u30c7\u30fc\u30bf\u3092\u66f8\u304d\u8fbc\u3080\uff08B1:\u5b9b\u540d, B2:\u4ef6\u540d \u306a\u3069\u56fa\u5b9a\u30bb\u30eb\u306b\u6295\u5165\uff09\n3. \u660e\u7d30\u884c\uff08\u4efb\u610f\u3067\u8907\u6570\uff09\u3092\u66f8\u304d\u8fbc\u3080\u3002\u5fc5\u8981\u306a\u3089\u30c6\u30f3\u30d7\u30ec\u30fc\u30c8\u306e\u884c\u66f8\u5f0f\u3092\u8907\u88fd\u3057\u3066\u304b\u3089\u30c7\u30fc\u30bf\u6295\u5165\u3002\n4. \u5225\u540d\u3067\u4fdd\u5b58\n&quot;&quot;&quot;\n\n\n# \u8a2d\u5b9a\nTEMPLATE_NAME = &quot;bill-template.ots&quot;\nOUTPUT_NAME = &quot;bill-output.ods&quot;\nDATA_SHEET_NAME = &quot;Data&quot;\nITEM_START_ROW = 5  # \u660e\u7d30\u306e\u958b\u59cb\u884c(0-based, 10\u884c\u76ee). \u30c6\u30f3\u30d7\u30ec\u30fc\u30c8\u69cb\u6210\u306b\u5408\u308f\u305b\u3066\u8abf\u6574\nITEM_TEMPLATE_ROW = 8  # \u66f8\u5f0f\u3092\u30b3\u30d4\u30fc\u3059\u308b\u5143\u884c(0-based). \u660e\u7d30\u306e1\u884c\u76ee\u306a\u3069\u3002\n\n\ndef to_file_url(path: Path) -&gt; str:\n\treturn uno.systemPathToFileUrl(str(path.resolve()))\n\n\ndef connect_desktop():\n\tlocal_ctx = uno.getComponentContext()\n\tresolver = local_ctx.ServiceManager.createInstanceWithContext(\n\t\t&quot;com.sun.star.bridge.UnoUrlResolver&quot;, local_ctx\n\t)\n\tctx = resolver.resolve(\n\t\t&quot;uno:socket,host=localhost,port=2002;urp;StarOffice.ComponentContext&quot;\n\t)\n\tsmgr = ctx.ServiceManager\n\tdesktop = smgr.createInstanceWithContext(&quot;com.sun.star.frame.Desktop&quot;, ctx)\n\tdoc = desktop.getCurrentComponent()\n\tif doc is None:\n\t\traise RuntimeError(&quot;\u30a2\u30af\u30c6\u30a3\u30d6\u306a Calc \u30c9\u30ad\u30e5\u30e1\u30f3\u30c8\u304c\u898b\u3064\u304b\u308a\u307e\u305b\u3093&quot;)\n\treturn desktop, doc\n\n\ndef create_doc_from_template(desktop, template_path: Path):\n\turl = to_file_url(template_path)\n\tprops = &#x5B;\n\t\tuno.createUnoStruct(&quot;com.sun.star.beans.PropertyValue&quot;),\n\t\tuno.createUnoStruct(&quot;com.sun.star.beans.PropertyValue&quot;),\n\t]\n\tprops&#x5B;0].Name = &quot;AsTemplate&quot;\n\tprops&#x5B;0].Value = True\n\tprops&#x5B;1].Name = &quot;Hidden&quot;  # UI\u304c\u6b32\u3057\u3044\u5834\u5408\u306f False \u306b\u5909\u66f4\n\tprops&#x5B;1].Value = True\n\treturn desktop.loadComponentFromURL(url, &quot;_blank&quot;, 0, tuple(props))\n\n\ndef set_scalar(sheet, address: str, value):\n\ttry:\n\t\tsheet.getCellRangeByName(address).setString(str(value))\n\texcept Exception:\n\t\tpass\n\ndef write_items(sheet, items, start_row: int, start_col: int = 0):\n\t&quot;&quot;&quot;\u660e\u7d30\u884c\u3092\u66f8\u304d\u8fbc\u3080\u3002 items \u306f2\u6b21\u5143\u914d\u5217\u3002&quot;&quot;&quot;\n\tfor r, row in enumerate(items):\n\t\tfor c, value in enumerate(row):\n\t\t\tcell = sheet.getCellByPosition(start_col + c, start_row + r)\n\t\t\tif isinstance(value, (int, float)):\n\t\t\t\tcell.setValue(value)\n\t\t\telse:\n\t\t\t\tcell.setString(str(value))\n\n\ndef main():\n\tbase_dir = Path(__file__).resolve().parent\n\ttemplate_path = base_dir \/ TEMPLATE_NAME\n\toutput_path = base_dir \/ OUTPUT_NAME\n\n\t# \u30b5\u30f3\u30d7\u30eb\u56fa\u5b9a\u9805\u76ee\n\tfields = {\n\t\t&quot;B1&quot;: &quot;\u682a\u5f0f\u4f1a\u793e\u30b5\u30f3\u30d7\u30eb \u69d8&quot;,  # \u5b9b\u540d\n\t\t&quot;B2&quot;: &quot;12\u6708\u5206 \u8acb\u6c42\u66f8&quot;,       # \u4ef6\u540d\n\t\t&quot;B3&quot;: &quot;2512-01&quot;,        # \u8acb\u6c42\u756a\u53f7\n\t\t&quot;B4&quot;: &quot;2025\/12\/17&quot;,        # \u8acb\u6c42\u65e5\n\t\t&quot;B18&quot;: &quot;\u3053\u308c\u306f\u30b5\u30f3\u30d7\u30eb\u8acb\u6c42\u66f8\u3067\u3059&quot;,  # \u5099\u8003\n\t}\n\n\t# \u660e\u7d30: &#x5B;No, \u6458\u8981, \u6570\u91cf, \u5358\u4f4d, \u5358\u4fa1]\n\titems = &#x5B;\n\t\t&#x5B;1, &quot;\u5546\u54c1A&quot;, 2, &quot;\u500b&quot;, 1500],\n        &#x5B;2, &quot;\u5546\u54c1B&quot;, 1, &quot;\u5f0f&quot;, 3000],\n        &#x5B;3, &quot;\u5546\u54c1C&quot;, 5, &quot;\u500b&quot;, 800],\n\t\t&#x5B;4, &quot;\u5546\u54c1D&quot;, 3, &quot;\u500b&quot;, 1200],\n\t]\n\n\tif not template_path.exists():\n\t\traise FileNotFoundError(f&quot;\u30c6\u30f3\u30d7\u30ec\u30fc\u30c8\u304c\u898b\u3064\u304b\u308a\u307e\u305b\u3093: {template_path}&quot;)\n\n\tdesktop, _ = connect_desktop()\n\tdoc = create_doc_from_template(desktop, template_path)\n\tsheets = doc.Sheets\n\n\tif not sheets.hasByName(DATA_SHEET_NAME):\n\t\traise RuntimeError(&quot;\u30c6\u30f3\u30d7\u30ec\u30fc\u30c8\u306b Data \u30b7\u30fc\u30c8\u304c\u3042\u308a\u307e\u305b\u3093&quot;)\n\tdata_sheet = sheets.getByName(DATA_SHEET_NAME)\n\n\t# \u56fa\u5b9a\u30bb\u30eb\u3092\u66f8\u304d\u8fbc\u307f\n\tfor addr, val in fields.items():\n\t\tset_scalar(data_sheet, addr, val)\n\n\twrite_items(data_sheet, items, start_row=ITEM_START_ROW, start_col=1)\n\n\t# \u4fdd\u5b58\n\tstore_props = (uno.createUnoStruct(&quot;com.sun.star.beans.PropertyValue&quot;),)\n\tstore_props&#x5B;0].Name = &quot;FilterName&quot;\n\tstore_props&#x5B;0].Value = &quot;calc8&quot;\n\tdoc.storeToURL(to_file_url(output_path), store_props)\n\tprint(f&quot;\u8acb\u6c42\u66f8\u3092\u4fdd\u5b58\u3057\u307e\u3057\u305f: {output_path}&quot;)\n\n\t# \u5f8c\u51e6\u7406\n\ttry:\n\t\tdoc.dispose()\n\texcept Exception:\n\t\tpass\n\n\nif __name__ == &quot;__main__&quot;:\n\ttry:\n\t\tmain()\n\texcept Exception as e:\n\t\tprint(f&quot;error: {e}&quot;)\n\n\n<\/pre><\/div>\n\n\n<p>\u3053\u308c\u3067\u3044\u3063\u305f\u3093\u3001\u8868\u5f62\u5f0f\u306e\u5e33\u7968\u3068\u5358\u7968\u306e\u4f5c\u6210\u304c\u3067\u304d\u308b\u3053\u3068\u304c\u78ba\u8a8d\u3067\u304d\u307e\u3057\u305f\u3002<\/p>\n\n\n\n<p>\u81ea\u5206\u304c\u696d\u52d9\u3067\u4f7f\u3063\u3066\u3044\u308b\u30d1\u30bf\u30fc\u30f3\u3068\u3057\u3066\u306f\u7db2\u7f85\u3067\u304d\u305f\u306e\u3067\u3001\u3042\u3068\u306f\u4f7f\u3044\u52dd\u624b\u3067\u3059\u3002\u3053\u308c\u3089\u306e Python \u30b3\u30fc\u30c9\u306f\u307b\u3068\u3093\u3069\u304c AI \u30a8\u30fc\u30b8\u30a7\u30f3\u30c8\u3067\u4f5c\u6210\u3057\u3066\u8cb0\u3063\u3066\u3044\u308b\u306e\u3067\u3001\u624b\u304c\u51fa\u3057\u305a\u3089\u3044\u72b6\u614b\u306b\u306a\u3063\u3066\u3044\u307e\u3059\u3002\u3042\u304f\u307e\u3067\u4f7f\u3044\u6368\u3066\u306e\u30b3\u30fc\u30c7\u30a3\u30f3\u30b0\u306b\u306a\u3063\u3066\u3044\u308b\u306e\u3067\u3001\u7d30\u304b\u3044\u3068\u3053\u308d\u3092\u4fee\u6b63\u3057\u3088\u3046\u3068\u3059\u308b\u3068\u30d7\u30ed\u30f3\u30d7\u30c8\u304b\u3089\u624b\u3092\u3044\u308c\u308b\u3053\u3068\u306b\u306a\u3063\u3066\u3057\u307e\u3044\u307e\u3059\u3002<br><\/p>\n\n\n\n<ul class=\"wp-block-list\">\n<li>\u305b\u3081\u3066 Calc \u3092\u64cd\u4f5c\u3059\u308b\u3068\u3053\u308d\u306e UNO API \u306e\u30b3\u30fc\u30c9\u88dc\u5b8c\u304c\u6b32\u3057\u3044 \u2192 \u30b9\u30bf\u30d6\u306e\u4f5c\u6210<\/li>\n\n\n\n<li>\u69cb\u9020\u4f53\u306e\u4f5c\u6210\u3067 createUnoStruct \u304c\u5fc5\u8981\u306b\u306a\u308b\u306e\u3067\u3001\u3053\u308c\u3092\u9069\u5f53\u306b\u30e9\u30c3\u30d7\u3059\u308b<\/li>\n\n\n\n<li>getCellByPosition \u3092 Cells \u306b\u5909\u3048\u308b\u3068\u304b\u3001VBA \u306b\u5bc4\u305b\u305f\u547d\u540d\u306b\u3057\u305f\u3044<\/li>\n<\/ul>\n\n\n\n<p>\u3053\u306e\u3042\u305f\u308a\u306f\u3001\u5e74\u660e\u3051\u3050\u3089\u3044\u306b\u8a66\u3057\u3066\u307f\u308b\u4e88\u5b9a\u3002<\/p>\n","protected":false},"excerpt":{"rendered":"<p>\u624b\u3082\u3068\u306b\u3042\u308b Excel \u3067\u4f5c\u6210\u3057\u305f\u8acb\u6c42\u66f8\u3092 LibreOffice Calc \u306b\u5909\u63db\u3057\u3066\u3044\u304d\u307e\u3059\u3002 \u8acb\u6c42\u66f8\u306e\u3088\u3046\u306a\u5358\u7968\u306f\u3001Word \u3067\u4f5c\u308b\u306e\u304c\u666e\u901a\u3060\u3068\u601d\u3046\u306e\u3067\u3059\u304c\u3001Excel \u306e\u307b\u3046\u304c\u610f\u5916\u3068\u697d\u3060\u3063\u305f\u308a\u3057\u307e\u3059\u3002\u307e\u3042\u3001C# &hellip; <a href=\"http:\/\/www.moonmile.net\/blog\/archives\/11859\">\u7d9a\u304d\u3092\u8aad\u3080 <span class=\"meta-nav\">&rarr;<\/span><\/a><\/p>\n","protected":false},"author":2,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_jetpack_memberships_contains_paid_content":false,"footnotes":""},"categories":[3,109],"tags":[],"class_list":["post-11859","post","type-post","status-publish","format-standard","hentry","category-dev","category-libreoffice"],"jetpack_featured_media_url":"","jetpack_sharing_enabled":true,"_links":{"self":[{"href":"http:\/\/www.moonmile.net\/blog\/wp-json\/wp\/v2\/posts\/11859","targetHints":{"allow":["GET"]}}],"collection":[{"href":"http:\/\/www.moonmile.net\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"http:\/\/www.moonmile.net\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"http:\/\/www.moonmile.net\/blog\/wp-json\/wp\/v2\/users\/2"}],"replies":[{"embeddable":true,"href":"http:\/\/www.moonmile.net\/blog\/wp-json\/wp\/v2\/comments?post=11859"}],"version-history":[{"count":4,"href":"http:\/\/www.moonmile.net\/blog\/wp-json\/wp\/v2\/posts\/11859\/revisions"}],"predecessor-version":[{"id":11868,"href":"http:\/\/www.moonmile.net\/blog\/wp-json\/wp\/v2\/posts\/11859\/revisions\/11868"}],"wp:attachment":[{"href":"http:\/\/www.moonmile.net\/blog\/wp-json\/wp\/v2\/media?parent=11859"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"http:\/\/www.moonmile.net\/blog\/wp-json\/wp\/v2\/categories?post=11859"},{"taxonomy":"post_tag","embeddable":true,"href":"http:\/\/www.moonmile.net\/blog\/wp-json\/wp\/v2\/tags?post=11859"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}