{"id":15595,"date":"2023-08-16T09:00:00","date_gmt":"2023-08-16T00:00:00","guid":{"rendered":"https:\/\/www.autooffice.co.kr\/blog\/2023\/08\/16\/deleting-labels-in-apps-script-2\/"},"modified":"2025-09-15T17:20:32","modified_gmt":"2025-09-15T08:20:32","slug":"deleting-labels-in-apps-script-2","status":"publish","type":"post","link":"https:\/\/www.autooffice.co.kr\/en\/blog\/2023\/08\/16\/deleting-labels-in-apps-script-2\/","title":{"rendered":"Get sliced range of elements of 2d array with Apps Script"},"content":{"rendered":"

This post is a corrected post after AI explains the code included in the book “Google Apps Script 101: Building Work Automation For Free”<\/a>. Added a strikethrough<\/s> when editing what AI has written, and added color<\/span> when edited by author<\/p>\n

Table of Contents<\/h2>\n
    \n
  1. Summary<\/a><\/li>\n
  2. Code<\/a><\/li>\n
  3. Code Explanation<\/a><\/li>\n
  4. Example<\/a><\/li>\n
  5. AI Prompt<\/a><\/li>\n<\/ol>\n

    Summary<\/h2>\n

    In this blog post, we will explore how to delete labels in Apps Script. We will learn how to access a specific sheet in a Google Spreadsheet, get the data range, slice the data to select a specific range of rows, and log the sliced data.<\/p>\n

    Code<\/h2>\n
    function getSlicedData() {\n  const SS = SpreadsheetApp.getActiveSpreadsheet();\n  const T_SHEET6 = SS.getSheetByName('Sheet6');\n\n  const data = T_SHEET6.getDataRange().getValues();\n  let dataSlice = data.slice(1, 3);\n  Logger.log(dataSlice);\n}<\/code><\/pre>\n
    Code Explanation<\/h2>\n
    The code declares a function named getSlicedData<\/code>. It retrieves the active spreadsheet using SpreadsheetApp.getActiveSpreadsheet()<\/code> and assigns it to the SS<\/code> variable.<\/p>\n
    The code then uses SS.getSheetByName('Sheet6')<\/code> to access a specific sheet named ‘Sheet6’ and assigns it to the T_SHEET6<\/code> variable.<\/p>\n
    The getDataRange()<\/code> method is used to retrieve the data range of the sheet, and the getValues()<\/code> method is used to get the values of the data range.<\/p>\n
    A portion of the data is sliced using the slice()<\/code> method, specifying the start and end indexes of the desired range of rows. The sliced data is stored in the dataSlice<\/code> variable.<\/p>\n
    In this case, the first number 1 represents index 1 of the array, including index 1. The second number 3 means index 3, but does not include index 3, but includes up to 2. <\/span><\/p>\n
    Finally, the sliced data is logged using Logger.log(dataSlice)<\/code>.<\/p>\n
    Example<\/h2>\n
    Suppose you have a Google Spreadsheet with a sheet named ‘Sheet6’ that contains the following data:<\/p>\n\n\n\n\n\n\n\n
    Column A<\/th>\nColumn B<\/th>\nColumn C<\/th>\n<\/tr>\n
    Label 1<\/td>\nLabel 2<\/td>\nLabel 3<\/td>\n<\/tr>\n
    Data 1<\/td>\nData 2<\/td>\nData 3<\/td>\n<\/tr>\n
    Data 4<\/td>\nData 5<\/td>\nData 6<\/td>\n<\/tr>\n
    Data 7<\/td>\nData 8<\/td>\nData 9<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n
    If the above getSlicedData<\/code> function is executed, the remaining data with labels removed will be written to the log as follows:<\/p>\n\n\n\n\n
    Data 1<\/td>\nData 2<\/td>\nData 3<\/td>\n<\/tr>\n
    Data 4<\/td>\nData 5<\/td>\nData 6<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n
    AI Prompt<\/h2>\n
    Get a range of data from a specific sheet in Google Sheets, select a range of rows using slice method <\/span>, and write the selected data to a log.<\/p>\n","protected":false},"excerpt":{"rendered":"
    In this blog post, we will explore how to delete labels in Apps Script. We will learn how to access a specific sheet in a Google Spreadsheet, get the data range, slice the data to select a specific range of rows, and log the sliced data.<\/p>\n","protected":false},"author":1,"featured_media":15606,"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":[512,69,540,7],"class_list":["post-15595","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-spreadsheet","category-apps-script","tag-ai-assisted","tag-script","tag-slice","tag-spreadsheet"],"translation":{"provider":"WPGlobus","version":"3.0.2","language":"en","enabled_languages":["ko","en"],"languages":{"ko":{"title":true,"content":true,"excerpt":true},"en":{"title":true,"content":true,"excerpt":true}}},"aioseo_notices":[],"_links":{"self":[{"href":"https:\/\/www.autooffice.co.kr\/en\/wp-json\/wp\/v2\/posts\/15595","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\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/www.autooffice.co.kr\/en\/wp-json\/wp\/v2\/comments?post=15595"}],"version-history":[{"count":4,"href":"https:\/\/www.autooffice.co.kr\/en\/wp-json\/wp\/v2\/posts\/15595\/revisions"}],"predecessor-version":[{"id":17166,"href":"https:\/\/www.autooffice.co.kr\/en\/wp-json\/wp\/v2\/posts\/15595\/revisions\/17166"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/www.autooffice.co.kr\/en\/wp-json\/wp\/v2\/media\/15606"}],"wp:attachment":[{"href":"https:\/\/www.autooffice.co.kr\/en\/wp-json\/wp\/v2\/media?parent=15595"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.autooffice.co.kr\/en\/wp-json\/wp\/v2\/categories?post=15595"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.autooffice.co.kr\/en\/wp-json\/wp\/v2\/tags?post=15595"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}