{"id":577,"date":"2017-03-03T15:26:33","date_gmt":"2017-03-03T08:26:33","guid":{"rendered":"http:\/\/www.yellowweb.id\/blog\/?p=577"},"modified":"2017-03-03T15:26:33","modified_gmt":"2017-03-03T08:26:33","slug":"ekspor-php-ke-excel","status":"publish","type":"post","link":"https:\/\/www.yellowweb.id\/blog\/ekspor-php-ke-excel\/","title":{"rendered":"Ekspor PHP ke Excel"},"content":{"rendered":"

Bagaimana cara melakukan ekspor data dari file.php untuk dijadikan ke dalam format ekstensi file.xls<\/span>
\nTutorial kali ini kita akan mencoba melakukan hal tersebut. Sangat di perlukan ketika kita ingin menampilkan data tersebut tidak dalam browser melainkan file yang berbeda (dalam hal ini format file .xls).
\n<\/p>\n

Baik untuk melakukan hal tersebut, persiapkan dulu databasenya yang ingin kita tarik(fetch). Kemudian jangan lupa untuk mendownload plugin PHPExcel<\/a>,<\/span> yang akan kita gunakan untuk melakukan ekspor data.<\/p>\n

Lihat skrip berikut, sesuaikan dengan database yang sudah dibuat.<\/p>\n

<?php\r\n\r\n#buat koneksi database\r\ninclude \"koneksi.php\";\r\n\r\n#query sql mengambil data dari databse\r\n$sql = \"SELECT * FROM tbl_biodata ORDER BY id_pegawai DESC\";\r\n$query = mysql_query($sql) or die (mysql_error());\r\n\r\n#sertakan path\/lokasi plugin phpexcel\r\nrequire_once dirname(__FILE__).'\/phpexcel-new\/Classes\/PHPExcel.php';\r\n\r\n\r\n$objPHPExcel = new PHPExcel();\r\n\r\n\/\/ Set properties\r\n$objPHPExcel->getProperties()->setCreator(\"Faroq\")\r\n\t\t\t\t\t\t\t\t->setLastModifiedBy(\"Faroq Modif\")\r\n\t\t\t\t\t\t\t\t->setTitle(\"Data Karyawan\")\r\n\t\t\t\t\t\t\t\t->setSubject(\"Data Karyawan\")\r\n\t\t\t\t\t\t\t\t->setDescription(\"Laporan Data Karyawan\")\r\n\t\t\t\t\t\t\t\t->setKeywords(\"Data Karyawan Excel\")\r\n\t\t\t\t\t\t\t\t->setCategory(\"Umum\");\r\n\r\n\r\n$row = 2; \/\/ mulai dari baris ke dua\r\n\r\n\/\/Tulis judul tabel\r\n\r\n$objPHPExcel->setActiveSheetIndex(0)\r\n\t\t\t->SetCellValue('A'.$row, 'Nomor Urut')\r\n\t\t\t->SetCellValue('B'.$row, 'ID')\r\n\t\t\t->SetCellValue('C'.$row, 'Nama Pegawai')\r\n\t\t\t->SetCellValue('D'.$row, 'Alamat')\r\n\t\t\t->SetCellValue('E'.$row, 'Jenis Kelamin')\r\n\t\t\t->SetCellValue('F'.$row, 'Email')\r\n\t\t\t->SetCellValue('G'.$row, 'Tanggal Lahir')\r\n\t\t\t->SetCellValue('H'.$row, 'Divisi')\r\n\t\t\t->SetCellValue('I'.$row, 'Hobi');\r\n\t\t\t\r\n\r\n\r\n$nomor = 1; \/\/nomor urut\r\n$row++;\r\n\r\n\/\/cetak dari database\r\nwhile($data = mysql_fetch_array($query)){\r\n\t$objPHPExcel->setActiveSheetIndex(0)\r\n\t\t\t->SetCellValue('A'.$row, $nomor)\r\n\t\t\t->SetCellValue('B'.$row, $data['id_pegawai'])\r\n\t\t\t->SetCellValue('C'.$row, $data['nama_pegawai'])\r\n\t\t\t->SetCellValue('D'.$row, $data['alamat'])\r\n\t\t\t->SetCellValue('E'.$row, $data['jenis_kelamin'])\r\n\t\t\t->SetCellValue('F'.$row, $data['email'])\r\n\t\t\t->SetCellValue('G'.$row, $data['tgl_lahir'])\r\n\t\t\t->SetCellValue('H'.$row, $data['divisi'])\r\n\t\t\t->SetCellValue('I'.$row, $data['tbl_hobi']);\r\n\r\n\t\t\t$row++;\r\n\t\t\t$nomor++;\/\/membuat nomor urut\r\n\r\n}\r\n\r\n\/\/membuat nama worksheet\r\n$objPHPExcel->getActiveSheet()->setTitle('Data Karyawan');\r\n$objPHPExcel->setActiveSheetIndex(0);\r\n\r\n\r\n\r\n\r\n\/\/ Redirect output to a client\u2019s web browser (Excel2007)\r\nheader('Content-Type: application\/vnd.openxmlformats-officedocument.spreadsheetml.sheet');\r\nheader('Content-Disposition: attachment;filename=\"Data Karyawan.xlsx\"');\r\nheader('Cache-Control: max-age=0');\r\n\/\/ If you're serving to IE 9, then the following may be needed\r\nheader('Cache-Control: max-age=1');\r\n\r\n\/\/ If you're serving to IE over SSL, then the following may be needed\r\nheader ('Expires: Mon, 26 Jul 1997 05:00:00 GMT'); \/\/ Date in the past\r\nheader ('Last-Modified: '.gmdate('D, d M Y H:i:s').' GMT'); \/\/ always modified\r\nheader ('Cache-Control: cache, must-revalidate'); \/\/ HTTP\/1.1\r\nheader ('Pragma: public'); \/\/ HTTP\/1.0\r\n\r\n$objWriter = PHPExcel_IOFactory::createWriter($objPHPExcel, 'Excel2007');\r\n$objWriter->save('php:\/\/output');\r\nexit;<\/pre>\n
Oke kita lihat penjalasan skripnya,<\/p>\n
<?php\r\n\r\n#buat koneksi database\r\ninclude \"koneksi.php\";\r\n\r\n#query sql mengambil data dari databse\r\n$sql = \"SELECT * FROM tbl_biodata ORDER BY id_pegawai DESC\";\r\n$query = mysql_query($sql) or die (mysql_error());\r\n\r\n#sertakan path\/lokasi plugin phpexcel\r\nrequire_once dirname(__FILE__).'\/phpexcel-new\/Classes\/PHPExcel.php';<\/pre>\n
Buat koneksinya, lalu jangan lupa untuk membuat query SQL, untuk memilih data dari tabel mana yang akan kita tampilkan.<\/p>\n
Jangan lupa posisikan Plugin PHPExcel sejajar dengan file proses atau output hasil ekspor.<\/p>\n
$objPHPExcel = new PHPExcel();\r\n\r\n\/\/ Set properties\r\n$objPHPExcel->getProperties()->setCreator(\"Faroq\")\r\n\t\t\t\t\t\t\t\t->setLastModifiedBy(\"Faroq Modif\")\r\n\t\t\t\t\t\t\t\t->setTitle(\"Data Karyawan\")\r\n\t\t\t\t\t\t\t\t->setSubject(\"Data Karyawan\")\r\n\t\t\t\t\t\t\t\t->setDescription(\"Laporan Data Karyawan\")\r\n\t\t\t\t\t\t\t\t->setKeywords(\"Data Karyawan Excel\")\r\n\t\t\t\t\t\t\t\t->setCategory(\"Umum\");\r\n\r\n\r\n$row = 2; \/\/ mulai dari baris ke dua\r\n\r\n\/\/Tulis judul tabel\r\n\r\n$objPHPExcel->setActiveSheetIndex(0)\r\n\t\t\t->SetCellValue('A'.$row, 'Nomor Urut')\r\n\t\t\t->SetCellValue('B'.$row, 'ID')\r\n\t\t\t->SetCellValue('C'.$row, 'Nama Pegawai')\r\n\t\t\t->SetCellValue('D'.$row, 'Alamat')\r\n\t\t\t->SetCellValue('E'.$row, 'Jenis Kelamin')\r\n\t\t\t->SetCellValue('F'.$row, 'Email')\r\n\t\t\t->SetCellValue('G'.$row, 'Tanggal Lahir')\r\n\t\t\t->SetCellValue('H'.$row, 'Divisi')\r\n\t\t\t->SetCellValue('I'.$row, 'Hobi');\r\n\t\t\t\r\n\r\n\r\n$nomor = 1; \/\/nomor urut\r\n$row++;\r\n\r\n\/\/cetak dari database\r\nwhile($data = mysql_fetch_array($query)){\r\n\t$objPHPExcel->setActiveSheetIndex(0)\r\n\t\t\t->SetCellValue('A'.$row, $nomor)\r\n\t\t\t->SetCellValue('B'.$row, $data['id_pegawai'])\r\n\t\t\t->SetCellValue('C'.$row, $data['nama_pegawai'])\r\n\t\t\t->SetCellValue('D'.$row, $data['alamat'])\r\n\t\t\t->SetCellValue('E'.$row, $data['jenis_kelamin'])\r\n\t\t\t->SetCellValue('F'.$row, $data['email'])\r\n\t\t\t->SetCellValue('G'.$row, $data['tgl_lahir'])\r\n\t\t\t->SetCellValue('H'.$row, $data['divisi'])\r\n\t\t\t->SetCellValue('I'.$row, $data['tbl_hobi']);\r\n\r\n\t\t\t$row++;\r\n\t\t\t$nomor++;\/\/membuat nomor urut\r\n\r\n}\r\n\r\n\/\/membuat nama worksheet\r\n$objPHPExcel->getActiveSheet()->setTitle('Data Karyawan');\r\n$objPHPExcel->setActiveSheetIndex(0);<\/pre>\n
Memulai mencetak dengan melakukan pembuatan kolom pada tabel heading dan isi yang diambil dari tabel yang ada di database dengan menggunakan fungsi while.<\/p>\n
Kemudian pada perintah diatas membuat nama sheet pada file yang akan di ekspor.<\/p>\n
Penjelasan sekrip berikutnya adalah, untuk membuat output\/ file berekstensi .xlsx atau file tersebut berformat file excel 2007.<\/p>\n
\/\/ Redirect output to a client\u2019s web browser (Excel2007)\r\nheader('Content-Type: application\/vnd.openxmlformats-officedocument.spreadsheetml.sheet');\r\nheader('Content-Disposition: attachment;filename=\"Data Karyawan.xlsx\"');\r\nheader('Cache-Control: max-age=0');\r\n\/\/ If you're serving to IE 9, then the following may be needed\r\nheader('Cache-Control: max-age=1');\r\n\r\n\/\/ If you're serving to IE over SSL, then the following may be needed\r\nheader ('Expires: Mon, 26 Jul 1997 05:00:00 GMT'); \/\/ Date in the past\r\nheader ('Last-Modified: '.gmdate('D, d M Y H:i:s').' GMT'); \/\/ always modified\r\nheader ('Cache-Control: cache, must-revalidate'); \/\/ HTTP\/1.1\r\nheader ('Pragma: public'); \/\/ HTTP\/1.0\r\n\r\n$objWriter = PHPExcel_IOFactory::createWriter($objPHPExcel, 'Excel2007');\r\n$objWriter->save('php:\/\/output');\r\nexit;<\/pre>\n
Silahkan mencobanya teman-teman, dan sampai jumpa lagi di artikel tutorial yang berikutnya. Ciao…<\/p>\n","protected":false},"excerpt":{"rendered":"
Bagaimana cara melakukan ekspor data dari file.php untuk dijadikan ke dalam format ekstensi file.xls Tutorial kali ini kita akan mencoba melakukan hal tersebut. Sangat di perlukan ketika kita ingin menampilkan data tersebut tidak dalam browser melainkan file yang berbeda (dalam hal ini format file .xls).<\/p>\n","protected":false},"author":1,"featured_media":582,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[190,110,11],"tags":[192,309,307,311,308,310,88,222],"class_list":["post-577","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-mysql","category-php","category-tutorial","tag-database","tag-ekspor","tag-excel","tag-export","tag-impor","tag-import","tag-php","tag-sql"],"yoast_head":"\nEkspor PHP ke Excel - YELLOWWEB.ID<\/title>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/www.yellowweb.id\/blog\/ekspor-php-ke-excel\/\" \/>\n<meta property=\"og:locale\" content=\"en_GB\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Ekspor PHP ke Excel - YELLOWWEB.ID\" \/>\n<meta property=\"og:description\" content=\"Bagaimana cara melakukan ekspor data dari file.php untuk dijadikan ke dalam format ekstensi file.xls Tutorial kali ini kita akan mencoba melakukan hal tersebut. Sangat di perlukan ketika kita ingin menampilkan data tersebut tidak dalam browser melainkan file yang berbeda (dalam hal ini format file .xls).\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.yellowweb.id\/blog\/ekspor-php-ke-excel\/\" \/>\n<meta property=\"og:site_name\" content=\"YELLOWWEB.ID\" \/>\n<meta property=\"article:published_time\" content=\"2017-03-03T08:26:33+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/i0.wp.com\/www.yellowweb.id\/blog\/wp-content\/uploads\/2017\/03\/phptoexcel.jpeg?fit=750%2C422&ssl=1\" \/>\n\t<meta property=\"og:image:width\" content=\"750\" \/>\n\t<meta property=\"og:image:height\" content=\"422\" \/>\n\t<meta property=\"og:image:type\" content=\"image\/jpeg\" \/>\n<meta name=\"author\" content=\"yellowweb\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"yellowweb\" \/>\n\t<meta name=\"twitter:label2\" content=\"Estimated reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"5 minutes\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\\\/\\\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\\\/\\\/www.yellowweb.id\\\/blog\\\/ekspor-php-ke-excel\\\/#article\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/www.yellowweb.id\\\/blog\\\/ekspor-php-ke-excel\\\/\"},\"author\":{\"name\":\"yellowweb\",\"@id\":\"https:\\\/\\\/www.yellowweb.id\\\/blog\\\/#\\\/schema\\\/person\\\/75188044e080844724e381ab6a5b9829\"},\"headline\":\"Ekspor PHP ke Excel\",\"datePublished\":\"2017-03-03T08:26:33+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\\\/\\\/www.yellowweb.id\\\/blog\\\/ekspor-php-ke-excel\\\/\"},\"wordCount\":190,\"image\":{\"@id\":\"https:\\\/\\\/www.yellowweb.id\\\/blog\\\/ekspor-php-ke-excel\\\/#primaryimage\"},\"thumbnailUrl\":\"https:\\\/\\\/www.yellowweb.id\\\/blog\\\/wp-content\\\/uploads\\\/2017\\\/03\\\/phptoexcel.jpeg\",\"keywords\":[\"database\",\"ekspor\",\"excel\",\"export\",\"impor\",\"import\",\"php\",\"sql\"],\"articleSection\":[\"MySQL\",\"PHP\",\"Tutorial\"],\"inLanguage\":\"en-GB\"},{\"@type\":\"WebPage\",\"@id\":\"https:\\\/\\\/www.yellowweb.id\\\/blog\\\/ekspor-php-ke-excel\\\/\",\"url\":\"https:\\\/\\\/www.yellowweb.id\\\/blog\\\/ekspor-php-ke-excel\\\/\",\"name\":\"Ekspor PHP ke Excel - YELLOWWEB.ID\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/www.yellowweb.id\\\/blog\\\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\\\/\\\/www.yellowweb.id\\\/blog\\\/ekspor-php-ke-excel\\\/#primaryimage\"},\"image\":{\"@id\":\"https:\\\/\\\/www.yellowweb.id\\\/blog\\\/ekspor-php-ke-excel\\\/#primaryimage\"},\"thumbnailUrl\":\"https:\\\/\\\/www.yellowweb.id\\\/blog\\\/wp-content\\\/uploads\\\/2017\\\/03\\\/phptoexcel.jpeg\",\"datePublished\":\"2017-03-03T08:26:33+00:00\",\"author\":{\"@id\":\"https:\\\/\\\/www.yellowweb.id\\\/blog\\\/#\\\/schema\\\/person\\\/75188044e080844724e381ab6a5b9829\"},\"breadcrumb\":{\"@id\":\"https:\\\/\\\/www.yellowweb.id\\\/blog\\\/ekspor-php-ke-excel\\\/#breadcrumb\"},\"inLanguage\":\"en-GB\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\\\/\\\/www.yellowweb.id\\\/blog\\\/ekspor-php-ke-excel\\\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-GB\",\"@id\":\"https:\\\/\\\/www.yellowweb.id\\\/blog\\\/ekspor-php-ke-excel\\\/#primaryimage\",\"url\":\"https:\\\/\\\/www.yellowweb.id\\\/blog\\\/wp-content\\\/uploads\\\/2017\\\/03\\\/phptoexcel.jpeg\",\"contentUrl\":\"https:\\\/\\\/www.yellowweb.id\\\/blog\\\/wp-content\\\/uploads\\\/2017\\\/03\\\/phptoexcel.jpeg\",\"width\":750,\"height\":422,\"caption\":\"phptoexcel\"},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\\\/\\\/www.yellowweb.id\\\/blog\\\/ekspor-php-ke-excel\\\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\\\/\\\/www.yellowweb.id\\\/blog\\\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Ekspor PHP ke Excel\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\\\/\\\/www.yellowweb.id\\\/blog\\\/#website\",\"url\":\"https:\\\/\\\/www.yellowweb.id\\\/blog\\\/\",\"name\":\"YELLOWWEB.ID\",\"description\":\"Kursus Web Design | Kursus Web Programming | Mobile Web Apps | Digital Marketing\",\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\\\/\\\/www.yellowweb.id\\\/blog\\\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"en-GB\"},{\"@type\":\"Person\",\"@id\":\"https:\\\/\\\/www.yellowweb.id\\\/blog\\\/#\\\/schema\\\/person\\\/75188044e080844724e381ab6a5b9829\",\"name\":\"yellowweb\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-GB\",\"@id\":\"https:\\\/\\\/secure.gravatar.com\\\/avatar\\\/5afd1bfac26e9377e8f5e36afb624cf3690dd31cb07c3961dfbc736b9ff1912f?s=96&d=mm&r=g\",\"url\":\"https:\\\/\\\/secure.gravatar.com\\\/avatar\\\/5afd1bfac26e9377e8f5e36afb624cf3690dd31cb07c3961dfbc736b9ff1912f?s=96&d=mm&r=g\",\"contentUrl\":\"https:\\\/\\\/secure.gravatar.com\\\/avatar\\\/5afd1bfac26e9377e8f5e36afb624cf3690dd31cb07c3961dfbc736b9ff1912f?s=96&d=mm&r=g\",\"caption\":\"yellowweb\"},\"sameAs\":[\"https:\\\/\\\/www.yellowweb.id\"],\"url\":\"https:\\\/\\\/www.yellowweb.id\\\/blog\\\/author\\\/yellowweb\\\/\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"Ekspor PHP ke Excel - YELLOWWEB.ID","robots":{"index":"index","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"canonical":"https:\/\/www.yellowweb.id\/blog\/ekspor-php-ke-excel\/","og_locale":"en_GB","og_type":"article","og_title":"Ekspor PHP ke Excel - YELLOWWEB.ID","og_description":"Bagaimana cara melakukan ekspor data dari file.php untuk dijadikan ke dalam format ekstensi file.xls Tutorial kali ini kita akan mencoba melakukan hal tersebut. Sangat di perlukan ketika kita ingin menampilkan data tersebut tidak dalam browser melainkan file yang berbeda (dalam hal ini format file .xls).","og_url":"https:\/\/www.yellowweb.id\/blog\/ekspor-php-ke-excel\/","og_site_name":"YELLOWWEB.ID","article_published_time":"2017-03-03T08:26:33+00:00","og_image":[{"width":750,"height":422,"url":"https:\/\/i0.wp.com\/www.yellowweb.id\/blog\/wp-content\/uploads\/2017\/03\/phptoexcel.jpeg?fit=750%2C422&ssl=1","type":"image\/jpeg"}],"author":"yellowweb","twitter_card":"summary_large_image","twitter_misc":{"Written by":"yellowweb","Estimated reading time":"5 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/www.yellowweb.id\/blog\/ekspor-php-ke-excel\/#article","isPartOf":{"@id":"https:\/\/www.yellowweb.id\/blog\/ekspor-php-ke-excel\/"},"author":{"name":"yellowweb","@id":"https:\/\/www.yellowweb.id\/blog\/#\/schema\/person\/75188044e080844724e381ab6a5b9829"},"headline":"Ekspor PHP ke Excel","datePublished":"2017-03-03T08:26:33+00:00","mainEntityOfPage":{"@id":"https:\/\/www.yellowweb.id\/blog\/ekspor-php-ke-excel\/"},"wordCount":190,"image":{"@id":"https:\/\/www.yellowweb.id\/blog\/ekspor-php-ke-excel\/#primaryimage"},"thumbnailUrl":"https:\/\/www.yellowweb.id\/blog\/wp-content\/uploads\/2017\/03\/phptoexcel.jpeg","keywords":["database","ekspor","excel","export","impor","import","php","sql"],"articleSection":["MySQL","PHP","Tutorial"],"inLanguage":"en-GB"},{"@type":"WebPage","@id":"https:\/\/www.yellowweb.id\/blog\/ekspor-php-ke-excel\/","url":"https:\/\/www.yellowweb.id\/blog\/ekspor-php-ke-excel\/","name":"Ekspor PHP ke Excel - YELLOWWEB.ID","isPartOf":{"@id":"https:\/\/www.yellowweb.id\/blog\/#website"},"primaryImageOfPage":{"@id":"https:\/\/www.yellowweb.id\/blog\/ekspor-php-ke-excel\/#primaryimage"},"image":{"@id":"https:\/\/www.yellowweb.id\/blog\/ekspor-php-ke-excel\/#primaryimage"},"thumbnailUrl":"https:\/\/www.yellowweb.id\/blog\/wp-content\/uploads\/2017\/03\/phptoexcel.jpeg","datePublished":"2017-03-03T08:26:33+00:00","author":{"@id":"https:\/\/www.yellowweb.id\/blog\/#\/schema\/person\/75188044e080844724e381ab6a5b9829"},"breadcrumb":{"@id":"https:\/\/www.yellowweb.id\/blog\/ekspor-php-ke-excel\/#breadcrumb"},"inLanguage":"en-GB","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.yellowweb.id\/blog\/ekspor-php-ke-excel\/"]}]},{"@type":"ImageObject","inLanguage":"en-GB","@id":"https:\/\/www.yellowweb.id\/blog\/ekspor-php-ke-excel\/#primaryimage","url":"https:\/\/www.yellowweb.id\/blog\/wp-content\/uploads\/2017\/03\/phptoexcel.jpeg","contentUrl":"https:\/\/www.yellowweb.id\/blog\/wp-content\/uploads\/2017\/03\/phptoexcel.jpeg","width":750,"height":422,"caption":"phptoexcel"},{"@type":"BreadcrumbList","@id":"https:\/\/www.yellowweb.id\/blog\/ekspor-php-ke-excel\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/www.yellowweb.id\/blog\/"},{"@type":"ListItem","position":2,"name":"Ekspor PHP ke Excel"}]},{"@type":"WebSite","@id":"https:\/\/www.yellowweb.id\/blog\/#website","url":"https:\/\/www.yellowweb.id\/blog\/","name":"YELLOWWEB.ID","description":"Kursus Web Design | Kursus Web Programming | Mobile Web Apps | Digital Marketing","potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/www.yellowweb.id\/blog\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"en-GB"},{"@type":"Person","@id":"https:\/\/www.yellowweb.id\/blog\/#\/schema\/person\/75188044e080844724e381ab6a5b9829","name":"yellowweb","image":{"@type":"ImageObject","inLanguage":"en-GB","@id":"https:\/\/secure.gravatar.com\/avatar\/5afd1bfac26e9377e8f5e36afb624cf3690dd31cb07c3961dfbc736b9ff1912f?s=96&d=mm&r=g","url":"https:\/\/secure.gravatar.com\/avatar\/5afd1bfac26e9377e8f5e36afb624cf3690dd31cb07c3961dfbc736b9ff1912f?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/5afd1bfac26e9377e8f5e36afb624cf3690dd31cb07c3961dfbc736b9ff1912f?s=96&d=mm&r=g","caption":"yellowweb"},"sameAs":["https:\/\/www.yellowweb.id"],"url":"https:\/\/www.yellowweb.id\/blog\/author\/yellowweb\/"}]}},"_links":{"self":[{"href":"https:\/\/www.yellowweb.id\/blog\/wp-json\/wp\/v2\/posts\/577","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.yellowweb.id\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.yellowweb.id\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.yellowweb.id\/blog\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/www.yellowweb.id\/blog\/wp-json\/wp\/v2\/comments?post=577"}],"version-history":[{"count":5,"href":"https:\/\/www.yellowweb.id\/blog\/wp-json\/wp\/v2\/posts\/577\/revisions"}],"predecessor-version":[{"id":583,"href":"https:\/\/www.yellowweb.id\/blog\/wp-json\/wp\/v2\/posts\/577\/revisions\/583"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/www.yellowweb.id\/blog\/wp-json\/wp\/v2\/media\/582"}],"wp:attachment":[{"href":"https:\/\/www.yellowweb.id\/blog\/wp-json\/wp\/v2\/media?parent=577"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.yellowweb.id\/blog\/wp-json\/wp\/v2\/categories?post=577"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.yellowweb.id\/blog\/wp-json\/wp\/v2\/tags?post=577"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}