使用autoResizeDimensionsRequest的Java Google Sheets API示例

import com.google.api.services.sheets.v4.Sheets;
import com.google.api.services.sheets.v4.model.AutoResizeDimensionsRequest;
import com.google.api.services.sheets.v4.model.DimensionRange;
import com.google.api.services.sheets.v4.model.Request;

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

public class GoogleSheetsExample {

    public static void main(String[] args) {
        try {
            // 初始化Google Sheets服务
            Sheets sheetsService = GoogleSheetsService.getSheetsService();

            // 定义要调整大小的维度范围
            DimensionRange dimensionRange = new DimensionRange();
            dimensionRange.setSheetId(0); // 表格的ID，0表示第一个表格
            dimensionRange.setDimension("COLUMNS"); // 要调整的维度，这里是列
            dimensionRange.setStartIndex(0); // 起始索引，0表示第一列
            dimensionRange.setEndIndex(5); // 结束索引，5表示第六列

            // 创建调整大小请求
            AutoResizeDimensionsRequest resizeRequest = new AutoResizeDimensionsRequest();
            resizeRequest.setDimensions(dimensionRange);

            // 创建请求列表
            List<Request> requests = new ArrayList<>();
            Request request = new Request();
            request.setAutoResizeDimensions(resizeRequest);
            requests.add(request);

            // 执行请求
            sheetsService.spreadsheets().batchUpdate("spreadsheetId", new com.google.api.services.sheets.v4.model.BatchUpdateSpreadsheetRequest().setRequests(requests)).execute();
            
            System.out.println("列宽已调整成功！");
        } catch (IOException | GeneralSecurityException e) {
            e.printStackTrace();
        }
    }
}