PHP xlsWriteLabel函数代码示例

    $sql .= "where tgl_update>= '" . balikTgl($_POST["frm"]["tgl_awal"]) . " 00:00:00' and tgl_update<='" . balikTgl($_POST["frm"]["tgl_akhir"]) . " 23:59:59'";
    $dataArray = $db_function->selectAllRows($sql);
    $row++;
    xlsWriteLabel($row, 0, "[debitur_trail]");
    $row++;
    foreach ($judulArrayTrail as $col => $data) {
        xlsWriteLabel($row, $col, $data);
    }
    $row++;
    foreach ($dataArray as $data) {
        foreach ($judulArrayTrail as $col => $judul) {
            $kata = $data[$col];
            if (strlen($kata) > 1000) {
                $kata = substr($kata, 0, 1000);
            }
            xlsWriteLabel($row, $col, $kata);
        }
        $row++;
    }
    xlsEOF();
    exit;
}
function xlsBOF()
{
    echo pack("ssssss", 0x809, 0x8, 0x0, 0x10, 0x0, 0x0);
    return;
}
function xlsEOF()
{
    echo pack("ss", 0xa, 0x0);
    return;

$tablehead = 1;
//baris berapa data mulai di tulis
$tablebody = 2;
//penulisan header
header("Pragma: public");
header("Expires: 0");
header("Cache-Control: must-revalidate, post-check=0,pre-check=0");
header("Content-Type: application/force-download");
header("Content-Type: application/octet-stream");
header("Content-Type: application/download");
header("Content-Disposition: attachment;filename=" . $namaFile . "");
header("Content-Transfer-Encoding: binary ");
xlsBOF();
//xlsWriteLabel(0,0,$judul);
$kolomhead = 0;
xlsWriteLabel($tablehead, $kolomhead++, "ID");
xlsWriteLabel($tablehead, $kolomhead++, "NAK");
xlsWriteLabel($tablehead, $kolomhead++, "NAMA");
xlsWriteLabel($tablehead, $kolomhead++, "NIK");
while ($data = mysql_fetch_array($result)) {
    $kolombody = 0;
    //gunakan xlsWriteNumber untuk penulisan nomor dan xlsWriteLabel untuk penulisan string
    xlsWriteNumber($tablebody, $kolombody++, $data['id']);
    xlsWriteLabel($tablebody, $kolombody++, $data['nak']);
    xlsWriteLabel($tablebody, $kolombody++, $data['nama']);
    xlsWriteLabel($tablebody, $kolombody++, $data['nik']);
    $tablebody++;
    //$nourut++;
}
xlsEOF();
exit;

xlsBOF();

/*
Make a top line on your excel sheet at line 1 (starting at 0).
The first number is the row number and the second number is the column, both are start at '0'
*/

xlsWriteLabel(0,0,"Title"); //Top Title

// Make column labels. (at line 3)
xlsWriteLabel(2,0,"Row Name"); // Row Name




$xlsRow = 3;

// Put data records from mysql by while loop.
while($row=mysql_fetch_array($result)){


    xlsWriteLabel($xlsRow,0,$row['']); //Each DB Row




    $xlsRow++;
}
xlsEOF();
exit();
?>

function print_expenselist_excel($array, $groupid)
{
    // http://www.appservnetwork.com/modules.php?name=News&file=article&sid=8
    $members = get_groupmembers($groupid);
    $mcount = count($members);
    // construct array to hold all expense id's per member
    for ($j = 0; $j < $mcount; $j++) {
        $expids[$members[$j]['user_id']] = get_user_expenses_idonly($members[$j]['user_id']);
    }
    // Send Header
    header("Pragma: public");
    header("Expires: 0");
    header("Cache-Control: must-revalidate, post-check=0, pre-check=0");
    header("Content-Type: application/force-download");
    header("Content-Type: application/octet-stream");
    header("Content-Type: application/download");
    header("Content-Disposition: attachment;filename=test.xls ");
    header("Content-Transfer-Encoding: binary ");
    // XLS Data Cell
    $result = mysql_db_query($dbname, "select id,prename,name,sname,grade from appdata where course='{$courseid}' and sec='{$section}'");
    xlsBOF();
    xlsWriteLabel(0, 0, "ID");
    xlsWriteLabel(0, 1, "Date");
    xlsWriteLabel(0, 2, "Type");
    xlsWriteLabel(0, 3, "Description");
    xlsWriteLabel(0, 4, "Amount");
    xlsWriteLabel(0, 5, "Paid by");
    for ($j = 0; $j < $mcount; $j++) {
        if (!empty($members[$j]['username'])) {
            $uname = " (" . $members[$j]['username'] . ")";
        } else {
            $uname = "";
        }
        xlsWriteLabel(0, 6 + $j, $members[$j]['realname'] . $uname);
    }
    $xlsRow = 1;
    $count = count($array);
    for ($i = 0; $i < $count; $i++) {
        if (!empty($array[$i]['username'])) {
            $uname = " (" . $array[$i]['username'] . ")";
        } else {
            $uname = "";
        }
        xlsWriteNumber($xlsRow, 0, $array[$i]['expense_id']);
        xlsWriteLabel($xlsRow, 1, $array[$i]['date']);
        xlsWriteLabel($xlsRow, 2, $array[$i]['type_name']);
        xlsWriteLabel($xlsRow, 3, $array[$i]['description']);
        xlsWriteNumber($xlsRow, 4, $array[$i]['amount']);
        xlsWriteLabel($xlsRow, 5, $array[$i]['realname'] . $uname);
        $x = 0;
        for ($j = 0; $j < $mcount; $j++) {
            // check number of participants for the expense
            if (in_array($array[$i]['expense_id'], $expids[$members[$j]['user_id']])) {
                $x += 1;
            }
        }
        for ($j = 0; $j < $mcount; $j++) {
            // write expense/person for each member
            if (in_array($array[$i]['expense_id'], $expids[$members[$j]['user_id']])) {
                xlsWriteNumber($xlsRow, 6 + $j, number_format($array[$i]['amount'] / $x, DECIMALS, DSEP, TSEP));
            } else {
                xlsWriteLabel($xlsRow, 6 + $j, "");
            }
        }
        $xlsRow++;
    }
    xlsEOF();
    exit;
}

mysql_connect("localhost", "root", "");
mysql_select_db("sms");
$keyword = $_GET['keyword'];
// query menampilkan semua data
$query = "\nSELECT playsms_featureSurvey.keyword, \n        playsms_tblSMSIncoming.in_sender, \n        playsms_tblSMSIncoming.in_message, \n        playsms_tblSMSIncoming.in_datetime\nFROM playsms_featureSurvey, playsms_tblSMSIncoming\nWHERE playsms_featureSurvey.keyword = playsms_tblSMSIncoming.in_keyword AND \n         playsms_featureSurvey.keyword = '{$keyword}'\nORDER BY playsms_tblSMSIncoming.in_datetime DESC\n\n";
$hasil = mysql_query($query);
// nilai awal untuk baris cell
$noBarisCell = 1;
// nilai awal untuk nomor urut data
$noData = 1;
while ($data = mysql_fetch_array($hasil)) {
    // menampilkan no. urut data
    xlsWriteNumber($noBarisCell, 0, $noData);
    // menampilkan data nim
    xlsWriteLabel($noBarisCell, 1, $data['keyword']);
    // menampilkan data nama mahasiswa
    xlsWriteLabel($noBarisCell, 2, $data['in_sender']);
    // menampilkan data nilai
    xlsWriteLabel($noBarisCell, 3, $data['in_message']);
    // menampilkan status kelulusan
    xlsWriteLabel($noBarisCell, 4, $data['in_datetime']);
    // increment untuk no. baris cell dan no. urut data
    $noBarisCell++;
    $noData++;
}
// memanggil function penanda akhir file excel
xlsEOF();
exit;
?>

    xlsWriteLabel(0, 10, mb_convert_encoding("聯絡人", "Big5", "UTF-8"));
    xlsWriteLabel(0, 11, mb_convert_encoding("電話", "Big5", "UTF-8"));
    while ($ly = @mysql_fetch_array($q_mid)) {
        $a++;
        xlsWriteNumber($a, 0, $a);
        xlsWriteLabel($a, 1, $ly[mid]);
        xlsWriteLabel($a, 2, $ly[tid]);
        xlsWriteLabel($a, 3, $ly[midf]);
        xlsWriteLabel($a, 4, $ly[tidf]);
        xlsWriteLabel($a, 5, $ly[mcc]);
        xlsWriteLabel($a, 6, mb_convert_encoding($ly[sob], "Big5", "UTF-8"));
        xlsWriteLabel($a, 7, mb_convert_encoding($ly[webname], "Big5", "UTF-8"));
        xlsWriteLabel($a, 8, mb_convert_encoding($ly[weburl], "Big5", "UTF-8"));
        xlsWriteLabel($a, 9, $ly[comid]);
        xlsWriteLabel($a, 10, mb_convert_encoding($ly[username], "Big5", "UTF-8"));
        xlsWriteLabel($a, 11, mb_convert_encoding($ly[phone], "Big5", "UTF-8"));
    }
    xlsEOF();
    exit;
} else {
    if ($btm == '匯出csv') {
        $Csv_fileName = "taishin_mid_{$hohsn}.csv";
        $fpw = mb_convert_encoding("序,mid,tid,分期mid,分期tid,行業別,營業項目,帳單名稱,網址,統編/身份證,聯絡人,電話", "Big5", "UTF-8") . "\r\n";
        while ($ly = @mysql_fetch_array($q_mid)) {
            $a++;
            $body = sprintf("%03d", $a) . ',' . $ly[mid] . ',' . $ly[tid] . ',' . $ly[midf] . ',' . $ly[tidf] . ',' . $ly[mcc] . ',' . $ly[sob] . ',' . $ly[webname] . ',' . $ly[weburl] . ',' . $ly[comid] . ',' . $ly[username] . ',' . $ly[phone];
            $fpw .= mb_convert_encoding($body, "Big5", "UTF-8") . "\r\n";
        }
        header("Content-disposition: attachment; filename={$Csv_fileName}");
        header("Content-Type: application/save-as");
        echo $fpw;

 public function excel()
 {
     $this->load->helper('exportexcel');
     $namaFile = "users.xls";
     $judul = "users";
     $tablehead = 2;
     $tablebody = 3;
     $nourut = 1;
     //penulisan header
     header("Pragma: public");
     header("Expires: 0");
     header("Cache-Control: must-revalidate, post-check=0,pre-check=0");
     header("Content-Type: application/force-download");
     header("Content-Type: application/octet-stream");
     header("Content-Type: application/download");
     header("Content-Disposition: attachment;filename=" . $namaFile . "");
     header("Content-Transfer-Encoding: binary ");
     xlsBOF();
     xlsWriteLabel(0, 0, $judul);
     $kolomhead = 0;
     xlsWriteLabel($tablehead, $kolomhead++, "no");
     xlsWriteLabel($tablehead, $kolomhead++, "ip_address");
     xlsWriteLabel($tablehead, $kolomhead++, "username");
     xlsWriteLabel($tablehead, $kolomhead++, "password");
     xlsWriteLabel($tablehead, $kolomhead++, "salt");
     xlsWriteLabel($tablehead, $kolomhead++, "email");
     xlsWriteLabel($tablehead, $kolomhead++, "activation_code");
     xlsWriteLabel($tablehead, $kolomhead++, "forgotten_password_code");
     xlsWriteLabel($tablehead, $kolomhead++, "forgotten_password_time");
     xlsWriteLabel($tablehead, $kolomhead++, "remember_code");
     xlsWriteLabel($tablehead, $kolomhead++, "created_on");
     xlsWriteLabel($tablehead, $kolomhead++, "last_login");
     xlsWriteLabel($tablehead, $kolomhead++, "active");
     xlsWriteLabel($tablehead, $kolomhead++, "sex");
     xlsWriteLabel($tablehead, $kolomhead++, "birth_date");
     xlsWriteLabel($tablehead, $kolomhead++, "yxdm");
     xlsWriteLabel($tablehead, $kolomhead++, "jszw");
     xlsWriteLabel($tablehead, $kolomhead++, "jszc");
     xlsWriteLabel($tablehead, $kolomhead++, "jsxl");
     xlsWriteLabel($tablehead, $kolomhead++, "phone");
     xlsWriteLabel($tablehead, $kolomhead++, "jsinfo");
     foreach ($this->users_model->get_all() as $data) {
         $kolombody = 0;
         //ubah xlsWriteLabel menjadi xlsWriteNumber untuk kolom numeric
         xlsWriteNumber($tablebody, $kolombody++, $nourut);
         xlsWriteLabel($tablebody, $kolombody++, $data->ip_address);
         xlsWriteLabel($tablebody, $kolombody++, $data->username);
         xlsWriteLabel($tablebody, $kolombody++, $data->password);
         xlsWriteLabel($tablebody, $kolombody++, $data->salt);
         xlsWriteLabel($tablebody, $kolombody++, $data->email);
         xlsWriteLabel($tablebody, $kolombody++, $data->activation_code);
         xlsWriteLabel($tablebody, $kolombody++, $data->forgotten_password_code);
         xlsWriteNumber($tablebody, $kolombody++, $data->forgotten_password_time);
         xlsWriteLabel($tablebody, $kolombody++, $data->remember_code);
         xlsWriteNumber($tablebody, $kolombody++, $data->created_on);
         xlsWriteNumber($tablebody, $kolombody++, $data->last_login);
         xlsWriteLabel($tablebody, $kolombody++, $data->active);
         xlsWriteLabel($tablebody, $kolombody++, $data->sex);
         xlsWriteLabel($tablebody, $kolombody++, $data->birth_date);
         xlsWriteLabel($tablebody, $kolombody++, $data->yxdm);
         xlsWriteLabel($tablebody, $kolombody++, $data->jszw);
         xlsWriteLabel($tablebody, $kolombody++, $data->jszc);
         xlsWriteLabel($tablebody, $kolombody++, $data->jsxl);
         xlsWriteNumber($tablebody, $kolombody++, $data->phone);
         xlsWriteLabel($tablebody, $kolombody++, $data->jsinfo);
         $tablebody++;
         $nourut++;
     }
     xlsEOF();
     exit;
 }

{
    echo pack("sssss", 0x203, 14, $Row, $Col, 0x0);
    echo pack("d", $Value);
    return;
}
function xlsWriteLabel($Row, $Col, $Value)
{
    $L = strlen($Value);
    echo pack("ssssss", 0x204, 8 + $L, $Row, $Col, 0x0, $L);
    echo $Value;
    return;
}
header("Pragma: public");
header("Expires: 0");
header("Cache-Control: must-revalidate, post-check=0, pre-check=0");
header("Content-Type: application/force-download");
header("Content-Type: application/octet-stream");
header("Content-Type: application/download");
header("Content-Disposition: attachment;filename=Mailing-List.xls");
header("Content-Transfer-Encoding: binary");
xlsBOF();
xlsWriteLabel(0, 0, "#");
xlsWriteLabel(0, 1, "Email");
$query = mysql_query("SELECT * FROM bow_mailinglist_tbl ORDER BY email_ad ASC");
$i = 0;
while ($rows = mysql_fetch_assoc($query)) {
    $i++;
    xlsWriteLabel($i, 0, $i);
    xlsWriteLabel($i, 1, $rows['email_ad']);
}
xlsEOF();

xlsWriteLabel(0, 6, "Note");
xlsWriteLabel(0, 7, "Economico");
$xlsRow = 1;
$tot_economico = 0;
foreach ($r as $key => $field) {
    if ($field['n_pdl'] > "1") {
        $economico = floatval($field['econ']) * floatval($field['n_pdl']);
        $compenso = floatval($field['prz']) * floatval($field['n_pdl']);
    } else {
        $economico = floatval($field['econ']);
        $compenso = floatval($field['prz']);
    }
    xlsWriteLabel($xlsRow, 0, $field['n_call']);
    xlsWriteLabel($xlsRow, 1, Inverti_Data($field['data_att']));
    xlsWriteLabel($xlsRow, 2, $field['cliente']);
    xlsWriteLabel($xlsRow, 3, $field['Comune'] . " (" . $field['Targa'] . ")");
    xlsWriteLabel($xlsRow, 4, $field['tecnico']);
    xlsWriteLabel($xlsRow, 5, $field['tipo']);
    xlsWriteLabel($xlsRow, 6, $field['note_call']);
    xlsWriteNumber($xlsRow, 7, sprintf("%.2f", $economico));
    $tot_economico += $economico;
    $xlsRow++;
}
xlsWriteLabel($xlsRow, 0, "Totale: ");
xlsWriteNumber($xlsRow, 1, sprintf("%.2f", $tot_economico));
xlsWriteLabel($xlsRow + 1, 0, "Aaaaaa: ");
xlsWriteNumber($xlsRow + 1, 1, "579,33");
xlsWriteLabel($xlsRow + 2, 0, "float con virgola: ");
xlsWriteNumber($xlsRow + 2, 1, sprintf("%,2f", $tot_economico));
xlsEOF();
exit;

function do_invoice_download()
{
    global $smarty;
    global $rpcpbx;
    global $friconf;
    $rpcres = sendrequest($rpcpbx->base_dbquery("select src,dst,calldate,billsec,cost from billinginvoice where calldate >= '" . $_REQUEST['year'] . "-" . $_REQUEST['month'] . "-01 00:00:00' and calldate <= '" . $_REQUEST['year'] . "-" . $_REQUEST['month'] . "-31 23:59:59' order by calldate desc"), 0);
    #CSV FORMAT
    if ($_REQUEST['format'] == 'csv') {
        header("Pragma: public");
        header("Expires: 0");
        header("Cache-Control: must-revalidate, post-check=0, pre-check=0");
        Header("Content-Type: application/vnd.ms-excel");
        Header("Content-Disposition: attachment; filename=billing_invoice.csv");
        header("Content-Transfer-Encoding: binary ");
        echo "caller,called,calldate,billsec,cost\n";
        foreach ($rpcres['result_array'] as $each) {
            echo $each['src'] . ',' . $each['dst'] . ',' . $each['calldate'] . ',' . $each['billsec'] . ',' . $each['cost'] . ',' . "\n";
        }
        exit;
    } else {
        include "../include/exportxls.php";
        header("Pragma: public");
        header("Expires: 0");
        header("Cache-Control: must-revalidate, post-check=0, pre-check=0");
        Header("Content-Type: application/vnd.ms-excel");
        Header("Content-Disposition: attachment; filename=billing_invoice.xls");
        header("Content-Transfer-Encoding: binary ");
        xlsBOF();
        xlsWriteLabel(0, 0, "src");
        xlsWriteLabel(0, 1, "dst");
        xlsWriteLabel(0, 2, "calldate");
        xlsWriteLabel(0, 3, "billsec");
        xlsWriteLabel(0, 4, "cost");
        $xlsRow = 1;
        foreach ($rpcres['result_array'] as $each) {
            xlsWriteLabel($xlsRow, 0, $each['src']);
            xlsWriteLabel($xlsRow, 1, $each['dst']);
            xlsWriteLabel($xlsRow, 2, $each['calldate']);
            xlsWriteLabel($xlsRow, 3, $each['billsec']);
            xlsWriteLabel($xlsRow, 4, $each['cost']);
            $xlsRow++;
        }
        xlsEOF();
        exit;
    }
    exit;
}

 public function excel()
 {
     $this->load->helper('exportexcel');
     $namaFile = "alumnos.xls";
     $judul = "alumnos";
     $tablehead = 2;
     $tablebody = 3;
     $nourut = 1;
     //penulisan header
     header("Pragma: public");
     header("Expires: 0");
     header("Cache-Control: must-revalidate, post-check=0,pre-check=0");
     header("Content-Type: application/force-download");
     header("Content-Type: application/octet-stream");
     header("Content-Type: application/download");
     header("Content-Disposition: attachment;filename=" . $namaFile . "");
     header("Content-Transfer-Encoding: binary ");
     xlsBOF();
     xlsWriteLabel(0, 0, $judul);
     $kolomhead = 0;
     xlsWriteLabel($tablehead, $kolomhead++, "no");
     xlsWriteLabel($tablehead, $kolomhead++, "NOMBRE_ALUMNO");
     xlsWriteLabel($tablehead, $kolomhead++, "APELLIDO_PATERNO");
     xlsWriteLabel($tablehead, $kolomhead++, "APELLIDO_MATERNO");
     xlsWriteLabel($tablehead, $kolomhead++, "EMAIL");
     xlsWriteLabel($tablehead, $kolomhead++, "TELEFONO");
     xlsWriteLabel($tablehead, $kolomhead++, "DIRECCION");
     xlsWriteLabel($tablehead, $kolomhead++, "SEXO");
     xlsWriteLabel($tablehead, $kolomhead++, "FECHA_NACIMIENTO");
     xlsWriteLabel($tablehead, $kolomhead++, "DNI");
     xlsWriteLabel($tablehead, $kolomhead++, "AÑO_INGRESO");
     xlsWriteLabel($tablehead, $kolomhead++, "SEMESTRE_INGRESO");
     xlsWriteLabel($tablehead, $kolomhead++, "CARRERA_PROFESIONAL");
     xlsWriteLabel($tablehead, $kolomhead++, "TURNO");
     foreach ($this->model_alumnos->get_all() as $data) {
         $kolombody = 0;
         //ubah xlsWriteLabel menjadi xlsWriteNumber untuk kolom numeric
         xlsWriteNumber($tablebody, $kolombody++, $nourut);
         xlsWriteLabel($tablebody, $kolombody++, $data->NOMBRE_ALUMNO);
         xlsWriteLabel($tablebody, $kolombody++, $data->APELLIDO_PATERNO);
         xlsWriteLabel($tablebody, $kolombody++, $data->APELLIDO_MATERNO);
         xlsWriteLabel($tablebody, $kolombody++, $data->EMAIL);
         xlsWriteLabel($tablebody, $kolombody++, $data->TELEFONO);
         xlsWriteLabel($tablebody, $kolombody++, $data->DIRECCION);
         xlsWriteLabel($tablebody, $kolombody++, $data->SEXO);
         xlsWriteNumber($tablebody, $kolombody++, $data->FECHA_NACIMIENTO);
         xlsWriteNumber($tablebody, $kolombody++, $data->DNI);
         xlsWriteNumber($tablebody, $kolombody++, $data->AÑO_INGRESO);
         xlsWriteLabel($tablebody, $kolombody++, $data->SEMESTRE_INGRESO);
         xlsWriteLabel($tablebody, $kolombody++, $data->CARRERA_PROFESIONAL);
         xlsWriteLabel($tablebody, $kolombody++, $data->TURNO);
         $tablebody++;
         $nourut++;
     }
     xlsEOF();
     exit;
 }

    xlsWriteLabel(0, 12, mb_convert_encoding("次特店網址", "Big5", "UTF-8"));
    while ($ly = @mysql_fetch_array($q_mid)) {
        $a++;
        xlsWriteNumber($a, 0, $a);
        xlsWriteLabel($a, 1, $ly[mid]);
        xlsWriteLabel($a, 2, $ly[tid]);
        xlsWriteLabel($a, 3, mb_convert_encoding($ly[day_3d], "Big5", "UTF-8"));
        xlsWriteLabel($a, 4, mb_convert_encoding($ly[zip], "Big5", "UTF-8"));
        xlsWriteLabel($a, 5, $ly[mcc]);
        xlsWriteLabel($a, 6, mb_convert_encoding($ly[webname], "Big5", "UTF-8"));
        xlsWriteLabel($a, 7, $ly[ints]);
        xlsWriteLabel($a, 8, $ly[red]);
        xlsWriteLabel($a, 9, $ly[yes_3d]);
        xlsWriteLabel($a, 10, $ly[comid]);
        xlsWriteLabel($a, 11, $ly[bossid]);
        xlsWriteLabel($a, 12, $ly[weburl]);
    }
    xlsEOF();
    exit;
} else {
    if ($btm == '匯出csv') {
        $Csv_fileName = "taishin_mid_{$hohsn}.csv";
        $fpw = mb_convert_encoding("特店數,次特店代號,端末機代號,3D生效日,區域別,MCC CODE,招牌/對外名稱,分期,紅利,3D,次特店統編,負責人ID,次特店網址", "Big5", "UTF-8") . "\r\n";
        while ($ly = @mysql_fetch_array($q_mid)) {
            $a++;
            $body = $a . ',' . $ly[mid] . ',' . $ly[tid] . ',' . $ly[day_3d] . ',' . $ly[zip] . ',' . $ly[mcc] . ',' . $ly[webname] . ',' . $ly[ints] . ',' . $ly[red] . ',' . $ly[yes_3d] . ',' . $ly[comid] . ',' . $ly[bossid] . ',' . $ly[weburl];
            $fpw .= mb_convert_encoding($body, "Big5", "UTF-8") . "\r\n";
        }
        header("Content-disposition: attachment; filename={$Csv_fileName}");
        header("Content-Type: application/save-as");
        echo $fpw;

 public function excel()
 {
     $this->load->helper('exportexcel');
     $namaFile = "guru.xls";
     $judul = "guru";
     $tablehead = 0;
     $tablebody = 1;
     $nourut = 1;
     //penulisan header
     header("Pragma: public");
     header("Expires: 0");
     header("Cache-Control: must-revalidate, post-check=0,pre-check=0");
     header("Content-Type: application/force-download");
     header("Content-Type: application/octet-stream");
     header("Content-Type: application/download");
     header("Content-Disposition: attachment;filename=" . $namaFile . "");
     header("Content-Transfer-Encoding: binary ");
     xlsBOF();
     $kolomhead = 0;
     xlsWriteLabel($tablehead, $kolomhead++, "No");
     xlsWriteLabel($tablehead, $kolomhead++, "Nuptk");
     xlsWriteLabel($tablehead, $kolomhead++, "Nama Guru");
     xlsWriteLabel($tablehead, $kolomhead++, "Tmp Lahir");
     xlsWriteLabel($tablehead, $kolomhead++, "Tgl Lahir");
     xlsWriteLabel($tablehead, $kolomhead++, "Golongan");
     xlsWriteLabel($tablehead, $kolomhead++, "Pend Guru");
     xlsWriteLabel($tablehead, $kolomhead++, "Id Matpel");
     foreach ($this->Guru_model->get_all() as $data) {
         $kolombody = 0;
         //ubah xlsWriteLabel menjadi xlsWriteNumber untuk kolom numeric
         xlsWriteNumber($tablebody, $kolombody++, $nourut);
         xlsWriteLabel($tablebody, $kolombody++, $data->nuptk);
         xlsWriteLabel($tablebody, $kolombody++, $data->nama_guru);
         xlsWriteLabel($tablebody, $kolombody++, $data->tmp_lahir);
         xlsWriteLabel($tablebody, $kolombody++, $data->tgl_lahir);
         xlsWriteLabel($tablebody, $kolombody++, $data->golongan);
         xlsWriteLabel($tablebody, $kolombody++, $data->pend_guru);
         xlsWriteNumber($tablebody, $kolombody++, $data->id_matpel);
         $tablebody++;
         $nourut++;
     }
     xlsEOF();
     exit;
 }

    $row = 0;
    // This tells us that we are on the first row
    $first = true;
    // Ok we are on the first row
    // lets make some headers of sorts
    if ($first) {
        $qcol = $q[$row];
        foreach ($qcol as $k => $v) {
            // take the key and make label
            // make it uppper case and replace _ with ' '
            xlsWriteLabel($row, $col, strtoupper(ereg_replace("_", " ", $v)));
            $col++;
        }
        // prepare for the first real data row
        $col = 0;
        $first = false;
    }
    for ($i = 1; $i < count($q); $i++) {
        $qcol = $q[$i];
        // go through the data
        foreach ($qcol as $k => $v) {
            // write it out
            xlsWriteLabel($i, $col, $v);
            $col++;
        }
        // reset col and goto next row
        $col = 0;
    }
    xlsEOF();
    exit;
}

 public function excel()
 {
     $this->load->helper('exportexcel');
     $namaFile = "jadwal.xls";
     $judul = "jadwal";
     $tablehead = 0;
     $tablebody = 1;
     $nourut = 1;
     //penulisan header
     header("Pragma: public");
     header("Expires: 0");
     header("Cache-Control: must-revalidate, post-check=0,pre-check=0");
     header("Content-Type: application/force-download");
     header("Content-Type: application/octet-stream");
     header("Content-Type: application/download");
     header("Content-Disposition: attachment;filename=" . $namaFile . "");
     header("Content-Transfer-Encoding: binary ");
     xlsBOF();
     $kolomhead = 0;
     xlsWriteLabel($tablehead, $kolomhead++, "No");
     xlsWriteLabel($tablehead, $kolomhead++, "Id Tes");
     xlsWriteLabel($tablehead, $kolomhead++, "Id Kelas");
     xlsWriteLabel($tablehead, $kolomhead++, "Tgl Tes");
     foreach ($this->Jadwal_model->get_all() as $data) {
         $kolombody = 0;
         //ubah xlsWriteLabel menjadi xlsWriteNumber untuk kolom numeric
         xlsWriteNumber($tablebody, $kolombody++, $nourut);
         xlsWriteNumber($tablebody, $kolombody++, $data->id_tes);
         xlsWriteNumber($tablebody, $kolombody++, $data->id_kelas);
         xlsWriteLabel($tablebody, $kolombody++, $data->tgl_tes);
         $tablebody++;
         $nourut++;
     }
     xlsEOF();
     exit;
 }