http://snipplr.com/language/php/tags/spreadsheet Recent snippets posted on Snipplr.com en-us Wed, 22 May 2013 03:11:57 GMT http://snipplr.com/view/64777/listing-google-spreadsheet-answers-with-php-parsing-json/ Make your spreadsheet public to get a key like this: 0AsfENoKj1ir7dE8yR6U0aUtpdTVNM20wRlNJOhZaclG Set it on the script and you're all done.

]]> Wed, 02 May 2012 09:07:04 GMT http://snipplr.com/view/64777/listing-google-spreadsheet-answers-with-php-parsing-json/ http://snipplr.com/view/11187/export-mysql-data-as-csv/ # Export MySQL Data as CSV This code takes a `mysql_query()` resource and outputs its rows into CSV spreadsheet format. Edit the `header('Content-Disposition...` declaration to tell the user's browser to either display the data as plain text or download it as an `attachment`. __Note:__ This doesn't include the code to connect to the database in the first place. Don't forget that, otherwise this code is pretty useless.

]]> Thu, 15 Jan 2009 00:09:34 GMT http://snipplr.com/view/11187/export-mysql-data-as-csv/