ãµã¤ãã®æ§ç¯ãä½åã®è²©å£²ãããã°ã®æ稿ããã®ä»ã«ããã¾ãã¾ãªæ©è½ãããã¾ãã ãã°ã¤ã³ ãµã¤ããã¯ãããã éå ¬éãµã¤ã ãã®ãµã¤ãã¯ç¾å¨ãã©ã¤ãã¼ãè¨å®ã«ãªã£ã¦ãã¾ãã
PHPExcelã使ã£ã¦ã¿ã ã«ã¼ãç·¨ - 130åä½ ååã¯ãã¡ã¤ã«åºåã試ãã¾ããããä»åã¯éã«ãã¡ã¤ã«ãããã¼ã¿ã®èªã¿è¾¼ã¿ããã¦ã¿ã¾ããCSVã®ãããªåç´ãªæ§é ã®ã·ã¼ããæ³å®ããã¨ãããã®ä¸ã®åã»ã«ã®å¤ãç¹°ãè¿ãå¦çã§åå¾ããã«ã¯ã©ãããããã§ãã å梱ããã¦ãããµã³ãã«ã®ãTest/28iterator.phpããåèã«ãã¦æ¸ãã¦ã¿ã¾ããã <?php //ã©ã¤ãã©ãªã®ã¤ã³ã¯ã«ã¼ã set_include_path(get_include_path() . PATH_SEPARATOR . './PHPExcel/Classes/'); include 'PHPExcel.php'; include 'PHPExcel/IOFactory.php'; //ãã¡ã¤ã«ãèªã¿è¾¼ãã§ã¤ã³ã¹ã¿ã³ã¹å (â»Excel2003以åã®å½¢å¼) $objReader = PHPExcel_IOFact
PCãç¡ç·ã»æç·ã¤ã³ã¿ã¼ãããããã¼ãã£ã³ã°ã«ã¼ã ãªã©ãåãã24æéå¶æ¥ã®ä¾¿å©ãªã¯ã¼ãã³ã°ã¹ãã¼ã¹ãæ´ç·´ãããã¤ã³ããªã¢ã¨é³æ¥½ãããã«ã«ãã§ã¨ãã¦ãåªç§ââãããªãã¬ãã·ãã«ãã¤å¿«é©ãªç©ºéãå宿ã«ãªã¼ãã³ï¼ã ã¤ã³ã¿ã¼ãããç°å¢ãæ¥é²ææ©ã§çºå±ãããªããæã ã®ã©ã¤ãã¹ã¿ã¤ã«ãããã¦ã¯ã¼ãã³ã°ã¹ã¿ã¤ã«ã¯å¤§ããå¤åãã¦ãããä»ã§ã¯ãªãã£ã¹ã®ä¸ã§ä¸æ¥ä¸éãããªãã¨ããèªåã®å¥½ããªå ´æã§ä»äºããããã¨ãå¯è½ãã«ãã§ã§ãããã«ã§ãæ°å¹¹ç·ãé£è¡æ©ã®ä¸ã§ãã¯ãã¾ãå ¬åã®ãã³ããªããã§ãä»äºã§ãã¦ãã¾ãæ代ã«ãªã£ãã®ã ã ã¨ã¯ããããã£ã±ãé»æºã¯ãã£ãã»ããããããã³ãã¼ãã¨ã£ããã¹ãã£ã³ãããããå¿ è¦ãåºã¦ãããã¨ããããããç¨åº¦ã®äººæ°ã§ãã¼ãã£ã³ã°ãããã¨ããããããããã¸ã§ã¯ã¿ã¼ãªããããã£ãããªã便å©ãã¤ã³ããªã¢é¢ã«ãæ°ãé ã£ã¦ãã£ããããã«ããããããããã³ã¼ãã¼ã飲ããããã£ã¨ãããªãâ¦â¦
ã¤ããã«ãªã£ã¼ï¼ï¼ãã©ããããããã§ãã æ ªå¼ä¼ç¤¾ãã¯ã·ã£ ã«è¡ã£ã¦ããï¼ã£ã¦ã®ãä¸åº¦ï¼å¹´åï¼2010å¹´4æï¼ã«æ¸ããã®ã ãã© æè¿åºæ¥ãã°ã£ããã®ãã«ã«å¼ã£è¶ãããããã®ã§ãéªéãã«è¡ã£ã¦ã¿ãï¼ ãªãã¨ä»åã¯å·åã¨ãªã¢ã¾ã§æ®å½±ããã¦ããã¡ããã¾ããããã²ãã¼ãããã¼ã ãã¯ã·ã£ããã¯ãã説æã®å¿ è¦ããªãæåSNSã¨æãããã®ã§èª¬æã¯çç¥ã ããããï¼ã¦äººã¯ååã®ã¨ã³ããªãåç §ãã¦ãã ã¡ãã ã»ãããåä»ã ==== ã©ã©ããmixiãã´ã ãªãã ãã·ãã¯ãªé°å²æ°ã大人ã«ãªã£ãã£ã¦ãããã â»å ¬éãã3ã¶æ以ä¸çµéããç¹å®ã®è¨äºã¯ææã¨ãªã£ã¦ããå ´åãããã¾ã ãã®ç¶ãã¯codocã§è³¼å ¥
ã¿ããªã§ä½ããªãã£ã¹ä»äºå ´ãµã¤ã
3ã¶æã§149.5åå¼·æééæã§ããGoogleDocsã«ããèªåè¦ããåã®ããæ¹ã¨ãã®å¹ç¨ ã«é¢ããã©ã¤ãã¬ã·ãããç´¹ä»ãã¾ããnanapi [ããã]ã¯ãã¿ããªã§ä½ãæ®ããã®ã¬ã·ããµã¤ãã§ããã¯ããã« ãã®ã¬ã·ãã®ä¸»æ¨ åå¼·è¨é²ãè¦ããåããç°¡åãªä»çµã¿ãæåã«ä½ããã¨ã§ã æ¥ã ã®åå¼·ã®ã¢ããã¼ã·ã§ã³ç¶ç¶ãç®æãã¾ãã ã¤ã³ãã è²ã åå¼·ãããï¼ã¨æã£ã¦åå¼·ãå§ãããã®ã®ãï¼æ¥å主ã«ãªã£ã¦ãã¾ãçµé¨ããæ¹å°ãªãç¡ããã¨æãã¾ããç§ã¯ããã£ã¡ã ããããããã¨ã«é¥ãã¾ãã ã©ããã¦ãç¶ç¶ãããåå¼·ããã£ãå ´åãæ¯æ¥ãè¨é²ããããã¨ãç¶ç¶ã®éµã¨ãªãã¨è¯ãè¨ããã¾ããï¼åèï¼ããæ2æèµ·ãã§ããªãã§ãã§ãããã®ç§ã®æ¸è©ãï¼ ãã ã ããã®ãè¨é²ããããã¨ãåå«ã ããç¶ç¶ã§ããªããã ãã£ï¼ã ãããªã¨ããã解æ¶ããã®ãä»åã®ã¬ã·ãã®ä¸»æ¨ã§ãã ãªããã¿ã¤ãã«ã®æéã«ã¤ãã¦ã§ããã201
ç®æ¬¡ã®ä½æä¾ ç®æ¬¡ã®ä½æä¾ ã¹ã¿ã¤ã«ã®è¨å®ããããtop㸠ä¾æãå ¥åãã¾ãã å段è½ã«ã«ã¼ã½ã«ã表示ããã¹ã¿ã¤ã«ããã¯ã¹ãããè¦åºã1ãï½ãè¦åºã3ããé¸æãã¦è¨å®ãã¾ãã è¦åºã1ã®è¨å® 1è¡ç®ãé¸æã(ã«ã¼ã½ã«ã表示ã)ãã¹ã¿ã¤ã«ããã¯ã¹ã§ãè¦åºã1ããé¸æãã¾ãã è¦åºã2ã®è¨å® 2è¡ç®ãé¸æãã7è¡ç®ã¯ãCtrlããã¼ãæ¼ããªããé¸æãã¾ãã ã¹ã¿ã¤ã«ããã¯ã¹ã§ãè¦åºã2ããé¸æãã¾ãã è¦åºã3ã®è¨å® 3è¡ç®ãé¸æãããCtrlããã¼ãæ¼ããªãã5è¡ç®ã8è¡ç®ã10è¡ç®ãé¸æãã¾ãã ã¹ã¿ã¤ã«ããã¯ã¹ã§ãè¦åºã3ããé¸æãã¾ãã è¦åºã1ï½è¦åºã3ãè¨å®ãããç¶æ ã§ãã ã¢ã¦ãã©ã¤ã³ã®è¨å®ããããtop㸠è¦åºã1ï½è¦åºã3ã«ã¢ã¦ãã©ã¤ã³ãè¨å®ãã¾ãã 1è¡ç®ã«ã«ã¼ã½ã«ã表示ãããæ¸å¼ãâãç®æ¡æ¸ãã¨æ®µè½çªå·ãã®ãã¢ã¦ãã©ã¤ã³ãã¿ããé¸æãã¾ãã ã¹ã¿ã¤ã«ãé¸æãããOKããã¿
don-gabachoã¯GAE/Jã«ãããªã¼ãã³ã½ã¼ã¹ã»ã½ããã¦ã§ã¢ãåºå¹¹ã·ã¹ãã ã«ãããæ大ã®ç®çã¯å¸³ç¥¨ã®åºåã«ããããªã®ã§ã·ã¹ãã ãéçºããéã«ã¯å¸³ç¥¨ã¸åºåããé ç®ãä»ã·ã¹ãã ã¸åã渡ãé ç®ããèããã¨åãããããï¼å人çãªçµé¨ã¨ãã¦ï¼ã åºåããã帳票 ããã帳票ãåºåããã·ã¹ãã ãèããã¨ãªãã¨è©±ã¯éããç¹ã«Webã·ã¹ãã ã¯å¸³ç¥¨åºåãè¦æã ãé常ã®HTMLãããã¹ããã¡ã¤ã«ãåºåããã®ã«æ¯ã¹ãã¨ç°ãªãã©ã¤ãã©ãªãå¿ è¦ã«ãªã£ãããããããã§è©¦ãããã®ãdon-gabachoã ã don-gabachoã¯ååã¯ã¦ãã¼ã¯ã ãããã®å®æ ã¯æçãªå¸³ç¥¨åºåã·ã¹ãã ã¨ãªã£ã¦ãããèªåã§å¸³ç¥¨ã®è¨è¨ãå¯è½ã§ãããã«é ç®ãè¨å®ãããã¨ã§åºåãããå¤ãä»»æã«å¤æ´ãã§ãããçæããã帳票ã¯Excelãã¡ã¤ã«ã¨ãã¦ãã¦ã³ãã¼ããã§ããã å ¥åç»é¢ PDFã§ã¯ãªãããExcelã®æ¹ãç´°ããªèª¿æ´ãã§ããã®ã§ä¾¿å©
ã¯ããã« æ¬é£è¼ã§ã¯ãPHPä¸ã§åä½ããã¢ããªã±ã¼ã·ã§ã³ãã¬ã¼ã ã¯ã¼ã¯ãZend Frameworkãã¨ãGoogleã®æä¾ãããµã¼ãã¹ãæ±ãããã®é¢æ°ã®éåä½ã§ãããGoogle Data APIãã¨ã®é£æºã«ã¤ãã¦ç´¹ä»ãã¾ããZend Frameworkã®Zend_Gdataã¨ããããã±ã¼ã¸ã使ç¨ãããã¨ã§Googleã«ã¬ã³ãã¼ãªã©ãå©ç¨ããã¢ããªã±ã¼ã·ã§ã³ãéçºãããã¨ãã§ãã¾ãã ä»åã¯Google Spreadsheet APIã使ç¨ãã¦Google Spreadsheetãµã¼ãã¹ã使ã£ã¦ã¿ã¾ããããExcelãCSVã¨ãã£ãGoogleã¹ãã¬ããã·ã¼ãã«åé¡ãããææ¸ããµã¼ãä¸ã§æ±ããã¨ãã§ãã¾ããç´æ¥ç·¨éããã ãã§ãªããã¢ããªã±ã¼ã·ã§ã³ã§ä½¿ç¨ãããã¼ã¿ã®ä¿åå ´æã¨ãã¦ãå©ç¨ã§ããã®ã§ãä»åã¯ã¡ãã£ã¨ãããã¼ã¿ãã¼ã¹ã¨ãã¦ä½¿ç¨ãã¦ã¿ã¾ãã 対象èªè PHPã®åºæ¬æ§æã¯ä¸éãç解ã
ã¯ããã«ãã¯ã¼ãã¤ã³ãã¨ããã®ã¯ãä»ãä¼ç»æ¸ä½æç¨ãã¼ã«ã¨ãã¦ãã¸ãã¹ã«ãªãã¦ã¯ãªããªãåå¨ã«ãªã£ãæãããã¾ããã¼ãèªèº«ããæ¬æ¥ã¯ä¼ç»è ãªã®ã§ãããã¾ã§æ°ãåããªããããã®ä¼ç»æ¸ããã¯ã¼ãã¤ã³ãã§æ¸ãã¦ãã¾ããããããªä¸ã§ãæãæ°ãã¤ããã¾ãåãå ¥ãã¦ããã®ãããã¶ã¤ã³ãã§ãããå 容ããããã¨ãªãããè¦ãç®ã®ç¾ããããèªãã§ã¿ãããªããããªæ§æã»æ¼åºãèªã¿ããããªã©ã«ãä½ãããã ãã£ã¦ãã¾ããããªããã¨ããã°ãä¼ç»æ¸ã¨ããã®ã¯ãå¤ãã®å ´åãã¾ãæã«åã£ã¦ãããã¾ã§ã«å¤§ããªãã¼ãã«ãããããã§ãããã®æ¬¡ã«ãå®éã«è¦ã¦èªãã§ãããã¾ã§ã«ã¾ã大ããªãã¼ãã«ãããã¾ãã ä¼ç»æ¸ã¨ããã®ã¯ãæ¸ãããå¿ ãèªã¾ããã¨ãããã®ã§ã¯ããã¾ããããããå¤ãã®ä¼ç»æ¸ã¯ãã»ã¨ãã©èªã¾ããªãéå½ã«ããã¾ãããªããã¨ããã°ãä¼ç»æ¸ã¨ããã®ã¯ããã¦ãããã¤ãæåºãããããã§ããä¸ã¤ã®æ¡ä»¶ã«å¯¾ãã10åã20åãæåºã
RPAè¦ç´ãããâæ¥åâã¨â人âã®é¢ä¿ 人çãªã½ã¼ã¹ãåç´ä½æ¥ãã解æ¾ï¼ é«ä»å 価å¤æ¥åã¸ã®è»¢æã®ããã« è¨å¤§ãªã¢ã¯ã»ã¹ãæ¯ããå±å°éª¨ é«ãå®å®æ§ã¨ããã©ã¼ãã³ã¹ãä¸¡ç« ZOZOTOWNãé¸ãã ã¹ãã¬ã¼ã¸åºç¤ã解説 ãã¸ãã¹ã®æ¨é²ã«ã¯å¿ é ï¼ ZDNetÃãã¤ã¯ãã½ãããè´ãç¹å¥ä¼ç» ä»ãå¿ è¦ãªæ¦ç¥çã»ãã¥ãªãã£ã¨ã¬ããã³ã¹ ãªã¢ã¼ãã¯ã¼ã¯ãæåãããæ¹æ³ å¿ é ã¨ãªãã»ãã¥ãªãã£ãã©ãå¼·åããã å¿ è¦ãªå¯¾ç5ã¤ãç´¹ä» å¹´é5,000件ã®åãåããã«å¯¾å¿ çåã解æ¶ãããã¦ã¼ã¶ã¼ãçããæ ã·ã¹ã ã¿ããªå¹¸ãã«ãªããã«ããã¹ã¯ã®æé©è§£ é«ãå¾æ¥å¡æºè¶³åº¦ã¨å®å¿ã»å®å ¨ æ°æ代ã«ãããçæ³ã®æ¥åç°å¢ãã Anywhere Workspaceãç®æãæªæ¥ ã¨ãã¸å¸å ´ã®æ´»æ§å㸠é«ã¾ãIoTãä¸å¿ã¨ããã¨ãã¸åéã¸ã®æå¾ OSSæ´»ç¨ãæ°ããæ代ã®ãã¸ãã¹ãæã ãã¼ã¿æ´»ç¨ã¯æ¬¡ã®ã¹ãã¼ã¸ã¸ ãã©ãã£ã·ã§ãã«
Googleããã¥ã¡ã³ãã¯ãã©ã¦ã¶ãã¼ã¹ã®Webãªãã£ã¹ã½ããã¦ã§ã¢ã ããã©ã¦ã¶ããªããã°ãªããªãã®ã§ãããããã©ã¦ã¶ã®ä¸ã«åãè¾¼ãã§ãã¾ãæ¹ã使ãåæã¯è¯ãããã ã ããèããã®ãã¯åãããªãããGoogleããã¥ã¡ã³ãã¨Firefoxãè¦äºã«é£æºãããã®ããã®ã½ããã¦ã§ã¢ã ã ä»åç´¹ä»ãããªã¼ãã³ã½ã¼ã¹ã»ã½ããã¦ã§ã¢ã¯gDocsBarããµã¤ããã¼ã«å¸¸é§ããGoogleããã¥ã¡ã³ãã ã gDocsBarã¯Firefoxã¢ããªã³ã¨ãã¦æä¾ãããã½ããã¦ã§ã¢ã§ãã¤ã³ã¹ãã¼ã«ããã¨ãµã¤ããã¼ã«Googleããã¥ã¡ã³ãã表示ãããããã«ãªãããã°ã¤ã³ããã¨ãèªåã®ã¢ã«ã¦ã³ãã®ããã¥ã¡ã³ããä¸è¦§è¡¨ç¤ºãããæ¤ç´¢ããã£ã«ã¿ãªã³ã°ãã§ããã ã¯ãªãã¯ããã¨ãã©ã¦ã¶å ã§è¡¨ç¤ºãããã®ã§ä¾¿å©ã ãããã¦ä½ããã便å©ãªã®ããµã¤ããã¼ä¸é¨ã«ããã¢ãããã¼ãæ©è½ã ãããã«ãã¡ã¤ã«ããã©ãã°ã¢ã³ãããããããã¨ãããã¥
ãå®æ¦ãã¯ç·éç·¨ãã®Part 2ã¯ãWindows XPã«ç¶ãã¦ãExcelã®ç©¶æ¥µãã¯ãã3åã«åãã¦å ¬éãã¾ããããã¾ã§ãã¸ã¿ã«ARENAã«æ²è¼ã«ãªã£ãExcelã®å®æ¦ãã¯ã¯250è¶ ããããä¸æ°ã«ãè¦ããã¾ãï¼ Part1ã®Windows XPåæ§ãå½¹ç«ã¤ãã¯ããã¯ãå¿ ãè¦ã¤ããã¯ãã§ãããã²ããã¯ãã¼ã¯ãã¦ãæ´»ç¨ãã ããã ãã¸ã¿ã«ARENAã§ã¯ãå¼ãç¶ãOutlook Expressãªã©ã®å®æ¦ãã¯ãã¾ã¨ãããã¼ã¸ãæ²è¼ããäºå®ã§ããä¹ãæå¾ ï¼
ãã¿ããªããããããã½ã³ã³ã½ãããããããã½ã¼ã¹ãã¯ã¹ããããããã¹ãã¼ã¬ã³ã§ãã ãã½ã³ã³ããã£ã¨èº«è¿ã§ã楽ãã便å©ãªãã®ã«ããããã«ããã½ã³ã³ã¨ã½ããã®å¯è½æ§ãåºãã¾ãã æ軽ã«ä½¿ããOfficeã½ãããThinkFreeããããã®è©¦ã¿ã®1ã¤ã æ¥æ¬èªçã¯ãã½ã¼ã¹ãã¯ã¹ãããå±ããã¾ãããã²ããå©ç¨ãã ããã
å¹³ç´ ãããPHPããï¼ãããæ顧ããã ããèª ã«ãããã¨ããããã¾ãã 2006å¹´ããéå¶ãã¦ã¾ããã¾ãããPHPããï¼ãã§ããããµã¼ãã¹ã®å©ç¨ç¶æ³ãéã¿ã¾ãã¦ã2018å¹´9æ25æ¥ï¼ç«ææ¥ï¼ããã¡ã¾ãã¦ãµã¼ãã¹ãçµäºããã¦ããã ããã¨ã«ãªãã¾ããã ãµã¼ãã¹çµäºã«ä¼´ãã¾ãã¦ã2018å¹´8æ28æ¥ï¼ç«ææ¥ï¼ãæã¡ã¾ãã¦ãæ°è¦ä¼å¡ç»é²ãªãã³ã«Q&Aæ²ç¤ºæ¿ã¸ã®æ°ããªè³ªåãåçã®æ稿ãåæ¢ããã¦ããã ãã¾ãã ãªãããç»é²ããã ããçæ§ã®å人æ å ±ã«ã¤ãã¾ãã¦ã¯ããµã¼ãã¹çµäºå¾ãå¼ç¤¾ã責任ããã£ã¦æ¶å»ãããã¾ãã ããã¾ã§å¤ãã®çæ§ã«ãå©ç¨ãããã ãã¾ãã¦ãèª ã«ãããã¨ããããã¾ããã ãµã¼ãã¹çµäºã«ä¼´ããçæ§ã«ã¯ãä¸ä¾¿ãããããããã¾ããã¨ãå¿ãããè©«ã³ç³ãä¸ãã¾ãã æ¬ä»¶ã«é¢ãããåãåããã¯ãã¡ããããé¡ããããã¾ãã
Tremend Tech Blog Spreadsheet dojo widget Click here for a demo of the spreadsheet widget. It is based on release 0.3.1 of dojo toolkit.Javascriptã使ã£ããã©ã¦ã¶ä¸ã§åä½ããExcelã·ã¼ãã©ã¤ãã©ãªã Dojoããã¼ã¹ã«ã³ã³ãã¼ãã³ãåããã¦ãã¦ããµã¤ãä¸ãããã¦ã³ãã¼ãå¯è½ã§ãã æ¸ä½ãã©ã¼ãããå¤æ´ããã©ã³ããµã¤ãºãé¢æ°ã¾ã§ä½¿ãã¾ãã ããã¯ãããã§ããã âã©ã¤ãã©ãªã®ãã¦ã³ãã¼ã
FindBugsã使ãã¨ãJavaã®å±éºãªãã°ãç¹å®ããä¿®æ£ãããã¨ãã§ãã¾ãããã®ã¦ãã¼ã¯ãªæ©è½ã¯ãJavaã®ä¸çã«æ°ããéçåæãã¼ã«ã®ãªãã§ãç°å½©ãæ¾ã£ã¦ãã¾ããFindBugsã®ã©ããã©ãç¹å¥ãªã®ãããã®è¨äºã§è§£ãæãããã¨ã«ãã¾ãã
é«æ©è½ãªGroupWareã®Ver.1åºã¾ãããphpGrouWareã®æµãããç»å ´ãã模æ§ã è¨ç½®ãµã¤ããã-->ãENTER è¨ç½®æ¹æ³ã¯ãpukiwikiã-->ãENTER ãããªç»é¢ã§ãã ã¤ã³ã¹ãã¼ã«æ¹æ³ -ãtar.bz2 ãæã£ã¦ãã¦å±éããå ¨é¨æ¸ãè¾¼ã¿å¯è½ã« -http://prdownloads.sourceforge.net/egroupware/eGroupWare-1.0.00.005-1.tar.gz?use_mirror=optusnet mysql -u root -p create database egroupware grant all on egroupware.* to egroupware@localhost identified by 'some_password'; -ãã©ã¦ã¶ããã¢ã¯ã»ã¹ã¦ã£ã¶ã¼ãã«å¾ãè¨å®ãã¦å®äºã -è¨
ãªãªã¼ã¹ãé害æ å ±ãªã©ã®ãµã¼ãã¹ã®ãç¥ãã
ææ°ã®äººæ°ã¨ã³ããªã¼ã®é ä¿¡
å¦çãå®è¡ä¸ã§ã
j次ã®ããã¯ãã¼ã¯
kåã®ããã¯ãã¼ã¯
lãã¨ã§èªã
eã³ã¡ã³ãä¸è¦§ãéã
oãã¼ã¸ãéã
{{#tags}}- {{label}}
{{/tags}}