Snipplr http://snipplr.com/tags/spreadsheet Recent snippets posted on Snipplr.com en-us Wed, 19 Jun 2013 11:54:19 GMT (PHP) Listing Google Spreadsheet answers with PHP (Parsing JSON) - Felladrin 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/ (JavaScript) Google Spreadsheet Geolocation - pmalerba http://snipplr.com/view/56944/google-spreadsheet-geolocation/

]]> Thu, 21 Jul 2011 03:11:29 GMT http://snipplr.com/view/56944/google-spreadsheet-geolocation/ (SAS) Exporting Multiple Data Sets to One Spreadsheet - webonomic http://snipplr.com/view/50839/exporting-multiple-data-sets-to-one-spreadsheet/ It's easy to export several data sets to one Excel spreadsheet with each data set in a separate worksheet.This example exports three SAS data sets (work.region, work.county and work.district) to the same spreadsheet (results.xls).

]]> Sat, 19 Mar 2011 07:32:29 GMT http://snipplr.com/view/50839/exporting-multiple-data-sets-to-one-spreadsheet/ (Other) oOo Conditional Formatting - darfix http://snipplr.com/view/48845/ooo-conditional-formatting/

]]> Fri, 11 Feb 2011 19:42:51 GMT http://snipplr.com/view/48845/ooo-conditional-formatting/ (Visual Basic) Spread设置下拉列表框型单元格 - sekihin http://snipplr.com/view/16469/spread/

]]> Mon, 29 Jun 2009 23:00:02 GMT http://snipplr.com/view/16469/spread/ (Visual Basic) Form事件中判断是否为Spread触发 - sekihin http://snipplr.com/view/16467/formspread/

]]> Mon, 29 Jun 2009 21:48:29 GMT http://snipplr.com/view/16467/formspread/ (Visual Basic) Spread单元格上锁 - sekihin http://snipplr.com/view/16466/spread/

]]> Mon, 29 Jun 2009 21:43:22 GMT http://snipplr.com/view/16466/spread/ (Visual Basic) Spread设置背景色 - sekihin http://snipplr.com/view/16465/spread/

]]> Mon, 29 Jun 2009 21:32:21 GMT http://snipplr.com/view/16465/spread/ (Visual Basic) Spread设置按钮型单元格 - sekihin http://snipplr.com/view/16464/spread/

]]> Mon, 29 Jun 2009 21:30:57 GMT http://snipplr.com/view/16464/spread/ (Visual Basic) Spread设置通货型单元格 - sekihin http://snipplr.com/view/16463/spread/

]]> Mon, 29 Jun 2009 21:19:29 GMT http://snipplr.com/view/16463/spread/ (Visual Basic) Spread设置文本型单元格 - sekihin http://snipplr.com/view/16462/spread/

]]> Mon, 29 Jun 2009 21:12:50 GMT http://snipplr.com/view/16462/spread/ (Visual Basic) Spread设置标签型单元格 - sekihin http://snipplr.com/view/16461/spread/

]]> Mon, 29 Jun 2009 21:07:16 GMT http://snipplr.com/view/16461/spread/ (Visual Basic) Spread内设置焦点 - sekihin http://snipplr.com/view/16460/spread/

]]> Mon, 29 Jun 2009 20:45:36 GMT http://snipplr.com/view/16460/spread/ (Visual Basic) 取得选择的复数行 - sekihin http://snipplr.com/view/16203//

]]> Mon, 22 Jun 2009 21:31:14 GMT http://snipplr.com/view/16203// (Visual Basic) 复数行选择SpreadSheet属性设置 - sekihin http://snipplr.com/view/16202/spreadsheet/

]]> Mon, 22 Jun 2009 21:15:53 GMT http://snipplr.com/view/16202/spreadsheet/ (Visual Basic) SpreadSheet 隐藏列的设置与还原 - sekihin http://snipplr.com/view/15795/spreadsheet-/

]]> Tue, 09 Jun 2009 21:53:46 GMT http://snipplr.com/view/15795/spreadsheet-/ (Visual Basic) SpreadSheet 清空Sheet - sekihin http://snipplr.com/view/15794/spreadsheet-sheet/

]]> Tue, 09 Jun 2009 21:52:14 GMT http://snipplr.com/view/15794/spreadsheet-sheet/ (Visual Basic) SpreadSheet设置行颜色 - sekihin http://snipplr.com/view/15793/spreadsheet/

]]> Tue, 09 Jun 2009 21:50:36 GMT http://snipplr.com/view/15793/spreadsheet/ (PHP) Export MySQL Data as CSV - mikegreen 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/ (Rails) Rails CSV Export - mikegreen http://snipplr.com/view/6365/rails-csv-export/

]]> Tue, 20 May 2008 15:26:27 GMT http://snipplr.com/view/6365/rails-csv-export/