Adding data to Google spreadsheet while creating using PHP -


i creating file on fly in google drive using php , google drive api. api allows add data while creating , know can use spreadsheet api add data later, want add data on fly , here code

$service = new google_service_drive($client); $file = new google_service_drive_drivefile(); $file->settitle( 'hello world!' ); $file->setdescription('a test document'); $data = "header1,header2,header2,"; // csv $file->setmimetype( 'application/vnd.google-apps.spreadsheet' );     $file = $service->files->insert( $file , array(   'data' => $data,   'convert' => true, )); 

here code, creates file title , description doesn't add headers, missing ?

first setup php quickstart sheets api. includes authentication , authorization processes need. checkout guide on writing on sheets api.

put https://sheets.googleapis.com/v4/spreadsheets/spreadsheet_id/values/range?valueinputoption=valueinputoption 

when wrote on spreadsheet, used xhr requests in js. it's in php, might easier. xhr request body looked like:

         var params = {            "range":"sheet1!a1",            "majordimension": "rows",            "values": [            ["this test"]           ],          } 

just take note of spreadsheetid , sheetid. can find sheetid of open sheet in spreadsheet url.


Comments