如何迭代Google Sheet中的所有行

function iterateRows() {
  var sheet = SpreadsheetApp.getActiveSpreadsheet().getActiveSheet();
  var dataRange = sheet.getDataRange();
  var values = dataRange.getValues();
  
  for (var i = 0; i < values.length; i++) {
    var row = values[i];
    // 对每一行进行操作，例如打印每一行的数据
    Logger.log(row);
  }
}

import gspread
from oauth2client.service_account import ServiceAccountCredentials

# 设置API凭证
scope = ['https://spreadsheets.google.com/feeds', 'https://www.googleapis.com/auth/drive']
credentials = ServiceAccountCredentials.from_json_keyfile_name('credentials.json', scope)
client = gspread.authorize(credentials)

# 打开Google Sheet
sheet = client.open('Sheet名称').sheet1

# 获取所有行数据
rows = sheet.get_all_records()

# 迭代所有行
for row in rows:
    # 对每一行进行操作，例如打印每一行的数据
    print(row)