{"width":"100%","provider_name":"Hatena Blog","height":"190","author_name":"moneyforwardDev","provider_url":"https://hatena.blog","title":"Ruby gem XlsFunction \u3092 OSS \u3068\u3057\u3066\u516c\u958b\u3057\u307e\u3057\u305f","type":"rich","author_url":"https://blog.hatena.ne.jp/moneyforwardDev/","blog_title":"Money Forward Developers Blog","version":"1.0","image_url":null,"blog_url":"https://moneyforward-dev.jp/","published":"2022-11-17 10:00:46","description":"\u3053\u3093\u306b\u3061\u306f\u3002\u798f\u5ca1\u958b\u767a\u62e0\u70b9\u3067 \u30af\u30e9\u30a6\u30c9\u50b5\u52d9\u652f\u6255 \u304a\u3088\u3073 \u30af\u30e9\u30a6\u30c9\u7d4c\u8cbb \u306e\u958b\u767a\u3092\u3057\u3066\u3044\u308b\u4e2d\u4e45\u559c\u3068\u7533\u3057\u307e\u3059\u3002 \u4eca\u56de\u306f\u793e\u5185\u3067\u958b\u767a\u3057\u305f gem XlsFunction \u3092 OSS \u3068\u3057\u3066\u516c\u958b\u3044\u305f\u3057\u307e\u3057\u305f\u306e\u3067\u3001\u305d\u306e\u7d39\u4ecb\u3092\u3055\u305b\u3066\u3044\u305f\u3060\u304d\u307e\u3059\u3002 XlsFunction \u3068\u306f Ruby \u3067 Excel \u306e\u95a2\u6570\u3092\u30a8\u30df\u30e5\u30ec\u30fc\u30c8\u3059\u308b\u3053\u3068\u304c\u3067\u304d\u307e\u3059\u3002 func = 'SUBSTITUTE(\"\u30de\u30cd\u30fc\u30d5\u30a9\u30ef\u30fc\u30c9\", \"\u30de\u30cd\u30fc\", \"\u30e9\u30a4\u30d5\")' XlsFunction.evaluate(func) # => \"\u30e9\u30a4\u30d5\u30d5\u30a9\u30ef\u30fc\u30c9\" func = 'ROUNDDOWN(100 / 3 * 2, 2)' XlsFunction.\u2026","url":"https://moneyforward-dev.jp/entry/2022/11/17/oss-for-xlsfunction/","html":"<iframe src=\"https://hatenablog-parts.com/embed?url=https%3A%2F%2Fmoneyforward-dev.jp%2Fentry%2F2022%2F11%2F17%2Foss-for-xlsfunction%2F\" title=\"Ruby gem XlsFunction \u3092 OSS \u3068\u3057\u3066\u516c\u958b\u3057\u307e\u3057\u305f - Money Forward Developers Blog\" class=\"embed-card embed-blogcard\" scrolling=\"no\" frameborder=\"0\" style=\"display: block; width: 100%; height: 190px; max-width: 500px; margin: 10px 0px;\"></iframe>","categories":[]}