API tools faq
paste
Advertisement
jamboljack

Export Excell

jamboljack
Sep 7th, 2015
260
0
Never
Add comment
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
PHP 10.75 KB | None | 0 0
raw download clone embed print report
  1. public function exportall() {      
  2.         $objPHPExcel = new PHPExcel();
  3.         // Set properties
  4.         $objPHPExcel->getProperties()
  5.                     ->setCreator("Alumni.umk.ac.id") //creator
  6.                     ->setTitle("Data Export Tabel Kuesioner");  //file title
  7.  
  8.         $objset = $objPHPExcel->setActiveSheetIndex(0); //inisiasi set object
  9.         $objget = $objPHPExcel->getActiveSheet();  //inisiasi get object
  10.  
  11.         $objget->setTitle('Sheet Data'); //sheet title
  12.         //$objset->setCellValue('A1',"This is Sample Excel File"); //insert cell value
  13.         //$objget->getStyle('A1')->getFont()->setBold(true)  // set font weight
  14.         //      ->setSize(15);    //set font size
  15.  
  16.         //table header
  17.         $cols = array("A","B","C","D","E","F","G","H","I","J","K","L","M","N","O","P","Q","R","S","T","U","V","W","X","Y","Z",
  18.             "AA","AB","AC","AD","AE","AF","AG","AH","AI","AJ","AK","AL","AM","AN","AO","AP","AQ","AR","AS","AT","AU","AV","AW",
  19.             "AX","AY","AZ","BA","BB","BC","BD","BE","BF","BG","BH","BI","BJ","BK","BL","BM","BN","BO","BP","BQ","BR","BS","BT",
  20.             "BU","BV","BW","BX","BY","BZ","CA","CB","CC","CD","CE","CF","CG","CH","CI","CJ","CK","CL","CM","CN","CO","CP","CQ",
  21.             "CR","CS","CT","CU","CV","CW","CX","CY","CZ","DA","DB","DC","DD","DE","DF","DG","DH","DI","DJ","DK","DL","DM","DN",
  22.             "DO","DP");
  23.  
  24.         $val = array("kdptimsmh","kdpstmsmh","nimhsmsmh","nmmhsmsmh","telpomsmh","emailmsmh","f301","f302","f303",
  25.                     "f401","f402","f403","f404","f405","f406","f407","f408","f409","f410","f411","f412","f413","f414",
  26.                     "f415","f416","f500","f501","f502","f6","f7","f7a","f8","f901","f902","f903","f904","f905","f906",
  27.                     "f1001","f1002","f1101","f1102","f12","f1301","f1301","f1303","f14","f15","f1601","f1602","f1603",
  28.                     "f1604","f1605","f1606","f1607","f1608","f1609","f1610","f1611","f1612","f1613","f1614","f171",
  29.                     "f172","f173","f174","f175","f176","f177","f178","f179","f1710","f1711","f1712","f1713","f1714","f1715",
  30.                     "f1716","f1717","f1718","f1719","f1720","f1721","f1722","f1723","f1724","f1725","f1726","f1727","f1728",
  31.                     "f1729","f1730","f1731","f1732","f1733","f1734","f1735","f1736","f1737","f1738","f1739","f1740","f1741",
  32.                     "f1742","f1743","f1744","f1745","f1746","f1747","f1748","f1749","f1750","f1751","f1752","f1753","f1754",
  33.                     "f1755","f1756","f1757","f1758");
  34.         for ($a=0; $a<120; $a++)
  35.         {
  36.             $objset->setCellValue($cols[$a].'1', $val[$a]);
  37.             //set borders
  38.             $objget->getStyle($cols[$a].'1')->getBorders()->getTop()->setBorderStyle(PHPExcel_Style_Border::BORDER_THIN);
  39.             //$objget->getStyle($cols[$a].'1')->getBorders,"f1301"(),""->getBottom()(-,"f1303">setBorderStyle(PHPExcel_Style_Border::BORDER_THIN);
  40.             $objget->getStyle($cols[$a].'1')->getBorders()->getLeft()->setBorderStyle(PHPExcel_Style_Border::BORDER_THIN);
  41.             $objget->getStyle($cols[$a].'1')->getBorders()->getRight()->setBorderStyle(PHPExcel_Style_Border::BORDER_THIN);
  42.  
  43.             //set alignment
  44.             $objget->getStyle($cols[$a].'1')->getAlignment()->setHorizontal(PHPExcel_Style_Alignment::HORIZONTAL_CENTER);
  45.             //set font weight
  46.             $objget->getStyle($cols[$a].'1')->getFont()->setBold(true) ;
  47.         }
  48.                
  49.             //taruh baris data disini
  50.             $Tahun1         = $this->uri->segment(4);
  51.             $Tahun2         = $this->uri->segment(5);
  52.  
  53.             $data = array(             
  54.                     'Tahun1' => $Tahun1,
  55.                     'Tahun2' => $Tahun2
  56.                 );         
  57.  
  58.             $datakuesioner = $this->laporan_model->export_all_kuesioner()->result();
  59.             $baris  = 2; // Awal isi Data / Record
  60.             foreach ($datakuesioner as $r) {
  61.                 $objset->setCellValue("A".$baris,''); //mengisi data untuk nomor urut
  62.                 $objset->setCellValue("B".$baris,''); //mengisi data untuk nama
  63.                 $objset->setCellValue("C".$baris,$r->alumni_nim); //mengisi data untuk alamat
  64.                 $objset->setCellValue("D".$baris,$r->alumni_nama); //mengisi data untuk TELP
  65.                 $objset->setCellValue("E".$baris,$r->alumni_hp); //mengisi data untuk TELP
  66.                 $objset->setCellValue("F".$baris,$r->alumni_email); //mengisi data untuk TELP
  67.                 $objset->setCellValue("G".$baris,$r->dikti_f301);
  68.                 $objset->setCellValue("H".$baris,$r->dikti_f302);
  69.                 $objset->setCellValue("I".$baris,$r->dikti_f303);
  70.                 $objset->setCellValue("J".$baris,$r->dikti_f401);
  71.                 $objset->setCellValue("K".$baris,$r->dikti_f402);
  72.                 $objset->setCellValue("L".$baris,$r->dikti_f403);
  73.                 $objset->setCellValue("M".$baris,$r->dikti_f404);
  74.                 $objset->setCellValue("N".$baris,$r->dikti_f405);
  75.                 $objset->setCellValue("O".$baris,$r->dikti_f406);
  76.                 $objset->setCellValue("P".$baris,$r->dikti_f407);
  77.                 $objset->setCellValue("Q".$baris,$r->dikti_f408);
  78.                 $objset->setCellValue("R".$baris,$r->dikti_f409);
  79.                 $objset->setCellValue("S".$baris,$r->dikti_f410);
  80.                 $objset->setCellValue("T".$baris,$r->dikti_f411);
  81.                 $objset->setCellValue("U".$baris,$r->dikti_f412);
  82.                 $objset->setCellValue("V".$baris,$r->dikti_f413);
  83.                 $objset->setCellValue("W".$baris,$r->dikti_f414);
  84.                 $objset->setCellValue("X".$baris,$r->dikti_f415);
  85.                 $objset->setCellValue("Y".$baris,$r->dikti_f416);
  86.                 $objset->setCellValue("Z".$baris,$r->dikti_f500);
  87.                 $objset->setCellValue("AA".$baris,$r->dikti_f501);             
  88.                 $objset->setCellValue("AB".$baris,$r->dikti_f502);
  89.                 $objset->setCellValue("AC".$baris,$r->dikti_f6);
  90.                 $objset->setCellValue("AD".$baris,$r->dikti_f7);
  91.                 $objset->setCellValue("AE".$baris,$r->dikti_f7a);
  92.                 $objset->setCellValue("AF".$baris,$r->dikti_f8);
  93.                 $objset->setCellValue("AG".$baris,$r->dikti_f901);
  94.                 $objset->setCellValue("AH".$baris,$r->dikti_f902);
  95.                 $objset->setCellValue("AI".$baris,$r->dikti_f903);
  96.                 $objset->setCellValue("AJ".$baris,$r->dikti_f904);
  97.                 $objset->setCellValue("AK".$baris,$r->dikti_f905);
  98.                 $objset->setCellValue("AL".$baris,$r->dikti_f906);
  99.                 $objset->setCellValue("AM".$baris,$r->dikti_f1001);
  100.                 $objset->setCellValue("AN".$baris,$r->dikti_f1002);
  101.                 $objset->setCellValue("AO".$baris,$r->dikti_f1101);
  102.                 $objset->setCellValue("AP".$baris,$r->dikti_f1102);
  103.                 $objset->setCellValue("AQ".$baris,$r->dikti_f12);
  104.                 $objset->setCellValue("AR".$baris,$r->dikti_f1301);
  105.                 $objset->setCellValue("AS".$baris,$r->dikti_f1302);
  106.                 $objset->setCellValue("AT".$baris,$r->dikti_f1303);
  107.                 $objset->setCellValue("AU".$baris,$r->dikti_f14);
  108.                 $objset->setCellValue("AV".$baris,$r->dikti_f15);
  109.                 $objset->setCellValue("AW".$baris,$r->dikti_f1601);
  110.                 $objset->setCellValue("AX".$baris,$r->dikti_f1602);
  111.                 $objset->setCellValue("AY".$baris,$r->dikti_f1603);
  112.                 $objset->setCellValue("AZ".$baris,$r->dikti_f1604);
  113.                 $objset->setCellValue("BA".$baris,$r->dikti_f1605);
  114.                 $objset->setCellValue("BB".$baris,$r->dikti_f1606);
  115.                 $objset->setCellValue("BC".$baris,$r->dikti_f1607);
  116.                 $objset->setCellValue("BD".$baris,$r->dikti_f1608);
  117.                 $objset->setCellValue("BE".$baris,$r->dikti_f1609);
  118.                 $objset->setCellValue("BF".$baris,$r->dikti_f1610);
  119.                 $objset->setCellValue("BG".$baris,$r->dikti_f1611);
  120.                 $objset->setCellValue("BH".$baris,$r->dikti_f1612);
  121.                 $objset->setCellValue("BI".$baris,$r->dikti_f1613);
  122.                 $objset->setCellValue("BJ".$baris,$r->dikti_f1614);
  123.                 $objset->setCellValue("BK".$baris,$r->dikti_f171);
  124.                 $objset->setCellValue("BL".$baris,$r->dikti_f172);
  125.                 $objset->setCellValue("BM".$baris,$r->dikti_f173);
  126.                 $objset->setCellValue("BN".$baris,$r->dikti_f174);
  127.                 $objset->setCellValue("BO".$baris,$r->dikti_f175);
  128.                 $objset->setCellValue("BP".$baris,$r->dikti_f176);
  129.                 $objset->setCellValue("BQ".$baris,$r->dikti_f177);
  130.                 $objset->setCellValue("BR".$baris,$r->dikti_f178);
  131.                 $objset->setCellValue("BS".$baris,$r->dikti_f179);
  132.                 $objset->setCellValue("BT".$baris,$r->dikti_f1710);
  133.                 $objset->setCellValue("BU".$baris,$r->dikti_f1711);
  134.                 $objset->setCellValue("BV".$baris,$r->dikti_f1712);
  135.                 $objset->setCellValue("BW".$baris,$r->dikti_f1713);
  136.                 $objset->setCellValue("BX".$baris,$r->dikti_f1714);
  137.                 $objset->setCellValue("BY".$baris,$r->dikti_f1715);
  138.                 $objset->setCellValue("BZ".$baris,$r->dikti_f1716);
  139.                 $objset->setCellValue("CA".$baris,$r->dikti_f1717);
  140.                 $objset->setCellValue("CB".$baris,$r->dikti_f1718);
  141.                 $objset->setCellValue("CC".$baris,$r->dikti_f1719);
  142.                 $objset->setCellValue("CD".$baris,$r->dikti_f1720);
  143.                 $objset->setCellValue("CE".$baris,$r->dikti_f1721);
  144.                 $objset->setCellValue("CF".$baris,$r->dikti_f1722);
  145.                 $objset->setCellValue("CG".$baris,$r->dikti_f1723);
  146.                 $objset->setCellValue("CH".$baris,$r->dikti_f1724);
  147.                 $objset->setCellValue("CI".$baris,$r->dikti_f1725);
  148.                 $objset->setCellValue("CJ".$baris,$r->dikti_f1726);
  149.                 $objset->setCellValue("CK".$baris,$r->dikti_f1727);
  150.                 $objset->setCellValue("CL".$baris,$r->dikti_f1728);
  151.                 $objset->setCellValue("CM".$baris,$r->dikti_f1729);
  152.                 $objset->setCellValue("CN".$baris,$r->dikti_f1730);
  153.                 $objset->setCellValue("CO".$baris,$r->dikti_f1731);
  154.                 $objset->setCellValue("CP".$baris,$r->dikti_f1732);
  155.                 $objset->setCellValue("CQ".$baris,$r->dikti_f1733);
  156.                 $objset->setCellValue("CR".$baris,$r->dikti_f1734);
  157.                 $objset->setCellValue("CS".$baris,$r->dikti_f1735);
  158.                 $objset->setCellValue("CT".$baris,$r->dikti_f1736);
  159.                 $objset->setCellValue("CU".$baris,$r->dikti_f1737);
  160.                 $objset->setCellValue("CV".$baris,$r->dikti_f1738);
  161.                 $objset->setCellValue("CW".$baris,$r->dikti_f1739);
  162.                 $objset->setCellValue("CX".$baris,$r->dikti_f1740);
  163.                 $objset->setCellValue("CY".$baris,$r->dikti_f1741);
  164.                 $objset->setCellValue("CZ".$baris,$r->dikti_f1742);
  165.                 $objset->setCellValue("DA".$baris,$r->dikti_f1743);
  166.                 $objset->setCellValue("DB".$baris,$r->dikti_f1744);
  167.                 $objset->setCellValue("DC".$baris,$r->dikti_f1745);
  168.                 $objset->setCellValue("DD".$baris,$r->dikti_f1746);
  169.                 $objset->setCellValue("DE".$baris,$r->dikti_f1747);
  170.                 $objset->setCellValue("DF".$baris,$r->dikti_f1748);
  171.                 $objset->setCellValue("DG".$baris,$r->dikti_f1749);
  172.                 $objset->setCellValue("DH".$baris,$r->dikti_f1750);
  173.                 $objset->setCellValue("DI".$baris,$r->dikti_f1751);
  174.                 $objset->setCellValue("DJ".$baris,$r->dikti_f1752);
  175.                 $objset->setCellValue("DK".$baris,$r->dikti_f1753);
  176.                 $objset->setCellValue("DL".$baris,$r->dikti_f1754);
  177.                 $objset->setCellValue("DM".$baris,$r->dikti_f1755);
  178.                 $objset->setCellValue("DN".$baris,$r->dikti_f1756);
  179.                 $objset->setCellValue("DO".$baris,$r->dikti_f1757);
  180.                 $objset->setCellValue("DP".$baris,$r->dikti_f1758);
  181.                 $baris++; //looping untuk barisny
  182.             }
  183.            
  184.             $objWriter = IOFactory::createWriter($objPHPExcel, 'Excel2007');
  185.             ob_end_clean();
  186.             // untuk excel 2007 atau yang berekstensi .xlsx
  187.             header('Content-Type: application/vnd.ms-excel');
  188.             header('Content-Disposition: attachment;filename="Data.xlsx"');
  189.             header('Cache-Control: max-age=0');                                    
  190.             $objWriter->save('php://output');
  191.             exit;
  192.     }
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement
Public Pastes
Advertisement
We use cookies for various purposes including analytics. By continuing to use Pastebin, you agree to our use of cookies as described in the Cookies Policy.  OK, I Understand
Not a member of Pastebin yet?
Sign Up, it unlocks many cool features!