CODEWITHSUNDEEP
javascriptexceloffice-app
Janitha Madushan
Janitha Madushan

Reputation: 1543

How to find the coordinates of excel sheet using office apps development

I am developing an excel office app. I need to update a cell using its coordinates. How to do this with javascript. for an example,

var x =1;
var y =2;

update_cell(1,2,'string');

Upvotes: 2

Views: 176

Answers (1)

Miro J.
Miro J.

Reputation: 4984

I had the same task. Apparently, there is no way in the current JavaScript API for Office 1.1.

A workaround, which worked in our scenario was to create a binding of the cell when: - a user selects it or - in the initial template we gave her

Check the Office.context.bindings object in the API help http://zoom.it/F2u0#full and try this as well:

Office.select('bindings#' + bindingId).setDataAsync(value, { coercionType: "matrix" });

Upvotes: 2

Related Questions