{"image_url":"https://cdn-ak.f.st-hatena.com/images/fotolife/y/ycloud/20230828/20230828065011.jpg","type":"rich","title":"\u3010Power Automate\u3011Excel\u306e\u8868\u304b\u3089\u5024\u62bd\u51fa\uff08\uff12\u6b21\u5143\u914d\u5217\u306eDataTable\u304b\u3089\u53d6\u5f97\uff09","published":"2023-08-29 12:30:00","categories":["PowerAutomate"],"version":"1.0","author_url":"https://blog.hatena.ne.jp/ycloud/","width":"100%","blog_title":"shikumika\u2019s diary","provider_name":"Hatena Blog","url":"https://shikumika.org/entry/powerautomate-datatable","height":"190","blog_url":"https://shikumika.org/","provider_url":"https://hatena.blog","description":"Power Automate Desktop\u306e\u300cExcel \u30ef\u30fc\u30af\u30b7\u30fc\u30c8\u304b\u3089\u8aad\u307f\u53d6\u308b\u300d\u306e\u30b9\u30c6\u30c3\u30d7\u3067\u3001\u5024\u3092DateTable\uff08\u30c7\u30fc\u30bf\u30c6\u30fc\u30d6\u30eb\uff09\u3067\u53d6\u5f97\u3057\u305f\u5834\u5408\u306a\u3069\u3001\u30c7\u30fc\u30bf\u30c6\u30fc\u30d6\u30eb\u304b\u3089\u5024\u62bd\u51fa\u306e\u57fa\u672c\u3002 \u57fa\u672c \u4f8b\u3048\u3070\u3001\u6b21\u306e\u3088\u3046\u306bExcelData\u3068\u3044\u3046\u5909\u6570\u306b\u3001\u30c7\u30fc\u30bf\u30c6\u30fc\u30d6\u30eb\u578b\u30675\u884c5\u5217\u306e2\u6b21\u5143\u914d\u5217\u304c\u683c\u7d0d\u3055\u308c\u3066\u3044\u308b\u3068\u3059\u308b\u3002 Datatable\uff08\u30c7\u30fc\u30bf\u30c6\u30fc\u30d6\u30eb\uff09\u306e\u30a4\u30e1\u30fc\u30b8 \u3053\u306e\u3068\u304d2\u884c3\u5217\u76ee\uff08\u7e26\u65b9\u5411\u306e\u756a\u53f71\u3001\u5217\u306fColumn3\uff09\u306b\u8a72\u5f53\u3059\u308b\u5024\u3092\u62bd\u51fa\u3059\u308b\u5834\u5408\u306f\u3001 %ExcelData[1][2]% \u3068\u5909\u6570\u306b\u89d2\u62ec\u5f27\u3092\u8ffd\u52a0\u3057\u3066\u884c\u5217\u306b\u76f8\u5f53\u3059\u308b\u6570\u5024\u3092\u6307\u5b9a\u3059\u308b\u3002 \u6570\u5024\u306f\u3001\u884c\u5217\u306e\u958b\u59cb\u756a\u53f7\u304c0\u3067\u3042\u308b\u3053\u3068\u306b\u6ce8\u610f\u3059\u308b\u3002 \u305d\u306e\u4ed6\u30c7\u2026","html":"<iframe src=\"https://hatenablog-parts.com/embed?url=https%3A%2F%2Fshikumika.org%2Fentry%2Fpowerautomate-datatable\" title=\"\u3010Power Automate\u3011Excel\u306e\u8868\u304b\u3089\u5024\u62bd\u51fa\uff08\uff12\u6b21\u5143\u914d\u5217\u306eDataTable\u304b\u3089\u53d6\u5f97\uff09 - shikumika\u2019s diary\" class=\"embed-card embed-blogcard\" scrolling=\"no\" frameborder=\"0\" style=\"display: block; width: 100%; height: 190px; max-width: 500px; margin: 10px 0px;\"></iframe>","author_name":"ycloud"}