Chilkat HOME .NET Core C# Android™ AutoIt C C# C++ Chilkat2-Python CkPython Classic ASP DataFlex Delphi ActiveX Delphi DLL Go Java Lianja Mono C# Node.js Objective-C PHP ActiveX PHP Extension Perl PowerBuilder PowerShell PureBasic Ruby SQL Server Swift 2 Swift 3,4,5... Tcl Unicode C Unicode C++ VB.NET VBScript Visual Basic 6.0 Visual FoxPro Xojo Plugin
(PHP ActiveX) Google Sheets - Create a New SpreadsheetDemonstrates how to create a new and empty spreadsheet.
<?php // This example requires the Chilkat API to have been previously unlocked. // See Global Unlock Sample for sample code. // This example uses a previously obtained access token having permission for the // Google Sheets scope. // In this example, Get Google Sheets OAuth2 Access Token, the access // token was saved to a JSON file. This example fetches the access token from the file.. // For versions of Chilkat < 10.0.0, use new COM('Chilkat_9_5_0.Chilkat.JsonObject') $jsonToken = new COM("Chilkat.JsonObject"); $success = $jsonToken->LoadFile('qa_data/tokens/googleSheets.json'); if ($jsonToken->HasMember('access_token') == 0) { print 'No access token found.' . "\n"; exit; } // For versions of Chilkat < 10.0.0, use new COM('Chilkat_9_5_0.Chilkat.Http') $http = new COM("Chilkat.Http"); $http->AuthToken = $jsonToken->stringOf('access_token'); // Create the following JSON: // The JSON code can be generated using this online tool: Generate JSON create code // { // "sheets": [ // { // "properties": { // "title": "Sample Tab" // } // } // ], // "properties": { // "title": "Create Spreadsheet using Sheets API v4" // } // } // This code generates the above JSON: // For versions of Chilkat < 10.0.0, use new COM('Chilkat_9_5_0.Chilkat.JsonObject') $json = new COM("Chilkat.JsonObject"); $json->UpdateString('sheets[0].properties.title','Sample Tab'); $json->UpdateString('properties.title','Create Spreadsheet using Sheets API v4'); // Send the POST to create the new Google spreadsheet. // resp is a Chilkat.HttpResponse $resp = $http->PostJson3('https://sheets.googleapis.com/v4/spreadsheets','application/json',$json); if ($http->LastMethodSuccess != 1) { print $http->LastErrorText . "\n"; exit; } print 'response status code = ' . $resp->StatusCode . "\n"; print 'response JSON:' . "\n"; $json->Load($resp->BodyStr); $json->EmitCompact = 0; print $json->emit() . "\n"; // A sample response is shown below. // To generate the parsing source code for a JSON response, paste // the JSON into this online tool: Generate JSON parsing code // { // "spreadsheetId": "1ueEQu3WDBkIAOUhzLnY4zr6JO5SrJx0dQ-YkQlUVYD0", // "properties": { // "title": "Create Spreadsheet using Sheets API v4", // "locale": "en_US", // "autoRecalc": "ON_CHANGE", // "timeZone": "Etc/GMT", // "defaultFormat": { // "backgroundColor": { // "red": 1, // "green": 1, // "blue": 1 // }, // "padding": { // "top": 2, // "right": 3, // "bottom": 2, // "left": 3 // }, // "verticalAlignment": "BOTTOM", // "wrapStrategy": "OVERFLOW_CELL", // "textFormat": { // "foregroundColor": {}, // "fontFamily": "arial,sans,sans-serif", // "fontSize": 10, // "bold": false, // "italic": false, // "strikethrough": false, // "underline": false // } // } // }, // "sheets": [ // { // "properties": { // "sheetId": 1629642057, // "title": "Sample Tab", // "index": 0, // "sheetType": "GRID", // "gridProperties": { // "rowCount": 1000, // "columnCount": 26 // } // } // } // ], // "spreadsheetUrl": "https://docs.google.com/spreadsheets/d/1ueEQu3WDBkIAOUhzLnY4zr6JO5SrJx0dQ-YkQlUVYD0/edit" // } // $spreadsheetId = $json->stringOf('spreadsheetId'); $propertiesTitle = $json->stringOf('properties.title'); $propertiesLocale = $json->stringOf('properties.locale'); $propertiesAutoRecalc = $json->stringOf('properties.autoRecalc'); $propertiesTimeZone = $json->stringOf('properties.timeZone'); $propertiesDefaultFormatBackgroundColorRed = $json->IntOf('properties.defaultFormat.backgroundColor.red'); $propertiesDefaultFormatBackgroundColorGreen = $json->IntOf('properties.defaultFormat.backgroundColor.green'); $propertiesDefaultFormatBackgroundColorBlue = $json->IntOf('properties.defaultFormat.backgroundColor.blue'); $propertiesDefaultFormatPaddingTop = $json->IntOf('properties.defaultFormat.padding.top'); $propertiesDefaultFormatPaddingRight = $json->IntOf('properties.defaultFormat.padding.right'); $propertiesDefaultFormatPaddingBottom = $json->IntOf('properties.defaultFormat.padding.bottom'); $propertiesDefaultFormatPaddingLeft = $json->IntOf('properties.defaultFormat.padding.left'); $propertiesDefaultFormatVerticalAlignment = $json->stringOf('properties.defaultFormat.verticalAlignment'); $propertiesDefaultFormatWrapStrategy = $json->stringOf('properties.defaultFormat.wrapStrategy'); $propertiesDefaultFormatTextFormatFontFamily = $json->stringOf('properties.defaultFormat.textFormat.fontFamily'); $propertiesDefaultFormatTextFormatFontSize = $json->IntOf('properties.defaultFormat.textFormat.fontSize'); $propertiesDefaultFormatTextFormatBold = $json->BoolOf('properties.defaultFormat.textFormat.bold'); $propertiesDefaultFormatTextFormatItalic = $json->BoolOf('properties.defaultFormat.textFormat.italic'); $propertiesDefaultFormatTextFormatStrikethrough = $json->BoolOf('properties.defaultFormat.textFormat.strikethrough'); $propertiesDefaultFormatTextFormatUnderline = $json->BoolOf('properties.defaultFormat.textFormat.underline'); $spreadsheetUrl = $json->stringOf('spreadsheetUrl'); $i = 0; $count_i = $json->SizeOfArray('sheets'); while (($i < $count_i)) { $json->I = $i; $propertiesSheetId = $json->IntOf('sheets[i].properties.sheetId'); $propertiesTitle = $json->stringOf('sheets[i].properties.title'); $propertiesIndex = $json->IntOf('sheets[i].properties.index'); $propertiesSheetType = $json->stringOf('sheets[i].properties.sheetType'); $propertiesGridPropertiesRowCount = $json->IntOf('sheets[i].properties.gridProperties.rowCount'); $propertiesGridPropertiesColumnCount = $json->IntOf('sheets[i].properties.gridProperties.columnCount'); $i = $i + 1; } ?> |
© 2000-2024 Chilkat Software, Inc. All Rights Reserved.