Office Add-In, updating table RRS feed

  • Question

  • Hi,

    I want to update a table in my excel sheet via an office add-in. 

    When I use the following code to update one line, there is no problem. But when I use this code to update multiple rows, my table won't update.

    var table = new Office.TableData(); table.rows = [["Seattle", "WA","test1","test2","test3","test4"],

    ["Seattle", "WA","test1","test2","test3","test4"]]; Office.context.document.bindings.getByIdAsync("dailyLog", function (asyncResult) { var binding = asyncResult.value; binding.deleteAllDataValuesAsync(); binding.setDataAsync(table, { coercionType: "table"});

    Any help on how to update easy multiple rows in my table?



    Saturday, February 6, 2016 5:23 PM

All replies