title: Google Sheets F# Access and XML
body: <p>I would like to load the contents of some spreadsheet into an XmlDocument. What I got is:</p>
  
  <pre><code>let req = WebRequest.Create "http://spreadsheets.google.com/ccc?key=pXMFQ3e4aFY11oQkT_7FhZg"
  let resp = req.GetResponse ()
  let stream = resp.GetResponseStream ()
  let xdoc = new XmlDocument()
  xdoc.Load stream
  </code></pre>
  
  <p>I get the following error:</p>
  
  <pre><code>System.Xml.XmlException: An error occurred while parsing EntityName. Line 12, position 22057.
    at System.Xml.XmlTextReaderImpl.Throw(Exception e)
    at System.Xml.XmlTextReaderImpl.ParseEntityName()
    at System.Xml.XmlTextReaderImpl.ParseEntityReference()
    at System.Xml.XmlTextReaderImpl.Read()
    at System.Xml.XmlLoader.LoadNode(Boolean skipOverWhitespace)
    at System.Xml.XmlLoader.LoadDocSequence(XmlDocument parentDoc)
    at System.Xml.XmlDocument.Load(XmlReader reader)
    at System.Xml.XmlDocument.Load(Stream inStream)
    at &lt;StartupCode$FSI_0008&gt;.$FSI_0008.main@()
  Stopped due to error
  </code></pre>
  
  <p>Replacing that spreadsheet with the simplest one with only a column of few integers does not change anything.</p>
  
  <p>Does it have something to do specifically with "Google Sheets" and if so, what should I do prior to loading or do I have to go down a different route?  </p>