Java Google Sheets API example with autoResizeDimensionsRequest -


i'm wondering how use autoresizedimensions in order set columns auto resize. following

list<request> requests = new arraylist<>();          autoresizedimensionsrequest autoresizedimensions = new autoresizedimensionsrequest();         requests.add(new request()                 .setautoresizedimensions(autoresizedimensions));         batchupdatespreadsheetrequest batchupdaterequest = new batchupdatespreadsheetrequest()                 .setrequests(requests);         sheets.spreadsheets().batchupdate(spreadsheetid, batchupdaterequest)                 .execute();

returns following error message

com.google.api.client.googleapis.json.googlejsonresponseexception: 400 bad request {   "code" : 400,   "errors" : [ {     "domain" : "global",     "message" : "invalid requests[1].autoresizedimensions: columns dimension supported",     "reason" : "badrequest"   } ],   "message" : "invalid requests[1].autoresizedimensions: columns dimension supported",   "status" : "invalid_argument"

i'm interested in setting specific width column. haven't found examples using java. if has come across 1 or know how love no it.

additionally i've added setdimensions code

dimensionrange dimensions = new dimensionrange().setdimension("a1:c6");

with setautoresizedimensions

requests.add(new request()                 .setautoresizedimensions(autoresizedimensions                         .setdimensions(dimensions)));

but i'm getting following error

com.google.api.client.googleapis.json.googlejsonresponseexception: 400 bad request {   "code" : 400,   "errors" : [ {     "domain" : "global",     "message" : "invalid value @ 'requests[3].auto_resize_dimensions.dimensions.dimension' (type_enum), \"a1:c6\"",     "reason" : "badrequest"   } ],   "message" : "invalid value @ 'requests[3].auto_resize_dimensions.dimensions.dimension' (type_enum), \"a1:c6\"",   "status" : "invalid_argument"

thanks conteh

the failures stem same reason: autoresizedimensionrequest not setup properly.

you need supply valid dimensionrange request's dimensions field in order request know dimensions resize. documentation dimensionrange describes it's purpose: a range along single dimension on sheet. indexes zero-based. indexes half open: start index inclusive , end index exclusive. missing indexes indicate range unbounded on side.

the first error ("invalid requests[1].autoresizedimensions: columns dimension supported") because request using default dimensionrange, means dimensionrange.dimension field using default value of dimension_unspecified. field enum of type dimension default value dimension_unspecified. error message saying, "only columns supported" , implicitly saying, "... supplied dimension_unspecified or rows".

the second error ("invalid value @ 'requests[3].auto_resize_dimensions.dimensions.dimension' (type_enum), \"a1:c6\"") because wrote a1 range dimension field. error message saying: "you gave me invalid value. enum, gave me a1:c6, , isn't valid enum."

the valid values dimension rows or columns (and autoresizedimensionrequest requires specify columns). in addition, you'll want specify sheetid (the id of sheet columns want resize) , startindex , endindex of columns want resize.

for example, if wanted automatically resize rows 0 , 1, use: autoresizedimensionsrequest autoresizedimensions = new autoresizedimensionsrequest(); dimensionrange dimensions = new dimensionrange().setdimension("columns").setstartindex(0).setendindex(2); autoresizedimensions.setdimensions(dimensions); (endindex 2 because end indexes exclusive, whereas start indexes inclusive.)


-

Comments

Post a Comment

Popular posts from this blog

angular - Is it possible to get native element for formControl? -

i've got angular2 reactive form . created formcontrol s , assigned input fields by [formcontrol]=... . understand creates nativeelement <-> formcontrol link. my question: possible nativeelement formcontrol ? wanna myformcontrol.nativeelement.focus() i can share 1 terrible solution works me. in reactive forms can use either 1) formcontroldirective ts mycontrol = new formcontrol('') template <input type="text" [formcontrol]="mycontrol"> or 2) formcontrolname ts myform: formgroup; constructor(private fb: formbuilder) {} ngoninit() { this.myform = this.fb.group({ foo: '' }); } template <form [formgroup]="myform"> <input type="text" formcontrolname="foo"> </form> so these directives write patch like 1) formcontroldirective const originformcontrolngonchanges = formcontroldirective.prototype.ngonchanges; formcontroldirective.proto
Read more

unity3d - Rotate an object to face an opposite direction -

i have object , b. when click on object b, rotates object b (a faces b). b doesn't face a. need following : when faces b, need face opposite direction. have code rotating @ b. how rotate face opposite direction after that? vector3 targetdirection = target - transform.position; float step = speed * time.deltatime; vector3 newdirection = vector3.rotatetowards (turretdome.transform.forward, targetdirection, step, 0.0f); turretdome.transform.rotation = quaternion.lookrotation (newdirection); you object facing object b, want inverse direction of object after that? objecta.transform.rotation = quaternion.inverse(objecta.transform.rotation) but lets assume example turretdome object a, (negate direction): turretdome.transform.rotation = quaternion.lookrotation (-newdirection); naturally, both of these snippets not show how smoothen rotation, seem know how use time.deltatime. just incase unsure, quaternion.lerp this
Read more

javascript - Why jQuery Select box change event is now working? -

i working on product filters user select select box according his/her preference not getting selected value user in jquery. html code:- <select name="product_filter" id="product_filter"> <option value="price_low_first">price : low high</option> <option value="price_high_first">price : high low</option> <option value="latest">latest</option> <option value="popular">most popular</option> </select> jquery code: $(function () { $("#product_filter").change(function () { alert("hi") var selectedtext = $(this).find("option:selected").text(); var selectedvalue = $(this).val(); alert("selected text: " + selectedtext + " value: " + selectedvalue); }); }); hi believe code perfect. once please check jquery.min.js
Read more