Export Google Table Date to CSV file

35 views
Skip to first unread message

Gopi Krishna Molabanti

unread,
Sep 28, 2015, 3:08:21 AM9/28/15
to Google Visualization API
Hi ,
I want to export my Google visualization Table Data to a Excel/CSV file.
But Toolbar option taking data from DataSource .i.e taking data from spreed sheets .
My requirement is toolbar taking data from DataTable or DataView.. is it possible..?
plz go through following code :

 function drawToolbar() {
     
var components = [
         
{type: 'igoogle', datasource: 'https://spreadsheets.google.com/tq?key=pCQbetd-CptHnwJEfo8tALA',
           gadget
: 'https://www.google.com/ig/modules/pie-chart.xml',
           userprefs
: {'3d': 1}},
         
{type: 'html', datasource: 'https://spreadsheets.google.com/tq?key=pCQbetd-CptHnwJEfo8tALA'},
         
{type: 'csv', datasource: 'https://spreadsheets.google.com/tq?key=pCQbetd-CptHnwJEfo8tALA'},
         
{type: 'htmlcode', datasource: 'https://spreadsheets.google.com/tq?key=pCQbetd-CptHnwJEfo8tALA',
           gadget
: 'https://www.google.com/ig/modules/pie-chart.xml',
           userprefs
: {'3d': 1},
           style
: 'width: 800px; height: 700px; border: 3px solid purple;'}
     
];

     
var container = document.getElementById('toolbar_div');
      google
.visualization.drawToolbar(container, components);
   
};

Gopi Krishna Molabanti

unread,
Sep 28, 2015, 3:09:34 AM9/28/15
to Google Visualization API
Table Data to CSV file
Reply all
Reply to author
Forward
0 new messages