Accessing a published Google Sheets from a webpage

Question

I have a page with this code:

xmlhttp = new XMLHttpRequest(); }
xmlhttp.open("GET","https://spreadsheets.google.com/feeds/cells/14EiO1Fq6Z9eiN03eejNMlPAISTmwwCLhtcZxoSqLszo/ovqq6ni/private/full",false);
xmlhttp.send();

The code is failing due to: No 'Access-Control-Allow-Origin' header is present on the requested resource. Origin 'http://www.acme.com' is therefore not allowed access.

How do I solve this? I tried using the callback parameter but that just results in the same error.

Is the problem the way I'm retrieving the URL, or something on the Google Sheets / Spreadsheets end?

Answer 1

Ended up solving this with using this URL: https://spreadsheets.google.com/feeds/cells/14EiO1Fq6Z9eiN03eejNMlPAISTmwwCLhtcZxoSqLszo/ovqq6ni/public/basic?alt=json-in-script&callback=googleDocCallback