Hi,I am trying to make a script That works with Google sheets using Python.
When retrieving data the default is by rows.How do I change this to Columns.
This is what works:
result =
service.spreadsheets().values().get(spreadsheetId=BuildSheet_ID,range=RANGE_NAME).execute()
_rawdata = result.get('values', [])
--> Results come with a list of list of rows
I want a list which is a list of columns:
I have tried this with no success:
result =
service.spreadsheets().values().get(spreadsheetId=BuildSheet_ID,range=RANGE_NAME,major_Dimesion='COLUMNS').execute()
result =
service.spreadsheets().values().get(spreadsheetId=BuildSheet_ID,range=RANGE_NAME,major_Dimesion=COLUMNS).execute()
Any help would be great. Thank you.
--
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.
