i have excel table 7 columns data , 6 calculated columns. table connected 3 charts.
a task pane add-in used parameters, implement security (bearer token) , data. query returns different number of rows different parameters.
because of this, cannot use range , have use office.tabledata.
on samples this table destroyed every time , created again, cannot use, because excel workbook used template, , not know, connection table has.
with bindings , tabledata possible use different number of rows, not update data partially.
these methods have tried without success: addfromnameditemasync, deletealldatavaluesasync, addrowsasync, setselecteddataasync.
i think, should possible, because of way how excel workbook queries work. how can solve this?
though dont have answer question if not able find answer question related office-add-in should ask question on social msdn forum. got answer there. can check asked question related office-add-in
Comments
Post a Comment