title: Read cell values without formatting into R with googlesheets
body: <p>Would like to be able to read Google Sheets cell values into R with googlesheets package, but without any cell formatting applied (e.g. comma separators, percentage conversion, etc.).</p>
  
  <p>Have tried gs_read() without specifying a range, which uses gs_read_csv(), which will "request the data from the Sheets API via the exportcsv link". Can't find a way to tell it to provide underlying cell value without formatting applied.</p>
  
  <p>Similarly, tried gs_read() and specifying a range, which uses gs_read_cellfeed(). But can't find a way to indicate that I want un-formatted cell values. </p>
  
  <p>Note: I'm not after the formulas in any cells, just the values without any formatting applied. </p>
  
  <p><strong>Example:</strong>
  (looks like I'm not able to post image images)
  Here's a screenshot of an example Google Sheet:
  <a href="https://www.dropbox.com/s/qff05u8nn3do33n/Screenshot%202015-07-26%2008.42.58.png?dl=0" rel="nofollow">https://www.dropbox.com/s/qff05u8nn3do33n/Screenshot%202015-07-26%2008.42.58.png?dl=0</a>
  First and third columns are numeric with no formatting applied, 2nd column applies comma separators for thousands, 4th column applies percentage formatting.</p>
  
  <p>Reading this sheet with the following code:</p>
  
  <pre><code>library(googlesheets)
  gs &lt;- gs_title("GoogleSheets Test")
  ws &lt;- gs_read(gs, ws = "Sheet1")
  </code></pre>
  
  <p>yields:</p>
  
  <pre><code>&gt; str(ws)
  Classes ‘tbl_df’, ‘tbl’ and 'data.frame':   3 obs. of  4 variables:
   $ Number         : int  123456 123457 123458
   $ Number_wFormat : chr  "123,456" "123,457" "123,458"
   $ Percent        : num  0.123 0.234 0.346
   $ Percent_wFormat: chr  "12.34%" "23.45%" "34.56%"
  </code></pre>
  
  <p>Would like to be able to read a worksheet that has formatting applied (ala columns 2 and 4), but read the unformatted values (ala columns 1 and 3).</p>