{"id":22928,"date":"2025-06-08T17:43:48","date_gmt":"2025-06-08T08:43:48","guid":{"rendered":"https:\/\/cg-method.com\/google\/?p=22928"},"modified":"2025-06-08T17:44:59","modified_gmt":"2025-06-08T08:44:59","slug":"spreadsheet-hierarchy-visualization","status":"publish","type":"post","link":"https:\/\/cg-method.com\/google\/spreadsheet-hierarchy-visualization\/","title":{"rendered":"Google\u30b9\u30d7\u30ec\u30c3\u30c9\u30b7\u30fc\u30c8\u2502\u7d44\u7e54\u56f3\u3084UI\u69cb\u9020\u306e\u60c5\u5831\u3092\u30d3\u30b8\u30e5\u30a2\u30eb\u5316\uff01\u968e\u5c64\u8868\u793a\u3059\u308b\u65b9\u6cd5"},"content":{"rendered":"\n

\u3053\u306e\u8a18\u4e8b\u3067\u306f\u3001Google\u30b9\u30d7\u30ec\u30c3\u30c9\u30b7\u30fc\u30c8\u3067\u7ba1\u7406\u3057\u3066\u3044\u308b\u968e\u5c64\u30c7\u30fc\u30bf<\/strong>\u3092\u3001D3.js \u3092\u4f7f\u3063\u3066\u30d6\u30e9\u30a6\u30b6\u4e0a\u306b\u30c4\u30ea\u30fc\u69cb\u9020\u3067\u53ef\u8996\u5316<\/strong>\u3059\u308b\u65b9\u6cd5\u3092\u3054\u7d39\u4ecb\u3057\u307e\u3059\u3002<\/p>\n\n\n\n

\u8868\u793a\u30a4\u30e1\u30fc\u30b8<\/span><\/strong><\/p>\n\n\n\n

\u30b9\u30d7\u30ec\u30c3\u30c9\u30b7\u30fc\u30c8<\/strong><\/p>\n\n\n\n

\u5143\u306e\u30c7\u30fc\u30bf\u3067\u3059\u3002<\/p>\n\n\n\n

\"\"<\/figure>\n\n\n\n

\u30b9\u30d7\u30ec\u30c3\u30c9\u30b7\u30fc\u30c8\u306e\u60c5\u5831\u3092\u5143\u306b\u968e\u5c64\u8868\u793a<\/strong><\/p>\n\n\n\n

\"\"<\/figure>\n\n\n\n

\u8907\u6570\u306e\u968e\u5c64\u8868\u793a\u306b\u3082\u5bfe\u5fdc\u3057\u3066\u3044\u307e\u3059\u3002<\/p>\n\n\n\n

\u3055\u3089\u306b\u3001\u30ce\u30fc\u30c9\u3092\u30db\u30d0\u30fc\u3057\u305f\u969b\u306b\u88dc\u8db3\u60c5\u5831\u3092\u30c4\u30fc\u30eb\u30c1\u30c3\u30d7\u3067\u8868\u793a<\/strong>\u3059\u308b\u3088\u3046\u30ab\u30b9\u30bf\u30de\u30a4\u30ba\u3057\u3066\u3044\u307e\u3059\u3002<\/p>\n\n\n\n

\u30b9\u30d7\u30ec\u30c3\u30c9\u30b7\u30fc\u30c8\u306e\u4f5c\u6210<\/h2>\n\n\n\n

\u307e\u305a\u306f\u30b9\u30d7\u30ec\u30c3\u30c9\u30b7\u30fc\u30c8\u3092\u7528\u610f\u3002<\/p>\n\n\n\n

\u305f\u3068\u3048\u3070\u4ee5\u4e0b\u306e\u3068\u304a\u308a\u3002<\/p>\n\n\n\n

\u30b0\u30eb\u30fc\u30d7\u540d<\/th>nodeId<\/th>parentId<\/th>\u30ce\u30fc\u30c9\u540d<\/th>\u88dc\u8db3\u60c5\u5831<\/th><\/tr><\/thead>
\u732b\u30ab\u30d5\u30a7\u306b\u3083\u3093\u305f<\/td>sample<\/td><\/td>\u5e97\u8217\u672c\u90e8<\/td>\u4f4f\u6240\u3001\u8cac\u4efb\u8005\u3001\u55b6\u696d\u6642\u9593<\/td><\/tr>
\u732b\u30ab\u30d5\u30a7\u306b\u3083\u3093\u305f<\/td>sample\/\u732b\u7ba1\u7406<\/td>sample<\/td>\u732b\u7ba1\u7406\u30a8\u30ea\u30a2<\/td>\u540d\u524d\u3001\u5e74\u9f62\u3001\u6027\u683c<\/td><\/tr>
\u732b\u30ab\u30d5\u30a7\u306b\u3083\u3093\u305f<\/td>sample\/\u732b\u7ba1\u7406\/\u30df\u30b1<\/td>sample\/\u732b\u7ba1\u7406<\/td>\u30df\u30b1<\/td>3\u6b73\u3001\u7518\u3048\u3093\u574a\u3001\u2640<\/td><\/tr>
\u732b\u30ab\u30d5\u30a7\u306b\u3083\u3093\u305f<\/td>sample\/\u732b\u7ba1\u7406\/\u30bf\u30de<\/td>sample\/\u732b\u7ba1\u7406<\/td>\u30bf\u30de<\/td>2\u6b73\u3001\u6d3b\u767a\u3001\u2642<\/td><\/tr>
\u732b\u30ab\u30d5\u30a7\u306b\u3083\u3093\u305f<\/td>sample\/\u8a2d\u5099\u7ba1\u7406<\/td>sample<\/td>\u8a2d\u5099\u7ba1\u7406<\/td>\u7a7a\u8abf\u3001\u6e05\u6383\u3001\u5099\u54c1<\/td><\/tr>
\u732b\u30ab\u30d5\u30a7\u306b\u3083\u3093\u305f<\/td>sample\/\u4e88\u7d04\u7ba1\u7406<\/td>sample 1 Variant<\/td>\u4e88\u7d04\u30fb\u9867\u5ba2\u7ba1\u7406<\/td>\u4e88\u7d04\u4e00\u89a7\u3001\u4f1a\u54e1\u30ab\u30fc\u30c9<\/td><\/tr><\/tbody><\/table><\/figure>\n\n\n\n

\u3042\u3068\u306f\u62e1\u5f35\u6a5f\u80fd\u304b\u3089APP Script\u3092\u9078\u629e\u3057\u3066\u30b3\u30fc\u30c9\u3092\u8a18\u8f09\u3059\u308b\u3060\u3051\u3067\u3059\u3002<\/p>\n\n\n\n

\"\"<\/figure>\n\n\n\n

\u4ee5\u4e0b\u3001\u3084\u308a\u65b9\u3067\u3059\u3002<\/p>\n\n\n\n

GAS\u2502\u30b3\u30fc\u30c9\u306e\u69cb\u6210<\/h2>\n\n\n\n
    \n
  • index.html<\/code> \u3067 <svg><\/code> \u3092\u914d\u7f6e<\/li>\n\n\n\n
  • js.html<\/code> \u306b CSS\u306b\u3088\u308b\u63cf\u753b\u30ed\u30b8\u30c3\u30af\u3092\u8a18\u8ff0<\/li>\n\n\n\n
  • js.html<\/code> \u306b D3.js \u306b\u3088\u308b\u63cf\u753b\u30ed\u30b8\u30c3\u30af\u3092\u8a18\u8ff0<\/li>\n\n\n\n
  • main.gs<\/code> \u3067 Apps Script \u7d4c\u7531\u3067\u30b7\u30fc\u30c8\u3092\u53d6\u5f97<\/li>\n<\/ul>\n\n\n\n
    \"\"<\/figure>\n\n\n\n

    \u30b3\u30fc\u30c9\u5168\u6587<\/h2>\n\n\n\n

    \u203b\u4ee5\u4e0b\u306e\u30b3\u30fc\u30c9\u3092\u8cbc\u308a\u4ed8\u3051\u3066\u304f\u3060\u3055\u3044\u3002<\/p>\n\n\n\n

    <\/div><\/div>","protected":false},"excerpt":{"rendered":"

    \u3053\u306e\u8a18\u4e8b\u3067\u306f\u3001Google\u30b9\u30d7\u30ec\u30c3\u30c9\u30b7\u30fc\u30c8\u3067\u7ba1\u7406\u3057\u3066\u3044\u308b\u968e\u5c64\u30c7\u30fc\u30bf\u3092\u3001D3.js \u3092\u4f7f\u3063\u3066\u30d6\u30e9\u30a6\u30b6\u4e0a\u306b\u30c4\u30ea\u30fc\u69cb\u9020\u3067\u53ef\u8996\u5316\u3059\u308b\u65b9\u6cd5\u3092\u3054\u7d39\u4ecb\u3057\u307e\u3059\u3002 \u8868\u793a\u30a4\u30e1\u30fc\u30b8 \u30b9\u30d7\u30ec\u30c3\u30c9\u30b7\u30fc\u30c8 \u5143\u306e\u30c7\u30fc\u30bf\u3067\u3059\u3002 \u30b9\u30d7\u30ec\u30c3\u30c9\u30b7\u30fc\u30c8\u306e\u60c5\u5831\u3092 […]<\/p>\n","protected":false},"author":1,"featured_media":22929,"comment_status":"closed","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"swell_btn_cv_data":"","footnotes":""},"categories":[16],"tags":[18,8],"class_list":["post-22928","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-web-applications","tag-gas","tag-subscription"],"_links":{"self":[{"href":"https:\/\/cg-method.com\/google\/wp-json\/wp\/v2\/posts\/22928","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/cg-method.com\/google\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/cg-method.com\/google\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/cg-method.com\/google\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/cg-method.com\/google\/wp-json\/wp\/v2\/comments?post=22928"}],"version-history":[{"count":2,"href":"https:\/\/cg-method.com\/google\/wp-json\/wp\/v2\/posts\/22928\/revisions"}],"predecessor-version":[{"id":22934,"href":"https:\/\/cg-method.com\/google\/wp-json\/wp\/v2\/posts\/22928\/revisions\/22934"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/cg-method.com\/google\/wp-json\/wp\/v2\/media\/22929"}],"wp:attachment":[{"href":"https:\/\/cg-method.com\/google\/wp-json\/wp\/v2\/media?parent=22928"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/cg-method.com\/google\/wp-json\/wp\/v2\/categories?post=22928"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/cg-method.com\/google\/wp-json\/wp\/v2\/tags?post=22928"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}