[B! PHPExcel] masapon49ã®ãƒ–ãƒƒã‚¯ãƒžãƒ¼ã‚¯

masapon49 id:masapon49

PHPExcelã«é–¢ã™ã‚‹masapon49ã®ãƒ–ãƒƒã‚¯ãƒžãƒ¼ã‚¯ (6)

${{author_name}}$

{{{comment_expanded}}}

{{label}}

{{#is_bookmark}}ãƒªã‚¹ãƒˆ{{/is_bookmark}}{{^is_bookmark}}ãƒªãƒ³ã‚¯{{/is_bookmark}}

${{author_name}}$
{{author_name}}{{created}}
{{ #comment }}{{ comment }}{{ /comment }}
- {{ label }}

${{author_name}}$

{{{comment_expanded}}}

{{label}}

{{#is_bookmark}}ãƒªã‚¹ãƒˆ{{/is_bookmark}}{{^is_bookmark}}ãƒªãƒ³ã‚¯{{/is_bookmark}}

ã‚»ãƒ«ã®ãƒ•ã‚©ãƒ³ãƒˆã‚µã‚¤ã‚ºã‚’è¨å®šã™ã‚‹ | PHPExcelã®ãƒŽãƒ¼ãƒˆ
/* 9ãƒã‚¤ãƒ³ãƒˆã‚’è¨å®šã™ã‚‹ */ $sheet->getStyle( 'A1' )->getFont()->setSize( 9 ); /* ãƒ‘ãƒ©ãƒ¡ãƒ¼ã‚¿ã‚’çœç•¥ã™ã‚‹ã¨10ãƒã‚¤ãƒ³ãƒˆã«ãªã‚‹ */ $sheet->getStyle( 'A1' )->getFont()->setSize(); getStyleãƒ¡ã‚½ãƒƒãƒ‰ã§ã‚¹ã‚¿ã‚¤ãƒ«ã‚ªãƒ–ã‚¸ã‚§ã‚¯ãƒˆï¼ˆPHP Excel_Styleï¼‰ã‚’å–å¾—ã—ã€ã•ã‚‰ã«getFontãƒ¡ã‚½ãƒƒãƒ‰ã§ãƒ•ã‚©ãƒ³ãƒˆã‚ªãƒ–ã‚¸ã‚§ã‚¯ãƒˆï¼ˆPHP Excel_Style_Fontï¼‰ã‚’å–å¾—ã€‚setSizeãƒ¡ã‚½ãƒƒãƒ‰ã§ãƒ‘ãƒ©ãƒ¡ãƒ¼ã‚¿ã«å¸Œæœ›ã™ã‚‹ãƒ•ã‚©ãƒ³ãƒˆã‚µã‚¤ã‚ºã‚’æŒ‡å®šã™ã‚‹ã€‚ãªãŠãƒ‘ãƒ©ãƒ¡ãƒ¼ã‚¿ã‚’çœç•¥ã¾ãŸã¯â€ã‚’æŒ‡å®šã—ãŸå ´åˆã¯ã€ãƒ‡ãƒ•ã‚©ãƒ«ãƒˆå€¤ã®10ãŒè¨å®šã•ã‚Œã‚‹ã€‚
masapon49 2014/11/17
ã‚·ãƒ¼ãƒˆå˜ä½ã«ã¯ãƒ•ã‚©ãƒ³ãƒˆæŒ‡å®šãŒå‡ºæ¥ãªã‹ã£ãŸãŒã€ã‚»ãƒ«å˜ä½ã¯å•é¡Œãªãå‡ºæ¥ã‚‹

php

PHPExcel
ãƒªãƒ³ã‚¯
ã‚»ãƒ«ã‚’æ ¼åçŠ¶ã®ç½«ç·šã§å›²ã‚€ | PHPExcelã®ãƒŽãƒ¼ãƒˆ
$sheet->getStyle( 'A1:A3' )->getBorders()->getAllBorders()->setBorderStyle( PHP Excel_Style_Border::BORDER_THIN ); // ã‚«ãƒ©ãƒ x1:y1ã‹ã‚‰x2:y2ã®ç¯„å›²ã®å ´åˆ $sheet->getStyle( PHP Excel_Cell::stringFromColumnIndex($x1).$y1.':'.PHP Excel_Cell::stringFromColumnIndex($x2).$y2 )->getBorders()->getAllBorders()->setBorderStyle( PHP Excel_Style_Border::BORDER_THIN ); getStyleã§è¤‡æ•°ã®ã‚»ãƒ«ã‚’æŒ‡å®šã™ã‚‹ã®ãŒãƒã‚¤ãƒ³ãƒˆã€‚ã‚ã¨ã¯getBordersãƒ¡ã‚½ãƒƒãƒ‰ã€getAllBordersã§å„
masapon49 2014/11/17
ç¯„å›²æŒ‡å®šã§ç½«ç·šæç”»

php

PHPExcel
ãƒªãƒ³ã‚¯
[PHP][Excel][PHPExcel] ãƒœãƒ¼ãƒ€ãƒ¼ã‚’ã¾ã¨ã‚ã¦è¨å®šã™ã‚‹
PHP Excelã®é–¢é€£ã‚µã‚¤ãƒˆã‚’è¦‹ã‚‹ã¨ä¸€ã¤ã®ã‚»ãƒ«ã«å¯¾ã—ã¦ä¸Šä¸‹å·¦å³ã®ãƒœãƒ¼ãƒ€ãƒ¼ã«ã¤ã‘ã‚‹ã¨ãã« //Classesã‚’ãŠã„ãŸãƒ‘ã‚¹ã‹ã‚‰PHP Excel.phpã‚’ã‚¤ãƒ³ã‚¯ãƒ«ãƒ¼ãƒ‰ã™ã‚‹ require_once('Classes/PHP Excel.php'); //æ›¸ãè¾¼ã‚€Excelã®ãƒ‘ã‚¹ define('EXCEL','data/test.xls'); //Excelã®ã‚¯ãƒ©ã‚¹ã‚’ä½œã‚‹ $excel=new PHP Excel(); //ã‚¢ã‚¯ãƒ†ã‚£ãƒ–ãªã‚·ãƒ¼ãƒˆã‚’å–å¾—ã™ã‚‹ $sheet=$excel->getActiveSheet(); //ã‚·ãƒ¼ãƒˆã«åå‰ã‚’ã¤ã‘ã‚‹ $sheet->setTitle('border test'); //A1å‚ç…§ã§å€¤ã‚’å…¥ã‚Œã‚‹ $sheet->setCellValue('A1','test'); //ã‚»ãƒ«ã®ä¸Šã«ç½«ç·šã‚’å¼•ã $sheet->getStyle('A1')->getBorders()
masapon49 2014/11/17
ã‚„ã£ã±ã‚Šä¸€æ‹¬æŒ‡å®šã‚ã£ãŸ

php

PHPExcel
ãƒªãƒ³ã‚¯
PHPExcelã®ä½¿ã„æ–¹ãƒ»ã‚¨ã‚¯ã‚»ãƒ«æ“ä½œæ–¹æ³•ã®ã¾ã¨ã‚
ã‚ã¾ã‚Šåˆ†ã‹ã‚Šã‚„ã™ãã¾ã¨ã¾ã£ã¦ã„ã‚‹ã‚µã‚¤ãƒˆãŒãªã‹ã£ãŸã®ã¨ã€è‹±èªžã‚’èªã¿ãŸããªã„ã®ã§ã€æœ€è¿‘ä½¿ç”¨ã—ãŸéƒ¨åˆ†ã«ã¤ã„ã¦è‡ªåˆ†ç”¨ã«ã¾ã¨ã‚ã¦ãŠãã¾ã™ã€‚ ä½¿ç”¨ã—ã¦ã„ãªã„éƒ¨åˆ†ã¯éšæ™‚è¿½åŠ ã—ã¦ã„ãã¾ã™ã€‚ æœ€ä½Žé™ã®åŸºæœ¬çš„ãªä½¿ã„æ–¹ã¯PHPã§ã‚¨ã‚¯ã‚»ãƒ«ï¼ˆxlsx&xlsï¼‰ã‚’æ‰±ã†æ–¹æ³•ã‚’èªã‚“ã§ãã ã•ã„ã€‚ ãƒ©ã‚¤ãƒ–ãƒ©ãƒªã®èªã¿è¾¼ã¿ //PHP Excelãƒ•ã‚¡ã‚¤ãƒ«ã®èªã¿è¾¼ã¿ include_once ( dirname(__FILE__) . '/Classes/PHP Excel.php'); include_once ( dirname(__FILE__) . '/Classes/PHP Excel/IOFactory.php');
masapon49 2014/11/15
ã‚»ãƒ«ã®æ“ä½œæ–¹æ³•

php

PHPExcel
ãƒªãƒ³ã‚¯
(PHP) PHPExcelã§å‡ºåŠ›æ™‚ã®åŒä¸€ã‚»ãƒ«å†…æ”¹è¡Œã•ã›ã‚‹æ–¹æ³• ï½œ æ—¥ã€…ã®è¦šæ›¸â€¦æ—¥å¸¸ã®ã“ã¨ã‚‚å°‘ã—ã ã‘
ã‚¹ãƒãƒ³ã‚µãƒ¼ãƒ‰ãƒªãƒ³ã‚¯ PHP å‰å›žPHP Excelã§å‡ºåŠ›ã—ãŸã‚“ã§ã™ãŒã€ (CakePHP2.x)Excelå‡ºåŠ›ã®ãŸã‚PHP Excelã‚’è¨ç½®ã—ã¦ã¿ã‚‹ ã‚»ãƒ«å†…ã§æ”¹è¡Œã•ã›ãŸã‹ã£ãŸã®ã§ ãã®æ–¹æ³•ã§ã™ã€‚ ã‚¹ãƒãƒ³ã‚µãƒ¼ãƒ‰ãƒªãƒ³ã‚¯ æ”¹è¡Œã™ã‚‹ãŸã‚ã®å®šæ•°PHP_EOL $PHP Excel->setActiveSheetIndex(0); //0ã¯sheet1(ä¸€ç•ªå·¦ã®ã‚·ãƒ¼ãƒˆ) $sheet = $objPHP Excel->getActiveSheet(); $cell = 'æ”¹è¡Œå‰' . PHP_EOL . 'æ”¹è¡Œå¾Œ'; $sheet->setCellValue('C5', $cell); æœ€åˆï¿¥nã§ã‚„ã£ã¦ã¿ã¦ã‚‚æ”¹è¡Œã•ã‚Œã¾ã›ã‚“ã§ã—ãŸã€‚ OSã«åˆã‚ã›ãŸæ”¹è¡Œã‚³ãƒ¼ãƒ‰ã‚’å…¥ã‚Œã¦ãã‚Œã‚‹å®šæ•°ã®PHP_EOLã‚’ä½¿ã†ã¨ æ”¹è¡ŒãŒã§ãã¾ã—ãŸã€‚ OSã®ç¨®é¡ž æ”¹è¡Œã‚³ãƒ¼ãƒ‰ æ”¹è¡Œã‚³ãƒ¼ãƒ‰æ–‡å— Windows
masapon49 2014/11/14
PHPExcelã®ã‚»ãƒ«å†…æ”¹è¡Œã®æ–¹æ³•Ï†(ï½€Ð´Â´)ï¾’ï¾“ï¾’ï¾“...

php

PHPExcel
ãƒªãƒ³ã‚¯
PHPExcel(ãƒªãƒ•ã‚¡ãƒ¬ãƒ³ã‚¹ï¼‘) Â« Fosters Technical Blog
//ã‚»ãƒ«ã®çµåˆ $sheet->mergeCells('A1:B1'); //ã‚»ãƒ«ã®ä¸å¤®å¯„ã›(æ°´å¹³ä½ç½®) $sheet->getStyle('A1')->getAlignment()->setHorizontal(PHP Excel_Style_Alignment::HORIZONTAL_CENTER); //ã‚»ãƒ«ã®ä¸å¤®å¯„ã›(åž‚ç›´ä½ç½®) $sheet->getStyle('A1')->getAlignment()->setVertical (PHP Excel_Style_Alignment::VERTICAL_CENTER); //ã‚»ãƒ«ã®å¹…è¨å®š $sheet->getColumnDimension('A1')->setWidth(20); //ã‚»ãƒ«ã®é«˜ã•è¨å®š $sheet->getRowDimension('A1')->setRowHeight(20); //ã‚»ãƒ«ã®å¹…è‡ªå‹•è¨å®š $sheet-
masapon49 2013/06/07
ã‚»ãƒ«ã®è‰²ã€…ãªæŒ‡å®š

php

ãƒ—ãƒã‚°ãƒ©ãƒ

PHPExcel
ãƒªãƒ³ã‚¯
1