使用Python格式化Google Sheets单元格遇AttributeError的解决咨询

Hey there! That AttributeError you're seeing happens because the standard gspread library doesn't include a built-in format method for worksheets—you need an official extension called gspread-formatting to handle cell formatting. Let's walk through how to get this working, plus an alternative if you don't want to add another dependency.

Step 1: Install the gspread-formatting library #

First, install the extension via pip:

pip install gspread-formatting

Step 2: Update your code to use the formatting tools #

Import the necessary classes from the extension, then use format_cell_range to apply bold formatting to your cells. Here's your modified code:

import gspread
from gspread_formatting import format_cell_range, CellFormat, TextFormat

# Set up access to Google Sheets
gc = gspread.authorize(GoogleCredentials.get_application_default())
wb = gc.open_by_url('https://docs.google.com/spreadsheets/d/ ... ')
sheet = wb.worksheet('Sheet1')

# Store data into variables
title = "Flash Drive"
price = 20.00
rating = 4.6

# Send data to specific cells in Google Sheets (Cells: J8, K8, L8)
sheet.update_cell(8, 9, title)
sheet.update_cell(8, 10, price)
sheet.update_cell(8, 11, rating)

# Make J8:L8 bold using gspread-formatting
bold_text_format = CellFormat(textFormat=TextFormat(bold=True))
format_cell_range(sheet, 'J8:L8', bold_text_format)

Alternative: Use Google Sheets API batch updates (no extra library) #

If you'd rather not install another package, you can directly call the Google Sheets API's batch update endpoint to apply formatting. Note that this uses 0-based indexing (unlike gspread's update_cell which uses 1-based), so you'll need to adjust your row/column numbers:

import gspread

# Set up access to Google Sheets (same as before)
gc = gspread.authorize(GoogleCredentials.get_application_default())
wb = gc.open_by_url('https://docs.google.com/spreadsheets/d/ ... ')
sheet = wb.worksheet('Sheet1')

# Store data and update cells (same as before)
title = "Flash Drive"
price = 20.00
rating = 4.6
sheet.update_cell(8, 9, title)
sheet.update_cell(8, 10, price)
sheet.update_cell(8, 11, rating)

# Create a batch update request to set bold formatting
format_requests = [
    {
        "repeatCell": {
            "range": {
                "sheetId": sheet.id,
                "startRowIndex": 7,  # J8 is row 8 in 1-based, so 7 in 0-based
                "endRowIndex": 8,
                "startColumnIndex": 9,  # J column is 9 in 0-based (A=0)
                "endColumnIndex": 12
            },
            "cell": {
                "userEnteredFormat": {
                    "textFormat": {
                        "bold": True
                    }
                }
            },
            "fields": "userEnteredFormat.textFormat.bold"
        }
    }
]

# Execute the batch update
wb.batch_update(format_requests)

Either approach will let you automatically apply bold formatting to your cells after writing data. Just make sure your service account has edit permissions for the sheet (which it should, since you can already write data).

内容的提问来源于stack exchange，提问作者RCube123