title: How to fill partially Excel table from Javascript task pane application
body: <p>I have an Excel table with 7 columns with data and 6 calculated columns. The table is connected with 3 charts. </p>
  
  <p>A task pane add-in is used to get some parameters, implement some security (Bearer Token) and get the data. The query returns different number of rows for different parameters. </p>
  
  <p>Because of this, I cannot use a range and have to use <code>Office.TableData</code>. </p>
  
  <p>On samples like <a href="https://github.com/OfficeDev/Excel-Add-in-JS-ExternalDataGitHub" rel="nofollow">this</a> the table is destroyed every time and created again, which I cannot use, because the Excel workbook is used as template, and I do not know, what for connection this table has. </p>
  
  <p>With bindings and <code>TableData</code> is possible to use different number of rows, but not to update the data partially. </p>
  
  <p>These are the methods I have tried without success: <code>addFromNamedItemAsync</code>, <code>deleteAllDataValuesAsync</code>, <code>addRowsAsync</code>, <code>setSelectedDataAsync</code>. </p>
  
  <p>I think, that it should be possible, because of the way how Excel Workbook Queries work. But how can I solve this?</p>