Use either the gid or sheet parameter, not both, and use a hash (#) instead of an ampersand (&), ie:
var query = new google.visualization.Query( 'https://spreadsheets.google.com/a/finance-in-motion.com/tq?key=0AjV_Fr31Owm1dHJpVDVDYVNQM3pxVnBlUEtDR1RWb1E#sheet=MySheetName' ); On Friday, June 1, 2012 4:31:22 AM UTC-4, shumway wrote: > > Hello, > > I am trying to query a specific sheet within a spreadsheet. > Unfortanetly it alwas takes the values of the sheet in position one. I > have tried setting the gid number to the sheet I want queried but it > still only queries the one in the first position. I also attempted to > use the &Sheet=SheetName parameter, but the result was also the same. > any help would be appreciated. Here is the code: > > function onldQuery(){ > var url='https://spreadsheets.google.com/a/finance-in-motion.com/tq? > key=0AjV_Fr31Owm1dDRXRGtIcUprZVRPbDM5Sl94dV9xRlE#gid=1<https://spreadsheets.google.com/a/finance-in-motion.com/tq?key=0AjV_Fr31Owm1dDRXRGtIcUprZVRPbDM5Sl94dV9xRlE#gid=1>'; > > > var query = new google.visualization.Query('https:// > spreadsheets.google.com/a/finance-in-motion.com/tq? > key=0AjV_Fr31Owm1dHJpVDVDYVNQM3pxVnBlUEtDR1RWb1E#gid=1'<http://spreadsheets.google.com/a/finance-in-motion.com/tq?key=0AjV_Fr31Owm1dHJpVDVDYVNQM3pxVnBlUEtDR1RWb1E#gid=1'>); > > > > query.send(handleOnldResponse); > > } -- 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/-/hq0b57-CKdwJ. 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.
