谷歌表格应用编程接口v4与Python。自动调整不工作列的大小

import googleapiclient.discovery
from google.oauth2 import service_account

# 认证和授权
credentials = service_account.Credentials.from_service_account_file(
    'path/to/service_account_key.json',
    scopes=['https://www.googleapis.com/auth/spreadsheets']
)

# 创建谷歌表格服务
service = googleapiclient.discovery.build('sheets', 'v4', credentials=credentials)

# 定义表格ID和范围
spreadsheet_id = 'your_spreadsheet_id'
range_name = 'Sheet1!A1:Z'

# 获取表格内容
result = service.spreadsheets().values().get(
    spreadsheetId=spreadsheet_id,
    range=range_name
).execute()

values = result.get('values', [])

# 计算每列的最大宽度
column_widths = []
for row in values:
    for i, cell in enumerate(row):
        if i >= len(column_widths):
            column_widths.append(len(cell))
        else:
            column_widths[i] = max(column_widths[i], len(cell))

# 调整列宽
requests = []
for i, width in enumerate(column_widths):
    requests.append({
        'updateDimensionProperties': {
            'range': {
                'sheetId': 0,
                'dimension': 'COLUMNS',
                'startIndex': i,
                'endIndex': i + 1
            },
            'properties': {
                'pixelSize': width * 7  # 估算的列宽度，可以根据需要进行调整
            },
            'fields': 'pixelSize'
        }
    })

service.spreadsheets().batchUpdate(
    spreadsheetId=spreadsheet_id,
    body={'requests': requests}
).execute()