使用 Google Sheets API 创建可链接访问的电子表格

<?php

// 确保您已经正确设置了 Google API 客户端
// 并获得了授权。

// 创建一个新的电子表格
$spreadsheet = new Google_Service_Sheets_Spreadsheet([
    'properties' => [
        'title' => $title,
    ]
]);

// 使用 Sheets API 创建电子表格
$spreadsheet = $service->spreadsheets->create($spreadsheet, ['fields' => 'spreadsheetId']);

// 构造电子表格的 URL
$url = "https://docs.google.com/spreadsheets/d/" . $spreadsheet->spreadsheetId . "/edit";
printf("URL: %s\n", $url);

?>

<?php

// 确保您已经正确设置了 Google API 客户端
// 并获得了 Drive API 的授权。

// 使用 Drive API 设置权限
$drive = new Google_Service_Drive($client);
$newPermission = new Google_Service_Drive_Permission();
$newPermission->setType('anyone');
$newPermission->setRole('reader');  // 可以设置为 'writer' 如果需要编辑权限
$drive->permissions->create($spreadsheet->spreadsheetId, $newPermission);

?>

<?php

require_once 'vendor/autoload.php'; // 引入 Composer 自动加载器

// 配置 Google API 客户端 (请替换为您的凭据)
$client = new Google_Client();
$client->setApplicationName('Google Sheets API PHP Quickstart');
$client->setScopes(Google_Service_Sheets::SPREADSHEETS, Google_Service_Drive::DRIVE);
$client->setAuthConfig('path/to/your/credentials.json'); // 替换为您的凭据文件路径
$client->setAccessType('offline');
$client->setPrompt('consent');

// 获取授权令牌
$tokenPath = 'token.json';
if (file_exists($tokenPath)) {
    $accessToken = json_decode(file_get_contents($tokenPath), true);
    $client->setAccessToken($accessToken);
}

if ($client->isAccessTokenExpired()) {
    if ($client->getRefreshToken()) {
        $client->fetchAccessTokenWithRefreshToken($client->getRefreshToken());
    } else {
        // Request authorization from the user.
        $authUrl = $client->createAuthUrl();
        printf("Open the following link in your browser:\n%s\n", $authUrl);
        print 'Enter verification code: ';
        $authCode = trim(fgets(STDIN));

        // Exchange authorization code for an access token.
        $accessToken = $client->fetchAccessTokenWithAuthCode($authCode);
        $client->setAccessToken($accessToken);

        // Check to see if there was an error.
        if (array_key_exists('error', $accessToken)) {
            throw new Exception(join(', ', $accessToken));
        }
    }
    // Save the token to a file.
    if (!file_exists(dirname($tokenPath))) {
        mkdir(dirname($tokenPath), 0700, true);
    }
    file_put_contents($tokenPath, json_encode($client->getAccessToken()));
}


$service = new Google_Service_Sheets($client);
$drive = new Google_Service_Drive($client);

$title = 'My New Spreadsheet';

// 创建一个新的电子表格
$spreadsheet = new Google_Service_Sheets_Spreadsheet([
    'properties' => [
        'title' => $title,
    ]
]);

$spreadsheet = $service->spreadsheets->create($spreadsheet, ['fields' => 'spreadsheetId']);

// 构造电子表格的 URL
$url = "https://docs.google.com/spreadsheets/d/" . $spreadsheet->spreadsheetId . "/edit";
printf("URL: %s\n", $url);

// 使用 Drive API 设置权限
$newPermission = new Google_Service_Drive_Permission();
$newPermission->setType('anyone');
$newPermission->setRole('reader');  // 可以设置为 'writer' 如果需要编辑权限
$drive->permissions->create($spreadsheet->spreadsheetId, $newPermission);

echo "Spreadsheet shared publicly with read access.\n";

?>