title: Getting value of a cell from google docs spreadsheet into javascript
body: <p>I have a javascript function </p>
  
  <pre><code>function calculate() {
    var interestRate=4.5;
    ...
  }
  </code></pre>
  
  <p>I would like the interestRate to come from a cell in a google Docs spreadsheet.
  I created a google docs spreadsheet, and stored the interest rate in Cell B2</p>
  
  <p>I used the "Get a link to Published Data" feature in Google Docs to to get a link to cell B2. The link looks like this.</p>
  
  <p><a href="https://docs.google.com/spreadsheet/pub?key=....c&amp;single=true&amp;gid=0&amp;range=b2&amp;output=html">https://docs.google.com/spreadsheet/pub?key=....c&amp;single=true&amp;gid=0&amp;range=b2&amp;output=html</a></p>
  
  <p>Is there anyway of getting the value from the link into my javascript function?</p>
  
  <p>Thanks</p>