{"id":16084,"date":"2024-04-10T14:51:20","date_gmt":"2024-04-10T05:51:20","guid":{"rendered":"https:\/\/www.autooffice.co.kr\/?p=16084"},"modified":"2025-09-15T17:39:13","modified_gmt":"2025-09-15T08:39:13","slug":"sheet-class%ec%9d%98-createtextfinder","status":"publish","type":"post","link":"https:\/\/www.autooffice.co.kr\/en\/blog\/2024\/04\/10\/sheet-class%ec%9d%98-createtextfinder\/","title":{"rendered":"Sheet class\uc758 createTextFinder() \uc0ac\uc6a9 \ubc29\ubc95"},"content":{"rendered":"\n
\n
    \n
  1. \uc694\uc57d<\/a><\/li>\n
  2. Sheet \ud074\ub798\uc2a4\uc5d0\uc11c createTextFinder() \uc0ac\uc6a9\ud558\uae30<\/a><\/li>\n<\/ol>\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 Sheet \ud074\ub798\uc2a4\uc5d0\uc11c \ud2b9\uc815 \ud14d\uc2a4\ud2b8\ub97c \ucc3e\ub294 \ubc29\ubc95\uc744 \uc18c\uac1c\ud569\ub2c8\ub2e4. Spreadsheet \ud074\ub798\uc2a4\uc5d0\uc11c createTextFinder()\uba54\uc18c\ub4dc\ub97c \uc0ac\uc6a9\ud558\ub294 \ubc29\ubc95\uc744 \uc18c\uac1c\ud558\ub294 \uc774\uc804 \ud3ec\uc2a4\ud2b8\ub85c\ubd80\ud130 \ub0b4\uc6a9\uc774 \uc774\uc5b4\uc9d1\ub2c8\ub2e4.
    <\/p>\n\n\n\n

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

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

    2. Sheet \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. createTextFinder()\ub97c Sheet \ud074\ub798\uc2a4\uc5d0\uc11c \uc0ac\uc6a9\ud558\uba74 \ud2b9\uc815 \uc2dc\ud2b8\ub97c \ub300\uc0c1\uc73c\ub85c \ud14d\uc2a4\ud2b8\ub97c \uac80\uc0c9\ud560 \uc218 \uc788\uc2b5\ub2c8\ub2e4.
    <\/p>\n\n\n\n

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

    <\/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><\/div>\n\t\t\t\t<\/td>\n\t\t\t\t\t\t
    function<\/span> <\/span>searchBySheet<\/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>let <\/span>sheet<\/span> <\/span>=<\/span> <\/span>SS<\/span>.<\/span>getSheets<\/span>(<\/span>)<\/span>[0]<\/span>;<\/span><\/div>
      <\/span>let <\/span>finder<\/span> <\/span>=<\/span> <\/span>sheet<\/span>.<\/span>createTextFinder<\/span>(<\/span>‘\ud14d\uc2a4\ud2b8 \ub610\ub294 \ubcc0\uc218’<\/span>)<\/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



    \uc774 \ucf54\ub4dc\ub294 getSheets<\/mark><\/code><\/strong> \ub97c \uc0ac\uc6a9\ud558\uc5ec \ud2b9\uc815 \uc2dc\ud2b8\ub97c \uc778\ub371\uc2a4\ub85c \ubd88\ub7ec\uc635\ub2c8\ub2e4. getSheets()[\uc778\ub371\uc2a4]<\/mark><\/code><\/strong> \ud615\uc2dd\uc73c\ub85c \uc0ac\uc6a9\ud569\ub2c8\ub2e4. \uc5ec\uae30\uc11c createTextFinder \uba54\uc18c\ub4dc\ub294 Sheet \ud074\ub798\uc2a4\uc758 \uba54\uc18c\ub4dc\ub85c \uc0ac\uc6a9\ud558\uace0 \uc788\uc9c0\uc694. \ub530\ub77c\uc11c \ubbf8\ub9ac \uc124\uc815\ud55c \uc2dc\ud2b8 \uc548\uc73c\ub85c \uac80\uc0c9 \ubc94\uc704\uac00 \ud55c\uc815\ub429\ub2c8\ub2e4.<\/p>\n\n\n\n

    \uc2dc\ud2b8\uc758 \uc774\ub984\uc744 \uc9c1\uc811 \uc9c0\uc815\ud558\ub824\uba74 getSheetByName()<\/mark><\/strong><\/code> \uba54\uc18c\ub4dc\ub97c \uc0ac\uc6a9\ud560 \uc218 \uc788\uc2b5\ub2c8\ub2e4. getSheetByName()<\/mark><\/code><\/strong> \uba54\uc18c\ub4dc \uc0ac\uc6a9 \ubc29\ubc95\uc740 \ub2e4\uc74c\uacfc \uac19\uc2b5\ub2c8\ub2e4.<\/p>\n\n\n\n

    function searchBySheet() {\n  const SS = SpreadsheetApp.getActiveSpreadsheet();\n  const sheet = SS.getSheetByName('\uc2dc\ud2b8 \uc774\ub984'); \n  let finder = sheet.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
    \uc544\ub798\uc758 \uc608\uc2dc\ub294 \u2018\uace0\uac1d \ubaa9\ub85d\u2019, \u2019\uc608\uc57d\u2019, \u2019\ubc29\ubb38 \ub0b4\uc5ed\u2019, \u2019\ube44\ud65c\ub3d9\uace0\uac1d\u2019 <\/strong>\uc2dc\ud2b8\ub85c \uad6c\uc131\ub418\uc5b4 \uc788\uc2b5\ub2c8\ub2e4. \u2018\uc2e0\uaddc \uace0\uac1d \ucd94\uac00<\/strong>\u2019 \uc2dc\ud2b8\uc5d0\uc11c \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 \u2018\uace0\uac1d \ubaa9\ub85d<\/strong>\u2019 \uc2dc\ud2b8\uc5d0 \uc800\uc7a5\ub418\ub294 \ub85c\uc9c1\uc785\ub2c8\ub2e4.

    <\/p>\n\n\n
    \n
    \"\"
    \uc815\ubcf4 \uc785\ub825 \ud6c4 \u2018\uc785\ub825\ud558\uae30<\/strong>\u2019 \ub97c \ud074\ub9ad\ud558\uba74 \u2018\uace0\uac1d \ubaa9\ub85d<\/strong>\u2019 \uc2dc\ud2b8\uc5d0 \ub370\uc774\ud130\uac00 \uc0bd\uc785\ub429\ub2c8\ub2e4.<\/figcaption><\/figure>\n<\/div>\n\n\n

    <\/p>\n\n\n
    \n
    \"\"
    \uace0\uac1d \uc815\ubcf4\uac00 \u2018\uace0\uac1d \ubaa9\ub85d<\/strong>\u2019 \uc2dc\ud2b8\uc5d0 \uc0bd\uc785\ub41c \ud654\uba74<\/figcaption><\/figure>\n<\/div>\n\n\n

    <\/p>\n\n\n\n
    \uc774\ub54c, \uc774\ubbf8 \ub4f1\ub85d\ub41c \uace0\uac1d\uc758 \uc815\ubcf4\uac00 \uc911\ubcf5\ub418\uc5b4 \uc800\uc7a5\ub418\uc5b4\uc11c\ub294 \uc548\ub418\uaca0\uc8e0. \ub530\ub77c\uc11c \uc815\ubcf4\ub97c \ub4f1\ub85d\ud558\uae30 \uc804\uc5d0 \uc911\ubcf5\ub41c \ub370\uc774\ud130\ub97c \uac80\uc0c9 \ud6c4 \uc911\ubcf5\ub418\ub294 \uc5f0\ub77d\ucc98\uac00 \uc5c6\ub2e4\uba74 \uace0\uac1d \ubaa9\ub85d\uc5d0 \uc815\ubcf4\ub97c \ub4f1\ub85d\ud558\uace0, \uc911\ubcf5\ub418\ub294 \uc5f0\ub77d\ucc98\uac00 \uc788\ub2e4\uba74 \uc911\ubcf5\ub41c \uac12\uc774 \uc874\uc7ac\ud558\ub294 \uc140\uc758 \uc704\uce58\ub97c \uc54c\ub824\uc8fc\ub294 \uc54c\ub9bc \ucc3d\uc744 \ud45c\uc2dc\ud558\ub294 \uae30\ub2a5\uc744 \ub123\uc5b4\ubcf4\uaca0\uc2b5\ub2c8\ub2e4.<\/p>\n\n\n\n
    \ud83d\udca1 \ucf54\ub4dc\ub97c \uc791\uc131\ud560 \ub54c \uc8fc\uc758\ud560 \uc810<\/strong><\/mark>\uc740, \uace0\uac1d\uc758 \uc5f0\ub77d\ucc98\ub97c \u2018\uace0\uac1d \ubaa9\ub85d<\/strong>\u2019 \uc774\uc678\uc758 \uc2dc\ud2b8\uc5d0\uc11c\ub294 \uac80\uc0c9\ud574\uc11c\ub294 \uc548\ub41c\ub2e4\ub294 \uac83\uc785\ub2c8\ub2e4. \uc704 \uc608\uc2dc\uc5d0\uc11c\ub294 \uace0\uac1d \uc5f0\ub77d\ucc98\ub97c \uac80\uc0c9\ud558\ub294 \ubc94\uc704\ub97c \u2018\uace0\uac1d \ubaa9\ub85d<\/strong>\u2019 \uc2dc\ud2b8\ub85c \ud55c\uc815\ud574\uc57c \uc815\ud655\ud55c \ub370\uc774\ud130\ub97c \ucc3e\uc544\uc57c \ud569\ub2c8\ub2e4.
    <\/p>\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. \uc608\uc2dc\uc5d0\uc11c\ub294 \uace0\uac1d \ubaa9\ub85d \ud0ed\uc744 \uc9c0\uc815\ud558\uae30 \uc704\ud574 getSheets()<\/mark><\/code><\/strong> \uba54\uc18c\ub4dc\ub97c \ud65c\uc6a9\ud558\uc600\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>setNewCustomerBySheet<\/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>SHEET<\/span> <\/span>=<\/span> <\/span>SS<\/span>.<\/span>getSheets<\/span>(<\/span>)<\/span>[1]<\/span>;<\/span><\/div>
     <\/div>
      <\/span>\/\/ \uc785\ub825 \ub370\uc774\ud130\ub97c \ubc30\uc5f4\ub85c \uac00\uc838\uc624\uae30<\/span><\/div>
      <\/span>let<\/span> <\/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>SHEET<\/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>‘${sheetName}’<\/span> <\/span>\uc2dc\ud2b8\uc758 <\/span>$<\/span>{<\/span>row<\/span>}<\/span>\ud589\uc744 <\/span>\ucc38\uc870\ud558\uc138\uc694.<\/span>`<\/span>)<\/span><\/div>
          <\/span>SpreadsheetApp<\/span>.<\/span>getUi<\/span>(<\/span>)<\/span>.<\/span>alert<\/span>(<\/span>‘\uc774\ubbf8 \uac00\uc785\ub41c \ud68c\uc6d0\uc785\ub2c8\ub2e4: \\\\’<\/span>‘ + sheetName + ‘<\/span>\\<\/span>\\<\/span>‘ \uc2dc\ud2b8\uc758 ‘<\/span> <\/span>+<\/span> <\/span>row<\/span> <\/span>+<\/span> <\/span>‘\ud589\uc744 \ucc38\uc870\ud558\uc138\uc694.’<\/span>)<\/span>;<\/span><\/div>
        <\/span>}<\/span>)<\/span>;<\/span><\/div>
      <\/span>}<\/span> <\/span>else<\/span> <\/span>{<\/span><\/div>
        <\/span>\/\/ \ubc30\uc5f4\ub85c \ub370\uc774\ud130 \uc0bd\uc785<\/span><\/div>
        <\/span>const<\/span> <\/span>lastRow<\/span> <\/span>=<\/span> <\/span>SHEET<\/span>.<\/span>getLastRow<\/span>(<\/span>)<\/span>;<\/span><\/div>
        <\/span>SHEET<\/span>.<\/span>getRange<\/span>(<\/span>lastRow<\/span> <\/span>+<\/span> <\/span>1<\/span>,<\/span> <\/span>1<\/span>,<\/span> <\/span>1<\/span>,<\/span> <\/span>4<\/span>)<\/span>.<\/span>setValues<\/span>(<\/span>[[<\/span>joinDate<\/span>,<\/span> <\/span>name<\/span>,<\/span> <\/span>hp<\/span>,<\/span> <\/span>location<\/span>]<\/span>]<\/span>)<\/span>;<\/span><\/div>
        <\/span>SpreadsheetApp<\/span>.<\/span>getUi<\/span>(<\/span>)<\/span>.<\/span>alert<\/span>(<\/span>‘\uc2e0\uaddc \uace0\uac1d \uc815\ubcf4\uac00 \ucd94\uac00\ub418\uc5c8\uc2b5\ub2c8\ub2e4.’<\/span>)<\/span>;<\/span><\/div>
      <\/span>}<\/span><\/div>
    }<\/span><\/div>
     <\/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. setNewCustomerBySheet<\/mark><\/code><\/strong> \ud568\uc218\ub97c \ud638\ucd9c\ud558\uba74 \uc2a4\ud06c\ub9bd\ud2b8\ub294 \ud604\uc7ac \ud65c\uc131\ud654\ub41c \uc2a4\ud504\ub808\ub4dc\uc2dc\ud2b8\ub97c \uac00\uc838\uc635\ub2c8\ub2e4.<\/li>\n\n\n\n
    2. getSheetByName<\/mark><\/code><\/strong> \uba54\uc18c\ub4dc\ub97c \uc0ac\uc6a9\ud558\uc5ec ‘\uc2e0\uaddc \uace0\uac1d \ucd94\uac00<\/strong>‘ \uc2dc\ud2b8\ub97c \uac00\uc838\uc635\ub2c8\ub2e4.<\/li>\n\n\n\n
    3. getSheets()[1]<\/strong><\/mark><\/code>\ub97c \uc0ac\uc6a9\ud558\uc5ec \uc2a4\ud504\ub808\ub4dc\uc2dc\ud2b8\uc758 \ub450 \ubc88\uc9f8 \uc2dc\ud2b8\ub97c \uac00\uc838\uc635\ub2c8\ub2e4. \u2018\uace0\uac1d \ubaa9\ub85d<\/strong>\u2019 \uc2dc\ud2b8\ub294 2\ubc88\uc9f8\ub85c \uc0dd\uc131\ub41c \uc2dc\ud2b8\uc774\uae30 \ub54c\ubb38\uc5d0 \ubc30\uc5f4\uc758 \uaddc\uce59\uc5d0 \ub530\ub77c\uc11c \u2018[1]<\/strong>\u2019 \ub85c \ud45c\uc2dc\ud558\uc5ec \uc2dc\ud2b8\ub97c \ubd88\ub7ec\uc654\uc2b5\ub2c8\ub2e4.
      <\/li>\n<\/ol>\n\n\n\n
      \ud83d\udca1 getSheets()<\/strong><\/mark><\/code> \uba54\uc18c\ub4dc\ub294 \uc2a4\ud504\ub808\ub4dc \uc2dc\ud2b8\uc5d0 \uc788\ub294 \ubaa8\ub4e0 \uc2dc\ud2b8\ub97c \ubc30\uc5f4\ub85c \ubc18\ud658\ud569\ub2c8\ub2e4. \uc774 \ubc30\uc5f4\uc758 \uc21c\uc11c\ub294 \uc2dc\ud2b8\uac00 \uc0dd\uc131\ub41c \uc21c\uc11c<\/span><\/strong>\uc5d0 \uc758\ud574 \uc815\ud574\uc9d1\ub2c8\ub2e4. \uc608\ub97c \ub4e4\uc5b4, getSheets()[0]<\/mark><\/strong><\/code>\uc740 \uc2a4\ud504\ub808\ub4dc\uc2dc\ud2b8\uc5d0\uc11c \uccab \ubc88\uc9f8\ub85c \ub9cc\ub4e4\uc5b4\uc9c4 \uc2dc\ud2b8<\/strong>\ub97c \uc758\ubbf8\ud558\uace0, getSheets()[1]<\/strong><\/mark><\/code>\ub294 \ub450 \ubc88\uc9f8\ub85c \ub9cc\ub4e4\uc5b4\uc9c4 \uc2dc\ud2b8<\/strong>\ub97c \uc758\ubbf8\ud569\ub2c8\ub2e4. \ubc30\uc5f4\uc758 \uccab \ubc88\uc9f8 \uc694\uc18c\ub294 \uc778\ub371\uc2a4\uac00 0\ubd80\ud130 \uc21c\ucc28\uc801\uc73c\ub85c \uc99d\uac00\ud558\uae30 \ub54c\ubb38\uc5d0 \ub450 \ubc88\uc9f8\ub85c \uc0dd\uc131\ub41c \u2018\uace0\uac1d \ubaa9\ub85d<\/strong>\u2019\uc2dc\ud2b8\ub97c [1]<\/strong>\ub85c \ud45c\uae30\ud569\ub2c8\ub2e4.<\/p>\n\n\n\n
        \n
      1. \u2018\uc2e0\uaddc \uace0\uac1d \ucd94\uac00<\/strong>\u2019 \uc2dc\ud2b8\uc5d0\uc11c \uace0\uac1d\uc758 \uc815\ubcf4\ub97c \uac00\uc838\uc624\uae30 \uc704\ud574 getRange('C3:C6')<\/strong><\/mark><\/code>\uc744 \uc0ac\uc6a9\ud558\uc5ec \ud574\ub2f9 \ubc94\uc704\uc758 \uac12\uc744 \uac00\uc838\uc635\ub2c8\ub2e4.<\/li>\n\n\n\n
      2. \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
      3. \ub450 \ubc88\uc9f8 \uc2dc\ud2b8\uc5d0\uc11c \uc911\ubcf5\ub41c \uc804\ud654\ubc88\ud638\ub97c \uac80\uc0ac\ud558\uae30 \uc704\ud574 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\uc73c\ub85c \ud45c\uc2dc\ud569\ub2c8\ub2e4. \uc774 \ubd80\ubd84\uc5d0\uc11c\ub3c4 forEach<\/mark><\/strong><\/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
      4. \uc911\ubcf5\ub41c \uc5f0\ub77d\ucc98\uac00 \uc5c6\uc744 \uacbd\uc6b0, \uace0\uac1d \uc815\ubcf4\ub97c \u2018\uace0\uac1d \ubaa9\ub85d<\/strong>\u2019 \uc2dc\ud2b8\uc758 \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
      5. \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
        \uc774 \ucf54\ub4dc\uc5d0\uc11c \uc720\uc758\ud560 \uc810\uc740 getSheets()[1]<\/strong><\/mark><\/code> \ub97c \ud1b5\ud574\uc11c \u2018\uace0\uac1d<\/strong> \ubaa9\ub85d<\/strong>\u2019\uc2dc\ud2b8\ub97c \ubd88\ub7ec\uc628\ub2e4\ub294 \uac83\uc785\ub2c8\ub2e4. \uc774\ub807\uac8c \uac80\uc0c9\ud560 \uc2dc\ud2b8\ub97c \ud55c\uc815\ud574\ub450\uba74 \ubd88\ud544\uc694\ud558\uac8c \ub2e4\ub978 \uc2dc\ud2b8\uc5d0\uc11c\ub3c4 \uac80\uc0c9\ud558\ub294 \uc77c\uc740 \uc5c6\uc5b4\uc9c0\uac8c \ub429\ub2c8\ub2e4. \uc2a4\ud06c\ub9bd\ud2b8\ub97c \ud560\ub2f9\ud558\uace0 \uc2e4\ud589\ud574\ubcf4\uaca0\uc2b5\ub2c8\ub2e4. \u2018\uc785\ub825\ud558\uae30<\/strong>\u2019 \ubc84\ud2bc\uc744 \uc6b0 \ud074\ub9ad \ud55c \ub4a4\uc5d0 \uc810 3\uac1c \ubc84\ud2bc\uc744 \ub204\ub974\uace0 \u2018\uc2a4\ud06c\ub9bd\ud2b8 \ud560\ub2f9<\/strong>\u2019 \ubc84\ud2bc\uc744 \ud074\ub9ad\ud569\ub2c8\ub2e4.

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

        <\/p>\n\n\n\n
        \ubbf8\ub9ac \uc791\uc131\ud55c \uc2a4\ud06c\ub9bd\ud2b8\uc758 \ud568\uc218 \uc774\ub984\uc744 \uc0bd\uc785 \ud6c4 \u2018\ud655\uc778\u2019 \ubc84\ud2bc\uc744 \ud074\ub9ad\ud569\ub2c8\ub2e4.

        <\/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<\/div>\n\n\n

        <\/p>\n\n\n\n
        \uc2a4\ud06c\ub9bd\ud2b8 \ud560\ub2f9\uc774 \uc644\ub8cc\ub418\uc5c8\uc2b5\ub2c8\ub2e4. \uc774\uc81c \uc2a4\ud06c\ub9bd\ud2b8\ub97c \ud55c\ubc88 \uc2e4\ud589\ud574\ubcfc\uae4c\uc694?

        <\/p>\n\n\n
        \n
        \"\"
        \uace0\uac1d \uc815\ubcf4 \ucd94\uac00 \uc644\ub8cc<\/figcaption><\/figure>\n<\/div>\n\n\n

        <\/p>\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. \u2018\uace0\uac1d \ubaa9\ub85d\u2019 \uc2dc\ud2b8\ub85c \uc774\ub3d9\ud574\uc11c \ub370\uc774\ud130 \uc0bd\uc785\uc774 \uc798 \ub418\uc5c8\ub294\uc9c0 \ud655\uc778\ud574\ubcf4\uaca0\uc2b5\ub2c8\ub2e4.

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

        \u2018\uace0\uac1d \ubaa9\ub85d<\/strong>\u2019\uc5d0 \uc815\uc0c1\uc801\uc73c\ub85c \uc800\uc7a5\ub418\uc5c8\ub124\uc694. \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
        \"\"
        \uc5f0\ub77d\ucc98\ub97c \uc81c\uc678\ud55c \uc815\ubcf4\ub97c \ubaa8\ub450 \uc218\uc815<\/figcaption><\/figure>\n<\/div>\n\n\n

        <\/p>\n\n\n\n
        \u2018\uc785\ub825\ud558\uae30<\/strong>\u2019 \ubc84\ud2bc\uc744 \ud074\ub9ad\ud574\ubcfc\uae4c\uc694?

        <\/p>\n\n\n
        \n
        \"\"
        \uc5f0\ub77d\ucc98\uac00 \uc911\ubcf5\ub418\uc5b4 \uc911\ubcf5 \uc54c\ub9bc\ucc3d\uc774 \ub744\uc6cc\uc9c4 \ud654\uba74<\/figcaption><\/figure>\n<\/div>\n\n\n

        <\/p>\n\n\n\n
        \uc911\ubcf5\ub41c \uc5f0\ub77d\ucc98\ub97c \ud655\uc778\ud558\uc600\uace0 \uc911\ubcf5\ub41c \uc140\uc758 \uc704\uce58\ub97c \uc804\ub2ec\ud558\uace0 \uc788\uc2b5\ub2c8\ub2e4. \ub85c\uadf8\ub3c4 \ub0a8\uc544\uc788\ub294 \uac83\uc744 \ud655\uc778\ud560 \uc218 \uc788\uc2b5\ub2c8\ub2e4.

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

        \uc2e4\ubb34\uc5d0\uc11c\ub294 \uc2a4\ud504\ub808\ub4dc\uc2dc\ud2b8\uac00 \ub354 \ubcf5\uc7a1\ud55c \uacbd\uc6b0\uac00 \ub9ce\uc2b5\ub2c8\ub2e4. \uc774 \ub54c\uc5d0 \ud2b9\uc815 \uc815\ubcf4\ub97c \uc2a4\ud504\ub808\ub4dc\uc2dc\ud2b8 \uc804\uccb4\uc5d0\uc11c \uac80\uc0c9\uc744 \ud558\uac8c \ub418\uba74 \uc758\ub3c4\ud55c \uac83\uacfc\ub294 \ub2e4\ub978 \uacf3\uc5d0\uc11c \uc815\ubcf4\uac00 \uac80\uc0c9\uc774 \ub420 \uc218\ub3c4 \uc788\uace0, \uac80\uc0c9 \uc2dc\uac04\u23f0\uc774 \uae38\uc5b4\uc9c0\uac8c \ub418\ub294 \uacbd\uc6b0\ub3c4 \uc788\uc2b5\ub2c8\ub2e4. \ud558\uc9c0\ub9cc \uc9c0\uae08\ucc98\ub7fc \uac80\uc0c9\ud558\ub294 \ubc94\uc704\ub97c \ud55c\uc815\ud558\uac8c \ub418\uba74 \uc815\ud655\ud55c \uc815\ubcf4\ub97c \ube60\ub974\uac8c \ucc3e\ub294\ub370 \ub3c4\uc6c0\uc774 \ub429\ub2c8\ub2e4.<\/mark><\/strong> \ud83d\udc4d\ud83c\udffb<\/p>\n\n\n\n
        Sheet \ud074\ub798\uc2a4\uc5d0\uc11c createTextFinder\ub97c \uc0ac\uc6a9\ud574\ubcf4\uc558\uc2b5\ub2c8\ub2e4. \ub9cc\uc57d \uac80\uc0c9\uc758 \ubc94\uc704\ub97c \ub354 \uc904\uc5ec\uc11c, \ud558\ub098\uc758 \uc2dc\ud2b8\uac00 \uc544\ub2c8\ub77c \uc2dc\ud2b8 \uc548\uc758 \ud2b9\uc815 \ubc94\uc704\uc5d0\uc11c \ud14d\uc2a4\ud2b8\ub97c \uac80\uc0c9\ud574\uc57c \ud55c\ub2e4\uba74 \uc5b4\ub5a8\uae4c\uc694?<\/p>\n\n\n\n
        \uc774 \uacbd\uc6b0\uc5d0\ub294 \ud14d\uc2a4\ud2b8\ub97c \ucc3e\ub294 \ubc94\uc704\ub97c \ub354 \uc138\ubd80\uc801\uc73c\ub85c \uc124\uc815\uc744 \ud574\uc57c\ud558\uae30 \ub54c\ubb38\uc5d0 Range \ud074\ub798\uc2a4\uc5d0\uc11c createTextFinder()\ub97c \uc0ac\uc6a9\ud558\ub294 \uac83\uc774 \ud558\ub098\uc758 \ubc29\ubc95\uc774 \ub420 \uc218 \uc788\uc2b5\ub2c8\ub2e4. \ub2e4\uc74c \ud3ec\uc2a4\ud2b8\uc5d0\uc11c\ub294 Range \ud074\ub798\uc2a4\uc5d0\uc11c createTextFinder\ub97c \uc0ac\uc6a9\ud574\ubcf4\uace0, textFinder\uc5d0\uc11c \uc81c\uacf5\ud558\ub294 \ub2e4\uc591\ud55c \uba54\uc18c\ub4dc\uc758 \uae30\ub2a5\uc744 \uc18c\uac1c\ud558\uaca0\uc2b5\ub2c8\ub2e4.<\/p>\n\n\n\n
        Range class\uc758 createTextFinder&TextFinder class\uc758 \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":"
        \uc694\uc57d Sheet \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 Sheet \ud074\ub798\uc2a4\uc5d0\uc11c \ud2b9\uc815 \ud14d\uc2a4\ud2b8\ub97c \ucc3e\ub294 \ubc29\ubc95\uc744 \uc18c\uac1c\ud569\ub2c8\ub2e4. Spreadsheet \ud074\ub798\uc2a4\uc5d0\uc11c createTextFinder()\uba54\uc18c\ub4dc\ub97c \uc0ac\uc6a9\ud558\ub294 \ubc29\ubc95\uc744 \uc18c\uac1c\ud558\ub294 \uc774\uc804 \ud3ec\uc2a4\ud2b8\ub85c\ubd80\ud130 \ub0b4\uc6a9\uc774 \uc774\uc5b4\uc9d1\ub2c8\ub2e4. Spreadsheet class\uc758 createTextFinder() 2. Sheet \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 \ub54c \uc0ac\uc6a9\ud560 \uc218 \uc788\ub294 \uba54\uc18c\ub4dc\ub85c, \uc2a4\ud504\ub808\ub4dc\uc2dc\ud2b8…<\/p>\n","protected":false},"author":6,"featured_media":16095,"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-16084","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\/16084","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=16084"}],"version-history":[{"count":77,"href":"https:\/\/www.autooffice.co.kr\/en\/wp-json\/wp\/v2\/posts\/16084\/revisions"}],"predecessor-version":[{"id":17182,"href":"https:\/\/www.autooffice.co.kr\/en\/wp-json\/wp\/v2\/posts\/16084\/revisions\/17182"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/www.autooffice.co.kr\/en\/wp-json\/wp\/v2\/media\/16095"}],"wp:attachment":[{"href":"https:\/\/www.autooffice.co.kr\/en\/wp-json\/wp\/v2\/media?parent=16084"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.autooffice.co.kr\/en\/wp-json\/wp\/v2\/categories?post=16084"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.autooffice.co.kr\/en\/wp-json\/wp\/v2\/tags?post=16084"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}