title: Pushing values to getColumn.values for Excel add In
body: <p>So I am trying to import and read a json to an excel sheet, using an add-in I'm developing. So I've gotten to a point where I'm getting <code>ColumnA</code> and <code>ColumnB</code> from my new <code>worksheet</code>. Then I'm trying to push the json fields onto the <code>Range.values</code> arrays of the columns. However once I run the program the worksheet is still blank. Here is the code:</p>
  
  <pre><code>function importJson(json, name){
  Excel.run(function (context) {
    ...
      var sheetRange = newWorksheet.getRange("A1:B1");
                              sheetRange.load('values');
                              var aColumn = sheetRange.getColumn(0);
                              var bColumn = sheetRange.getColumn(1);
                              aColumn.load('values');
                              bColumn.load('values');
                              return context.sync().then(function () {                             
                                  printJson(json, aColumn, bColumn);
  
                              });
  });
  
  printJson(json, aColumn, bColumn)
  {
   if (json instanceof Object) {                                
                      aColumn.values.push(json.display);                    
                      if (json.default != null) {
                          bColumn.values.push(json.default);                    
                      }                   
                  }                
                  if (json.fields != null) {
                      for (var i = 0; i &lt; json.fields.length; i++) {
                          printSchema(json.fields[i], aColumn, bColumn);
                      }
                  }
  }
  </code></pre>
  
  <p>Running the debugger I see the values from the <code>json</code> object being pushed onto the arrays but run I still don't see them on the <code>worksheet</code></p>
  
  <p>Thanks for any help! </p>