title: Can't set NumberFormat with Excel JavaScript API
body: <p>I'm using the excel Javascript API and after searching through the docs, still can't find a solution for what I'm trying to achieve. </p>
  
  <p>So I want to set everything to have the number format "Text" so none of Excel's auto-formatting messes with any of the cells' content (no removing leading zeros or changing date formats). </p>
  
  <p>The docs suggest changing the format via: </p>
  
  <p><code>Worksheets("Sheet1").Range("A17").NumberFormat = "General"</code></p>
  
  <p>But it seems the sheet object doesn't contain a Range method. </p>
  
  <p>Instead I tried to use the getRange method on my table like this: </p>
  
  <p><code>constructionTable.getRange().NumberFormat = "Text"</code></p>
  
  <p>This didn't throw any errors, but didn't seem to do anything. </p>
  
  <p>Formatting the table range had previously worked for stuff like this: </p>
  
  <p><code>constructionTable.getRange().format.autofitColumns()</code></p>
  
  <p>So I also checked whether <code>constructionTable.getRange().range.format</code> contains a method called NumberFormat or numberFormat, but it does not :( </p>
  
  <p>Has anyone had any success doing this?</p>