Java Google Sheets API获取备注/链接表单单元格

import com.google.api.services.sheets.v4.Sheets;
import com.google.api.services.sheets.v4.model.CellData;
import com.google.api.services.sheets.v4.model.ExtendedValue;
import com.google.api.services.sheets.v4.model.GridRange;
import com.google.api.services.sheets.v4.model.Request;
import com.google.api.services.sheets.v4.model.ValueRange;

import java.io.IOException;
import java.security.GeneralSecurityException;
import java.util.ArrayList;
import java.util.List;

public class GoogleSheetsExample {
    private static final String SPREADSHEET_ID = "your-spreadsheet-id";
    private static final String RANGE = "Sheet1!A1"; // 指定要获取备注的单元格范围

    public static void main(String[] args) throws IOException, GeneralSecurityException {
        // 创建Google Sheets服务
        Sheets sheetsService = GoogleSheetsService.createSheetsService();

        // 构建请求，获取指定单元格的备注
        List<Request> requests = new ArrayList<>();
        requests.add(new Request()
                .setGetCell(new com.google.api.services.sheets.v4.model.GetCellRequest()
                        .setFields("note")
                        .setRange(new GridRange()
                                .setSheetId(0)
                                .setStartRowIndex(0)
                                .setEndRowIndex(1)
                                .setStartColumnIndex(0)
                                .setEndColumnIndex(1)
                        )
                )
        );

        // 发送请求并获取响应
        sheetsService.spreadsheets().batchUpdate(SPREADSHEET_ID, new com.google.api.services.sheets.v4.model.BatchUpdateSpreadsheetRequest()
                .setRequests(requests))
                .execute();

        // 解析响应，获取备注内容
        ValueRange response = sheetsService.spreadsheets().values()
                .get(SPREADSHEET_ID, RANGE)
                .execute();
        List<List<Object>> values = response.getValues();
        if (values != null && !values.isEmpty()) {
            List<Object> row = values.get(0);
            if (row != null && !row.isEmpty()) {
                CellData cellData = (CellData) row.get(0);
                ExtendedValue extendedValue = cellData.getEffectiveValue();
                String note = extendedValue.getNote();
                System.out.println("备注内容：" + note);
            }
        }
    }
}