Snippets Collections
function myFunction() {
  let sheetData = SpreadsheetApp.getActiveSpreadsheet()
    .getSheetByName("Data")
    .getDataRange()
    .getValues();

  for (let i = 1; i < sheetData.length; i++) {
    Logger.log(sheetData[i][0]);
  }

  SpreadsheetApp.getActiveSpreadsheet()
    .getSheetByName("Data")
    .getDataRange()
    .setValues(sheetData);
}
star

Wed Mar 30 2022 23:45:13 GMT+0000 (Coordinated Universal Time) https://www.reddit.com/r/GoogleAppsScript/comments/hob5tn/issues_copying_csv_data_to_google_sheets/

#google #app #script

Save snippets that work with our extensions

Available in the Chrome Web Store Get Firefox Add-on Get VS Code extension