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
Post a Comment