PHPアプリã§Google Spreadsheetをデータベースã¨ã—ã¦åˆ©ç”¨ã—よã†ï¼ˆ1/4）：CodeZine
ã¯ã˜ã‚㫠本連載ã§ã¯ã€PHP上ã§å‹•ä½œã™ã‚‹ã‚¢ãƒ—リケーションフレームワーク「Zend Frameworkã€ã¨ã€Googleã®æä¾›ã™ã‚‹ã‚µãƒ¼ãƒ“スを扱ã†ãŸã‚ã®é–¢æ•°ã®é›†åˆä½“ã§ã‚る「Google Data APIã€ã¨ã®é€£æºã«ã¤ã„ã¦ç´¹ä»‹ã—ã¾ã™ã€‚Zend Frameworkã®Zend_Gdataã¨ã„ã†ãƒ‘ッケージを使用ã™ã‚‹ã“ã¨ã§Googleカレンダーãªã©ã‚’利用ã—ãŸã‚¢ãƒ—リケーションを開発ã™ã‚‹ã“ã¨ãŒã§ãã¾ã™ã€‚ 今回ã¯Google Spreadsheet APIを使用ã—ã¦Google Spreadsheetサービスを使ã£ã¦ã¿ã¾ã—ょã†ã€‚Excelã‚„CSVã¨ã„ã£ãŸGoogleスプレッドシートã«åˆ†é¡žã•ã‚Œã‚‹æ–‡æ›¸ã‚’サーãƒä¸Šã§æ‰±ã†ã“ã¨ãŒã§ãã¾ã™ã€‚直接編集ã™ã‚‹ã ã‘ã§ãªãã€ã‚¢ãƒ—リケーションã§ä½¿ç”¨ã™ã‚‹ãƒ‡ãƒ¼ã‚¿ã®ä¿å˜å ´æ‰€ã¨ã—ã¦ã‚‚利用ã§ãã‚‹ã®ã§ã€ä»Šå›žã¯ã¡ã‚‡ã£ã¨ã—ãŸãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã¨ã—ã¦ä½¿ç”¨ã—ã¦ã¿ã¾ã™ã€‚ 対象èªè€… PHPã®åŸºæœ¬æ§‹æ–‡ã¯ä¸€é€šã‚Šç†è§£ã—
ã€Reflex iText】 Google Spread Sheetã‹ã‚‰PDF生æˆã™ã‚‹Bookmarklet
マイクãƒã‚½ãƒ•ãƒˆãŒãƒãƒƒãƒˆç‰ˆã‚ªãƒ•ã‚£ã‚¹ã‚’発売ã™ã‚‹ãã†ã 。ãƒãƒƒãƒˆåŒ–ã«ã‚ˆã‚Šã€è»½é‡åŒ–ã•ã‚Œã€ã©ã“ã‹ã‚‰ã§ã‚‚アクセスã§ãã‚‹ã¨ã„ã†åˆ©ä¾¿æ€§ã‚‚ã‚ã‚‹ãŒã€ãれ以上ã«ã€ä»–ã®ã‚µãƒ¼ãƒ“スやアプリã¨å”調ã§ãるメリットã®æ–¹ãŒå¤§ãã„ã¨ç§ã¯æ€ã†ã€‚例ãˆã°ã€Reflex iTextã¯ã€ãƒãƒƒãƒˆä¸Šã®æ§˜ã€…ãªãƒ‡ãƒ¼ã‚¿ã‚’å…ƒã«PDF化ã§ãã‚‹ãŒã€Googleã®Spread Sheetã¨é€£æºã™ã‚‹ã“ã¨ã‚‚ã§ãる。ãƒãƒƒãƒˆä¸Šã§ãƒ‡ãƒ¼ã‚¿ã‚’作æˆã—ã¦PDF帳票を出力ã™ã‚‹ã€ã¨ã„ã£ãŸBIツールã®ã‚ˆã†ãªã“ã¨ãŒå€‹ã€…ã®ã‚µãƒ¼ãƒ“スをマッシュアップã•ã›ã‚‹ã“ã¨ã§å¯èƒ½ã«ãªã‚‹ã®ã§ã‚る。 * GoogleSpreadSheetCsvParser http://csv2xml.latest.reflex-itext.appspot.com/ * GoogleSpreadSheet > Shre > Get the link to share 1. Allow anyone with the li
How to use Google Spreadsheets for TDD
The concept introduced in a talk Manager's Introduction to Test-Driven Development, demonstrating TDD with Excel and VBA.March 24, 2014· 4 minutes to read The idea is from 2008 by Dave Nicolette and Karl Scotland and they first presented it in their talk “Manager’s Introduction to Test-Driven Development†where they are showing managers how to do TDD with Excel and VBA. Inspired by this talk see h
Google Visualization APIを使ã£ã¦Webアプリケーションã«ã‚°ãƒ©ãƒ•ã‚£ã‚«ãƒ«ãƒ‡ãƒ¼ã‚¿ã‚’表示ã™ã‚‹
ã¯ã˜ã‚㫠最近ã¯ã€ãƒãƒƒãƒˆãƒ¯ãƒ¼ã‚¯ä¸Šã«å˜åœ¨ã™ã‚‹ãƒ‡ãƒ¼ã‚¿ãŒã¾ã™ã¾ã™å¢—ãˆã¦ãŠã‚Šã€ãã®å½¢å¼ã‚„å ´æ‰€ã‚‚ã•ã¾ã–ã¾ã§ã™ã€‚ã“ã†ã—ãŸå‚¾å‘ã‹ã‚‰ã€ãƒ“ジュアル分æžã€ã¤ã¾ã‚Šãƒãƒƒãƒˆä¸Šã®ãƒ‡ãƒ¼ã‚¿ã‹ã‚‰å¿…è¦ãªæƒ…å ±ã‚’æŠ½å‡ºã—ã¦ä¸€ç›®ã§åˆ†ã‹ã‚‹ã‚ˆã†ã«æ示ã™ã‚‹æ©Ÿèƒ½ãŒé‡è¦ã«ãªã£ã¦ã„ã¾ã™ã€‚開発者ã®å¤šãã¯ã€ã“ã®ã‚ˆã†ãªãƒ‡ãƒ¼ã‚¿ã‚’集ã‚ã¦åˆ†æžã—ã€ãƒ€ãƒƒã‚·ãƒ¥ãƒœãƒ¼ãƒ‰ã€ãƒ¬ãƒãƒ¼ãƒˆã€ã‚°ãƒ©ãƒ•ã®ã‚ˆã†ãªãƒ•ã‚©ãƒ¼ãƒ ã«ã¾ã¨ã‚ã¦å…¬é–‹ã™ã‚‹å½¹å‰²ã‚‚æ‹…ã£ã¦ã„ã¾ã™ã€‚ãã®éš›ã«å¨åŠ›ã‚’発æ®ã™ã‚‹ã®ãŒã€è¡¨ç¾åŠ›ã®é«˜ã„ç”»åƒã‚„図表ã§ã™ã€‚ ã“ã†ã—ãŸæ–°ãŸãªè¦æ±‚ã«å¿œãˆã‚‹ãŸã‚ã«ã€Google Visualization APIã¯ã€é–‹ç™ºè€…ãŒãƒ“ジュアル分æžã‚’è¡Œã†ä¸€å…ƒçš„ãªæ–¹æ³•ã¨ã€ãƒ‡ãƒ¼ã‚¿ã‚’ビジュアル化ã™ã‚‹ã»ã¨ã‚“ã©ã®çŠ¶æ³ã«å¯¾å¿œã§ãる豊富ãªã‚°ãƒ©ãƒ•ã‚£ãƒƒã‚¯ã‚³ãƒ³ãƒãƒ¼ãƒãƒ³ãƒˆã‚„グラフ作æˆã‚³ãƒ³ãƒãƒ¼ãƒãƒ³ãƒˆã‚’æä¾›ã—ã¾ã™ã€‚ã“ã®APIã¯ã€ãƒ‡ãƒ¼ã‚¿äº¤æ›ã®ä»•æ§˜ã¨ä¸€é€£ã®ãƒ©ã‚¤ãƒ–ラリã§æ§‹æˆã•ã‚Œã¦ã„ã¾ã™ã€‚ã“れらã®ãƒ©ã‚¤ãƒ–ラリを利用ã™ã‚‹ã“ã¨ã§ã€é–‹ç™ºè€…ã¯ã€æ§‹é€ 化ã•ã‚Œ
Data Scraping Wikipedia with Google Spreadsheets
OUseful.Info, the blog… Trying to find useful things to do with emerging technologies in open education and data journalism. Snarky and sweary to anyone who emails to offer me content for the site. Prompted in part by a presentation I have to give tomorrow as an OU eLearning community session (I hope some folks turn up – the 90 minute session on Mashing Up the PLE – RSS edition is the only reason
Ring
Ringã¨ã¯ã€ãƒªã‚¯ãƒ«ãƒ¼ãƒˆã‚°ãƒ«ãƒ¼ãƒ—会社従æ¥å“¡ã‚’対象ã«ã—ãŸæ–°è¦äº‹æ¥æ案制度ã§ã™ã€‚ 『ゼクシィã€ã€ŽR25ã€ã€Žã‚¹ã‚¿ãƒ‡ã‚£ã‚µãƒ—リã€ãªã©æ•°å¤šãã®äº‹æ¥ã‚’生ã¿å‡ºã—ã¦ããŸæ–°è¦äº‹æ¥åˆ¶åº¦ã¯ã€ 1982å¹´ã«ã€ŒRINGã€ã¨ã—ã¦ã‚¹ã‚¿ãƒ¼ãƒˆã—ã€1990年「New RINGã€ã¨æ”¹å®šã€ãã—ã¦2018年「Ringã€ã«ãƒªãƒ‹ãƒ¥ãƒ¼ã‚¢ãƒ«ã—ã¾ã—ãŸã€‚ リクルートグループã®å¾“æ¥å“¡ã¯èª°ã§ã‚‚自由ã«å‚åŠ ã™ã‚‹ã“ã¨ãŒã§ã〠テーマã¯ãƒªã‚¯ãƒ«ãƒ¼ãƒˆã®æ—¢å˜é ˜åŸŸã«é™ã‚‰ãšã€ã‚ã‚Šã¨ã‚ã‚‰ã‚†ã‚‹é ˜åŸŸãŒå¯¾è±¡ã§ã™ã€‚ リクルートã«ã¨ã£ã¦ã€Ringã¨ã¯ã€Œæ–°ã—ã„価値ã®å‰µé€ ã€ã¨ã„ã†ã‚°ãƒ«ãƒ¼ãƒ—経営ç†å¿µã‚’体ç¾ã™ã‚‹å ´ã§ã‚り〠従æ¥å“¡ãŒè‡ªåˆ†ã®æ„æ€ã§æ–°è¦äº‹æ¥ã‚’æ案・実ç¾ã§ãる機会ã§ã™ã€‚ Ringフãƒãƒ¼ ãã®å¾Œã®äº‹æ¥é–‹ç™ºæ‰‹æ³• Ringを通éŽã—ãŸæ¡ˆä»¶ã¯ã€äº‹æ¥åŒ–を検討ã™ã‚‹æ¨©åˆ©ã‚’å¾—ã¦ã€äº‹æ¥é–‹ç™ºã‚’è¡Œã„ã¾ã™ã€‚ ã•ã¾ã–ã¾ãªäº‹æ¥é–‹ç™ºã®æ‰‹æ³•ãŒã‚ã‚Šã¾ã™ãŒã€ä¾‹ãˆã°æ—¢å˜é ˜åŸŸã§ã®äº‹æ¥é–‹ç™ºã®å ´åˆã¯ã€ 担当事æ¥ä¼šç¤¾å†…ã§äºˆç®—ã‚„
map a listã§ã‚¹ãƒ—レッドシートã®ã‚¢ãƒ‰ãƒ¬ã‚¹ã‚’グーグルマップ上ã«è¡¨ç¤º | ライフãƒãƒƒã‚«ãƒ¼ãƒ»ã‚¸ãƒ£ãƒ‘ン
フリーサービス「map a listã€ã‚’使ãˆã°ã€ã‚¢ã‚«ã‚¦ãƒ³ãƒˆå†…ã®ã‚°ãƒ¼ã‚°ãƒ«ã‚¹ãƒ—レッドシートã‹ã‚‰ç›´æŽ¥ã‚¢ãƒ‰ãƒ¬ã‚¹ã‚’å–ã‚Šè¾¼ã¿ã€ãれをカスタマイズã•ã‚ŒãŸã‚°ãƒ¼ã‚°ãƒ«ãƒžãƒƒãƒ—ã¸è¡¨ç¤ºã—ã¦ãã‚Œã¾ã™ã€‚ウェブベースã®ãƒ‡ãƒ¼ã‚¿ãƒžãƒƒãƒ”ングツールã¯ä»–ã«ã‚‚多々ã‚ã‚Šã¾ã™ãŒã€ã“ã®ã‚°ãƒ¼ã‚°ãƒ«ãƒ‰ã‚ュメントã‹ã‚‰ãŠæ‰‹è»½ã«ãƒ‡ãƒ¼ã‚¿ã‚’å–ã‚Šè¾¼ã‚ã€æ‰‹é †ã‚’追ã£ã¦ã„ãã ã‘ã§ã¡ã‚ƒã‚“ã¨ãƒ‡ãƒ¼ã‚¿ãŒåæ˜ ã•ã‚Œã¦ã„ãウィーザードã®ç°¡å˜ã•ã¯ä»–ã«é¡žã‚’見ãªã„ã§ã™ã。 ホームパーティーや飲ã¿ä¼šã€çµå©šå¼å ´ã®æ¡ˆå†…ãªã©ä½¿ã„æ–¹ã¯è‰²ã€…。スプレッドシートã®æ–¹ã§ã‚¢ãƒ‰ãƒ¬ã‚¹ã‚’ä¿®æ£ã™ã‚‹ã¨è‡ªå‹•çš„ã«åœ°å›³ã®æƒ…å ±ã‚‚æ›´æ–°ã•ã‚Œã‚‹ä»•çµ„ã¿ã«ãªã£ã¦ã„ã‚‹æ°—ã®åˆ©ãよã†ã‚‚良ã„æ„Ÿã˜ã€‚スプレッドシート自体ã®å…±æœ‰ã‚‚当然å¯èƒ½ã§ã™ã—ã€KMLã«ã‚¨ã‚¯ã‚¹ãƒãƒ¼ãƒˆã—ã¦ã‚°ãƒ¼ã‚°ãƒ«ã‚¢ãƒ¼ã‚¹ã§éŠã‚“ã りも出æ¥ã‚‹ã¨è¨€ã†ã®ã ã‹ã‚‰ã€ã“ã‚Œã§ã‚°ãƒ¼ã‚°ãƒ«ãƒžãƒƒãƒ—ã®ä½¿ã„é“ãŒã•ã‚‰ã«å¢—ãˆã‚‹ã“ã¨é–“é•ã„ãªã—ã£ï¼ map a list [via MakeUseOf.com] Ke
Simple example of retrieving JSON feeds from Spreadsheets Data API  | Google Data APIs  | Google for Developers
Simple example of retrieving JSON feeds from Spreadsheets Data API Stay organized with collections Save and categorize content based on your preferences. Warning: This page is about Google's older APIs, the Google Data APIs; it's relevant only to the APIs that are listed in the Google Data APIs directory, many of which have been replaced with newer APIs. For information about a specific new API, s
Official Google Data APIs Blog: GData for Google Spreadsheets
Today we would like to introduce the newest kid on the Google Data API block, Google Spreadsheets data API. Calendars and blogs have all been done and embraced by the data feed developer community, but in Google's on-going attempt to push the envelope, here is the next installment for GData. Now there is the possibility of getting a feed listing your updated spreadsheets, and since there is more t
Tremend Tech Blog Spreadsheet dojo widget
Update3: We’re back to our own hosting.Update2: Razvan Dragomirescu was kind enough to mirror the spreadsheet widget. Click here to access the demo. Thanks, Razvan!Update: Due to high traffic the demo page might load very slowly. Please have patience. In the last weeks, I’ve been using my so very little spare time to create a spreadsheet widget based on dojo. Click here for a demo of the spreadshe
1
ãŠçŸ¥ã‚‰ã›
障害
ランã‚ング
リリースã€éšœå®³æƒ…å ±ãªã©ã®ã‚µãƒ¼ãƒ“スã®ãŠçŸ¥ã‚‰ã›
最新ã®äººæ°—エントリーã®é…ä¿¡
j次ã®ãƒ–ックマーク
kå‰ã®ãƒ–ックマーク
lã‚ã¨ã§èªã‚€
eコメント一覧を開ã
oページを開ã
ReadWrite - IoT and Technology News
Accelerating Your Growth from R&D to ROI
Visualizing data in the cloud
{{#tags}}- {{label}}
{{/tags}}