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

<?php

// 确保你已经正确设置了 Google API 客户端
$service = new Google_Service_Sheets($client);

$title = 'My New Spreadsheet';

$spreadsheet = new Google_Service_Sheets_Spreadsheet([
    'properties' => [
        'title' => $title,
    ]
]);

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

// 电子表格的 ID 可以通过 $spreadsheet->spreadsheetId 访问
echo "电子表格ID: " . $spreadsheet->spreadsheetId . "\n";

?>

<?php

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

?>

<?php

$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'; // 确保你已经安装了 Google API 客户端库

// 设置你的 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'); // 替换为你的 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 {
        // 获取授权 URL
        $authUrl = $client->createAuthUrl();
        printf("请访问以下 URL 并授权应用程序:\n%s\n", $authUrl);
        fwrite(STDOUT, "输入授权码: ");
        $authCode = trim(fgets(STDIN));

        // 交换授权码以获取访问令牌
        $accessToken = $client->fetchAccessTokenWithAuthCode($authCode);
        $client->setAccessToken($accessToken);

        // 检查是否出现错误
        if (array_key_exists('error', $accessToken)) {
            throw new Exception(join(', ', $accessToken));
        }

        // 将凭据保存到磁盘以供下次使用
        if (!file_exists(dirname($tokenPath))) {
            mkdir(dirname($tokenPath), 0700, true);
        }
        file_put_contents($tokenPath, json_encode($client->getAccessToken()));
    }
}

// 创建 Google Sheets 和 Drive 服务对象
$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);

// 设置共享权限
$newPermission = new Google_Service_Drive_Permission();
$newPermission->setType('anyone');
$newPermission->setRole('reader');  // 或者 'writer' 如果你想允许编辑
$drive->permissions->create($spreadsheet->spreadsheetId, $newPermission);

echo "电子表格已成功创建并设置为可链接访问。\n";

?>