{"id":16042,"date":"2024-04-10T12:43:02","date_gmt":"2024-04-10T03:43:02","guid":{"rendered":"https:\/\/www.autooffice.co.kr\/?p=16042"},"modified":"2025-09-15T17:37:12","modified_gmt":"2025-09-15T08:37:12","slug":"spreadsheet-class%ec%9d%98-createtextfinder","status":"publish","type":"post","link":"https:\/\/www.autooffice.co.kr\/en\/blog\/2024\/04\/10\/spreadsheet-class%ec%9d%98-createtextfinder\/","title":{"rendered":"Spreadsheet class\uc758 createTextFinder() \uc0ac\uc6a9 \ubc29\ubc95"},"content":{"rendered":"\n<a href=\"#anchor-1\">1. \uc694\uc57d<\/a><\/br>\n<a href=\"#anchor-2\">2. createTextFinder()\ub780?<\/a><\/br>\n<a href=\"#anchor-3\">3. Spreadsheet \ud074\ub798\uc2a4\uc5d0\uc11c createTextFinder() \uc0ac\uc6a9\ud558\uae30<\/a><\/br>\n\n\n<div class=\"wp-block-aioseo-table-of-contents\"><ol><li><a class=\"aioseo-toc-item\" href=\"#anchor-1\">1. \uc694\uc57d<\/a><\/li><li><a class=\"aioseo-toc-item\" href=\"#anchor-2\">2. createTextFinder()\ub780?<\/a><\/li><li><a class=\"aioseo-toc-item\" href=\"#anchor-3\">3. Spreadsheet \ud074\ub798\uc2a4\uc5d0\uc11c createTextFinder() \uc0ac\uc6a9\ud558\uae30<\/a><ol><li><a class=\"aioseo-toc-item\" href=\"#aioseo-\uae30\ubcf8-\uc0ac\uc6a9-\ubc29\ubc95\">\uae30\ubcf8 \uc0ac\uc6a9 \ubc29\ubc95<\/a><\/li><li><a class=\"aioseo-toc-item\" href=\"#aioseo-\ud65c\uc6a9-\uc608\uc2dc\">\ud65c\uc6a9 \uc608\uc2dc<\/a><\/li><li><a class=\"aioseo-toc-item\" href=\"#aioseo-\ucf54\ub4dc\">\ucf54\ub4dc<\/a><\/li><li><a class=\"aioseo-toc-item\" href=\"#aioseo-\ucf54\ub4dc-\uc124\uba85\">\ucf54\ub4dc \uc124\uba85<\/a><\/li><\/ol><\/li><li><a class=\"aioseo-toc-item\" href=\"#aioseo-\uc5c5\ubb34-\ud6a8\uc728\uc131-200-\uc62c\ub9ac\uae30-with-autooffice\">\uc5c5\ubb34 \ud6a8\uc728\uc131 200% \uc62c\ub9ac\uae30, with autooffice<\/a><\/li><li><a class=\"aioseo-toc-item\" href=\"#aioseo-\ub8e8\ucee4-\uc2a4\ud29c\ub514\uc624-\uac1c\ubc1c-\ubb38\uc758\ub294-\uad6c\uae00\ud3fc\uc744-\uc774\uc6a9\ud574\uc8fc\uc138\uc694\">\ud504\ub85c\uc81d\ud2b8 \uac1c\ubc1c \ubb38\uc758\ub294 \uad6c\uae00\ud3fc\uc744 \uc774\uc6a9\ud574\uc8fc\uc138\uc694!<\/a><\/li><\/ol><\/div>\n\n\n<h2 class=\"wp-block-heading\" id=\"anchor-1\"><br>1. \uc694\uc57d<\/h2>\n\n\n\n<p><br>\uc774 \ud3ec\uc2a4\ud2b8\uc5d0\uc11c\ub294 createTextFinder() \uba54\uc18c\ub4dc\ub97c \uc0ac\uc6a9\ud558\uc5ec Spreadsheet \ud074\ub798\uc2a4\uc5d0\uc11c \ud2b9\uc815 \ud14d\uc2a4\ud2b8\ub97c \ucc3e\ub294 \ubc29\ubc95\uc744 \uc18c\uac1c\ud569\ub2c8\ub2e4. \uc774 \ud3ec\uc2a4\ud2b8\ub294 Sheet, Range \ud074\ub798\uc2a4\uc5d0\uc11c createTextFinder() \uba54\uc18c\ub4dc\ub97c \uc0ac\uc6a9\ud558\ub294 \ubc29\ubc95\uc744 \uc18c\uac1c\ud558\ub294 \ud3ec\uc2a4\ud2b8\ub85c \ub0b4\uc6a9\uc774 \uc774\uc5b4\uc9d1\ub2c8\ub2e4.<br><br><a href=\"https:\/\/www.autooffice.co.kr\/blog\/2024\/04\/10\/sheet-class%ec%9d%98-createtextfinder\/\">Sheet class\uc758 createTextFinder()<\/a><br><a href=\"https:\/\/www.autooffice.co.kr\/blog\/2024\/04\/10\/range-class%ec%9d%98-createtextfindertextfinder-class%ec%9d%98-%eb%a9%94%ec%86%8c%eb%93%9c-%ec%86%8c%ea%b0%9c\/\">Range class\uc758 createTextFinder&amp;TextFinder class\uc758 \uba54\uc18c\ub4dc \uc18c\uac1c<\/a><br><br><\/p>\n\n\n\n<h2 class=\"wp-block-heading\" id=\"anchor-2\">2. createTextFinder()\ub780?<\/h2>\n\n\n\n<p><br>\uad6c\uae00 \uc2dc\ud2b8\uc5d0\uc11c \uc571\uc2a4 \uc2a4\ud06c\ub9bd\ud2b8\ub85c \uc791\uc5c5\uc744 \ud558\ub2e4\ubcf4\uba74 \ud2b9\uc815 \ud14d\uc2a4\ud2b8\ub97c \uac80\uc0c9\ud574\uc57c \ud560 \ub54c\uac00 \ub9ce\uc2b5\ub2c8\ub2e4. \uc608\ub97c \ub4e4\uc5b4, \ub2e4\uc74c\uc758 \uc774\ubbf8\uc9c0\ucc98\ub7fc \uace0\uac1d \uc815\ubcf4\ub97c \uad00\ub9ac\ud558\ub294 \uad6c\uae00 \uc2dc\ud2b8\uc5d0 \uc571\uc2a4 \uc2a4\ud06c\ub9bd\ud2b8\ub85c \uc2e0\uaddc \uace0\uac1d\uc744 \ucd94\uac00\ud558\ub294 \uae30\ub2a5\uc744 \uc0ac\uc6a9\ud55c\ub2e4\uace0 \uac00\uc815\ud574\ubcfc\uae4c\uc694? \uace0\uac1d \uc815\ubcf4\ub97c \uc785\ub825\ud55c \ub4a4\uc5d0 \u2018<strong>\uc785\ub825\ud558\uae30<\/strong>\u2019 \ubc84\ud2bc\uc744 \ub204\ub974\uba74, \uadf8 \ub2e4\uc74c \uc774\ubbf8\uc9c0\ucc98\ub7fc \uace0\uac1d\ub4e4\uc758 \ubaa9\ub85d\uc73c\ub85c \uc800\uc7a5\ub429\ub2c8\ub2e4.<br><br>\uace0\uac1d \uc815\ubcf4 \uad00\ub9ac\uc5d0 \uc18c\ud640\ud574\uc9c0\uba74 \uc911\ubcf5\ub418\ub294 \ub370\uc774\ud130\uc758 \uc218\uac00 \ub9ce\uc544\uc9c8 \uc218 \uc788\uc2b5\ub2c8\ub2e4. \uc774 \ub54c, \uc571\uc2a4 \uc2a4\ud06c\ub9bd\ud2b8\ub97c \uc774\uc6a9\ud558\uba74 \uc0c8\ub85c\uc6b4 \uace0\uac1d \uc815\ubcf4\uac00 \uc785\ub825\ub420 \ub54c\ub9c8\ub2e4 \ud574\ub2f9 \uace0\uac1d\uc774 \uc774\ubbf8 \ub4f1\ub85d\ub41c \uace0\uac1d\uc778\uc9c0 \ud655\uc778\ud558\uace0 \uc54c\ub9bc\uc744 \ud45c\uc2dc\ud560 \uc218 \uc788\uc2b5\ub2c8\ub2e4.<br><br><\/p>\n\n\n<div class=\"wp-block-image\">\n<figure class=\"aligncenter size-full is-resized\"><img loading=\"lazy\" decoding=\"async\" width=\"379\" height=\"484\" src=\"https:\/\/www.autooffice.co.kr\/wp\/wp-content\/uploads\/2024\/04\/1.\uc608\uc2dc.jpg\" alt=\"\" class=\"wp-image-16044\" style=\"width:437px;height:auto\" srcset=\"https:\/\/www.autooffice.co.kr\/wp\/wp-content\/uploads\/2024\/04\/1.\uc608\uc2dc.jpg 379w, https:\/\/www.autooffice.co.kr\/wp\/wp-content\/uploads\/2024\/04\/1.\uc608\uc2dc-235x300.jpg 235w\" sizes=\"auto, (max-width: 379px) 100vw, 379px\" \/><figcaption class=\"wp-element-caption\">\u2018<strong>\uc785\ub825\ud558\uae30<\/strong>\u2019\ubc84\ud2bc\uc744 \ud074\ub9ad \uc2dc \uc571\uc2a4 \uc2a4\ud06c\ub9bd\ud2b8 \ucf54\ub4dc\uc5d0 \uc758\ud574 \uace0\uac1d\uc758 \uc815\ubcf4\uac00 \uc800\uc7a5\ub429\ub2c8\ub2e4.<br><\/figcaption><\/figure>\n<\/div>\n\n<div class=\"wp-block-image\">\n<figure class=\"aligncenter size-full is-resized\"><img loading=\"lazy\" decoding=\"async\" width=\"366\" height=\"132\" src=\"https:\/\/www.autooffice.co.kr\/wp\/wp-content\/uploads\/2024\/04\/2.-\uc608\uc2dc.jpg\" alt=\"\" class=\"wp-image-16045\" style=\"width:462px;height:auto\" srcset=\"https:\/\/www.autooffice.co.kr\/wp\/wp-content\/uploads\/2024\/04\/2.-\uc608\uc2dc.jpg 366w, https:\/\/www.autooffice.co.kr\/wp\/wp-content\/uploads\/2024\/04\/2.-\uc608\uc2dc-300x108.jpg 300w\" sizes=\"auto, (max-width: 366px) 100vw, 366px\" \/><figcaption class=\"wp-element-caption\">\uc785\ub825\ud55c \uace0\uac1d\uc758 \uc815\ubcf4\uac00 \uc800\uc7a5\ub41c \ubaa9\ub85d<\/figcaption><\/figure>\n<\/div>\n\n\n<p><br>\uad6c\uae00 \uc571\uc2a4 \uc2a4\ud06c\ub9bd\ud2b8\uc758 \u2018<strong>createTextFinder()<\/strong>\u2019 \ub294 \uad6c\uae00 \uc2a4\ud504\ub808\ub4dc\uc2dc\ud2b8\uc5d0\uc11c \ud14d\uc2a4\ud2b8\ub97c \uac80\uc0c9\ud560 \ub54c \uc0ac\uc6a9\ud560 \uc218 \uc788\ub294 \uba54\uc18c\ub4dc\uc785\ub2c8\ub2e4. \ud2b9\uc815 \uc2a4\ud504\ub808\ub4dc\uc2dc\ud2b8 \ubc94\uc704\uc5d0\uc11c \ud2b9\uc815 \ud14d\uc2a4\ud2b8\ub97c \ucc3e\uace0, \ud574\ub2f9 \ud14d\uc2a4\ud2b8\uac00 \ud3ec\ud568\ub41c \ubaa8\ub4e0 \uc140\uc774\ub098 \ubb38\uc11c \uc694\uc18c\ub97c \ubc18\ud658\ud569\ub2c8\ub2e4. \uba54\uc18c\ub4dc\uc758 \uad04\ud638 \uc548\uc5d0\ub294 \ud14d\uc2a4\ud2b8\ub97c \ub123\uc5b4\ub3c4 \ub418\uace0, \ubcc0\uc218\ub97c \ub123\uc5b4\ub3c4 \ub429\ub2c8\ub2e4.<br><br><\/p>\n\n\n\n<h2 class=\"wp-block-heading\" id=\"anchor-3\">3. Spreadsheet \ud074\ub798\uc2a4\uc5d0\uc11c createTextFinder() \uc0ac\uc6a9\ud558\uae30<\/h2>\n\n\n\n<p><br>Spreadsheet \ud074\ub798\uc2a4\uc758 <strong>createTextFinder()<\/strong>\ub294 <mark style=\"background-color:#fffd73\" class=\"has-inline-color\"><strong>\uad6c\uae00 \uc2dc\ud2b8 \uc804\uccb4\ub97c \ub300\uc0c1\uc73c\ub85c \ud14d\uc2a4\ud2b8\ub97c \uac80\uc0c9<\/strong><\/mark>\ud569\ub2c8\ub2e4. <br><br>\uc2e4\ubb34\uc5d0\uc11c\ub294 \ud6e8\uc52c \ub354 \ub2e4\uc591\ud558\uace0 \ubcf5\uc7a1\ud55c \uc815\ubcf4\ub4e4\uc744 \ub2e4\ub8e8\uaca0\uc9c0\ub9cc, \uc774\ubc88 \ud3ec\uc2a4\ud2b8\ub294 \uc571\uc2a4 \uc2a4\ud06c\ub9bd\ud2b8\uc758 \uba54\uc18c\ub4dc\ub97c \uc18c\uac1c\ud558\uae30 \uc704\ud55c \ubaa9\uc801\uc774\uae30 \ub54c\ubb38\uc5d0, \uc55e\uc5d0\uc11c \ubcf4\uc558\ub358 \uac04\ub2e8\ud55c \uc774\ubbf8\uc9c0 \uc18d \uc608\uc2dc\ub97c \uc0ac\uc6a9\ud558\uaca0\uc2b5\ub2c8\ub2e4. \uace0\uac1d\uc758 \uace0\uc720\ud55c \uc815\ubcf4\uc778 \uc5f0\ub77d\ucc98\uac00 \uc911\ubcf5\ub418\ub294\uc9c0 \ud655\uc778\ud558\uc5ec \uc5f0\ub77d\ucc98\uac00 \uc874\uc7ac\ud558\uc9c0 \uc54a\ub294\ub2e4\uba74 \uace0\uac1d \ubaa9\ub85d\uc5d0 \uc800\uc7a5\ud558\uace0, \uc5f0\ub77d\ucc98\uac00 \uc774\ubbf8 \uc874\uc7ac\ud55c\ub2e4\uba74 \uace0\uac1d \ubaa9\ub85d\uc5d0 \uc800\uc7a5\ud558\uc9c0 \uc54a\uace0 \uc54c\ub9bc \ucc3d\uc744 \ub744\uc6cc\ubcf4\uaca0\uc2b5\ub2c8\ub2e4.<br><br><\/p>\n\n\n\n<h5 class=\"wp-block-heading\" id=\"aioseo-\uae30\ubcf8-\uc0ac\uc6a9-\ubc29\ubc95\">\uae30\ubcf8 \uc0ac\uc6a9 \ubc29\ubc95<\/h5>\n\n\n\n<p><br>\uae30\ubcf8\uc801\uc778 \uc0ac\uc6a9 \ubc29\ubc95\uc740 \ub2e4\uc74c\uacfc \uac19\uc2b5\ub2c8\ub2e4. createTextFinder \uba54\uc18c\ub4dc\ub294 \ud2b9\uc815 \ubb38\uc790\uc5f4 \ub610\ub294 \uc815\uaddc\uc2dd\uc744 \uc0ac\uc6a9\ud558\uc5ec \uc2a4\ud504\ub808\ub4dc\uc2dc\ud2b8\uc758 \uc140\uc744 \uac80\uc0c9\ud558\ub294 \ub370 \uc0ac\uc6a9\ub429\ub2c8\ub2e4. \ubcc0\uc218\ub97c \ub123\uc5b4\uc11c \uac80\uc0c9\ud560 \uc218\ub3c4 \uc788\uc2b5\ub2c8\ub2e4. \uc774 \uba54\uc18c\ub4dc\ub294 \u2018TextFinder\u2019 \uac1d\uccb4\ub97c \ubc18\ud658\ud569\ub2c8\ub2e4.<br><\/p>\n\n\n\n<pre class=\"wp-block-code\"><code>function searchBySpreadsheet() {\n  const SS = SpreadsheetApp.getActiveSpreadsheet();\n  let finder = SS.createTextFinder('\ud14d\uc2a4\ud2b8 \ub610\ub294 \ubcc0\uc218');\n}<\/code><\/pre>\n\n\n\n<p><br>\uad6c\uae00\uc5d0\uc11c \uc81c\uacf5\ud558\ub294 \uacf5\uc2dd \ub808\ud37c\ub7f0\uc2a4\ub294 \ub2e4\uc74c \uc6f9\uc0ac\uc774\ud2b8\ub97c \ucc38\uace0\ud574\uc8fc\uc138\uc694.<br><br><\/p>\n\n\n<div class=\"wp-block-image\">\n<figure class=\"aligncenter size-full\"><a href=\"https:\/\/developers.google.com\/apps-script\/reference\/spreadsheet\/spreadsheet?hl=ko#createtextfinderfindtext\" target=\"_blank\" rel=\"noreferrer noopener\"><img loading=\"lazy\" decoding=\"async\" width=\"392\" height=\"129\" src=\"https:\/\/www.autooffice.co.kr\/wp\/wp-content\/uploads\/2024\/04\/Google.png\" alt=\"\" class=\"wp-image-16046\" srcset=\"https:\/\/www.autooffice.co.kr\/wp\/wp-content\/uploads\/2024\/04\/Google.png 392w, https:\/\/www.autooffice.co.kr\/wp\/wp-content\/uploads\/2024\/04\/Google-300x99.png 300w\" sizes=\"auto, (max-width: 392px) 100vw, 392px\" \/><\/a><figcaption class=\"wp-element-caption\"><a href=\"https:\/\/developers.google.com\/apps-script\/reference\/spreadsheet\/spreadsheet?hl=ko#createtextfinderfindtext\" target=\"_blank\" rel=\"noopener\" title=\"\">\uad6c\uae00 \uacf5\uc2dd \ub808\ud37c\ub7f0\uc2a4 \ubc14\ub85c\uac00\uae30<\/a><\/figcaption><\/figure>\n<\/div>\n\n\n<h5 class=\"wp-block-heading\" id=\"aioseo-\ud65c\uc6a9-\uc608\uc2dc\"><br><br>\ud65c\uc6a9 \uc608\uc2dc<br><br><\/h5>\n\n\n\n<p>\ub2e4\uc74c\uc758 \uc2a4\ud504\ub808\ub4dc\uc2dc\ud2b8\ub97c \ud568\uaed8 \ubcf4\uc2dc\uc8e0. \uc2e0\uaddc \uace0\uac1d\uc758 \uc815\ubcf4\ub97c \uc785\ub825\ud558\ub294 \ud654\uba74\uc785\ub2c8\ub2e4. \uc2e0\uaddc \uace0\uac1d\uc758 \uac00\uc785\uc77c\uacfc \uc774\ub984, \uc5f0\ub77d\ucc98\uc640 \uc9c0\uc5ed\uc744 \uc124\uc815\ud55c \ub4a4\uc5d0 \u2018<strong>\uc785\ub825\ud558\uae30<\/strong>\u2019 \ubc84\ud2bc\uc744 \ub204\ub974\uba74, \uc785\ub825\ud55c \uc9c0\uc5ed\uc5d0 \ud574\ub2f9\ud558\ub294 \uc2dc\ud2b8\uc5d0 \uace0\uac1d \uc815\ubcf4\uac00 \uae30\uc785\ub429\ub2c8\ub2e4. \uace0\uac1d \uc815\ubcf4\uac00 \uc9c0\uc5ed \ubd84\ub958\uc5d0 \ub530\ub77c \uc5ec\ub7ec \uac1c\uc758 \uc2dc\ud2b8\uc5d0 \uc800\uc7a5\ub418\ub294 \uac83\uc785\ub2c8\ub2e4.<br><\/p>\n\n\n<div class=\"wp-block-image\">\n<figure class=\"aligncenter size-full\"><img loading=\"lazy\" decoding=\"async\" width=\"595\" height=\"753\" src=\"https:\/\/www.autooffice.co.kr\/wp\/wp-content\/uploads\/2024\/04\/3.\uc2e0\uaddc-\uace0\uac1d-\ucd94\uac00.jpg\" alt=\"\" class=\"wp-image-16047\" srcset=\"https:\/\/www.autooffice.co.kr\/wp\/wp-content\/uploads\/2024\/04\/3.\uc2e0\uaddc-\uace0\uac1d-\ucd94\uac00.jpg 595w, https:\/\/www.autooffice.co.kr\/wp\/wp-content\/uploads\/2024\/04\/3.\uc2e0\uaddc-\uace0\uac1d-\ucd94\uac00-237x300.jpg 237w\" sizes=\"auto, (max-width: 595px) 100vw, 595px\" \/><figcaption class=\"wp-element-caption\">\uace0\uac1d \uc815\ubcf4\ub97c \uc9c0\uc5ed\uc5d0 \ub9de\ub294 \uc2dc\ud2b8\uc5d0 \uc800\uc7a5\ud569\ub2c8\ub2e4.<\/figcaption><\/figure>\n<\/div>\n\n\n<p><br>\u2018<strong>\uc11c\uc6b8<\/strong>\u2019 \uc9c0\uc5ed\uc758 \uace0\uac1d\uc744 \uc785\ub825 \ud6c4 \u2018<strong>\uc785\ub825\ud558\uae30<\/strong>\u2019 \ubc84\ud2bc\uc744 \ud074\ub9ad\ud558\uba74 \uc544\ub798\ucc98\ub7fc \u2018<strong>\uc11c\uc6b8<\/strong>\u2019 \uc2dc\ud2b8\uc5d0 \ud68c\uc6d0\uc774 \ucd94\uac00\ub429\ub2c8\ub2e4.<br><br><\/p>\n\n\n<div class=\"wp-block-image\">\n<figure class=\"aligncenter size-full is-resized\"><img loading=\"lazy\" decoding=\"async\" width=\"613\" height=\"577\" src=\"https:\/\/www.autooffice.co.kr\/wp\/wp-content\/uploads\/2024\/04\/4.\ucd94\uac00-\uc644\ub8cc.jpg\" alt=\"\" class=\"wp-image-16048\" style=\"width:613px;height:auto\" srcset=\"https:\/\/www.autooffice.co.kr\/wp\/wp-content\/uploads\/2024\/04\/4.\ucd94\uac00-\uc644\ub8cc.jpg 613w, https:\/\/www.autooffice.co.kr\/wp\/wp-content\/uploads\/2024\/04\/4.\ucd94\uac00-\uc644\ub8cc-300x282.jpg 300w\" sizes=\"auto, (max-width: 613px) 100vw, 613px\" \/><figcaption class=\"wp-element-caption\">\uc9c0\uc5ed\uc774 &#8216;<strong>\uc11c\uc6b8<\/strong>&#8216;\uc778 \uace0\uac1d\uc758 \uc815\ubcf4\uac00 \uc2e0\uaddc \ub4f1\ub85d\ub41c \ud654\uba74<\/figcaption><\/figure>\n<\/div>\n\n\n<p><br>\u2018<strong>\uc2e0\uaddc \uace0\uac1d \ucd94\uac00<\/strong>\u2019 \uc2dc\ud2b8\uc5d0 \uc788\ub294 \u2018<strong>\uc785\ub825\ud558\uae30<\/strong>\u2019 \ubc84\ud2bc\uc5d0 \ud560\ub2f9\ub41c \uc2a4\ud06c\ub9bd\ud2b8\ub294 \uc544\ub798\uc640 \uac19\uc2b5\ub2c8\ub2e4.<br><br><\/p>\n\n\n\n<h5 class=\"wp-block-heading\" id=\"aioseo-\ucf54\ub4dc\">\ucf54\ub4dc<br><br><\/h5>\n\n\n\n<div id=\"urvanov-syntax-highlighter-6617541ef25fa432511513\" class=\"urvanov-syntax-highlighter-syntax crayon-theme-powershell-ise urvanov-syntax-highlighter-font-sourcecodepro urvanov-syntax-highlighter-os-pc print-yes notranslate\" data-settings=\" no-popup minimize scroll-always\" style=\"max-width: 800px;margin-top: 12px;margin-bottom: 12px;font-size: 12px !important;line-height: 25px !important;height: auto\">\n\t\t\n\t\t\t<div class=\"urvanov-syntax-highlighter-plain-wrap\"><\/div>\n\t\t\t<div class=\"urvanov-syntax-highlighter-main\" style=\"max-width: 800px;position: relative;z-index: 1\">\n\t\t\t\t<table class=\"crayon-table\" style=\"margin-left: -25px\">\n\t\t\t\t\t<tbody><tr class=\"urvanov-syntax-highlighter-row\">\n\t\t\t\t<td class=\"crayon-nums \" data-settings=\"hide\">\n\t\t\t\t\t<div class=\"urvanov-syntax-highlighter-nums-content\" style=\"font-size: 12px !important;line-height: 25px !important\"><div class=\"crayon-num\" data-line=\"urvanov-syntax-highlighter-6617541ef25fa432511513-1\">1<\/div><div class=\"crayon-num\" data-line=\"urvanov-syntax-highlighter-6617541ef25fa432511513-2\">2<\/div><div class=\"crayon-num\" data-line=\"urvanov-syntax-highlighter-6617541ef25fa432511513-3\">3<\/div><div class=\"crayon-num\" data-line=\"urvanov-syntax-highlighter-6617541ef25fa432511513-4\">4<\/div><div class=\"crayon-num\" data-line=\"urvanov-syntax-highlighter-6617541ef25fa432511513-5\">5<\/div><div class=\"crayon-num\" data-line=\"urvanov-syntax-highlighter-6617541ef25fa432511513-6\">6<\/div><div class=\"crayon-num\" data-line=\"urvanov-syntax-highlighter-6617541ef25fa432511513-7\">7<\/div><div class=\"crayon-num\" data-line=\"urvanov-syntax-highlighter-6617541ef25fa432511513-8\">8<\/div><div class=\"crayon-num\" data-line=\"urvanov-syntax-highlighter-6617541ef25fa432511513-9\">9<\/div><div class=\"crayon-num\" data-line=\"urvanov-syntax-highlighter-6617541ef25fa432511513-10\">10<\/div><div class=\"crayon-num\" data-line=\"urvanov-syntax-highlighter-6617541ef25fa432511513-11\">11<\/div><div class=\"crayon-num\" data-line=\"urvanov-syntax-highlighter-6617541ef25fa432511513-12\">12<\/div><div class=\"crayon-num\" data-line=\"urvanov-syntax-highlighter-6617541ef25fa432511513-13\">13<\/div><div class=\"crayon-num\" data-line=\"urvanov-syntax-highlighter-6617541ef25fa432511513-14\">14<\/div><div class=\"crayon-num\" data-line=\"urvanov-syntax-highlighter-6617541ef25fa432511513-15\">15<\/div><div class=\"crayon-num\" data-line=\"urvanov-syntax-highlighter-6617541ef25fa432511513-16\">16<\/div><div class=\"crayon-num\" data-line=\"urvanov-syntax-highlighter-6617541ef25fa432511513-17\">17<\/div><div class=\"crayon-num\" data-line=\"urvanov-syntax-highlighter-6617541ef25fa432511513-18\">18<\/div><div class=\"crayon-num\" data-line=\"urvanov-syntax-highlighter-6617541ef25fa432511513-19\">19<\/div><div class=\"crayon-num\" data-line=\"urvanov-syntax-highlighter-6617541ef25fa432511513-20\">20<\/div><div class=\"crayon-num\" data-line=\"urvanov-syntax-highlighter-6617541ef25fa432511513-21\">21<\/div><div class=\"crayon-num\" data-line=\"urvanov-syntax-highlighter-6617541ef25fa432511513-22\">22<\/div><div class=\"crayon-num\" data-line=\"urvanov-syntax-highlighter-6617541ef25fa432511513-23\">23<\/div><div class=\"crayon-num\" data-line=\"urvanov-syntax-highlighter-6617541ef25fa432511513-24\">24<\/div><div class=\"crayon-num\" data-line=\"urvanov-syntax-highlighter-6617541ef25fa432511513-25\">25<\/div><div class=\"crayon-num\" data-line=\"urvanov-syntax-highlighter-6617541ef25fa432511513-26\">26<\/div><div class=\"crayon-num\" data-line=\"urvanov-syntax-highlighter-6617541ef25fa432511513-27\">27<\/div><div class=\"crayon-num\" data-line=\"urvanov-syntax-highlighter-6617541ef25fa432511513-28\">28<\/div><\/div>\n\t\t\t\t<\/td>\n\t\t\t\t\t\t<td class=\"urvanov-syntax-highlighter-code\"><div class=\"crayon-pre\" style=\"font-size: 12px !important;line-height: 25px !important\"><div class=\"crayon-line\" id=\"urvanov-syntax-highlighter-6617541ef25fa432511513-1\"><span class=\"crayon-t\">function<\/span><span class=\"crayon-h\"> <\/span><span class=\"crayon-e\">setNewCustomerBySpreadsheet<\/span><span class=\"crayon-sy\">(<\/span><span class=\"crayon-sy\">)<\/span><span class=\"crayon-h\"> <\/span><span class=\"crayon-sy\">{<\/span><\/div><div class=\"crayon-line\" id=\"urvanov-syntax-highlighter-6617541ef25fa432511513-2\"><span class=\"crayon-h\">&nbsp;&nbsp;<\/span><span class=\"crayon-m\">const<\/span><span class=\"crayon-h\"> <\/span><span class=\"crayon-v\">SS<\/span><span class=\"crayon-h\"> <\/span><span class=\"crayon-o\">=<\/span><span class=\"crayon-h\"> <\/span><span class=\"crayon-v\">SpreadsheetApp<\/span><span class=\"crayon-sy\">.<\/span><span class=\"crayon-e\">getActiveSpreadsheet<\/span><span class=\"crayon-sy\">(<\/span><span class=\"crayon-sy\">)<\/span><span class=\"crayon-sy\">;<\/span><\/div><div class=\"crayon-line\" id=\"urvanov-syntax-highlighter-6617541ef25fa432511513-3\"><span class=\"crayon-h\">&nbsp;&nbsp;<\/span><span class=\"crayon-m\">const<\/span><span class=\"crayon-h\"> <\/span><span class=\"crayon-v\">ADD_CUSTOMER<\/span><span class=\"crayon-h\"> <\/span><span class=\"crayon-o\">=<\/span><span class=\"crayon-h\"> <\/span><span class=\"crayon-v\">SS<\/span><span class=\"crayon-sy\">.<\/span><span class=\"crayon-e\">getSheetByName<\/span><span class=\"crayon-sy\">(<\/span><span class=\"crayon-s\">&#8216;\uc2e0\uaddc \uace0\uac1d \ucd94\uac00&#8217;<\/span><span class=\"crayon-sy\">)<\/span><span class=\"crayon-sy\">;<\/span><\/div><div class=\"crayon-line\" id=\"urvanov-syntax-highlighter-6617541ef25fa432511513-4\">&nbsp;<\/div><div class=\"crayon-line\" id=\"urvanov-syntax-highlighter-6617541ef25fa432511513-5\"><span class=\"crayon-h\">&nbsp;&nbsp;<\/span><span class=\"crayon-c\">\/\/ \uc785\ub825 \ub370\uc774\ud130\ub97c \ubc30\uc5f4\ub85c \uac00\uc838\uc624\uae30<\/span>\n<\/div><div class=\"crayon-line\" id=\"urvanov-syntax-highlighter-6617541ef25fa432511513-6\"><span class=\"crayon-h\">&nbsp;&nbsp;<\/span><span class=\"crayon-v\">let<\/span><span class=\"crayon-h\"> <\/span><span class=\"crayon-e\">[<\/span><span class=\"crayon-v\">joinDate<\/span><span class=\"crayon-sy\">,<\/span><span class=\"crayon-h\"> <\/span><span class=\"crayon-r\">name<\/span><span class=\"crayon-sy\">,<\/span><span class=\"crayon-h\"> <\/span><span class=\"crayon-v\">hp<\/span><span class=\"crayon-sy\">,<\/span><span class=\"crayon-h\"> <\/span><span class=\"crayon-r\">location<\/span><span class=\"crayon-sy\">]<\/span><span class=\"crayon-h\"> <\/span><span class=\"crayon-o\">=<\/span><span class=\"crayon-h\"> <\/span><span class=\"crayon-v\">ADD_CUSTOMER<\/span><span class=\"crayon-sy\">.<\/span><span class=\"crayon-e\">getRange<\/span><span class=\"crayon-sy\">(<\/span><span class=\"crayon-s\">&#8216;C3:C6&#8217;<\/span><span class=\"crayon-sy\">)<\/span><span class=\"crayon-sy\">.<\/span><span class=\"crayon-e\">getValues<\/span><span class=\"crayon-sy\">(<\/span><span class=\"crayon-sy\">)<\/span><span class=\"crayon-sy\">.<\/span><span class=\"crayon-e\">map<\/span><span class=\"crayon-sy\">(<\/span><span class=\"crayon-v\">row<\/span><span class=\"crayon-h\"><\/span><span class=\"crayon-o\"> =&gt;<\/span><span class=\"crayon-h\"> <\/span><span class=\"crayon-v\">row<\/span><span class=\"crayon-e\">[<\/span><span class=\"crayon-cn\">0<\/span><span class=\"crayon-sy\">]<\/span><span class=\"crayon-sy\">)<\/span><span class=\"crayon-sy\">;<\/span><\/div><div class=\"crayon-line\" id=\"urvanov-syntax-highlighter-6617541ef25fa432511513-7\">&nbsp;<\/div><div class=\"crayon-line\" id=\"urvanov-syntax-highlighter-6617541ef25fa432511513-8\"><span class=\"crayon-h\">&nbsp;&nbsp;<\/span><span class=\"crayon-c\">\/\/ \uc911\ubcf5 \ub370\uc774\ud130 \ucc3e\uae30<\/span><\/div><div class=\"crayon-line\" id=\"urvanov-syntax-highlighter-6617541ef25fa432511513-9\"><span class=\"crayon-h\">&nbsp;&nbsp;<\/span><span class=\"crayon-m\">const<\/span><span class=\"crayon-h\"> <\/span><span class=\"crayon-v\">hpFinder<\/span><span class=\"crayon-h\"> <\/span><span class=\"crayon-o\">=<\/span><span class=\"crayon-h\"> <\/span><span class=\"crayon-v\">SS<\/span><span class=\"crayon-sy\">.<\/span><span class=\"crayon-e\">createTextFinder<\/span><span class=\"crayon-sy\">(<\/span><span class=\"crayon-v\">hp<\/span><span class=\"crayon-sy\">)<\/span><span class=\"crayon-sy\">.<\/span><span class=\"crayon-e\">matchEntireCell<\/span><span class=\"crayon-sy\">(<\/span><span class=\"crayon-t\">true<\/span><span class=\"crayon-sy\">)<\/span><span class=\"crayon-sy\">.<\/span><span class=\"crayon-e\">findAll<\/span><span class=\"crayon-sy\">(<\/span><span class=\"crayon-sy\">)<\/span><span class=\"crayon-sy\">;<\/span><\/div><div class=\"crayon-line\" id=\"urvanov-syntax-highlighter-6617541ef25fa432511513-10\">&nbsp;<\/div><div class=\"crayon-line\" id=\"urvanov-syntax-highlighter-6617541ef25fa432511513-11\"><span class=\"crayon-h\">&nbsp;&nbsp;<\/span><span class=\"crayon-c\">\/\/ \uc911\ubcf5 \ub370\uc774\ud130\uac00 \uc788\ub294\uc9c0 \ud655\uc778<\/span><\/div><div class=\"crayon-line\" id=\"urvanov-syntax-highlighter-6617541ef25fa432511513-12\"><span class=\"crayon-h\">&nbsp;&nbsp;<\/span><span class=\"crayon-st\">if<\/span><span class=\"crayon-h\"> <\/span><span class=\"crayon-sy\">(<\/span><span class=\"crayon-v\">hpFinder<\/span><span class=\"crayon-sy\">.<\/span><span class=\"crayon-v\">length<\/span><span class=\"crayon-h\"> <\/span><span class=\"crayon-e\">&gt;<\/span><span class=\"crayon-h\"> <\/span><span class=\"crayon-cn\">1<\/span><span class=\"crayon-sy\">)<\/span><span class=\"crayon-h\"> <\/span><span class=\"crayon-sy\">{<\/span><\/div><div class=\"crayon-line\" id=\"urvanov-syntax-highlighter-6617541ef25fa432511513-13\"><span class=\"crayon-h\">&nbsp;&nbsp;&nbsp;&nbsp;<\/span><span class=\"crayon-v\">hpFinder<\/span><span class=\"crayon-sy\">.<\/span><span class=\"crayon-st\">forEach<\/span><span class=\"crayon-sy\">(<\/span><span class=\"crayon-v\">occurrence<\/span><span class=\"crayon-h\"> <\/span><span class=\"crayon-e\">=&gt;<\/span><span class=\"crayon-h\"> <\/span><span class=\"crayon-sy\">{<\/span><\/div><div class=\"crayon-line\" id=\"urvanov-syntax-highlighter-6617541ef25fa432511513-14\"><span class=\"crayon-h\">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;<\/span><span class=\"crayon-e\">let <\/span><span class=\"crayon-v\">sheetName<\/span><span class=\"crayon-h\"> <\/span><span class=\"crayon-o\">=<\/span><span class=\"crayon-h\"> <\/span><span class=\"crayon-v\">occurrence<\/span><span class=\"crayon-sy\">.<\/span><span class=\"crayon-e\">getSheet<\/span><span class=\"crayon-sy\">(<\/span><span class=\"crayon-sy\">)<\/span><span class=\"crayon-sy\">.<\/span><span class=\"crayon-e\">getName<\/span><span class=\"crayon-sy\">(<\/span><span class=\"crayon-sy\">)<\/span><span class=\"crayon-sy\">;<\/span><\/div><div class=\"crayon-line\" id=\"urvanov-syntax-highlighter-6617541ef25fa432511513-15\"><span class=\"crayon-h\">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;<\/span><span class=\"crayon-e\">let <\/span><span class=\"crayon-v\">row<\/span><span class=\"crayon-h\"> <\/span><span class=\"crayon-o\">=<\/span><span class=\"crayon-h\"> <\/span><span class=\"crayon-v\">occurrence<\/span><span class=\"crayon-sy\">.<\/span><span class=\"crayon-e\">getRow<\/span><span class=\"crayon-sy\">(<\/span><span class=\"crayon-sy\">)<\/span><span class=\"crayon-sy\">;<\/span><\/div><div class=\"crayon-line\" id=\"urvanov-syntax-highlighter-6617541ef25fa432511513-16\"><span class=\"crayon-h\">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;<\/span><span class=\"crayon-st\">if<\/span><span class=\"crayon-h\"> <\/span><span class=\"crayon-sy\">(<\/span><span class=\"crayon-v\">sheetName<\/span><span class=\"crayon-h\"> <\/span><span class=\"crayon-o\">!==<\/span><span class=\"crayon-h\"> <\/span><span class=\"crayon-v\">ADD_CUSTOMER<\/span><span class=\"crayon-sy\">.<\/span><span class=\"crayon-e\">getName<\/span><span class=\"crayon-sy\">(<\/span><span class=\"crayon-sy\">)<\/span><span class=\"crayon-sy\">)<\/span><span class=\"crayon-h\"> <\/span><span class=\"crayon-sy\">{<\/span><\/div><div class=\"crayon-line\" id=\"urvanov-syntax-highlighter-6617541ef25fa432511513-17\"><span class=\"crayon-h\">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;<\/span><span class=\"crayon-v\">Logger<\/span><span class=\"crayon-sy\">.<\/span><span class=\"crayon-e\">log<\/span><span class=\"crayon-sy\">(<\/span><span class=\"crayon-sy\">`<\/span>\uc774\ubbf8<span class=\"crayon-h\"> <\/span>\uac00\uc785\ub41c<span class=\"crayon-h\"> <\/span>\ud68c\uc6d0\uc785\ub2c8\ub2e4<span class=\"crayon-o\">:<\/span><span class=\"crayon-h\"> <\/span><span class=\"crayon-s\">&#8216;${sheetName}&#8217;<\/span><span class=\"crayon-h\"> <\/span>\uc2dc\ud2b8\uc758<span class=\"crayon-h\"> <\/span><span class=\"crayon-sy\">$<\/span><span class=\"crayon-sy\">{<\/span><span class=\"crayon-v\">row<\/span><span class=\"crayon-sy\">}<\/span>\ud589\uc744<span class=\"crayon-h\"> <\/span>\ucc38\uc870\ud558\uc138\uc694<span class=\"crayon-sy\">.<\/span><span class=\"crayon-sy\">`<\/span><span class=\"crayon-sy\">)<\/span><span class=\"crayon-sy\">;<\/span><\/div><div class=\"crayon-line\" id=\"urvanov-syntax-highlighter-6617541ef25fa432511513-18\"><span class=\"crayon-h\">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;<\/span><span class=\"crayon-v\">SpreadsheetApp<\/span><span class=\"crayon-sy\">.<\/span><span class=\"crayon-e\">getUi<\/span><span class=\"crayon-sy\">(<\/span><span class=\"crayon-sy\">)<\/span><span class=\"crayon-sy\">.<\/span><span class=\"crayon-e\">alert<\/span><span class=\"crayon-sy\">(<\/span><span class=\"crayon-sy\">`<\/span>\uc774\ubbf8<span class=\"crayon-h\"> <\/span>\uac00\uc785\ub41c<span class=\"crayon-h\"> <\/span>\ud68c\uc6d0\uc785\ub2c8\ub2e4<span class=\"crayon-o\">:<\/span><span class=\"crayon-h\"> <\/span><span class=\"crayon-s\">&#8216;${sheetName}&#8217;<\/span><span class=\"crayon-h\"> <\/span>\uc2dc\ud2b8\uc758<span class=\"crayon-h\"> <\/span><span class=\"crayon-sy\">$<\/span><span class=\"crayon-sy\">{<\/span><span class=\"crayon-v\">row<\/span><span class=\"crayon-sy\">}<\/span>\ud589\uc744<span class=\"crayon-h\"> <\/span>\ucc38\uc870\ud558\uc138\uc694<span class=\"crayon-sy\">.<\/span><span class=\"crayon-sy\">`<\/span><span class=\"crayon-sy\">)<\/span><span class=\"crayon-sy\">;<\/span><\/div><div class=\"crayon-line\" id=\"urvanov-syntax-highlighter-6617541ef25fa432511513-19\"><span class=\"crayon-h\">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;<\/span><span class=\"crayon-sy\">}<\/span><\/div><div class=\"crayon-line\" id=\"urvanov-syntax-highlighter-6617541ef25fa432511513-20\"><span class=\"crayon-h\">&nbsp;&nbsp;&nbsp;&nbsp;<\/span><span class=\"crayon-sy\">}<\/span><span class=\"crayon-sy\">)<\/span><span class=\"crayon-sy\">;<\/span><\/div><div class=\"crayon-line\" id=\"urvanov-syntax-highlighter-6617541ef25fa432511513-21\"><span class=\"crayon-h\">&nbsp;&nbsp;<\/span><span class=\"crayon-sy\">}<\/span><span class=\"crayon-h\"> <\/span><span class=\"crayon-st\">else<\/span><span class=\"crayon-h\"> <\/span><span class=\"crayon-sy\">{<\/span><\/div><div class=\"crayon-line\" id=\"urvanov-syntax-highlighter-6617541ef25fa432511513-22\"><span class=\"crayon-h\">&nbsp;&nbsp;&nbsp;&nbsp;<\/span><span class=\"crayon-c\">\/\/ \uc911\ubcf5 \ub370\uc774\ud130\uac00 \uc5c6\uc73c\uba74 \ud574\ub2f9 \uc9c0\uc5ed\uc758 \uc2dc\ud2b8\uc5d0 \uace0\uac1d \uc815\ubcf4 \uc785\ub825<\/span><\/div><div class=\"crayon-line\" id=\"urvanov-syntax-highlighter-6617541ef25fa432511513-23\"><span class=\"crayon-h\">&nbsp;&nbsp;&nbsp;&nbsp;<\/span><span class=\"crayon-e\">let <\/span><span class=\"crayon-v\">targetSheet<\/span><span class=\"crayon-h\"> <\/span><span class=\"crayon-o\">=<\/span><span class=\"crayon-h\"> <\/span><span class=\"crayon-v\">SS<\/span><span class=\"crayon-sy\">.<\/span><span class=\"crayon-e\">getSheetByName<\/span><span class=\"crayon-sy\">(<\/span><span class=\"crayon-r\">location<\/span><span class=\"crayon-sy\">)<\/span><span class=\"crayon-sy\">;<\/span><\/div><div class=\"crayon-line\" id=\"urvanov-syntax-highlighter-6617541ef25fa432511513-24\"><span class=\"crayon-h\">&nbsp;&nbsp;&nbsp;&nbsp;<\/span><span class=\"crayon-m\">const<\/span><span class=\"crayon-h\"> <\/span><span class=\"crayon-v\">lastRow<\/span><span class=\"crayon-h\"> <\/span><span class=\"crayon-o\">=<\/span><span class=\"crayon-h\"> <\/span><span class=\"crayon-v\">targetSheet<\/span><span class=\"crayon-sy\">.<\/span><span class=\"crayon-e\">getLastRow<\/span><span class=\"crayon-sy\">(<\/span><span class=\"crayon-sy\">)<\/span><span class=\"crayon-sy\">;<\/span><\/div><div class=\"crayon-line\" id=\"urvanov-syntax-highlighter-6617541ef25fa432511513-25\"><span class=\"crayon-h\">&nbsp;&nbsp;&nbsp;&nbsp;<\/span><span class=\"crayon-v\">targetSheet<\/span><span class=\"crayon-sy\">.<\/span><span class=\"crayon-e\">getRange<\/span><span class=\"crayon-sy\">(<\/span><span class=\"crayon-v\">lastRow<\/span><span class=\"crayon-h\"> <\/span><span class=\"crayon-o\">+<\/span><span class=\"crayon-h\"> <\/span><span class=\"crayon-cn\">1<\/span><span class=\"crayon-sy\">,<\/span><span class=\"crayon-h\"> <\/span><span class=\"crayon-cn\">1<\/span><span class=\"crayon-sy\">,<\/span><span class=\"crayon-h\"> <\/span><span class=\"crayon-cn\">1<\/span><span class=\"crayon-sy\">,<\/span><span class=\"crayon-h\"> <\/span><span class=\"crayon-cn\">4<\/span><span class=\"crayon-sy\">)<\/span><span class=\"crayon-sy\">.<\/span><span class=\"crayon-e\">setValues<\/span><span class=\"crayon-sy\">(<\/span><span class=\"crayon-sy\">[[<span class=\"crayon-v\">joinDate<\/span><span class=\"crayon-sy\">,<\/span><span class=\"crayon-h\"> <\/span><span class=\"crayon-r\">name<\/span><span class=\"crayon-sy\">,<\/span><span class=\"crayon-h\"> <\/span><span class=\"crayon-v\">hp<\/span><span class=\"crayon-sy\">,<\/span><span class=\"crayon-h\"> <\/span><span class=\"crayon-r\">location<\/span><span class=\"crayon-sy\">]<\/span><span class=\"crayon-sy\">]<\/span><span class=\"crayon-sy\">)<\/span><span class=\"crayon-sy\">;<\/span><\/div><div class=\"crayon-line\" id=\"urvanov-syntax-highlighter-6617541ef25fa432511513-26\"><span class=\"crayon-h\">&nbsp;&nbsp;&nbsp;&nbsp;<\/span><span class=\"crayon-v\">SpreadsheetApp<\/span><span class=\"crayon-sy\">.<\/span><span class=\"crayon-e\">getUi<\/span><span class=\"crayon-sy\">(<\/span><span class=\"crayon-sy\">)<\/span><span class=\"crayon-sy\">.<\/span><span class=\"crayon-e\">alert<\/span><span class=\"crayon-sy\">(<\/span><span class=\"crayon-s\">&#8216;\uc2e0\uaddc \uace0\uac1d \uc815\ubcf4\uac00 \ucd94\uac00\ub418\uc5c8\uc2b5\ub2c8\ub2e4.&#8217;<\/span><span class=\"crayon-sy\">)<\/span><span class=\"crayon-sy\">;<\/span><\/div><div class=\"crayon-line\" id=\"urvanov-syntax-highlighter-6617541ef25fa432511513-27\"><span class=\"crayon-h\">&nbsp;&nbsp;<\/span><span class=\"crayon-sy\">}<\/span><\/div><div class=\"crayon-line\" id=\"urvanov-syntax-highlighter-6617541ef25fa432511513-28\"><span class=\"crayon-sy\">}<\/span><\/div><\/div><\/td>\n\t\t\t\t\t<\/tr>\n\t\t\t\t<\/tbody><\/table>\n\t\t\t<\/div>\n\t\t<\/div>\n\n\n\n<p><br><\/p>\n\n\n\n<h5 class=\"wp-block-heading\" id=\"aioseo-\ucf54\ub4dc-\uc124\uba85\">\ucf54\ub4dc \uc124\uba85<br><br><\/h5>\n\n\n\n<p>\uc774 \ucf54\ub4dc\ub294 \uc0ac\uc6a9\uc790\uac00 \uc785\ub825\ud55c \uc9c0\uc5ed\uc744 \ud655\uc778\ud558\uace0, \ud574\ub2f9\ub418\ub294 \uc2dc\ud2b8\uc5d0 \uc0c8\ub85c\uc6b4 \uace0\uac1d \ub370\uc774\ud130\ub97c \ucd94\uac00\ud558\ub294 \uc791\uc5c5\uc744 \uc218\ud589\ud569\ub2c8\ub2e4.<\/p>\n\n\n\n<ol class=\"wp-block-list\">\n<li><code><strong><mark style=\"background-color:#EDF2F7;color:#f836c7\" class=\"has-inline-color\">SpreadsheetApp.getActiveSpreadsheet()<\/mark><\/strong><\/code>\ub97c \uc0ac\uc6a9\ud558\uc5ec \ud604\uc7ac \ud65c\uc131\ud654\ub41c \uc2a4\ud504\ub808\ub4dc\uc2dc\ud2b8\ub97c \uac00\uc838\uc635\ub2c8\ub2e4.<\/li>\n\n\n\n<li><strong><code><mark style=\"background-color:#EDF2F7;color:#f836c7\" class=\"has-inline-color\">getSheetByName<\/mark><\/code><\/strong> \uba54\uc18c\ub4dc\ub97c \uc0ac\uc6a9\ud558\uc5ec &#8216;<strong>\uc2e0\uaddc \uace0\uac1d \ucd94\uac00<\/strong>&#8216; \uc2dc\ud2b8\ub97c \uac00\uc838\uc635\ub2c8\ub2e4.<\/li>\n\n\n\n<li>\u2018<strong>\uc2e0\uaddc \uace0\uac1d \ucd94\uac00<\/strong>\u2019 \uc2dc\ud2b8\uc5d0\uc11c \uace0\uac1d\uc758 \uc815\ubcf4\ub97c \uac00\uc838\uc624\uae30 \uc704\ud574 <code><strong><mark style=\"background-color:#EDF2F7;color:#f836c7\" class=\"has-inline-color\">getRange('C3:C6')<\/mark><\/strong><\/code>\uc744 \uc0ac\uc6a9\ud558\uc5ec \ud574\ub2f9 \ubc94\uc704\uc758 \uac12\uc744 \uac00\uc838\uc635\ub2c8\ub2e4.<\/li>\n\n\n\n<li>\uace0\uac1d \uc815\ubcf4\uac00 \ud3ec\ud568\ub41c \ubc30\uc5f4\uc5d0\uc11c \ud544\uc694\ud55c \uc815\ubcf4(\uac00\uc785\uc77c, \uc774\ub984, \uc804\ud654\ubc88\ud638, \uc704\uce58)\ub97c \ucd94\ucd9c\ud574\uc11c \ubcc0\uc218\ub85c \ud560\ub2f9\ud569\ub2c8\ub2e4.<\/li>\n\n\n\n<li><strong><code><mark style=\"background-color:#EDF2F7;color:#f836c7\" class=\"has-inline-color\">createTextFinder()<\/mark><\/code><\/strong> \uba54\uc18c\ub4dc\ub97c \uc0ac\uc6a9\ud558\uc5ec \uc911\ubcf5\ub41c \uc5f0\ub77d\ucc98\ub97c \ucc3e\uc2b5\ub2c8\ub2e4. SS\ub4a4\uc5d0 \uba54\uc18c\ub4dc\ub97c \uc774\uc5b4\uc801\uc5b4\uc11c Spreadsheet \ud074\ub798\uc2a4\uc5d0\uc11c \uc0ac\uc6a9\ud569\ub2c8\ub2e4. \uc774 \ub54c, <code><strong><mark style=\"background-color:#EDF2F7;color:#f836c7\" class=\"has-inline-color\">matchEntireCell(true)<\/mark><\/strong><\/code>\ub97c \uc0ac\uc6a9\ud558\uc5ec \uc5f0\ub77d\ucc98\uac00 \uc140 \uc804\uccb4\uc640 \uc815\ud655\ud788 \uc77c\uce58\ud558\ub294\uc9c0 \ud655\uc778\ud569\ub2c8\ub2e4.<\/li>\n\n\n\n<li>\uc911\ubcf5\ub41c \uc5f0\ub77d\ucc98\uac00 \uc788\ub294\uc9c0 \ud655\uc778\ud569\ub2c8\ub2e4. \ub9cc\uc57d \uc911\ubcf5\ub41c \uc5f0\ub77d\ucc98\uac00 \uc788\uc744 \uacbd\uc6b0, \ub85c\uadf8\ub97c \ub0a8\uae30\uace0, \uc54c\ub9bc\ucc3d\uc73c\ub85c \ud574\ub2f9 \uc704\uce58\ub97c \ud45c\uc2dc\ud569\ub2c8\ub2e4.<br><\/li>\n<\/ol>\n\n\n\n<p>\ud83d\udca1 \uc5ec\uae30\uc11c forEach \ubb38\uc740 <strong><mark style=\"background-color:#EDF2F7;color:#f836c7\" class=\"has-inline-color\"><code>createTextFinder()<\/code><\/mark> <\/strong>\uba54\uc18c\ub4dc\ub85c \uc5bb\uc740 \uacb0\uacfc\ub97c \uc21c\ud68c\ud558\uba74\uc11c \uc815\ubcf4\ub97c \ud655\uc778\ud558\ub294 \uc5ed\ud560\uc744 \ud569\ub2c8\ub2e4. <mark style=\"background-color:#EDF2F7;color:#f836c7\" class=\"has-inline-color\"><code><strong>hpFinder<\/strong><\/code><\/mark>\ub97c \uadf8\ub300\ub85c Logger.log\uc5d0 \uc804\ub2ec\ud558\uba74 \ub2e8\uc21c\ud788 \uac1d\uccb4\uc758 \uc2dd\ubcc4\uc790\uc640 \ud615\uc2dd\ub9cc\uc744 \ud45c\uc2dc\ud558\uae30 \ub54c\ubb38\uc5d0 forEach\ubb38\uc744 \uc0ac\uc6a9\ud558\uc5ec \uac01 \uc911\ubcf5\ub418\ub294 \uac12\ub4e4\uc758 \uc704\uce58 \uc815\ubcf4\ub97c \ucd94\ucd9c\ud558\ub294 \uc791\uc5c5\uc744 \ucd94\uac00\ud558\uc600\uc2b5\ub2c8\ub2e4.<br><\/p>\n\n\n\n<ol start=\"7\" class=\"wp-block-list\">\n<li>\uc911\ubcf5\ub41c \uc5f0\ub77d\ucc98\uac00 \uc5c6\uc744 \uacbd\uc6b0, \uace0\uac1d \uc815\ubcf4\ub97c \ud574\ub2f9 \uc9c0\uc5ed \uc2dc\ud2b8\uc758 \ub9c8\uc9c0\ub9c9 \ud589\uc5d0 \ucd94\uac00\ud569\ub2c8\ub2e4. <strong><code><mark style=\"background-color:#EDF2F7;color:#f836c7\" class=\"has-inline-color\">getLastRow()<\/mark><\/code><\/strong> \ub294 \ub370\uc774\ud130\uac00 \uc788\ub294 \ub9c8\uc9c0\ub9c9 \ud589\uc744 \uac00\uc838\uc635\ub2c8\ub2e4. \ub9c8\uc9c0\ub9c9 \ud589\uc758 \ub2e4\uc74c \ud589\uc5d0 \ub370\uc774\ud130\ub97c \ucd94\uac00\ud558\uae30 \uc704\ud574 1\uc744 \ub354\ud574\uc8fc\uc5c8\uc2b5\ub2c8\ub2e4.<\/li>\n\n\n\n<li>\uace0\uac1d \uc815\ubcf4\uac00 \ucd94\uac00\ub418\uc5c8\ub2e4\ub294 \uc54c\ub9bc\ucc3d\uc744 \ud45c\uc2dc\ud569\ub2c8\ub2e4.<br><\/li>\n<\/ol>\n\n\n\n<p>\uc704 \ucf54\ub4dc\uc5d0\uc11c \uc544\ub798\uc758 \uc870\uac74\ubb38\uc5d0 \uc720\uc758\ud574\ubcf4\uaca0\uc2b5\ub2c8\ub2e4.<br><\/p>\n\n\n\n<div id=\"urvanov-syntax-highlighter-6617563a2bead085938021\" class=\"urvanov-syntax-highlighter-syntax crayon-theme-powershell-ise urvanov-syntax-highlighter-font-sourcecodepro urvanov-syntax-highlighter-os-pc print-yes notranslate\" data-settings=\" no-popup minimize scroll-always\" style=\"max-width: 800px;margin-top: 12px;margin-bottom: 12px;font-size: 12px !important;line-height: 25px !important;height: auto\">\n\t\t\n\t\t\t<div class=\"urvanov-syntax-highlighter-plain-wrap\"><\/div>\n\t\t\t<div class=\"urvanov-syntax-highlighter-main\" style=\"max-width: 800px;position: relative;z-index: 1\">\n\t\t\t\t<table class=\"crayon-table\" style=\"margin-left: -25px\">\n\t\t\t\t\t<tbody><tr class=\"urvanov-syntax-highlighter-row\">\n\t\t\t\t<td class=\"crayon-nums \" data-settings=\"hide\">\n\t\t\t\t\t<div class=\"urvanov-syntax-highlighter-nums-content\" style=\"font-size: 12px !important;line-height: 25px !important\"><div class=\"crayon-num\" data-line=\"urvanov-syntax-highlighter-6617563a2bead085938021-1\">1<\/div><div class=\"crayon-num\" data-line=\"urvanov-syntax-highlighter-6617563a2bead085938021-2\">2<\/div><div class=\"crayon-num\" data-line=\"urvanov-syntax-highlighter-6617563a2bead085938021-3\">3<\/div><div class=\"crayon-num\" data-line=\"urvanov-syntax-highlighter-6617563a2bead085938021-4\">4<\/div><div class=\"crayon-num\" data-line=\"urvanov-syntax-highlighter-6617563a2bead085938021-5\">5<\/div><div class=\"crayon-num\" data-line=\"urvanov-syntax-highlighter-6617563a2bead085938021-6\">6<\/div><div class=\"crayon-num\" data-line=\"urvanov-syntax-highlighter-6617563a2bead085938021-7\">7<\/div><div class=\"crayon-num\" data-line=\"urvanov-syntax-highlighter-6617563a2bead085938021-8\">8<\/div><div class=\"crayon-num\" data-line=\"urvanov-syntax-highlighter-6617563a2bead085938021-9\">9<\/div><div class=\"crayon-num\" data-line=\"urvanov-syntax-highlighter-6617563a2bead085938021-10\">10<\/div><\/div>\n\t\t\t\t<\/td>\n\t\t\t\t\t\t<td class=\"urvanov-syntax-highlighter-code\"><div class=\"crayon-pre\" style=\"font-size: 12px !important;line-height: 25px !important\"><div class=\"crayon-line\" id=\"urvanov-syntax-highlighter-6617563a2bead085938021-1\"><span class=\"crayon-st\">if<\/span><span class=\"crayon-h\"> <\/span><span class=\"crayon-sy\">(<\/span><span class=\"crayon-v\">hpFinder<\/span><span class=\"crayon-sy\">.<\/span><span class=\"crayon-v\">length<\/span><span class=\"crayon-h\"> <\/span><span class=\"crayon-e\">&gt;<\/span><span class=\"crayon-h\"> <\/span><span class=\"crayon-cn\">1<\/span><span class=\"crayon-sy\">)<\/span><span class=\"crayon-h\"> <\/span><span class=\"crayon-sy\">{<\/span><\/div><div class=\"crayon-line\" id=\"urvanov-syntax-highlighter-6617563a2bead085938021-2\"><span class=\"crayon-h\">&nbsp;&nbsp;&nbsp;&nbsp;<\/span><span class=\"crayon-v\">hpFinder<\/span><span class=\"crayon-sy\">.<\/span><span class=\"crayon-st\">forEach<\/span><span class=\"crayon-sy\">(<\/span><span class=\"crayon-v\">occurrence<\/span><span class=\"crayon-h\"> <\/span><span class=\"crayon-e\">=&gt;<\/span><span class=\"crayon-h\"> <\/span><span class=\"crayon-sy\">{<\/span><\/div><div class=\"crayon-line\" id=\"urvanov-syntax-highlighter-6617563a2bead085938021-3\"><span class=\"crayon-h\">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;<\/span><span class=\"crayon-e\">let <\/span><span class=\"crayon-v\">sheetName<\/span><span class=\"crayon-h\"> <\/span><span class=\"crayon-o\">=<\/span><span class=\"crayon-h\"> <\/span><span class=\"crayon-v\">occurrence<\/span><span class=\"crayon-sy\">.<\/span><span class=\"crayon-e\">getSheet<\/span><span class=\"crayon-sy\">(<\/span><span class=\"crayon-sy\">)<\/span><span class=\"crayon-sy\">.<\/span><span class=\"crayon-e\">getName<\/span><span class=\"crayon-sy\">(<\/span><span class=\"crayon-sy\">)<\/span><span class=\"crayon-sy\">;<\/span><\/div><div class=\"crayon-line\" id=\"urvanov-syntax-highlighter-6617563a2bead085938021-4\"><span class=\"crayon-h\">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;<\/span><span class=\"crayon-e\">let <\/span><span class=\"crayon-v\">row<\/span><span class=\"crayon-h\"> <\/span><span class=\"crayon-o\">=<\/span><span class=\"crayon-h\"> <\/span><span class=\"crayon-v\">occurrence<\/span><span class=\"crayon-sy\">.<\/span><span class=\"crayon-e\">getRow<\/span><span class=\"crayon-sy\">(<\/span><span class=\"crayon-sy\">)<\/span><span class=\"crayon-sy\">;<\/span><\/div><div class=\"crayon-line\" id=\"urvanov-syntax-highlighter-6617563a2bead085938021-5\"><span class=\"crayon-h\">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;<\/span><span class=\"crayon-st\">if<\/span><span class=\"crayon-h\"> <\/span><span class=\"crayon-sy\">(<\/span><span class=\"crayon-v\">sheetName<\/span><span class=\"crayon-h\"> <\/span><span class=\"crayon-o\">!==<\/span><span class=\"crayon-h\"> <\/span><span class=\"crayon-v\">ADD_CUSTOMER<\/span><span class=\"crayon-sy\">.<\/span><span class=\"crayon-e\">getName<\/span><span class=\"crayon-sy\">(<\/span><span class=\"crayon-sy\">)<\/span><span class=\"crayon-sy\">)<\/span><span class=\"crayon-h\"> <\/span><span class=\"crayon-sy\">{<\/span><\/div><div class=\"crayon-line\" id=\"urvanov-syntax-highlighter-6617563a2bead085938021-6\"><span class=\"crayon-h\">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;<\/span><span class=\"crayon-v\">Logger<\/span><span class=\"crayon-sy\">.<\/span><span class=\"crayon-e\">log<\/span><span class=\"crayon-sy\">(<\/span><span class=\"crayon-sy\">`<\/span>\uc774\ubbf8<span class=\"crayon-h\"> <\/span>\uac00\uc785\ub41c<span class=\"crayon-h\"> <\/span>\ud68c\uc6d0\uc785\ub2c8\ub2e4<span class=\"crayon-o\">:<\/span><span class=\"crayon-h\"> <\/span><span class=\"crayon-s\">&#8216;${sheetName}&#8217;<\/span><span class=\"crayon-h\"> <\/span>\uc2dc\ud2b8\uc758<span class=\"crayon-h\"> <\/span><span class=\"crayon-sy\">$<\/span><span class=\"crayon-sy\">{<\/span><span class=\"crayon-v\">row<\/span><span class=\"crayon-sy\">}<\/span>\ud589\uc744<span class=\"crayon-h\"> <\/span>\ucc38\uc870\ud558\uc138\uc694<span class=\"crayon-sy\">.<\/span><span class=\"crayon-sy\">`<\/span><span class=\"crayon-sy\">)<\/span><span class=\"crayon-sy\">;<\/span><\/div><div class=\"crayon-line\" id=\"urvanov-syntax-highlighter-6617563a2bead085938021-7\"><span class=\"crayon-h\">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;<\/span><span class=\"crayon-v\">SpreadsheetApp<\/span><span class=\"crayon-sy\">.<\/span><span class=\"crayon-e\">getUi<\/span><span class=\"crayon-sy\">(<\/span><span class=\"crayon-sy\">)<\/span><span class=\"crayon-sy\">.<\/span><span class=\"crayon-e\">alert<\/span><span class=\"crayon-sy\">(<\/span><span class=\"crayon-sy\">`<\/span>\uc774\ubbf8<span class=\"crayon-h\"> <\/span>\uac00\uc785\ub41c<span class=\"crayon-h\"> <\/span>\ud68c\uc6d0\uc785\ub2c8\ub2e4<span class=\"crayon-o\">:<\/span><span class=\"crayon-h\"> <\/span><span class=\"crayon-s\">&#8216;${sheetName}&#8217;<\/span><span class=\"crayon-h\"> <\/span>\uc2dc\ud2b8\uc758<span class=\"crayon-h\"> <\/span><span class=\"crayon-sy\">$<\/span><span class=\"crayon-sy\">{<\/span><span class=\"crayon-v\">row<\/span><span class=\"crayon-sy\">}<\/span>\ud589\uc744<span class=\"crayon-h\"> <\/span>\ucc38\uc870\ud558\uc138\uc694<span class=\"crayon-sy\">.<\/span><span class=\"crayon-sy\">`<\/span><span class=\"crayon-sy\">)<\/span><span class=\"crayon-sy\">;<\/span><\/div><div class=\"crayon-line\" id=\"urvanov-syntax-highlighter-6617563a2bead085938021-8\"><span class=\"crayon-h\">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;<\/span><span class=\"crayon-sy\">}<\/span><\/div><div class=\"crayon-line\" id=\"urvanov-syntax-highlighter-6617563a2bead085938021-9\"><span class=\"crayon-h\">&nbsp;&nbsp;&nbsp;&nbsp;<\/span><span class=\"crayon-sy\">}<\/span><span class=\"crayon-sy\">)<\/span><span class=\"crayon-sy\">;<\/span><\/div><div class=\"crayon-line\" id=\"urvanov-syntax-highlighter-6617563a2bead085938021-10\"><span class=\"crayon-h\">&nbsp;&nbsp;<\/span><span class=\"crayon-sy\">}<\/span><\/div><\/div><\/td>\n\t\t\t\t\t<\/tr>\n\t\t\t\t<\/tbody><\/table>\n\t\t\t<\/div>\n\t\t<\/div>\n\n\n\n<p><br>\ub370\uc774\ud130\uc758 \uac2f\uc218\uac00 1\uac1c\ub97c \ucd08\uacfc\ud560 \uacbd\uc6b0\uc5d0 \uc774\ubbf8 \uac00\uc785\ub41c \ud68c\uc6d0\uc774\ub77c\ub294 \uc54c\ub9bc\ucc3d\uc744 \ub744\uc6b0\ub77c\ub294 \uc870\uac74\ubb38\uc785\ub2c8\ub2e4. \uc65c 0\uac1c\uac00 \uc544\ub2cc 1\uac1c\ub97c \ucd08\uacfc\ud560 \uacbd\uc6b0\uc5d0 \uc54c\ub9bc\ucc3d\uc744 \ub744\uc6b0\ub3c4\ub85d \uc124\uc815\ud588\uc744\uae4c\uc694? <mark style=\"background-color:#fffd73\" class=\"has-inline-color\"><strong>Spreadsheet \ud074\ub798\uc2a4\uc5d0\uc11c createTextFinder\ub97c \uc0ac\uc6a9\ud558\uba74 \uc804\uccb4 \uc2dc\ud2b8\uc5d0\uc11c \uac80\uc0c9<\/strong><\/mark>\uc744 \ud558\uae30 \ub54c\ubb38\uc785\ub2c8\ub2e4. \uc544\ub798\uc758 \u2018<strong>\uc2e0\uaddc \uace0\uac1d \ucd94\uac00<\/strong>\u2019 \uc785\ub825\ucc3d\uc5d0 \uc785\ub825\ud55c \uac12\ub3c4 \uc774\ubbf8 \uc911\ubcf5\ub41c \uac12\uc73c\ub85c \ucc98\ub9ac\ud558\ub294 \uac83\uc774\uc9c0\uc694. \uadf8\ub798\uc11c \u2018<strong>sheetName<\/strong>\u2019 \uc774 \u2018<strong>\uc2e0\uaddc \uace0\uac1d \ucd94\uac00<\/strong>\u2019 \uc2dc\ud2b8\uc778 \uacbd\uc6b0\uc5d0\ub294 alert\ub97c \ub178\ucd9c\uc2dc\ud0a4\uc9c0 \uc54a\ub3c4\ub85d \ucc98\ub9ac\ud558\uace0 \uc788\uc2b5\ub2c8\ub2e4.<br><br><\/p>\n\n\n<div class=\"wp-block-image\">\n<figure class=\"aligncenter size-full\"><img loading=\"lazy\" decoding=\"async\" width=\"671\" height=\"811\" src=\"https:\/\/www.autooffice.co.kr\/wp\/wp-content\/uploads\/2024\/04\/5.\uc785\ub825\ucc3d\uc5d0\uc11c-\uc774\ubbf8-\uc911\ubcf5.jpg\" alt=\"\" class=\"wp-image-16049\" srcset=\"https:\/\/www.autooffice.co.kr\/wp\/wp-content\/uploads\/2024\/04\/5.\uc785\ub825\ucc3d\uc5d0\uc11c-\uc774\ubbf8-\uc911\ubcf5.jpg 671w, https:\/\/www.autooffice.co.kr\/wp\/wp-content\/uploads\/2024\/04\/5.\uc785\ub825\ucc3d\uc5d0\uc11c-\uc774\ubbf8-\uc911\ubcf5-248x300.jpg 248w\" sizes=\"auto, (max-width: 671px) 100vw, 671px\" \/><\/figure>\n<\/div>\n\n\n<p><br>\uc774\uc81c \u2018<strong>\uc785\ub825\ud558\uae30<\/strong>\u2019 \ubc84\ud2bc\uc5d0 \uc2a4\ud06c\ub9bd\ud2b8\ub97c \ud560\ub2f9\ud574\ubcf4\uaca0\uc2b5\ub2c8\ub2e4. \u2018<strong>\uc785\ub825\ud558\uae30<\/strong>\u2019\ubc84\ud2bc\uc758 \uc6b0 \ud074\ub9ad\uc744 \ud558\uba74 \uc0c1\ub2e8\uc5d0 \uc810 3\uac1c \ubc84\ud2bc\uc774 \ub178\ucd9c\ub429\ub2c8\ub2e4. \ud574\ub2f9 \ubc84\ud2bc\uc744 \ub204\ub974\uace0 \u2018<strong>\uc2a4\ud06c\ub9bd\ud2b8 \ud560\ub2f9<\/strong>\u2019 \ubc84\ud2bc\uc744 \ud074\ub9ad\ud569\ub2c8\ub2e4.<br><br><\/p>\n\n\n<div class=\"wp-block-image\">\n<figure class=\"aligncenter size-full\"><img loading=\"lazy\" decoding=\"async\" width=\"530\" height=\"537\" src=\"https:\/\/www.autooffice.co.kr\/wp\/wp-content\/uploads\/2024\/04\/6.\uc2a4\ud06c\ub9bd\ud2b8-\ud560\ub2f9.jpg\" alt=\"\" class=\"wp-image-16050\" srcset=\"https:\/\/www.autooffice.co.kr\/wp\/wp-content\/uploads\/2024\/04\/6.\uc2a4\ud06c\ub9bd\ud2b8-\ud560\ub2f9.jpg 530w, https:\/\/www.autooffice.co.kr\/wp\/wp-content\/uploads\/2024\/04\/6.\uc2a4\ud06c\ub9bd\ud2b8-\ud560\ub2f9-296x300.jpg 296w\" sizes=\"auto, (max-width: 530px) 100vw, 530px\" \/><figcaption class=\"wp-element-caption\">\uc8103\uac1c \ubc84\ud2bc \ud074\ub9ad \u2192 \u2018<strong>\uc2a4\ud06c\ub9bd\ud2b8 \ud560\ub2f9<\/strong>\u2019 \ud074\ub9ad<\/figcaption><\/figure>\n<\/div>\n\n\n<p><br>\ub2e4\uc74c \ucc3d\uc5d0\uc11c \ud568\uc218\uc758 \uc774\ub984\uc744 \uc785\ub825 \ud6c4 \ud655\uc778 \ubc84\ud2bc\uc744 \ud074\ub9ad\ud558\uba74 \u2018<strong>\uc785\ub825\ud558\uae30<\/strong>\u2019 \ubc84\ud2bc\uc5d0 \uc2a4\ud06c\ub9bd\ud2b8 \ud560\ub2f9\uc774 \uc644\ub8cc\ub429\ub2c8\ub2e4.<br><br><\/p>\n\n\n\n<figure class=\"wp-block-image size-full\"><img loading=\"lazy\" decoding=\"async\" width=\"764\" height=\"490\" src=\"https:\/\/www.autooffice.co.kr\/wp\/wp-content\/uploads\/2024\/04\/7.\uc2a4\ud06c\ub9bd\ud2b8\uba85-\uc785\ub825-\ud6c4-\ud655\uc778.jpg\" alt=\"\" class=\"wp-image-16051\" srcset=\"https:\/\/www.autooffice.co.kr\/wp\/wp-content\/uploads\/2024\/04\/7.\uc2a4\ud06c\ub9bd\ud2b8\uba85-\uc785\ub825-\ud6c4-\ud655\uc778.jpg 764w, https:\/\/www.autooffice.co.kr\/wp\/wp-content\/uploads\/2024\/04\/7.\uc2a4\ud06c\ub9bd\ud2b8\uba85-\uc785\ub825-\ud6c4-\ud655\uc778-300x192.jpg 300w\" sizes=\"auto, (max-width: 764px) 100vw, 764px\" \/><figcaption class=\"wp-element-caption\">\uc571\uc2a4 \uc2a4\ud06c\ub9bd\ud2b8 \ud568\uc218\uba85 \uc785\ub825 \ud6c4 \u2018<strong>\ud655\uc778<\/strong>\u2019 \ubc84\ud2bc \ud074\ub9ad<\/figcaption><\/figure>\n\n\n\n<p><br>\uc2a4\ud06c\ub9bd\ud2b8 \ud560\ub2f9\uc744 \uc644\ub8cc\ud588\uc73c\uba74 \ud55c\ubc88 \ud14c\uc2a4\ud2b8\ud574\ubcf4\uaca0\uc2b5\ub2c8\ub2e4. \uc704\uc758 \uc870\uac74\ubb38\uc744 \ud1b5\ud574\uc11c \uc911\ubcf5\ub418\ub294 \ub370\uc774\ud130\uac00 \uc5c6\ub2e4\uba74 \uc2e0\uaddc \uace0\uac1d \uc815\ubcf4\ub97c \uc0bd\uc785\ud558\uace0, \uc911\ubcf5\ub418\ub294 \ub370\uc774\ud130\uac00 \uc788\ub2e4\uba74 \ucd94\uac00\ud558\uc9c0 \uc54a\uace0 \uc54c\ub9bc\ucc3d\uc744 \ub744\uc6b8 \uac83\uc785\ub2c8\ub2e4. \uc2e4\ud589\ud574\ubcfc\uae4c\uc694?<br><br><\/p>\n\n\n<div class=\"wp-block-image\">\n<figure class=\"aligncenter size-full\"><img loading=\"lazy\" decoding=\"async\" width=\"782\" height=\"699\" src=\"https:\/\/www.autooffice.co.kr\/wp\/wp-content\/uploads\/2024\/04\/8.\uc911\ubcf5\ub418\uc9c0-\uc54a\uc744\ub54c-\uc785\ub825-\uc644\ub8cc\ucc3d.jpg\" alt=\"\" class=\"wp-image-16052\" srcset=\"https:\/\/www.autooffice.co.kr\/wp\/wp-content\/uploads\/2024\/04\/8.\uc911\ubcf5\ub418\uc9c0-\uc54a\uc744\ub54c-\uc785\ub825-\uc644\ub8cc\ucc3d.jpg 782w, https:\/\/www.autooffice.co.kr\/wp\/wp-content\/uploads\/2024\/04\/8.\uc911\ubcf5\ub418\uc9c0-\uc54a\uc744\ub54c-\uc785\ub825-\uc644\ub8cc\ucc3d-300x268.jpg 300w, https:\/\/www.autooffice.co.kr\/wp\/wp-content\/uploads\/2024\/04\/8.\uc911\ubcf5\ub418\uc9c0-\uc54a\uc744\ub54c-\uc785\ub825-\uc644\ub8cc\ucc3d-768x686.jpg 768w\" sizes=\"auto, (max-width: 782px) 100vw, 782px\" \/><\/figure>\n<\/div>\n\n\n<p><br>\uc2a4\ud06c\ub9bd\ud2b8\uac00 \uc815\uc0c1\uc801\uc73c\ub85c \uc2e4\ud589\ub418\uc5c8\uc2b5\ub2c8\ub2e4. \ub370\uc774\ud130\uac00 \uc81c\ub300\ub85c \uc800\uc7a5\ub418\uc5c8\ub294\uc9c0\ub3c4 \ud655\uc778\ud574\ubcf4\uaca0\uc2b5\ub2c8\ub2e4.<br><br><\/p>\n\n\n<div class=\"wp-block-image\">\n<figure class=\"aligncenter size-full\"><img loading=\"lazy\" decoding=\"async\" width=\"639\" height=\"513\" src=\"https:\/\/www.autooffice.co.kr\/wp\/wp-content\/uploads\/2024\/04\/9.\uc800\uc7a5-\ud655\uc778.jpg\" alt=\"\" class=\"wp-image-16053\" srcset=\"https:\/\/www.autooffice.co.kr\/wp\/wp-content\/uploads\/2024\/04\/9.\uc800\uc7a5-\ud655\uc778.jpg 639w, https:\/\/www.autooffice.co.kr\/wp\/wp-content\/uploads\/2024\/04\/9.\uc800\uc7a5-\ud655\uc778-300x241.jpg 300w\" sizes=\"auto, (max-width: 639px) 100vw, 639px\" \/><\/figure>\n<\/div>\n\n\n<p><br>\u2018<strong>\uc11c\uc6b8<\/strong>\u2019 \uc2dc\ud2b8\uc5d0 \uc815\ud655\ud788 \ub370\uc774\ud130\uac00 \uc0bd\uc785\ub418\uc5c8\uc2b5\ub2c8\ub2e4. \uc704\uc5d0\uc11c \uc791\uc131\ud55c \ucf54\ub4dc\ub294, \uc2e0\uaddc \uace0\uac1d\uc744 \ub4f1\ub85d\ud560 \ub54c\uc5d0 \uc911\ubcf5\ub418\ub294 \uc5f0\ub77d\ucc98\uac00 \uc788\ub294\uc9c0 \uc9c0\uc5ed\uc744 \uad6c\ubd84\ud558\uc9c0 \uc54a\uace0 \uc804\uccb4 \uc2dc\ud2b8\uc5d0\uc11c \uac80\uc0c9\ud558\ub3c4\ub85d \uc791\uc131\ub418\uc5c8\uc2b5\ub2c8\ub2e4. \ub2e4\uc74c \uc0ac\uc9c4\ucc98\ub7fc \ub3d9\uc77c\ud55c \ub370\uc774\ud130\ub97c \uc9c0\uc5ed\ub9cc \u2018<strong>\uacbd\uae30\ub3c4<\/strong>\u2019\ub85c \ubc14\uafb8\uc5b4 \u2018<strong>\uc785\ub825\ud558\uae30<\/strong>\u2019\ubc84\ud2bc\uc744 \ub204\ub974\uba74 \uc5b4\ub5bb\uac8c \ub420\uae4c\uc694?<br><br><\/p>\n\n\n<div class=\"wp-block-image\">\n<figure class=\"aligncenter size-full\"><img loading=\"lazy\" decoding=\"async\" width=\"450\" height=\"452\" src=\"https:\/\/www.autooffice.co.kr\/wp\/wp-content\/uploads\/2024\/04\/10.\uc9c0\uc5ed\ub9cc-\ubc14\uafd4\uc11c-\ub2e4\uc2dc-\ub4f1\ub85d.jpg\" alt=\"\" class=\"wp-image-16054\" srcset=\"https:\/\/www.autooffice.co.kr\/wp\/wp-content\/uploads\/2024\/04\/10.\uc9c0\uc5ed\ub9cc-\ubc14\uafd4\uc11c-\ub2e4\uc2dc-\ub4f1\ub85d.jpg 450w, https:\/\/www.autooffice.co.kr\/wp\/wp-content\/uploads\/2024\/04\/10.\uc9c0\uc5ed\ub9cc-\ubc14\uafd4\uc11c-\ub2e4\uc2dc-\ub4f1\ub85d-300x300.jpg 300w, https:\/\/www.autooffice.co.kr\/wp\/wp-content\/uploads\/2024\/04\/10.\uc9c0\uc5ed\ub9cc-\ubc14\uafd4\uc11c-\ub2e4\uc2dc-\ub4f1\ub85d-150x150.jpg 150w\" sizes=\"auto, (max-width: 450px) 100vw, 450px\" \/><figcaption class=\"wp-element-caption\">\uc9c0\uc5ed \uc815\ubcf4\ub9cc \ubc14\uafb8\uc5b4\uc11c \uc785\ub825\uc744 \uc2dc\ub3c4\ud569\ub2c8\ub2e4.<\/figcaption><\/figure>\n<\/div>\n\n\n<p><br>\uc758\ub3c4\ub300\ub85c \uc791\ub3d9\ub41c\ub2e4\uba74 \uc911\ubcf5\ub370\uc774\ud130\ub85c \ucc98\ub9ac\uac00 \ub418\uc5b4 \ub370\uc774\ud130 \uc800\uc7a5\uc774 \ub418\uc9c0 \uc54a\uace0 \uc54c\ub9bc\ucc3d\uc774 \ub744\uc6cc\uc9c8 \uac83\uc785\ub2c8\ub2e4.<br><br><\/p>\n\n\n\n<figure class=\"wp-block-image size-full\"><img loading=\"lazy\" decoding=\"async\" width=\"825\" height=\"781\" src=\"https:\/\/www.autooffice.co.kr\/wp\/wp-content\/uploads\/2024\/04\/11.\uc2e0\uaddc\uace0\uac1d-\uc568\ub7ff.jpg\" alt=\"\" class=\"wp-image-16055\" srcset=\"https:\/\/www.autooffice.co.kr\/wp\/wp-content\/uploads\/2024\/04\/11.\uc2e0\uaddc\uace0\uac1d-\uc568\ub7ff.jpg 825w, https:\/\/www.autooffice.co.kr\/wp\/wp-content\/uploads\/2024\/04\/11.\uc2e0\uaddc\uace0\uac1d-\uc568\ub7ff-300x284.jpg 300w, https:\/\/www.autooffice.co.kr\/wp\/wp-content\/uploads\/2024\/04\/11.\uc2e0\uaddc\uace0\uac1d-\uc568\ub7ff-768x727.jpg 768w\" sizes=\"auto, (max-width: 825px) 100vw, 825px\" \/><\/figure>\n\n\n\n<p><br>\ub85c\uadf8\uc5d0\ub3c4 \ub3d9\uc77c\ud55c \ub0b4\uc6a9\uc774 \uae30\ub85d\ub418\uc5c8\uc2b5\ub2c8\ub2e4. \uc785\ub825\ud558\uace0\uc790 \ud558\ub294 \uc2dc\ud2b8\ub294 \u2018\uacbd\uae30\ub3c4\u2019 \uc2dc\ud2b8\uc600\uc9c0\ub9cc \u2018\uc11c\uc6b8\u2019 \uc2dc\ud2b8\uc5d0\uc11c \uc911\ubcf5 \ub370\uc774\ud130\uac00 \uc788\ub2e4\ub294 \uc54c\ub9bc\uc744 \ub744\uc6b0\uace0, \ub370\uc774\ud130\ub294 \uc2e4\uc81c\ub85c \uc785\ub825\ub418\uc9c0\ub294 \uc54a\uc558\uc2b5\ub2c8\ub2e4. \uc758\ub3c4\ud55c \uae30\ub2a5\uc744 \uc798 \uc218\ud589\ud558\uace0 \uc788\ub124\uc694.<br><br><\/p>\n\n\n\n<figure class=\"wp-block-image size-large\"><img loading=\"lazy\" decoding=\"async\" width=\"1024\" height=\"168\" src=\"https:\/\/www.autooffice.co.kr\/wp\/wp-content\/uploads\/2024\/04\/12.\ub85c\uadf8-1024x168.jpg\" alt=\"\" class=\"wp-image-16056\" srcset=\"https:\/\/www.autooffice.co.kr\/wp\/wp-content\/uploads\/2024\/04\/12.\ub85c\uadf8-1024x168.jpg 1024w, https:\/\/www.autooffice.co.kr\/wp\/wp-content\/uploads\/2024\/04\/12.\ub85c\uadf8-300x49.jpg 300w, https:\/\/www.autooffice.co.kr\/wp\/wp-content\/uploads\/2024\/04\/12.\ub85c\uadf8-768x126.jpg 768w, https:\/\/www.autooffice.co.kr\/wp\/wp-content\/uploads\/2024\/04\/12.\ub85c\uadf8.jpg 1049w\" sizes=\"auto, (max-width: 1024px) 100vw, 1024px\" \/><figcaption class=\"wp-element-caption\">\uc911\ubcf5 \ub370\uc774\ud130\ub97c \uc54c\ub9ac\ub294 \ub85c\uadf8<br><\/figcaption><\/figure>\n\n\n\n<p><br>\uc774\uc81c, createTextFinder\ub97c Sheet \ud074\ub798\uc2a4\uc5d0\uc11c \uc0ac\uc6a9\ud558\ub294 \ubc29\ubc95\uc744 \ub2e4\uc74c\uc758 \ud3ec\uc2a4\ud305\uc73c\ub85c \uc774\uc5b4\uc11c \uc0b4\ud3b4\ubcf4\uaca0\uc2b5\ub2c8\ub2e4.<\/p>\n\n\n\n<p><a href=\"https:\/\/www.autooffice.co.kr\/blog\/2024\/04\/10\/sheet-class%ec%9d%98-createtextfinder\/\">Sheet class\uc758 createTextFinder()<\/a><\/p>\n\n\n\n<p><br><\/p>\n\n\n\n<hr class=\"wp-block-separator has-alpha-channel-opacity is-style-wide\"\/>\n\n\n\n<p><br><\/p>\n\n\n\n<figure class=\"wp-block-image size-full\"><img loading=\"lazy\" decoding=\"async\" width=\"691\" height=\"512\" src=\"https:\/\/www.autooffice.co.kr\/wp\/wp-content\/uploads\/2025\/08\/image-27.png\" alt=\"\" class=\"wp-image-17075\" srcset=\"https:\/\/www.autooffice.co.kr\/wp\/wp-content\/uploads\/2025\/08\/image-27.png 691w, https:\/\/www.autooffice.co.kr\/wp\/wp-content\/uploads\/2025\/08\/image-27-300x222.png 300w\" sizes=\"auto, (max-width: 691px) 100vw, 691px\" \/><\/figure>\n\n\n\n<h2 class=\"wp-block-heading\" id=\"aioseo-\uc5c5\ubb34-\ud6a8\uc728\uc131-200-\uc62c\ub9ac\uae30-with-autooffice\">\uc5c5\ubb34 \ud6a8\uc728\uc131 200% \uc62c\ub9ac\uae30, with autooffice<\/h2>\n\n\n\n<h2 class=\"wp-block-heading\" id=\"aioseo-\ub8e8\ucee4-\uc2a4\ud29c\ub514\uc624-\uac1c\ubc1c-\ubb38\uc758\ub294-\uad6c\uae00\ud3fc\uc744-\uc774\uc6a9\ud574\uc8fc\uc138\uc694\">\ud504\ub85c\uc81d\ud2b8 \uac1c\ubc1c \ubb38\uc758\ub294 \uad6c\uae00\ud3fc\uc744 \uc774\uc6a9\ud574\uc8fc\uc138\uc694!<\/h2>\n\n\n\n<p><\/p>\n\n\n\n<p><a href=\"https:\/\/docs.google.com\/forms\/d\/e\/1FAIpQLSc-FiMM9foF0jEAWqL7IePJTEdQ0X9asQTENOIv_3mltyq2zg\/viewform?pli=1\" target=\"_blank\" rel=\"noopener\" title=\"\">\uc624\ud1a0\uc624\ud53c\uc2a4 \ud504\ub85c\uc81d\ud2b8 \ubb38\uc758<\/a><\/p>\n\n\n\n<p><br><br><\/p>\n","protected":false},"excerpt":{"rendered":"<p>1. \uc694\uc57d 2. createTextFinder()\ub780? 3. Spreadsheet \ud074\ub798\uc2a4\uc5d0\uc11c createTextFinder() \uc0ac\uc6a9\ud558\uae30 1. \uc694\uc57d \uc774 \ud3ec\uc2a4\ud2b8\uc5d0\uc11c\ub294 createTextFinder() \uba54\uc18c\ub4dc\ub97c \uc0ac\uc6a9\ud558\uc5ec Spreadsheet \ud074\ub798\uc2a4\uc5d0\uc11c \ud2b9\uc815 \ud14d\uc2a4\ud2b8\ub97c \ucc3e\ub294 \ubc29\ubc95\uc744 \uc18c\uac1c\ud569\ub2c8\ub2e4. \uc774 \ud3ec\uc2a4\ud2b8\ub294 Sheet, Range \ud074\ub798\uc2a4\uc5d0\uc11c createTextFinder() \uba54\uc18c\ub4dc\ub97c \uc0ac\uc6a9\ud558\ub294 \ubc29\ubc95\uc744 \uc18c\uac1c\ud558\ub294 \ud3ec\uc2a4\ud2b8\ub85c \ub0b4\uc6a9\uc774 \uc774\uc5b4\uc9d1\ub2c8\ub2e4. Sheet class\uc758 createTextFinder()Range class\uc758 createTextFinder&amp;TextFinder class\uc758 \uba54\uc18c\ub4dc \uc18c\uac1c 2. createTextFinder()\ub780? \uad6c\uae00 \uc2dc\ud2b8\uc5d0\uc11c \uc571\uc2a4 \uc2a4\ud06c\ub9bd\ud2b8\ub85c \uc791\uc5c5\uc744 \ud558\ub2e4\ubcf4\uba74 \ud2b9\uc815 \ud14d\uc2a4\ud2b8\ub97c \uac80\uc0c9\ud574\uc57c&#8230;<\/p>\n","protected":false},"author":6,"featured_media":16043,"comment_status":"closed","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_kad_post_transparent":"","_kad_post_title":"","_kad_post_layout":"","_kad_post_sidebar_id":"","_kad_post_content_style":"","_kad_post_vertical_padding":"","_kad_post_feature":"","_kad_post_feature_position":"","_kad_post_header":false,"_kad_post_footer":false,"footnotes":""},"categories":[5,118],"tags":[69,551,556,557,11,13,555,12],"class_list":["post-16042","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-spreadsheet","category-apps-script","tag-script","tag-autooffice","tag-createtextfinder","tag-textfinder","tag-11","tag-13","tag-555","tag-12"],"translation":{"provider":"WPGlobus","version":"3.0.2","language":"en","enabled_languages":["ko","en"],"languages":{"ko":{"title":true,"content":true,"excerpt":false},"en":{"title":false,"content":false,"excerpt":false}}},"aioseo_notices":[],"_links":{"self":[{"href":"https:\/\/www.autooffice.co.kr\/en\/wp-json\/wp\/v2\/posts\/16042","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.autooffice.co.kr\/en\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.autooffice.co.kr\/en\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.autooffice.co.kr\/en\/wp-json\/wp\/v2\/users\/6"}],"replies":[{"embeddable":true,"href":"https:\/\/www.autooffice.co.kr\/en\/wp-json\/wp\/v2\/comments?post=16042"}],"version-history":[{"count":59,"href":"https:\/\/www.autooffice.co.kr\/en\/wp-json\/wp\/v2\/posts\/16042\/revisions"}],"predecessor-version":[{"id":17181,"href":"https:\/\/www.autooffice.co.kr\/en\/wp-json\/wp\/v2\/posts\/16042\/revisions\/17181"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/www.autooffice.co.kr\/en\/wp-json\/wp\/v2\/media\/16043"}],"wp:attachment":[{"href":"https:\/\/www.autooffice.co.kr\/en\/wp-json\/wp\/v2\/media?parent=16042"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.autooffice.co.kr\/en\/wp-json\/wp\/v2\/categories?post=16042"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.autooffice.co.kr\/en\/wp-json\/wp\/v2\/tags?post=16042"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}