StackOverflow2013

Note that there are some explanatory texts on larger screens.

plurals

PO
text
Body
copied!<p>To generate the table you'll want to check out the <a href="http://code.google.com/apis/visualization/documentation/gallery/table.html" rel="nofollow">Google Charts Table</a> documentation. The code to generate a table will look something like:</p> <pre><code> <head> <script type='text/javascript' src='https://www.google.com/jsapi'></script> <script type='text/javascript'> google.load('visualization', '1', {packages:['table']}); google.setOnLoadCallback(drawTable); function drawTable() { var data = new google.visualization.DataTable(); data.addColumn('string', 'Name'); data.addColumn('number', 'Salary'); data.addColumn('boolean', 'Full Time Employee'); data.addRows(2); data.setCell(0, 0, 'Mike'); data.setCell(0, 1, 10000, '$10,000'); data.setCell(0, 2, true); data.setCell(1, 0, 'Jim'); data.setCell(1, 1, 8000, '$8,000'); data.setCell(1, 2, false); var table = new google.visualization.Table(document.getElementById('table_div')); table.draw(data, {showRowNumber: true}); } </script> </head> <div id='table_div'></div> </code></pre> <p>The data you're populating the table with will theoretically need to be stored server-side already. You can store the data in a database such as a MySQL database, of which there are many tutorials online on how to set one up.</p> <p>There are a number of ways to convert the data into a .csv file server-side. As an example, using PHP you could use <a href="http://us2.php.net/manual/en/function.fputcsv.php" rel="nofollow">fputcsv</a>, by creating an arbitrary .csv file path on your server, then reading the data from your database to populate the .csv file. See the fputscsv documentation for examples on how to properly do this.</p>

Querying!

Guidance

An individual column

Larger individual text columns get their own page to allow for proper reading.

SQuiL has stopped working due to an internal error.

If you are curious you may find further information in the browser console, which is accessible through the devtools (F12).

Reload