{"id":16135,"date":"2024-04-10T16:39:44","date_gmt":"2024-04-10T07:39:44","guid":{"rendered":"https:\/\/www.autooffice.co.kr\/?p=16135"},"modified":"2025-09-15T17:41:02","modified_gmt":"2025-09-15T08:41:02","slug":"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","status":"publish","type":"post","link":"https:\/\/www.autooffice.co.kr\/en\/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\/","title":{"rendered":"Range class\uc758 createTextFinder() \uc0ac\uc6a9 \ubc29\ubc95"},"content":{"rendered":"\n1. \uc694\uc57d<\/a>
\n2. Range \ud074\ub798\uc2a4\uc5d0\uc11c createTextFinder \uc0ac\uc6a9\ud558\uae30<\/a>
\n\n\n\n


<\/p>\n\n\n\n

1. \uc694\uc57d
<\/h2>\n\n\n\n


\uc774 \ud3ec\uc2a4\ud2b8\uc5d0\uc11c\ub294 createTextFinder() \uba54\uc18c\ub4dc\ub97c \uc0ac\uc6a9\ud558\uc5ec Range \ud074\ub798\uc2a4\uc5d0\uc11c \ud2b9\uc815 \ud14d\uc2a4\ud2b8\ub97c \ucc3e\ub294 \ubc29\ubc95\uacfc textFinder\uc5d0\uc11c \uc81c\uacf5\ud558\ub294 \uba54\uc18c\ub4dc\ub97c \uc18c\uac1c\ud569\ub2c8\ub2e4. createTextFinder()\ub97c \ucc98\uc74c \uc811\ud574\ubcf4\uc2e0 \ubd84\uc774\ub77c\uba74 \uc774\uc804\uc758 \ud3ec\uc2a4\ud2b8\ub97c \uba3c\uc800 \uc77d\uc5b4\ubcf4\uc2dc\uae38 \uad8c\ud569\ub2c8\ub2e4.
<\/p>\n\n\n\n

Spreadsheet class\uc758 createTextFinder()<\/a>
Sheet class\uc758 createTextFinder()<\/a>

<\/p>\n\n\n\n

2. Range \ud074\ub798\uc2a4\uc5d0\uc11c createTextFinder \uc0ac\uc6a9\ud558\uae30<\/h2>\n\n\n\n


\uc9c0\ub09c \ud3ec\uc2a4\ud2b8\uc5d0\uc11c \uc0b4\ud3b4\ubcf4\uc558\ub4ef\uc774 \uad6c\uae00 \uc571\uc2a4 \uc2a4\ud06c\ub9bd\ud2b8\uc758 \u2018createTextFinder()\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\ub85c, \uc2a4\ud504\ub808\ub4dc\uc2dc\ud2b8 \ubc94\uc704\uc5d0\uc11c \ud14d\uc2a4\ud2b8\ub97c \ucc3e\ub294 \uae30\ub2a5\uc744 \uc218\ud589\ud569\ub2c8\ub2e4. Range \ud074\ub798\uc2a4\uc758 createTextFinder()\ub294 \ud55c \uc2dc\ud2b8 \ub0b4\uc758 \ud2b9\uc815\ud55c \ubc94\uc704\ub97c \ub300\uc0c1\uc73c\ub85c \ud14d\uc2a4\ud2b8\ub97c \uac80\uc0c9\ud569\ub2c8\ub2e4.
<\/p>\n\n\n\n

\uae30\ubcf8 \uc0ac\uc6a9 \ubc29\ubc95

<\/h5>\n\n\n\n
function searchByRange() {\n  const SS = SpreadsheetApp.getActiveSpreadsheet();\n  const range = SS.getSheetByName('\uc2dc\ud2b8 \uc774\ub984').getRange('\ubc94\uc704');\n  const finder = range.createTextFinder('\ud14d\uc2a4\ud2b8 \ub610\ub294 \ubcc0\uc218');\n}<\/code><\/pre>\n\n\n\n

\uc704 \ucf54\ub4dc\ub294 createTextFinder\ub97c \ud2b9\uc815 \uc2dc\ud2b8 \uc548\uc758 \ud2b9\uc815 \ubc94\uc704\ub85c \uc9c0\uc815\ud569\ub2c8\ub2e4. \ubbf8\ub9ac \uc9c0\uc815\ud55c \uc2dc\ud2b8\uc758 \ubc94\uc704 \uc548\uc5d0\uc11c createTextFinder\uc9c0\uc815\ub41c \ud14d\uc2a4\ud2b8 \ub610\ub294 \ubcc0\uc218\ub97c \uac80\uc0c9\ud558\ub294 TextFinder \uac1d\uccb4\ub97c \uc0dd\uc131\ud569\ub2c8\ub2e4. \ucf54\ub4dc\ub294 \ub2e4\uc74c\uacfc \uac19\uc2b5\ub2c8\ub2e4.
<\/p>\n\n\n\n
function searchByActiveRange() {\n  const SS = SpreadsheetApp.getActiveSpreadsheet();\n  const range = SS.getActiveRange(); \/\/ \ud604\uc7ac \ud65c\uc131\ud654\ub41c \ubc94\uc704 \uac00\uc838\uc624\uae30\n  const finder = range.createTextFinder('\ud14d\uc2a4\ud2b8 \ub610\ub294 \ubcc0\uc218');\n}<\/code><\/pre>\n\n\n\n

\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.

<\/p>\n\n\n
\n
\"\"<\/a>
\uad6c\uae00 \uacf5\uc2dd \ub808\ud37c\ub7f0\uc2a4 \ubc14\ub85c\uac00\uae30<\/a><\/figcaption><\/figure>\n<\/div>\n\n\n

\ud65c\uc6a9 \uc608\uc2dc

<\/h5>\n\n\n\n
\ub2e4\uc74c\uc758 \uc2a4\ud504\ub808\ub4dc\uc2dc\ud2b8\ub294 \uc2e0\uaddc \uace0\uac1d\uc758 \uc815\ubcf4\ub97c \uc785\ub825\ud558\ub294 \uc2dc\ud2b8\uc640 \ub370\uc774\ud130\uac00 \uc800\uc7a5\ub418\ub294 \uc2dc\ud2b8\uac00 \ub3d9\uc77c\ud569\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\uc785\ub825\ud558\uae30<\/strong>\u2019 \ubc84\ud2bc\uc744 \ub204\ub974\uba74, \ud558\ub2e8\uc5d0 \ub370\uc774\ud130\uac00 \uae30\uc785\uc774 \ub41c\ub2e4\uace0 \uc608\ub97c \ub4e4\uc5b4\ubcf4\uaca0\uc2b5\ub2c8\ub2e4.<\/p>\n\n\n\n
\ud754\ud55c \uad6c\uc870\ub294 \uc544\ub2c8\uc9c0\ub9cc, \uc2a4\ud504\ub808\ub4dc\uc2dc\ud2b8\uac00 \uc785\ub825\ub418\ub294 \uc2dc\ud2b8\uc640 \uc800\uc7a5\ub418\ub294 \uc2dc\ud2b8\uac00 \ub3d9\uc77c\ud55c \ud0ed\uc774\uba74 Spreadsheet \ud074\ub798\uc2a4\ub098 Sheet \ud074\ub798\uc2a4\uc5d0\uc11c createTextFinder\ub97c \uc0ac\uc6a9\ud558\uba74 \uc5b4\ub5a4 \ubb38\uc81c\uac00 \ubc1c\uc0dd\ud560\uae4c\uc694? \uace0\uac1d\uc758 \uc815\ubcf4\ub97c \uc785\ub825\ud558\ub294 \ubd80\ubd84\uc5d0\uc11c\ubd80\ud130 \uc911\ubcf5 \ub370\uc774\ud130\uac00 \ubc1c\uc0dd\ud560 \uc218 \ubc16\uc5d0 \uc5c6\uc2b5\ub2c8\ub2e4. \ub530\ub77c\uc11c \uc544\ub798\uc758 \uc2dc\ud2b8\uc5d0\uc11c Range \ud074\ub798\uc2a4\ub97c \uc0ac\uc6a9\ud558\uc5ec \uace0\uac1d \uc815\ubcf4\ub97c \uc800\uc7a5\ud558\ub294 \ubaa9\ub85d\uc758 \ubc94\uc704\ub97c \uc9c0\uc815\ud558\uace0, \ub370\uc774\ud130\ub97c \ucd94\uac00\ud558\ub294 \uae30\ub2a5\uc744 \uad6c\ud604\ud574\ubcf4\uaca0\uc2b5\ub2c8\ub2e4.
<\/p>\n\n\n\n
\"\"<\/figure>\n\n\n\n

\u2018\uc2e0\uaddc \uace0\uac1d \ucd94\uac00<\/strong>\u2019 \uc2dc\ud2b8\uc5d0 \uc788\ub294 \u2018\uc785\ub825\ud558\uae30<\/strong>\u2019 \ubc84\ud2bc\uc5d0 \ud560\ub2f9\ub41c \uc2a4\ud06c\ub9bd\ud2b8\ub294 \uc544\ub798\uc640 \uac19\uc2b5\ub2c8\ub2e4. \uba3c\uc800 getRange() \uba54\uc18c\ub4dc\ub97c \uc0ac\uc6a9\ud574\ubcf4\uaca0\uc2b5\ub2c8\ub2e4.

<\/p>\n\n\n\n
\ucf54\ub4dc

<\/h5>\n\n\n\n
\n\t\t\n\t\t\t
<\/div>\n\t\t\t
\n\t\t\t\t\n\t\t\t\t\t\n\t\t\t\t
\n\t\t\t\t\t
1<\/div>
2<\/div>
3<\/div>
4<\/div>
5<\/div>
6<\/div>
7<\/div>
8<\/div>
9<\/div>
10<\/div>
11<\/div>
12<\/div>
13<\/div>
14<\/div>
15<\/div>
16<\/div>
17<\/div>
18<\/div>
19<\/div>
20<\/div>
21<\/div>
22<\/div>
23<\/div>
24<\/div>
25<\/div><\/div>\n\t\t\t\t<\/td>\n\t\t\t\t\t\t
function<\/span> <\/span>setNewCustomerByRange<\/span>(<\/span>)<\/span> <\/span>{<\/span><\/div>
  <\/span>const<\/span> <\/span>SS<\/span> <\/span>=<\/span> <\/span>SpreadsheetApp<\/span>.<\/span>getActiveSpreadsheet<\/span>(<\/span>)<\/span>;<\/span><\/div>
  <\/span>const<\/span> <\/span>ADD_CUSTOMER<\/span> <\/span>=<\/span> <\/span>SS<\/span>.<\/span>getSheetByName<\/span>(<\/span>‘\uc2e0\uaddc \uace0\uac1d \ucd94\uac00’<\/span>)<\/span>;<\/span><\/div>
  <\/span>const<\/span> <\/span>LAST_ROW<\/span> <\/span>=<\/span> <\/span>ADD_CUSTOMER<\/span>.<\/span>getLastRow<\/span>(<\/span>)<\/span>;<\/span> <\/span><\/div>
  <\/span>const<\/span> <\/span>RANGE<\/span> <\/span>=<\/span> <\/span>ADD_CUSTOMER<\/span>.<\/span>getRange<\/span>(<\/span>‘A14:D’<\/span> <\/span>+<\/span> <\/span>LAST_ROW<\/span>)<\/span>;<\/span><\/div>
 <\/div>
  <\/span>\/\/ \uc785\ub825 \ub370\uc774\ud130\ub97c \ubc30\uc5f4\ub85c \uac00\uc838\uc624\uae30<\/span><\/div>
  <\/span>let<\/span> <\/span>[joinDate<\/span>,<\/span> <\/span>name<\/span>,<\/span> <\/span>hp<\/span>,<\/span> <\/span>location<\/span>]<\/span> <\/span>=<\/span> <\/span>ADD_CUSTOMER<\/span>.<\/span>getRange<\/span>(<\/span>‘C3:C6’<\/span>)<\/span>.<\/span>getValues<\/span>(<\/span>)<\/span>.<\/span>map<\/span>(<\/span>row<\/span> <\/span> =><\/span> <\/span>row<\/span>[<\/span>0<\/span>]<\/span>)<\/span>;<\/span><\/div>
 <\/div>
  <\/span>\/\/ \uc911\ubcf5 \ub370\uc774\ud130 \uac80\uc0ac<\/span><\/div>
  <\/span>const<\/span> <\/span>hpFinder<\/span> <\/span>=<\/span> <\/span>RANGE<\/span>.<\/span>createTextFinder<\/span>(<\/span>hp<\/span>)<\/span>.<\/span>matchEntireCell<\/span>(<\/span>true<\/span>)<\/span>.<\/span>findAll<\/span>(<\/span>)<\/span>;<\/span><\/div>
  <\/span>if<\/span> <\/span>(<\/span>hpFinder<\/span>.<\/span>length<\/span> <\/span>><\/span> <\/span>0<\/span>)<\/span> <\/span>{<\/span><\/div>
    <\/span>hpFinder<\/span>.<\/span>forEach<\/span>(<\/span>occurrence<\/span> <\/span>=><\/span> <\/span>{<\/span><\/div>
      <\/span>let <\/span>sheetName<\/span> <\/span>=<\/span> <\/span>occurrence<\/span>.<\/span>getSheet<\/span>(<\/span>)<\/span>.<\/span>getName<\/span>(<\/span>)<\/span>;<\/span><\/div>
      <\/span>let <\/span>row<\/span> <\/span>=<\/span> <\/span>occurrence<\/span>.<\/span>getRow<\/span>(<\/span>)<\/span>;<\/span><\/div>
      <\/span>Logger<\/span>.<\/span>log<\/span>(<\/span>`<\/span>\uc774\ubbf8 <\/span>\uac00\uc785\ub41c <\/span>\ud68c\uc6d0\uc785\ub2c8\ub2e4:<\/span> <\/span>$<\/span>{<\/span>sheetName<\/span>}<\/span>‘ \uc2dc\ud2b8\uc758 ${row}\ud589\uc744 \ucc38\uc870\ud558\uc138\uc694.`)<\/span><\/div>
      SpreadsheetApp.getUi().alert(‘<\/span>\uc774\ubbf8 <\/span>\uac00\uc785\ub41c <\/span>\ud68c\uc6d0\uc785\ub2c8\ub2e4:<\/span> <\/span>\\<\/span>\\<\/span>”<\/span> <\/span>+<\/span> <\/span>sheetName<\/span> <\/span>+<\/span> <\/span>‘\\\\’<\/span> <\/span>\uc2dc\ud2b8\uc758 <\/span>‘ + row + ‘<\/span>\ud589\uc744 <\/span>\ucc38\uc870\ud558\uc138\uc694.<\/span>‘);<\/span><\/div>
    });<\/span><\/div>
  } else {<\/span><\/div>
    const lastRow = RANGE.getLastRow(); \/\/ \ub9c8\uc9c0\ub9c9 \ud589 \uac00\uc838\uc624\uae30<\/span><\/div>
    Logger.log(lastRow);<\/span><\/div>
    RANGE.getSheet().getRange(lastRow +1, 1, 1, 4).setValues([[joinDate, name, hp, location]]);<\/span><\/div>
    SpreadsheetApp.getUi().alert(‘<\/span>\uc2e0\uaddc <\/span>\uace0\uac1d <\/span>\uc815\ubcf4\uac00 <\/span>\ucd94\uac00\ub418\uc5c8\uc2b5\ub2c8\ub2e4.<\/span>‘)<\/span>;<\/span><\/div>
  <\/span>}<\/span><\/div>
}<\/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

\ucf54\ub4dc \uc124\uba85

<\/h5>\n\n\n\n
    \n
  1. getSheetByName('\uc2e0\uaddc \uace0\uac1d \ucd94\uac00')<\/mark><\/code><\/strong> \uba54\uc18c\ub4dc\ub97c \uc0ac\uc6a9\ud558\uc5ec ‘\uc2e0\uaddc \uace0\uac1d \ucd94\uac00<\/strong>‘\ub77c\ub294 \uc774\ub984\uc758 \uc2dc\ud2b8\ub97c \uac00\uc838\uc635\ub2c8\ub2e4.<\/li>\n\n\n\n
  2. getLastRow()<\/mark><\/code><\/strong> \ub97c \ud1b5\ud574 ‘\uc2e0\uaddc \uace0\uac1d \ucd94\uac00<\/strong>‘ \uc2dc\ud2b8\uc5d0\uc11c \ub370\uc774\ud130\uac00 \uc788\ub294 \ub9c8\uc9c0\ub9c9 \ud589\uc758 \ubc88\ud638\ub97c \uac00\uc838\uc635\ub2c8\ub2e4.<\/li>\n\n\n\n
  3. getRange('A14:D' + LAST_ROW)<\/mark><\/strong><\/code> ‘\uc2e0\uaddc \uace0\uac1d \ucd94\uac00<\/strong>‘ \uc2dc\ud2b8\uc5d0\uc11c \ub370\uc774\ud130\uac00 \uc785\ub825\ub418\uc5b4 \uc788\ub294 \ubc94\uc704(A14\ubd80\ud130 \ub370\uc774\ud130\uac00 \uc874\uc7ac\ud558\ub294 \ub9c8\uc9c0\ub9c9 \ud589\uae4c\uc9c0)\ub97c \uc815\uc758\ud558\uc600\uc2b5\ub2c8\ub2e4. \ub370\uc774\ud130\uac00 \uc874\uc7ac\ud558\ub294 \ub9c8\uc9c0\ub9c9 \ud589\uc758 \uc704\uce58\uac00 \ub2f4\uae34 LASW_ROW\ub97c \uc0ac\uc6a9\ud558\uc9c0 \uc54a\uc73c\uba74 \ub370\uc774\ud130\uac00 \uc874\uc7ac\ud558\uc9c0 \uc54a\ub294 \uc140\uae4c\uc9c0 \ubaa8\ub450 \uac80\uc0c9\ud558\ubbc0\ub85c \ub370\uc774\ud130\uac00 \uc874\uc7ac\ud558\ub294 \ud589\uae4c\uc9c0 \ubc94\uc704\ub97c \ucd95\uc18c\ud558\uae30 \uc704\ud574 LAST_ROW \ubcc0\uc218\ub97c \uc0ac\uc6a9\ud558\uc600\uc2b5\ub2c8\ub2e4.<\/li>\n\n\n\n
  4. \uace0\uac1d \uc815\ubcf4\ub97c \uac00\uc838\uc624\uae30 \uc704\ud574 getRange('C3:C6').getValues().map(row => row[0])<\/strong><\/mark><\/code>\ub97c \uc0ac\uc6a9\ud569\ub2c8\ub2e4. \uc774\ub294 ‘\uc2e0\uaddc \uace0\uac1d \ucd94\uac00<\/strong>‘ \uc2dc\ud2b8\uc5d0\uc11c C3\ubd80\ud130 C6\uae4c\uc9c0\uc758 \ubc94\uc704\uc5d0 \uc788\ub294 \ub370\uc774\ud130\ub97c \uac00\uc838\uc640\uc11c \ubc30\uc5f4\ub85c \ubcc0\ud658\ud569\ub2c8\ub2e4.<\/li>\n\n\n\n
  5. \uc9c0\uc815\ub41c \ubc94\uc704\uc5d0\uc11c createTextFinder<\/mark><\/code><\/strong> \uba54\uc18c\ub4dc\ub97c \uc0ac\uc6a9\ud558\uc5ec \uc911\ubcf5\ub41c \uc804\ud654\ubc88\ud638\ub97c \ucc3e\uc2b5\ub2c8\ub2e4. \ub9cc\uc57d \uc911\ubcf5\ub41c \uc5f0\ub77d\ucc98\uac00 \uc788\uc744 \uacbd\uc6b0, \ud574\ub2f9 \uc704\uce58\ub97c \ub85c\uadf8\ub85c \ub0a8\uae30\uace0, \uc54c\ub9bc\ucc3d\uc744 \ud45c\uc2dc\ud569\ub2c8\ub2e4. forEach<\/strong><\/mark><\/code>\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 \uc218\ud589\ud569\ub2c8\ub2e4.<\/li>\n\n\n\n
  6. \uc911\ubcf5\ub41c \uc5f0\ub77d\ucc98\uac00 \uc5c6\uc744 \uacbd\uc6b0, \uace0\uac1d \uc815\ubcf4\ub97c \u2018\uc2e0\uaddc \uace0\uac1d \ucd94\uac00<\/strong>\u2019 \uc2dc\ud2b8\uc758 \ubaa9\ub85d \ubc94\uc704 \ub9c8\uc9c0\ub9c9 \ud589\uc5d0 \ucd94\uac00\ud569\ub2c8\ub2e4. getLastRow()<\/mark><\/code><\/strong> \ub294 \ub370\uc774\ud130\uac00 \uc788\ub294 \ub9c8\uc9c0\ub9c9 \ud589\uc744 \uac00\uc838\uc624\uae30 \ub54c\ubb38\uc5d0 \ub370\uc774\ud130\uac00 \ub36e\uc5b4\uc4f0\uc5ec\uc9c0\ub294 \uac83\uc744 \ubc29\uc9c0\ud558\uae30 \uc704\ud574 1\uc744 \ub354\ud574\uc8fc\uc5c8\uc2b5\ub2c8\ub2e4.<\/li>\n\n\n\n
  7. \uace0\uac1d \uc815\ubcf4\uac00 \ucd94\uac00\ub418\uc5c8\ub2e4\ub294 \uc54c\ub9bc\ucc3d\uc744 \ud45c\uc2dc\ud569\ub2c8\ub2e4.<\/li>\n<\/ol>\n\n\n\n
    \uc55e\uc11c \uc0b4\ud3b4\ubcf4\uc558\ub358 Spreadsheet, Sheet \ud074\ub798\uc2a4\uc5d0\uc11c \uc0ac\uc6a9\ub420 \ub54c\uc640 \ube44\uc2b7\ud558\uc9c0\ub9cc, \ub2e4\ub978 \uc810\uc740 getRange()<\/strong><\/mark><\/code>\ub97c \ud1b5\ud574\uc11c \ubc94\uc704\ub97c \uc9c0\uc815\ud55c\ub2e4\ub294 \uac83\uc785\ub2c8\ub2e4. \uc774\ub807\uac8c getRange()<\/strong><\/mark><\/code><\/strong> \ub97c \uc0ac\uc6a9\ud558\uba74 \uac19\uc740 \uc2dc\ud2b8 \ub0b4\uc5d0\uc11c\ub3c4 \uc6d0\ud558\ub294 \ubc94\uc704 \uc548\uc5d0\uc11c\ub9cc \uc911\ubcf5\ub41c \ub370\uc774\ud130\ub97c \uac80\uc0c9\ud558\ub294 \uac83\uc774 \uac00\ub2a5\ud569\ub2c8\ub2e4.<\/p>\n\n\n\n
    \uc774\uc81c \uc2a4\ud06c\ub9bd\ud2b8\ub97c \ud560\ub2f9\ud558\uace0 \uc2e4\ud589\ud574\ubcf4\uaca0\uc2b5\ub2c8\ub2e4.

    <\/p>\n\n\n\n
    \"\"
    \uc8103\uac1c \ubc84\ud2bc \ud074\ub9ad \u2192 \u2018\uc2a4\ud06c\ub9bd\ud2b8 \ud560\ub2f9<\/strong>\u2019 \ud074\ub9ad<\/figcaption><\/figure>\n\n\n\n

    <\/p>\n\n\n\n
    \"\"
    \uc571\uc2a4 \uc2a4\ud06c\ub9bd\ud2b8 \ud568\uc218\uba85 \uc785\ub825 \ud6c4 \u2018\ud655\uc778<\/strong>\u2019 \ubc84\ud2bc \ud074\ub9ad<\/figcaption><\/figure>\n\n\n\n

    <\/p>\n\n\n\n
    \uc774\uc81c \ud55c\ubc88 \uc2e4\ud589\ud574\ubcfc\uae4c\uc694?

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

    \uace0\uac1d \uc815\ubcf4\uac00 \ucd94\uac00\ub418\uc5c8\ub2e4\ub294 \uc54c\ub9bc\ucc3d\uc774 \uc815\uc0c1\uc801\uc73c\ub85c \ucd9c\ub825\ub418\uc5c8\uc2b5\ub2c8\ub2e4. \uc9c0\uc815\ub41c \ubc94\uc704\uc5d0 \ub370\uc774\ud130\uac00 \uc798 \ucd94\uac00\ub418\uc5c8\ub124\uc694.
    <\/p>\n\n\n\n
    \uc774\uc81c \uac80\uc0c9 \uc870\uac74\uc778 \uc5f0\ub77d\ucc98\ub97c \uc81c\uc678\ud55c \uac00\uc785\uc77c, \uc774\ub984, \uc9c0\uc5ed\uc744 \ubc14\uafbc \ucc44\ub85c \ub2e4\uc2dc \u2018\uc785\ub825\ud558\uae30<\/strong>\u2019 \ubc84\ud2bc\uc744 \ud074\ub9ad\ud574\ubcf4\uaca0\uc2b5\ub2c8\ub2e4. \uc5f0\ub77d\ucc98\uac00 \uc911\ubcf5\uc774 \ub41c\ub2e4\uba74 \ub370\uc774\ud130\uc758 \uc0bd\uc785\uc774 \uc774\ub8e8\uc5b4\uc838\uc11c\ub294 \uc548\ub418\uba70, \uc911\ubcf5\ub41c \uc140\uc758 \uc704\uce58\ub97c \uc54c\ub9bc\ucc3d\uc744 \ud1b5\ud574 \uc804\ub2ec\ubc1b\uc544\uc57c \ud569\ub2c8\ub2e4. \ud14c\uc2a4\ud2b8\ub97c \uc704\ud574 \ub2e4\uc74c\uc758 \uc815\ubcf4\ub97c \uc785\ub825\ud558\uc600\uc2b5\ub2c8\ub2e4.

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

    \u2018\uc785\ub825\ud558\uae30<\/strong>\u2019 \ubc84\ud2bc\uc744 \ud074\ub9ad\ud574\ubcf4\uaca0\uc2b5\ub2c8\ub2e4.

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

    \uc911\ubcf5\ub41c \uc5f0\ub77d\ucc98\ub97c \ud655\uc778\ud558\uc600\uace0 \uc911\ubcf5\ub41c \uc140\uc758 \uc704\uce58\ub97c \uc798 \uc804\ub2ec\ud558\uace0 \uc788\ub124\uc694.<\/p>\n\n\n\n
    \ub85c\uadf8\ub3c4 \ub0a8\uc544\uc788\ub294 \uac83\uc744 \ud655\uc778\ud560 \uc218 \uc788\uc2b5\ub2c8\ub2e4. createTextFinder\ub294 \ud544\uc694\ud55c \uac80\uc0c9\uc758 \ubc94\uc704\uc5d0 \ub530\ub77c \uc5ec\ub7ec \ud074\ub798\uc2a4\uc5d0\uc11c \uc9c0\uc6d0\ud558\uace0 \uc788\ub294\ub370, \uc9c0\uae08\ucc98\ub7fc \uac80\uc0c9\ud558\ub294 \ubc94\uc704\ub97c \ucd5c\uc18c\ud654\ud558\uc5ec \uc9c0\uc815\ud558\uba74 \uc6d0\ud558\ub294 \uc815\ubcf4\ub97c \uc815\ud655\ud558\uace0 \ube60\ub974\uac8c \ucc3e\uc744 \uc218 \uc788\uc2b5\ub2c8\ub2e4.

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

    \uc9c0\uae08\uae4c\uc9c0 3\uac1c\uc758 \ud3ec\uc2a4\ud2b8\uc5d0 \uac78\uccd0\uc11c Spreadsheet, Sheet, Range \ud074\ub798\uc2a4\uc5d0\uc11c createTextFinder()\ub97c \uc0ac\uc6a9\ud558\ub294 \ubc29\ubc95\uc744 \uc0b4\ud3b4\ubcf4\uc558\uc2b5\ub2c8\ub2e4. \uc571\uc2a4 \uc2a4\ud06c\ub9bd\ud2b8\ub85c \ud14d\uc2a4\ud2b8\ub97c \ucc3e\ub294 \uae30\ub2a5\uc5d0 \ub2e4\uc591\ud55c \ubc94\uc704\uae4c\uc9c0 \uc9c0\uc815\ud560 \uc218 \uc788\ub2e4\ub2c8 \uc815\ub9d0 \uc720\uc6a9\ud55c \uae30\ub2a5\uc774\uc8e0? \ud558\uc9c0\ub9cc \uc774 \ubfd0\ub9cc\uc774 \uc544\ub2d9\ub2c8\ub2e4. createTextFinder()\uba54\uc18c\ub4dc\ub294 \ub2e4\uc591\ud55c \uc635\uc158\uc744 \uc9c0\uc6d0\ud569\ub2c8\ub2e4. <\/p>\n\n\n\n
    <\/p>\n\n\n\n
    \uc774\uc5b4\uc9c0\ub294 \ud3ec\uc2a4\ud2b8\uc5d0\uc11c TextFinder \ud074\ub798\uc2a4\uc5d0\uc11c \uc81c\uacf5\ud558\ub294 \ub2e4\uc591\ud55c \uc635\uc158\uc744 \uc18c\uac1c\ud558\uaca0\uc2b5\ub2c8\ub2e4.

    <\/p>\n\n\n\n
    TextFinder class \uba54\uc18c\ub4dc \uc18c\uac1c<\/a>
    <\/p>\n\n\n\n

    <\/p>\n\n\n\n
    \n\n\n\n

    <\/p>\n\n\n\n
    \"\"<\/figure>\n\n\n\n
    \uc5c5\ubb34 \ud6a8\uc728\uc131 200% \uc62c\ub9ac\uae30, with autooffice<\/h2>\n\n\n\n
    \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>\n\n\n\n
    \uc624\ud1a0\uc624\ud53c\uc2a4 \ud504\ub85c\uc81d\ud2b8 \ubb38\uc758<\/a><\/p>\n\n\n\n


    <\/p>\n","protected":false},"excerpt":{"rendered":"
    1. \uc694\uc57d 2. Range \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 Range \ud074\ub798\uc2a4\uc5d0\uc11c \ud2b9\uc815 \ud14d\uc2a4\ud2b8\ub97c \ucc3e\ub294 \ubc29\ubc95\uacfc textFinder\uc5d0\uc11c \uc81c\uacf5\ud558\ub294 \uba54\uc18c\ub4dc\ub97c \uc18c\uac1c\ud569\ub2c8\ub2e4. createTextFinder()\ub97c \ucc98\uc74c \uc811\ud574\ubcf4\uc2e0 \ubd84\uc774\ub77c\uba74 \uc774\uc804\uc758 \ud3ec\uc2a4\ud2b8\ub97c \uba3c\uc800 \uc77d\uc5b4\ubcf4\uc2dc\uae38 \uad8c\ud569\ub2c8\ub2e4. Spreadsheet class\uc758 createTextFinder()Sheet class\uc758 createTextFinder() 2. Range \ud074\ub798\uc2a4\uc5d0\uc11c createTextFinder \uc0ac\uc6a9\ud558\uae30 \uc9c0\ub09c \ud3ec\uc2a4\ud2b8\uc5d0\uc11c \uc0b4\ud3b4\ubcf4\uc558\ub4ef\uc774 \uad6c\uae00 \uc571\uc2a4 \uc2a4\ud06c\ub9bd\ud2b8\uc758 \u2018createTextFinder()\u2019 \ub294 \uad6c\uae00 \uc2a4\ud504\ub808\ub4dc\uc2dc\ud2b8\uc5d0\uc11c \ud14d\uc2a4\ud2b8\ub97c \uac80\uc0c9\ud560…<\/p>\n","protected":false},"author":6,"featured_media":16349,"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":[558,551,556,557,11,13,555,12],"class_list":["post-16135","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-spreadsheet","category-apps-script","tag-appsscript","tag-autooffice","tag-createtextfinder","tag-textfinder","tag-11","tag-13","tag-555","tag-12"],"translation":{"provider":"WPGlobus","version":"3.0.3","language":"en","enabled_languages":["ko","en"],"languages":{"ko":{"title":true,"content":true,"excerpt":false},"en":{"title":false,"content":false,"excerpt":false}}},"aioseo_notices":[],"aioseo_head":"\n\t\t\n\t\n\t\n\t\n\t\n\t\n\t\n\t\t\n\t\t\n\t\t\n\t\t\n\t\t\n\t\t\n\t\t\n\t\t\n\t\t\n\t\t\n\t\t\n\t\t\n\t\t\n\t\t\n\t\t\n\t\t\n\t\t