时间戳

首页 > 解决方案 > “$service->spreadsheets->create($requestBody)”创建后的文件在哪里

laravel-5 - “$service->spreadsheets->create($requestBody)”创建后的文件在哪里

问题描述

非常感谢您阅读本文，它很长！

  1. 我运行我的功能：

    public function createSpreadSheet()
{
        $client = $this->getClient();
        $service = new \Google_Service_Sheets($client);
        // TODO: Assign values to desired properties of `requestBody`:
        $requestBody = new \Google_Service_Sheets_Spreadsheet();
        $response = $service->spreadsheets->create($requestBody);
        echo '<pre>', var_export($response, true), '</pre>', "\n";
}

  2. 我得到了一个结果：

    Google_Service_Sheets_Spreadsheet::__set_state(array(
'collection_key' => 'sheets',
'developerMetadataType' => 'Google_Service_Sheets_DeveloperMetadata',
'developerMetadataDataType' => 'array',
'namedRangesType' => 'Google_Service_Sheets_NamedRange',
'namedRangesDataType' => 'array',
'propertiesType' => 'Google_Service_Sheets_SpreadsheetProperties',
'propertiesDataType' => '',
'sheetsType' => 'Google_Service_Sheets_Sheet',
'sheetsDataType' => 'array',
'spreadsheetId' => '1QlBQo_YHQpiiMBWn6b6wSMVWkiFRx4grJhPParXUUSU',
'spreadsheetUrl' => 'https://docs.google.com/spreadsheets/d/1QlBQo_YHQpiiMBWn6b6wSMVWkiFRx4grJhPParXUUSU/edit',
'internal_gapi_mappings' => 
array (
),
modelData' => 
array (
),
'processed' => 
array (
),
'properties' => 
Google_Service_Sheets_SpreadsheetProperties::__set_state(array(
'autoRecalc' => 'ON_CHANGE',
'defaultFormatType' => 'Google_Service_Sheets_CellFormat',
'defaultFormatDataType' => '',
'iterativeCalculationSettingsType' => 'Google_Service_Sheets_IterativeCalculationSettings',
'iterativeCalculationSettingsDataType' => '',
'locale' => 'en_US',
'timeZone' => 'Etc/GMT',
'title' => 'Untitled spreadsheet',
'internal_gapi_mappings' => 
array (
),
'modelData' => 
array (
),
'processed' => 
array (
),
'defaultFormat' => 
Google_Service_Sheets_CellFormat::__set_state(array(
'backgroundColorType' => 'Google_Service_Sheets_Color',
'backgroundColorDataType' => '',
'bordersType' => 'Google_Service_Sheets_Borders',
'bordersDataType' => '',
'horizontalAlignment' => NULL,
'hyperlinkDisplayType' => NULL,
'numberFormatType' => 'Google_Service_Sheets_NumberFormat',
'numberFormatDataType' => '',
.........
.........
))

  3. 我访问了它返回的链接：' https://docs.google.com/spreadsheets/d/1QlBQo_YHQpiiMBWn6b6wSMVWkiFRx4grJhPParXUUSU/edit '

  4. 它给了我这个“请求访问”页面，然后我按下请求访问

  5. 我打开我的电子邮件并收到以下信息：您的邮件未发送到 xxxxxx@xxxxxxxx.iam.gserviceaccount.com，因为找不到域 admanager-1x3x71x4x27x4.iam.gserviceaccount.com。检查拼写错误或不必要的空格，然后重试。

  6. 有什么问题吗？我该怎么办？我只想打开文件并检查它的位置。

非常感谢！

标签： laravel-5google-sheets-apigoogle-api-php-client

解决方案

推荐阅读