Hi Eric ,
In the response of batch update
Google_Service_Sheets_BatchUpdateSpreadsheetResponse::__set_state(array(
'collection_key' => 'replies',
'repliesType' => 'Google_Service_Sheets_Response',
'repliesDataType' => 'array',
'spreadsheetId' => 'id of my sheet',
'updatedSpreadsheetType' => 'Google_Service_Sheets_Spreadsheet',
'updatedSpreadsheetDataType' => '',
'internal_gapi_mappings' =>
array (
),
'modelData' =>
array (
'replies' =>
array (
0 =>
array (
),
),
),
'processed' =>
array (
),
))
After the update i need to get the dimensions of the current table rows -
there is a object class do i need to send it in a separate request or?
(2) Reason why i am asking about range is - lets say the rows will keep
getting added and the last rows i need to calculate sum or any other excel
custom forumla. after adding the row SUM (G2:G3) needs to be updated to
SUM (G2:G3) but instead what it does is creates a new row below
even if i manually place the sum() in the spreadsheet the data keeps
getting added after the sum row.which is quite confusing.
Can you point me in the right direction as i cant find any relevent example
for this.
Also - Spreadsheets.values it only works with spreadsheet id and is not for
internal sheets that has been added correct took me a while to figure that
out.
Hoping for a responce from your end.
Thanks
Ritesh
On Sunday, June 11, 2017 at 4:09:07 PM UTC+5:30, ritesh khare wrote:
>
> hey everyone ,
>
> I am dynamically creating sheets using php api.
>
> once the sheets are created - I am using Google_Service_Sheets batchupdate
> method to update the rows.
>
> Lets say i have a 2rows and 6 colums (1,2,hello , 4 , time , jojo)
>
> The rows are dynamic as i am appending data in realtime.
>
> I need what i can do to is keep the last row for calculation of Colums
> like sum total etc.
>
> Which class do i need to use to do that ?
>
> Ritesh
>
>
>
>
--
You received this message because you are subscribed to the Google Groups
"Google Spreadsheets API" group.
To unsubscribe from this group and stop receiving emails from it, send an email
to [email protected].
For more options, visit https://groups.google.com/d/optout.
