Ahh, ok. So basically, the implementation of the ChartWrappers using
query's is a bit quirky, so there isn't actually any way to get the
DataTable back out when doing that (at least, not when I last checked,
which was admittedly a long time ago). What you should do here is switch
to using a regular query, something like this:
google.load('visualization', '1', {'packages': ['corechart']});
google.setOnLoadCallback(drawVisualization);
function drawVisualization() {
var query = new google.visualization.Query(
'https://docs.google.com/spreadsheet/ccc?key=0ArzcNGBduYipdDc3VUtSQUQ4dUNRdnVRZUYzTGRjZVE&range=A1'
);
query.send(function (response) {
if (response.isError()) {
alert('Error in query: ' + response.getMessage() + ' ' +
response.getDetailedMessage());
return;
}
var data = response.getDataTable();
var flipNumber = data.getValue(0, 0);
// do something with flipNumber
});
}
I'm not certain what will happen when you query a cell with an image in it;
that's not something I've ever seen done before. You should be fine if it
returns an <img> tag with the appropriate url, though.
On Tuesday, October 16, 2012 1:05:57 PM UTC-4, Billy Bones wrote:
>
> Thanks ASG!
>
> I'm in over my head. I am using chart wrappers to draw the charts. I am
> giving them a containerId at this time. Then I am creating a div that it
> sits inside of. Do I scrap that to call the DataTable#getValue method or is
> that something I do inside of the chart wrapper? When I set up the chart
> wrapper to call the data table, it will import numbers into my dashboard,
> but I have a flip number as a jpg associated with each real number, and I
> was trying to bring those over from the spreadsheet. I imagine that there
> is a much better way to do what I am trying to do.
>
> <!DOCTYPE html>
> <html>
> <head>
> <meta http-equiv="Content-Type" content="text/html;
> charset=UTF-8"></meta>
> <title>Home Page</title>
> <!--Load the AJAX API-->
> <script type="text/javascript" src="http://www.google.com/jsapi
> "></script>
> <script type="text/javascript">
> //Load the Visualization API and the ready-made Google table
> visualization
> google.load('visualization', '1', {'packages':['corechart']});
> </script>
>
> <script type='text/javascript'>
> function drawF() {
> // Define the chart using setters:
> var wrap = new google.visualization.ChartWrapper();
> wrap.setChartType('Table');
> wrap.setDataSourceUrl('
> https://docs.google.com/spreadsheet/ccc?key=0ArzcNGBduYipdDc3VUtSQUQ4dUNRdnVRZUYzTGRjZVE&range=A1'
> );
> wrap.setContainerId('flipnumbers');
> wrap.setOptions({'title':'Total
> Clients','width':480,'height':410,});
> wrap.draw();
> wrap.getChart();
> }
> function drawVisualization() {
> drawF ();
> }
>
> google.setOnLoadCallback(drawVisualization);
> </script>
> </head>
> <body>
> <div id="flipnumbers"
> style="position:absolute;left:10px;top:0px;border:5px black
> solid;border-radius:25px;
> -moz-border-radius:25px;height:420px;width:500px;padding:6px;"></div>
>
> </div>
> </div>
>
> </body>
> </html>
>
> On Monday, October 15, 2012 3:17:33 PM UTC-7, Billy Bones wrote:
>>
>> Hi folks, I know this is child's play to most of you. I am using google
>> docs forms to populate google docs spreadsheets which populate a dashboard
>> of google visualization charts on my website. There are times when I would
>> just like to take one number from a spreadsheet and post it to my site in a
>> customized way. Ideally, I could use large "flip chart" style numbers to
>> display the number in my google docs spreadsheet. I am able to place a
>> table on my site to get the information there, but I would like to be able
>> to draw individual numbers from my spreadsheet in stylized colors, sizes,
>> or fonts. Any ideas for me?
>>
>> Billy
>>
>
--
You received this message because you are subscribed to the Google Groups
"Google Visualization API" group.
To view this discussion on the web visit
https://groups.google.com/d/msg/google-visualization-api/-/GvCAyknGHlIJ.
To post to this group, send email to [email protected].
To unsubscribe from this group, send email to
[email protected].
For more options, visit this group at
http://groups.google.com/group/google-visualization-api?hl=en.
