Dynamically add rows to google spreadsheet - response.getDataTable() function is used

[josep...@gmail.com]

Hello,

I am new to Google Charts. I use response.getDataTable() to fetch data from spreadsheet and create a bubble chart. Now I want to add rows dynamically to the data table. But data.addRow() function is not working for me. Could someone please help me with the issue?

[Sergey Grabkovsky]

Hi Joseph,

I just tested this myself, and things appear to work fairly reasonably.

Here is a jsfiddle example of me querying a spreadsheet, using response.getDataTable(), drawing it, adding a row to the data, and then drawing in another Table: http://jsfiddle.net/3L8fck9f/

On Thu, Feb 18, 2016 at 1:18 AM <josep...@gmail.com> wrote:

Hello,

I am new to Google Charts. I use response.getDataTable() to fetch data from spreadsheet and create a bubble chart. Now I want to add rows dynamically to the data table. But data.addRow() function is not working for me. Could someone please help me with the issue?

--
You received this message because you are subscribed to the Google Groups "Google Visualization API" group.
To unsubscribe from this group and stop receiving emails from it, send an email to google-visualizati...@googlegroups.com.
To post to this group, send email to google-visua...@googlegroups.com.
Visit this group at https://groups.google.com/group/google-visualization-api.
To view this discussion on the web visit https://groups.google.com/d/msgid/google-visualization-api/9cba2c74-a5ec-4e6f-af92-3b2cccf77c76%40googlegroups.com.
For more options, visit https://groups.google.com/d/optout.

--

	•	Sergey Grabkovsky
	•	Software Engineer
	•	Google, Inc
	•	gra...@google.com

[josep...@gmail.com]

Hi Sergey, 

Thanks for your response. The number of columns specified in the array did not match with that of the source sheet. Its fixed now.