PHP header_excel Exemples

Exemple #1

Fichier : export-pencapaian-kemampuan.php Projet : arvinnizar/flight-recorder

<?php

header_excel('pencapaian-kemampuan.xls');
?>
<style type="text/css">
    .rotation td {
        border-collapse:collapse;
        border: 1px #ccc solid;
    }
    .rotate {
         -moz-transform: rotate(-90.0deg);  /* FF3.5+ */
           -o-transform: rotate(-90.0deg);  /* Opera 10.5 */
      -webkit-transform: rotate(-90.0deg);  /* Saf3.1+, Chrome */
                 filter:  progid:DXImageTransform.Microsoft.BasicImage(rotation=0.083);  /* IE6,IE7 */
             -ms-filter: "progid:DXImageTransform.Microsoft.BasicImage(rotation=0.083)"; /* IE8 */
        text-align: center;
    }
</style>
<table>
    <tr><td colspan="12">REKAP PENCAPAIAN KEMAMPUAN</td></tr>
</table>
<table border="1" width="100%">
    <thead>
        <tr>
            <th width="3%">No.</th>
            <th width="15%" colspan="3" class="left">Description</th>
            <?php 
foreach ($penerbang as $datas) {
    ?>
            <th width="5%"><?php 
    echo $datas->kode_dragon;

Exemple #2

Fichier : export-pendaftar.php Projet : arvinnizar/akn

<?php

header_excel('rekap-pmb.xls');
?>
<table><tr><td colspan="31">REKAP DATA PENDAFTAR</td></table>
<table border="1">
    <thead>
    <tr>
      <th>Tanggal</th>
      <th>No. Daftar</th>
      <th>Nama</th>
      <th>Tempat</th>
      <th>Tanggal Lahir</th>
      <th>Agama</th>
      <th>Jekel</th>
      <th>Alamat</th>
      <th>Desa</th>
      <th>Kecamatan</th>
      <th>Kabupaten</th>
      <th>No. Telp.</th>
      <th>Nama Ayah</th>
      <th>Nama Ibu</th>
      <th>Pekerjaan Ayah</th>
      <th>Pekerjaan Ibu</th>
      <th>Penghasilan Ayah</th>
      <th>Penghasilan Ibu</th>
      <th>Yg Membiayai</th>
      <th>Nama Wali</th>
      <th>Hubungan Wali</th>
      <th>Penghasilan Wali</th>
      <th>Alamat Wali</th>

Exemple #3

Fichier : export-logbook.php Projet : arvinnizar/flight-recorder

<?php

header_excel('logbook' . $penerbang->nama . '.xls');
ini_set('display_errors', 1);
ini_set('display_startup_errors', 1);
error_reporting(E_ALL);
?>
<table>
    <tr>
        <td colspan="18" align="center">REKAP LOGBOOK <?php 
echo $penerbang->nama;
?>
</td>
    </tr>
</table>
<table border="1" width="100%">
    <thead>
        <tr>
            <th width="3%" rowspan="3">No.</th>
            <th colspan="2">YEAR</th>
            <th colspan="2" rowspan="2">AIRCRAFT</th>
            <th rowspan="3">1ST PILOT</th>
            <th rowspan="3">DUAL</th>
            <th rowspan="3">DUTY</th>
            <th colspan="2">DAY FLYING</th>
            <th colspan="2">NIGHT FLYING</th>
            <th colspan="2">FLIGHT TIME</th>
            <th colspan="2">INSTRUMENT FLYING</th>
            <th colspan="2">INSTRUCTION FLYING</th>
        </tr>
        <tr>

Exemple #4

Fichier : penggunaan-dana.php Projet : arvinnizar/anggaran

<?php

header_excel('penggunaan-dana-bos.xls');
?>
<table width="100%"><tr><td align="center" colspan="6"><?php 
echo strtoupper($title);
?>
<br/>Periode: <?php 
echo indo_tgl(date2mysql(get_safe('awal')));
?>
 s.d <?php 
echo indo_tgl(date2mysql(get_safe('akhir')));
?>
</td></tr></table>
<table width="100%">
    <tr><td colspan="2">Nama Madrasah</td><td colspan="4">: <?php 
echo $attr->nama;
?>
</td></tr>
    <tr><td colspan="2">NSM</td><td colspan="4">: <?php 
echo $attr->nsm;
?>
 </td></tr>
    <tr><td colspan="2">Kabupaten</td><td colspan="4">:  <?php 
echo $attr->kabupaten;
?>
</td></tr>
    <tr><td colspan="2">Provinsi</td><td colspan="4">:  <?php 
echo $attr->provinsi;
?>
</td></tr>

Exemple #5

Fichier : buku-kas-umum.php Projet : arvinnizar/anggaran

<?php

header_excel('buku-kas-umum.xls');
foreach ($data as $value) {
}
?>
<table width="100%"><tr><td align="center" colspan="7"><?php 
echo $title;
?>
</td></tr></table>
<table width="100%">
    <tr><td colspan="2">Nama Madrasah</td><td colspan="5">: <?php 
echo $attr->nama;
?>
</td></tr>
    <tr><td colspan="2">Desa/Kecamatan</td><td colspan="5">: <?php 
echo $attr->kelurahan . '/' . $attr->kecamatan;
?>
</td></tr>
    <tr><td colspan="2">Kabupaten</td><td colspan="5">: <?php 
echo $attr->kabupaten;
?>
</td></tr>
    <tr><td colspan="2">Provinsi</td><td colspan="5">: <?php 
echo $attr->provinsi;
?>
</td></tr>
</table>
<table width="100%" border="1">
    <thead>
        <tr>

Exemple #6

Fichier : export-jam-lat-n-ops.php Projet : arvinnizar/flight-recorder

<?php

header_excel('rekap-jam-laps-n-ops-' . get_safe('bulan') . '.xls');
?>
<style type="text/css">
    table td { font-family: Arial; }
</style>
<table>
    <tr>
        <td colspan="2" align="center">WING UDARA 3 LANUD ISWAHJUDI</td><td colspan="3"></td><td colspan="3">Lampiran II</td>
    </tr>
    <tr>
        <td colspan="2" align="center">SKADRON UDARA 3</td><td colspan="3"></td><td colspan="3">Laporan Bulan <?php 
echo substr(indo_tgl(get_safe('bulan') . '-01'), 2, 50);
?>
</td>
    </tr>
    <tr>
        <td colspan="2" align="center"></td><td colspan="3"></td><td colspan="3">Tanggal <?php 
echo indo_tgl(date("Y-m-d"));
?>
</td>
    </tr>
    <tr><td colspan="8"></td></tr>
</table>
<table>
    <tr><td colspan="8" align="center"><b>LAPORAN JAM TERBANG</b></td></tr>
</table>
<!-- REKAP JAM OPS DAN LAT <?php 
echo strtoupper(substr(indo_tgl(get_safe('bulan') . '-01'), 2, 50));
?>

Exemple #7

Fichier : rekap-pajak.php Projet : arvinnizar/anggaran

<?php

header_excel('rekap-pajak.xls');
foreach ($data as $value) {
}
?>
<table width="100%"><tr><td align="center" colspan="10">BUKU PEMBANTU PAJAK<br/>Bulan: <?php 
echo tampil_bulan(get_safe('tanggal') . '-01');
?>
</td></tr></table>
<table width="100%">
    <tr><td colspan="2">Nama Madrasah</td><td colspan="8">: <?php 
echo $attr->nama;
?>
</td></tr>
    <tr><td colspan="2">Desa/Kecamatan</td><td colspan="8">: <?php 
echo $attr->kelurahan . '/' . $attr->kecamatan;
?>
</td></tr>
    <tr><td colspan="2">Kabupaten</td><td colspan="8">: <?php 
echo $attr->kabupaten;
?>
</td></tr>
    <tr><td colspan="2">Provinsi</td><td colspan="8">: <?php 
echo $attr->provinsi;
?>
</td></tr>
</table>
<br/>
<table width="100%" border="1">
    <thead>

Exemple #8

Fichier : export-rekap-progres-2.php Projet : arvinnizar/flight-recorder

<?php

header_excel('export-progres-report2-' . get_safe('tanggal') . '.xls');
?>

<style type="text/css">
    table td { font-family: Arial; }
</style>
<table>
    <tr>
        <td colspan="2" align="center">WING UDARA 3 LANUD ISWAHJUDI</td><td colspan="3"></td><td colspan="2">Lampiran II</td>
    </tr>
    <tr>
        <td colspan="2" align="center">SKADRON UDARA 3</td><td colspan="3"></td><td colspan="2">Laporan Bulan <?php 
echo substr(indo_tgl(get_safe('tanggal') . '-01'), 2, 50);
?>
</td>
    </tr>
    <tr>
        <td colspan="2" align="center"></td><td colspan="3"></td><td colspan="2">Tanggal <?php 
echo indo_tgl(date("Y-m-d"));
?>
</td>
    </tr>
    <tr><td colspan="7"></td></tr>
</table>
<table>
    <tr><td colspan="7" align="center"><b>DATA PELAKSANAAN DAN JAM TERBANG LATIHAN</b></td></tr>
    <tr><td colspan="7" align="center"><b>BULAN <?php 
echo strtoupper(substr(indo_tgl(get_safe('tanggal') . '-01'), 2, 50));
?>

Exemple #9

Fichier : export-currency-penerbang.php Projet : arvinnizar/flight-recorder

<?php

header_excel('currency-penerbang.xls');
?>
<table>
    <tr><td colspan="10">CURRENCY PENERBANG</td></tr>
</table>
<table border="1" width="100%">
    <thead>
        <tr>
            <th width="3%">No.</th>
            <th width="15%" class="left">EXC</th>
            <?php 
foreach ($penerbang as $datas) {
    ?>
            <th width="5%"><?php 
    echo $datas->kode_dragon;
    ?>
</th>
            <?php 
}
?>
        </tr>
    </thead>
    <tbody>
        <?php 
foreach ($data as $key => $value) {
    ?>
        <tr>
            <td align="center"><?php 
    echo ++$key;

Exemple #10

Fichier : export-terbang-penerbang.php Projet : arvinnizar/flight-recorder

<?php

header_excel('rekap-terbang-penerbang-' . get_safe('tanggal') . '.xls');
//tampil_nama_bulan(get_safe('tanggal'))
?>
<style type="text/css">
    table td { font-family: Arial; }
</style>
<table>
    <tr>
        <td colspan="14"></td>
        <td colspan="3">Lampiran I</td>
    </tr>
    <tr>
        <td colspan="14"></td>
        <td colspan="3">Laporan Bulan <?php 
echo tampil_nama_bulan(get_safe('tanggal'));
?>
</td>
    </tr>
    <tr>
        <td colspan="14"></td>
        <td colspan="3">Tanggal <?php 
echo indo_tgl(date("Y-m-d"));
?>
</td>
    </tr>
</table>
<table width="100%">
    <tr>
        <td colspan="17" align="center"><b>DAFTAR PEROLEHAN JAM TERBANG PENERBANG</b></td>

Exemple #11

Fichier : rekap-bank.php Projet : arvinnizar/anggaran

<?php

header_excel('rekap-bank.xls');
foreach ($data as $value) {
}
?>
<table width="100%"><tr><td align="center" colspan="7">BUKU PEMBANTU BANK<br/>Bulan: <?php 
echo tampil_bulan(get_safe('tanggal') . '-01');
?>
</td></tr></table>
<table width="100%">
    <tr><td colspan="2">Nama Madrasah</td><td colspan="5">: <?php 
echo $attr->nama;
?>
</td></tr>
    <tr><td colspan="2">Desa/Kecamatan</td><td colspan="5">: <?php 
echo $attr->kelurahan . '/' . $attr->kecamatan;
?>
</td></tr>
    <tr><td colspan="2">Kabupaten</td><td colspan="5">: <?php 
echo $attr->kabupaten;
?>
</td></tr>
    <tr><td colspan="2">Provinsi</td><td colspan="5">: <?php 
echo $attr->provinsi;
?>
</td></tr>
</table>
<table width="100%" border="1">
    <thead>
        <tr>

Exemple #12

Fichier : penggunaan-dana-non-personal.php Projet : arvinnizar/anggaran

<?php

header_excel('penggunaan-dana-non-personal.xls');
?>
<link rel="stylesheet" href="<?php 
echo base_url('assets/css/printing-A4-landscape.css');
?>
" media="all" /> 
<table width="100%"><tr><td align="center" colspan="<?php 
echo count($data);
?>
"><?php 
echo strtoupper($title);
?>
 <?php 
echo indo_tgl(date2mysql(get_safe('awal')));
?>
 s.d <?php 
echo indo_tgl(date2mysql(get_safe('akhir')));
?>
<br/>TINGKAT MADRASAH</td></tr></table>
<table width="100%">
    <tr><td colspan="2">Nama Madrasah</td><td colspan="4">: <?php 
echo $attr->nama;
?>
</td></tr>
    <tr><td colspan="2">NSM</td><td colspan="4">: <?php 
echo $attr->nsm;
?>
 </td></tr>
    <tr><td colspan="2">Kabupaten</td><td colspan="4">:  <?php 

Exemple #13

Fichier : export-siklus-profisiensi.php Projet : arvinnizar/flight-recorder

<?php

header_excel('siklus-profisiensi.xls');
?>
<table>
    <tr><td colspan="10">SIKLUS PROFISIENSI</td></tr>
</table>
<table border="1" width="100%">
    <thead>
        <tr>
            <th width="3%">No.</th>
            <th width="15%" class="left">EXC</th>
            <?php 
foreach ($penerbang as $datas) {
    ?>
            <th width="5%"><?php 
    echo $datas->kode_dragon;
    ?>
</th>
            <?php 
}
?>
        </tr>
    </thead>
    <tbody>
        <?php 
foreach ($data as $key => $value) {
    ?>
        <tr valign="top">
            <td align="center"><?php 
    echo ++$key;

Exemple #14

Fichier : export-ts-pesawat.php Projet : arvinnizar/flight-recorder

<?php

header_excel('rekap-troubleshoot-pswt.xls');
?>
<table>
    <tr>
        <td colspan="8" align="center">REKAP TROUBLESHOOTING PESAWAT</td>
    </tr>
</table>
<table width="100%" border="1">
    <thead>
        <tr>
            <th width="3%">No.</th>
            <th width="15%" class="left">Pesawat</th>
            <th width="10%" class="left">Waktu Order</th>
            <th width="17%" class="left">Keterangan</th>
            <th width="10%" class="left">Progres</th>
            <th width="10%" class="left">Waktu Selesai</th>
            <th width="17%" class="left">Keterangan</th>
            <th width="10%" class="left">Status</th>
            <th width="10%" class="left">Status 781K</th>
        </tr>
    </thead>
    <tbody>
        <?php 
foreach ($data as $key => $val) {
    ?>
        <tr>
            <td align="center"><?php 
    echo ++$key;
    ?>

Exemple #15

Fichier : export-hurt.php Projet : arvinnizar/flight-recorder

<?php

header_excel('rekap-hurt.xls');
?>
<table>
    <tr>
        <td colspan="10">REKAP HURT <?php 
echo get_safe('tanggal') === '' ? 'SEMUA TANGGAL' : 'TANGGAL ' . get_safe('tanggal');
?>
</td>
    </tr>
</table>
<table border="1">
    <thead>
        <tr>
            <th width="3%">No.</th>
            <th width="10%" class="left">tanggal</th>
            <th width="20%" class="left">Penerbang</th>
            <th width="10%" class="left">Kualifikasi</th>
            <th width="15%" class="left">Mission/Exc</th>
            <th width="7%" class="left">F/B Seat</th>
            <th width="10%">Terbang Ke</th>
            <th width="10%">Total<br/>Resiko</th>
            <th width="10%" class="left">Kode<br/>Warna</th>
            <th width="10%" class="left">Remark</th>
        </tr>
    </thead>
    <tbody>
        <?php 
foreach ($data as $key => $value) {
    $warna = 'style="background:' . $value->warna . ';"';

Exemple #16

Fichier : export-event-notice.php Projet : arvinnizar/flight-recorder

<?php

header_excel('EVENT-NOTICE.xls');
?>
<table><tr><td colspan="5">EVENT NOTICE</td></tr></table>
<table border="1">
    <thead>
        <tr>
            <th width="3%">No.</th>
            <th width="10%" class="left">Tanggal</th>
            <th width="30%" class="left">Judul</th>
            <th width="50%" class="left">Keterangan</th>
        </tr>
    </thead>
    <tbody>
        <?php 
foreach ($data as $key => $value) {
    ?>
            <tr>
                <td align="center"><?php 
    echo ++$key;
    ?>
</td>
                <td><?php 
    echo datefmysql($value->tanggal);
    ?>
</td>
                <td><?php 
    echo $value->judul;
    ?>
</td>

Exemple #17

Fichier : buku-pembantu-kas.php Projet : arvinnizar/anggaran

<?php

header_excel('buku-pembantu-kas.xls');
foreach ($data as $value) {
}
?>
<table width="100%"><tr><td align="center" colspan="7"><?php 
echo $title;
?>
</td></tr></table>
<table width="100%">
    <tr><td colspan="2">Nama Madrasah</td><td colspan="5">: <?php 
echo $attr->nama;
?>
</td></tr>
    <tr><td colspan="2">Desa/Kecamatan</td><td colspan="5">: <?php 
echo $attr->kelurahan . '/' . $attr->kecamatan;
?>
</td></tr>
    <tr><td colspan="2">Kabupaten</td><td colspan="5">: <?php 
echo $attr->kabupaten;
?>
</td></tr>
    <tr><td colspan="2">Provinsi</td><td colspan="5">: <?php 
echo $attr->provinsi;
?>
</td></tr>
</table>
<br/>
<table width="100%" border="1">
    <thead>