{"id":12710,"date":"2020-05-02T14:24:22","date_gmt":"2020-05-02T05:24:22","guid":{"rendered":"https:\/\/www.ka-net.org\/blog\/?p=12710"},"modified":"2020-09-03T16:01:28","modified_gmt":"2020-09-03T07:01:28","slug":"office-scriptspower-automate%e3%81%8b%e3%82%89%e3%82%b9%e3%82%af%e3%83%aa%e3%83%97%e3%83%88%e3%82%92%e5%ae%9f%e8%a1%8c%e3%81%99%e3%82%8b","status":"publish","type":"post","link":"https:\/\/www.ka-net.org\/blog\/?p=12710","title":{"rendered":"[Office Scripts]Power Automate\u304b\u3089\u30b9\u30af\u30ea\u30d7\u30c8\u3092\u5b9f\u884c\u3059\u308b"},"content":{"rendered":"

\u4e0b\u8a18Web\u30b5\u30a4\u30c8\u306b\u3042\u308b\u901a\u308a\u3001Office Scripts\u306e\u30b9\u30af\u30ea\u30d7\u30c8\u306fPower Automate\u304b\u3089\u5b9f\u884c\u3059\u308b\u3053\u3068\u304c\u3067\u304d\u307e\u3059\u3002<\/p>\n

Through this feature, you can record your actions inside an Excel workbook and save it to a script. Later you can use the script with Power Automate (formerly Microsoft Flow) or integrate with your workflow.<\/p><\/blockquote>\n

https:\/\/mspoweruser.com\/office-scripts-microsoft-finally-makes-it-easy-to-create-scripts-for-excel\/<\/a> \u3088\u308a<\/p>\n

Office Scripts can be run through Power Automate. Your workbook can be updated through scheduled or event-driven flows, letting you automate workflows without even opening Excel.<\/p><\/blockquote>\n

https:\/\/docs.microsoft.com\/en-us\/office\/dev\/scripts\/resources\/vba-differences<\/a> \u3088\u308a<\/p>\n

\u4eca\u56de\u306fPower Automate\u306e\u30d5\u30ed\u30fc\u304b\u3089Office Scripts\u306e\u30b9\u30af\u30ea\u30d7\u30c8\u3092\u5b9f\u884c\u3059\u308b\u65b9\u6cd5\u3092\u7d39\u4ecb\u3057\u307e\u3059\u3002<\/p>\n

\u5b9f\u884c\u3059\u308b\u30b9\u30af\u30ea\u30d7\u30c8\u306e\u4f5c\u6210<\/h4>\n

\u307e\u305a\u306f\u5bfe\u8c61\u3068\u306a\u308b\u30d5\u30a1\u30a4\u30eb\u3068\u5b9f\u884c\u3059\u308b\u30b9\u30af\u30ea\u30d7\u30c8\u3092\u4f5c\u6210\u3057\u307e\u3059\u3002<\/p>\n

\"\"<\/a><\/p>\n