{"id":109,"date":"2010-02-03T13:06:00","date_gmt":"2010-02-03T04:06:00","guid":{"rendered":"http:\/\/phpdev.comsys-blog.com\/?p=109"},"modified":"2010-02-03T13:06:00","modified_gmt":"2010-02-03T04:06:00","slug":"php%e3%81%a7excel%e3%82%92%e7%94%9f%e6%88%90%e3%81%a7%e3%81%8d%e3%81%aa%e3%81%84%e3%81%8b%e3%81%aa%e3%81%81%ef%bd%9e%e3%81%aa%e3%82%93%e3%81%a6%e6%80%9d%e3%81%a3%e3%81%a6%e3%81%84%e3%81%9f%e3%82%89","status":"publish","type":"post","link":"https:\/\/tamura.jp\/?p=109","title":{"rendered":"PHP\u3067Excel\u3092\u751f\u6210\u3067\u304d\u306a\u3044\u304b\u306a\u3041\uff5e\u306a\u3093\u3066\u601d\u3063\u3066\u3044\u305f\u3089"},"content":{"rendered":"

PHP\u3067Excel\u3092\u751f\u6210\u3067\u304d\u306a\u3044\u304b\u306a\u3041\uff5e\u306a\u3093\u3066\u601d\u3063\u3066\u3044\u305f\u3089<\/p>\n

\u306a\u3093\u3068\u3042\u308b\u3067\u306f\u306a\u3044\u304b<\/p>\n

\u540d\u524d\u306f\u3001[PHPExcel] \u306a\u3093\u3068\u3079\u305f\u306a\u540d\u524d\u3002<\/span><\/p>\n

\u3055\u3063\u305d\u304f\u4f7f\u3063\u3066\u307f\u305f\u3089\u3001\u3053\u3093\u306a\u611f\u3058\u3067\u3067\u304d\u307e\u3057\u305f\u3002<\/span><\/p>\n

\u00a0$reader = PHPExcel_IOFactory::createReader(‘Excel2007’);
\n\u00a0$xl = $reader->load(configure::$excel_folder . ‘\/’ . ‘scg_base.xlsx’);
\n\u00a0$xl->setActiveSheetIndex(0);
\n\u00a0$sheet = $xl->getActiveSheet();<\/p>\n

\u00a0$sheet->setCellValue(‘B1’,$_POST[‘sel_table’]);
\n\u00a0$i = 3;
\n\u00a0foreach($array as $key => $value)
\n\u00a0{
\n\u00a0\u00a0$sheet->setCellValue(‘A’ . $i,$value[‘fieldname’]);
\n\u00a0\u00a0$sheet->setCellValue(‘B’ . $i,$value[‘fieldtype’]);
\n\u00a0\u00a0$sheet->setCellValue(‘C’ . $i,$value[‘len’]);
\n\u00a0\u00a0$sheet->setCellValue(‘D’ . $i,$value[‘period’]);
\n\u00a0\u00a0$sheet->setCellValue(‘E’ . $i,$value[‘max_len’]);
\n\u00a0\u00a0$sheet->setCellValue(‘F’ . $i,$value[‘comment’]);
\n\u00a0\u00a0$sheet->setCellValue(‘G’ . $i,$value[‘type’]);
\n\u00a0\u00a0if($main_key[‘fieldname’] == $value[‘fieldname’])
\n\u00a0\u00a0{
\n\u00a0\u00a0\u00a0$sheet->setCellValue(‘H’. $i,’\u25cb’);
\n\u00a0\u00a0}
\n\u00a0\u00a0else
\n\u00a0\u00a0{
\n\u00a0\u00a0\u00a0$sheet->setCellValue(‘H’. $i,”);
\n\u00a0\u00a0}
\n\u00a0\u00a0if($value[‘field’]) $sheet->setCellValue(‘I’ . $i, ‘\u25cb’);
\n\u00a0\u00a0$sheet->setCellValue(‘J’ . $i,$value[‘ime_mode’]);
\n\u00a0\u00a0if($value[‘search’]) $sheet->setCellValue(‘K’ . $i,’\u25cb’);
\n\u00a0\u00a0if($value[‘necessary’]) $sheet->setCellValue(‘L’ . $i,’\u25cb’);
\n\u00a0\u00a0$i ++;
\n\u00a0}
\n\u00a0$writer = PHPExcel_IOFactory::createWriter($xl, ‘Excel5’);
\n\u00a0$uniqid = uniqid(‘aa’,true);
\n\u00a0$filename = configure::$excel_folder . ‘\/’ . $uniqid .”.xls”;
\n\u00a0$writer->save($filename);<\/p>\n","protected":false},"excerpt":{"rendered":"

PHP\u3067Excel\u3092\u751f\u6210\u3067\u304d\u306a\u3044\u304b\u306a\u3041\uff5e\u306a\u3093\u3066\u601d\u3063\u3066\u3044\u305f\u3089 \u306a\u3093\u3068\u3042\u308b\u3067\u306f\u306a\u3044\u304b \u540d\u524d\u306f\u3001[PHPExcel] \u306a\u3093\u3068\u3079\u305f\u306a\u540d\u524d\u3002 \u3055\u3063\u305d\u304f\u4f7f\u3063\u3066\u307f\u305f\u3089\u3001\u3053\u3093\u306a\u611f\u3058\u3067\u3067\u304d\u307e\u3057\u305f\u3002 \u00a0$reader = PHPExcel_ […]<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[24],"tags":[],"class_list":["post-109","post","type-post","status-publish","format-standard","hentry","category-phpexcel"],"_links":{"self":[{"href":"https:\/\/tamura.jp\/index.php?rest_route=\/wp\/v2\/posts\/109","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/tamura.jp\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/tamura.jp\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/tamura.jp\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/tamura.jp\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=109"}],"version-history":[{"count":0,"href":"https:\/\/tamura.jp\/index.php?rest_route=\/wp\/v2\/posts\/109\/revisions"}],"wp:attachment":[{"href":"https:\/\/tamura.jp\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=109"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/tamura.jp\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=109"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/tamura.jp\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=109"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}