PHP xlsBOF函数代码示例

OGeek|极客世界-中国程序员成长平台 › 门户 › 编程› PHP›PHP编程经验

原作者: [db:作者] 来自: [db:来源] 收藏邀请

本文整理汇总了PHP中xlsBOF函数的典型用法代码示例。如果您正苦于以下问题：PHP xlsBOF函数的具体用法？PHP xlsBOF怎么用？PHP xlsBOF使用的例子？那么恭喜您, 这里精选的函数代码示例或许可以为您提供帮助。

在下文中一共展示了xlsBOF函数的19个代码示例，这些例子默认根据受欢迎程度排序。您可以为喜欢或者感觉有用的代码点赞，您的评价将有助于我们的系统推荐出更棒的PHP代码示例。

示例1: excel

 public function excel()
 {
     $this->load->helper('exportexcel');
     $namaFile = "tbl_kelompok.xls";
     $judul = "tbl_kelompok";
     $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++, "Nidn");
     xlsWriteLabel($tablehead, $kolomhead++, "Dpl");
     xlsWriteLabel($tablehead, $kolomhead++, "Lokasi");
     xlsWriteLabel($tablehead, $kolomhead++, "Jumlah");
     foreach ($this->Daftar_kelompok->get_all() as $data) {
         $kolombody = 0;
         //ubah xlsWriteLabel menjadi xlsWriteNumber untuk kolom numeric
         xlsWriteNumber($tablebody, $kolombody++, $nourut);
         xlsWriteLabel($tablebody, $kolombody++, $data->nidn);
         xlsWriteLabel($tablebody, $kolombody++, $data->dpl);
         xlsWriteLabel($tablebody, $kolombody++, $data->lokasi);
         xlsWriteNumber($tablebody, $kolombody++, $data->jumlah);
         $tablebody++;
         $nourut++;
     }
     xlsEOF();
     exit;
 }

开发者ID:Furiansyah，项目名称:lp2m_uinsgd_ac_id，代码行数:38，代码来源:Daftar_kelompok.php

示例2: excel

 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;
 }

开发者ID:rezaple，项目名称:CI_Basecode，代码行数:36，代码来源:Jadwal.php

示例3: excel

 public function excel()
 {
     $this->load->helper('exportexcel');
     $namaFile = "facultad.xls";
     $judul = "facultad";
     $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_FACULTAD");
     foreach ($this->model_facultad->get_all() as $data) {
         $kolombody = 0;
         //ubah xlsWriteLabel menjadi xlsWriteNumber untuk kolom numeric
         xlsWriteNumber($tablebody, $kolombody++, $nourut);
         xlsWriteLabel($tablebody, $kolombody++, $data->NOMBRE_FACULTAD);
         $tablebody++;
         $nourut++;
     }
     xlsEOF();
     exit;
 }

开发者ID:actcux，项目名称:ProyectoNotasQr，代码行数:33，代码来源:Facultad.php

示例4: Create_Excel_File

function Create_Excel_File($ExcelFile, $Data)
{
    header('Content-type: application/x-msexcel');
    header("Content-Disposition: attachment; filename={$ExcelFile}");
    function xlsBOF()
    {
        echo pack("ssssss", 0x809, 0x8, 0x0, 0x10, 0x0, 0x0);
        return;
    }
    function xlsEOF()
    {
        echo pack("ss", 0xa, 0x0);
        return;
    }
    function xlsWriteNumber($Row, $Col, $Value)
    {
        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;
    }
    xlsBOF();
    for ($i = 0; $i < count($Data[0]); $i++) {
        for ($j = 0; $j < count($Data); $j++) {
            $v = $Data[$j][$i];
            xlsWriteLabel($j, $i, $v);
        }
    }
    xlsEOF();
}

开发者ID:dalinhuang，项目名称:concourse，代码行数:36，代码来源:MsXlsGenerator.php

示例5: Create_Excel_File

function Create_Excel_File($ExcelFile, $Data)
{
    header("meta  http-equiv='content-type' content='text/html' charset='gb2312'");
    header('Content-type: application/x-msexcel');
    header("Content-Disposition: attachment; filename={$ExcelFile}");
    function xlsBOF()
    {
        echo pack("ssssss", 0x809, 0x8, 0x0, 0x10, 0x0, 0x0);
        return;
    }
    function xlsEOF()
    {
        echo pack("ss", 0xa, 0x0);
        return;
    }
    function xlsWriteNumber($Row, $Col, $Value)
    {
        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 iconv('UTF-8','GB2312',$Value);
        echo hebrevc($Value);
        return;
    }
    xlsBOF();
    error_log(print_r($Data, true) . "\n", 3, 'error.log');
    for ($i = 0; $i < count($Data[0]); $i++) {
        for ($j = 0; $j < count($Data); $j++) {
            $v = $Data[$j][$i];
            xlsWriteLabel($j, $i, $v);
        }
    }
    xlsEOF();
}

开发者ID:kenlong，项目名称:example，代码行数:39，代码来源:Excel.class.php

示例6: search_excel

 function search_excel($VAR, $construct, $type)
 {
     global $C_translate;
     # set the field list for this method:
     $arr = $construct->method["{$type}"];
     $filename = 'Export.xls';
     # determine what action to take:
     # inline display, download, email, web save
     if ($VAR["type"] == "display") {
         header('Content-type: application/x-msexcel');
         header("Content-Disposition: inline; filename={$filename}");
         header("Content-Description: PHP/INTERBASE Generated Data");
     } else {
         if ($VAR["type"] == "download") {
             header("Content-Disposition: attachment; filename={$filename}");
         } else {
             if ($VAR["type"] == "email") {
                 echo "Email exports not supported yet!";
                 exit;
             } else {
                 if ($VAR["type"] == "email") {
                     echo "Saving exports not supported yet!";
                     exit;
                 }
             }
         }
     }
     # Start the Excel Stream
     xlsBOF();
     /************** BEGIN STANDARD EXPORT SEARCH CODE *********************/
     # set the field list for this method:
     $arr = $construct->method["{$type}"];
     # loop through the field list to create the sql queries
     $arr = $construct->method[$type];
     $field_list = '';
     $i = 0;
     while (list($key, $value) = each($arr)) {
         if ($i == 0) {
             $field_var = $construct->table . '_' . $value;
             $field_list .= AGILE_DB_PREFIX . $construct->table . '.' . $value;
             // determine if this record is linked to another table/field
             if ($construct->field[$value]["asso_table"] != "") {
                 $this->linked[] = array('field' => $value, 'link_table' => $construct->field[$value]["asso_table"], 'link_field' => $construct->field[$value]["asso_field"]);
             }
         } else {
             $field_var = $construct->table . '_' . $value;
             $field_list .= "," . AGILE_DB_PREFIX . $construct->table . "." . $value;
             // determine if this record is linked to another table/field
             if ($construct->field[$value]["asso_table"] != "") {
                 $this->linked[] = array('field' => $value, 'link_table' => $construct->field[$value]["asso_table"], 'link_field' => $construct->field[$value]["asso_field"]);
             }
         }
         $i++;
     }
     # get the search details:
     if (isset($VAR['search_id'])) {
         include_once PATH_CORE . 'search.inc.php';
         $search = new CORE_search();
         $search->get($VAR['search_id']);
     } else {
         echo '<BR> The search terms submitted were invalid!';
     }
     # get the sort order details:
     if (isset($VAR['order_by']) && $VAR['order_by'] != "") {
         $order_by = ' ORDER BY ' . AGILE_DB_PREFIX . $construct->table . '.' . $VAR['order_by'];
         $smarty_order = $VAR['order_by'];
     } else {
         $order_by = ' ORDER BY ' . AGILE_DB_PREFIX . $construct->table . '.' . $construct->order_by;
         $smarty_order = $search->order_by;
     }
     # determine the offset & limit
     if (isset($VAR['page'])) {
         $current_page = $VAR['page'];
     } else {
         $current_page = '0';
     }
     # determine the offset & limit
     if ($current_page == 0) {
         $offset = '0,10000000';
     } else {
         $offset = $current_page * $search->limit - $search->limit . ',' . $search->limit;
     }
     # format saved search string
     $sql = explode(" WHERE ", $search->sql);
     # generate the full query
     $q = preg_replace("/%%fieldList%%/i", $field_list, $search->sql);
     $q = preg_replace("/%%tableList%%/i", AGILE_DB_PREFIX . $construct->table, $q);
     $q = preg_replace("/%%whereList%%/i", "", $q);
     $q .= " " . AGILE_DB_PREFIX . $construct->table . ".site_id = '" . DEFAULT_SITE . "'";
     $q .= $order_by;
     $db =& DB();
     # determine the offset & limit
     $result = $db->Execute($q);
     # error reporting
     if ($result === false) {
         global $C_debug;
         $C_debug->error('core:export.inc.php', 'search_xml', $db->ErrorMsg() . '<br><br>' . $q);
         echo "An SQL error has occured!";
         return;
     }
//.........这里部分代码省略.........

开发者ID:chiranjeevjain，项目名称:agilebill，代码行数:101，代码来源:export.inc.php

示例7: excel

 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;
 }

开发者ID:rezaple，项目名称:CI_Basecode，代码行数:44，代码来源:Guru.php

示例8: print_expenselist_excel

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;
}

开发者ID:Whiskey24，项目名称:GoingDutchApi，代码行数:69，代码来源:functions.php

示例9: do_record_download

function do_record_download()
{
    global $smarty;
    global $rpcpbx;
    global $friconf;
    //禁止使用因为某些条件
    if (trim($_REQUEST['start_date']) == '' && trim($_REQUEST['end_date']) == '' && trim($_REQUEST['id']) == "") {
        error_popbox(601, null, null, null, null, 'submit_failed');
    }
    //格式化条件
    $sqlwhere = '';
    //取出当前要显示的类型
    if ($_REQUEST['dcontext'] == 'trunk') {
        $sqlwhere .= " and dcontext like 'from-trunk%'";
    } elseif ($_REQUEST['dcontext'] == 'exten') {
        $sqlwhere .= " and dcontext like 'from-exten%'";
    }
    //取出
    if (trim($_REQUEST['start_date']) != '' && trim($_REQUEST['end_date']) != '') {
        $sqlwhere .= " and calldate >= '" . $_REQUEST['start_date'] . " 00:00:00' and calldate <= '" . $_REQUEST['end_date'] . " 23:59:59'";
    }
    if (trim($_REQUEST['src']) != '') {
        $sqlwhere .= " and src like '" . preg_replace("/\\*/", "%", $_REQUEST['src']) . "'";
        $smarty->assign("src", $_REQUEST['src']);
    }
    if (trim($_REQUEST['dst']) != '') {
        $sqlwhere .= " and dst like '" . preg_replace("/\\*/", "%", $_REQUEST['dst']) . "'";
        $smarty->assign("dst", $_REQUEST['dst']);
    }
    //如果发现了ID覆盖其他参数
    if (trim($_REQUEST['id']) != "") {
        $sqlwhere = "id = '" . $_REQUEST['id'] . "'";
        $smarty->assign("id", $_REQUEST['id']);
    }
    //最后生成
    $sqlwhere = preg_replace("/^ and/", "", $sqlwhere);
    if (trim($sqlwhere) != '') {
        $sqlwhere = 'where ' . $sqlwhere;
    }
    //取出所有数据
    $rpcres = sendrequest($rpcpbx->base_dbquery("select * from cdr " . $sqlwhere . " order by calldate desc"), 0);
    //输出
    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=record.xls");
    header("Content-Transfer-Encoding: binary ");
    xlsBOF();
    xlsWriteLabel(0, 0, "Calling Record Statistical");
    xlsWriteLabel(1, 1, "calltype " . $_REQUEST['dcontext']);
    xlsWriteLabel(2, 0, "Date Range " . $_REQUEST['start_date'] . " To " . $_REQUEST['end_date']);
    xlsWriteLabel(3, 0, "Call From " . $_REQUEST['src'] . " To " . $_REQUEST['dst']);
    //	xlsWriteLabel(4,0,"calltype");
    xlsWriteLabel(4, 0, "");
    xlsWriteLabel(4, 1, "src");
    xlsWriteLabel(4, 2, "dst");
    xlsWriteLabel(4, 3, "disposition");
    xlsWriteLabel(4, 4, "duration");
    xlsWriteLabel(4, 5, "billsec");
    xlsWriteLabel(4, 6, "calldate");
    $xlsRow = 5;
    foreach ($rpcres['result_array'] as $each) {
        //		if (preg_match("/trunk/",$each['dcontext'])) {
        //			xlsWriteLabel($xlsRow,0,'trunk');
        //		} elseif (preg_match("/exten/",$each['dcontext'])) {
        //			xlsWriteLabel($xlsRow,0,'exten');
        //		} else {
        xlsWriteLabel($xlsRow, 0, '');
        //		}
        xlsWriteLabel($xlsRow, 1, $each['src']);
        xlsWriteLabel($xlsRow, 2, $each['dst']);
        xlsWriteLabel($xlsRow, 3, $each['disposition']);
        xlsWriteLabel($xlsRow, 4, $each['duration']);
        xlsWriteLabel($xlsRow, 5, $each['billsec']);
        xlsWriteLabel($xlsRow, 6, $each['calldate']);
        $xlsRow++;
    }
    xlsEOF();
    exit;
}

开发者ID:ljhcj，项目名称:IRISCC，代码行数:82，代码来源:option_static.php

示例10: excel

 public function excel()
 {
     $this->load->helper('exportexcel');
     $namaFile = "m_admin.xls";
     $judul = "m_admin";
     $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++, "Username");
     xlsWriteLabel($tablehead, $kolomhead++, "Password");
     xlsWriteLabel($tablehead, $kolomhead++, "Level");
     xlsWriteLabel($tablehead, $kolomhead++, "Kon Id");
     foreach ($this->Admin_model->get_all() as $data) {
         $kolombody = 0;
         //ubah xlsWriteLabel menjadi xlsWriteNumber untuk kolom numeric
         xlsWriteNumber($tablebody, $kolombody++, $nourut);
         xlsWriteLabel($tablebody, $kolombody++, $data->username);
         xlsWriteLabel($tablebody, $kolombody++, $data->password);
         xlsWriteLabel($tablebody, $kolombody++, $data->level);
         xlsWriteNumber($tablebody, $kolombody++, $data->kon_id);
         $tablebody++;
         $nourut++;
     }
     xlsEOF();
     exit;
 }

开发者ID:nurisakbar，项目名称:racode，代码行数:38，代码来源:Admin.php

示例11: excel

 public function excel()
 {
     $this->load->helper('exportexcel');
     $namaFile = "tbl_daftar_kkm.xls";
     $judul = "tbl_daftar_kkm";
     $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++, "Nama");
     xlsWriteLabel($tablehead, $kolomhead++, "Jenis Kelamin");
     xlsWriteLabel($tablehead, $kolomhead++, "Tempat Tanggal Lahir");
     xlsWriteLabel($tablehead, $kolomhead++, "Fakultas");
     xlsWriteLabel($tablehead, $kolomhead++, "Jurusan");
     xlsWriteLabel($tablehead, $kolomhead++, "Semester");
     xlsWriteLabel($tablehead, $kolomhead++, "Alamat Asal");
     xlsWriteLabel($tablehead, $kolomhead++, "Alamat Sekarang");
     xlsWriteLabel($tablehead, $kolomhead++, "No Telp");
     xlsWriteLabel($tablehead, $kolomhead++, "Keterangan Khusus");
     xlsWriteLabel($tablehead, $kolomhead++, "Persyaratan");
     xlsWriteLabel($tablehead, $kolomhead++, "Foto");
     xlsWriteLabel($tablehead, $kolomhead++, "Id Kelompok");
     xlsWriteLabel($tablehead, $kolomhead++, "Dpl");
     xlsWriteLabel($tablehead, $kolomhead++, "Surat Keterangan Kuliah");
     xlsWriteLabel($tablehead, $kolomhead++, "Bukti Lunas Spp");
     xlsWriteLabel($tablehead, $kolomhead++, "Formulir Pendaftaran");
     foreach ($this->Daftar_peserta_kkm->get_all() as $data) {
         $kolombody = 0;
         //ubah xlsWriteLabel menjadi xlsWriteNumber untuk kolom numeric
         xlsWriteNumber($tablebody, $kolombody++, $nourut);
         xlsWriteLabel($tablebody, $kolombody++, $data->nama);
         xlsWriteLabel($tablebody, $kolombody++, $data->jenis_kelamin);
         xlsWriteLabel($tablebody, $kolombody++, $data->tempat_tanggal_lahir);
         xlsWriteLabel($tablebody, $kolombody++, $data->fakultas);
         xlsWriteLabel($tablebody, $kolombody++, $data->jurusan);
         xlsWriteLabel($tablebody, $kolombody++, $data->semester);
         xlsWriteLabel($tablebody, $kolombody++, $data->alamat_asal);
         xlsWriteLabel($tablebody, $kolombody++, $data->alamat_sekarang);
         xlsWriteLabel($tablebody, $kolombody++, $data->no_telp);
         xlsWriteLabel($tablebody, $kolombody++, $data->keterangan_khusus);
         xlsWriteLabel($tablebody, $kolombody++, $data->persyaratan);
         xlsWriteLabel($tablebody, $kolombody++, $data->foto);
         xlsWriteNumber($tablebody, $kolombody++, $data->id_kelompok);
         xlsWriteLabel($tablebody, $kolombody++, $data->dpl);
         xlsWriteLabel($tablebody, $kolombody++, $data->surat_keterangan_kuliah);
         xlsWriteLabel($tablebody, $kolombody++, $data->bukti_lunas_spp);
         xlsWriteLabel($tablebody, $kolombody++, $data->formulir_pendaftaran);
         $tablebody++;
         $nourut++;
     }
     xlsEOF();
     exit;
 }

开发者ID:Furiansyah，项目名称:lp2m_uinsgd_ac_id，代码行数:64，代码来源:daftar_peserta_kkm.php

示例12: excel

 public function excel()
 {
     $this->load->helper('exportexcel');
     $namaFile = "mahasiswa.xls";
     $judul = "mahasiswa";
     $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++, "Nama");
     xlsWriteLabel($tablehead, $kolomhead++, "Jenis Kelamin");
     xlsWriteLabel($tablehead, $kolomhead++, "Id Agama");
     xlsWriteLabel($tablehead, $kolomhead++, "Hoby");
     xlsWriteLabel($tablehead, $kolomhead++, "Alamat");
     xlsWriteLabel($tablehead, $kolomhead++, "Tanggal Lahir");
     foreach ($this->Mahasiswa_model->get_all() as $data) {
         $kolombody = 0;
         //ubah xlsWriteLabel menjadi xlsWriteNumber untuk kolom numeric
         xlsWriteNumber($tablebody, $kolombody++, $nourut);
         xlsWriteLabel($tablebody, $kolombody++, $data->nama);
         xlsWriteLabel($tablebody, $kolombody++, $data->jenis_kelamin);
         xlsWriteNumber($tablebody, $kolombody++, $data->id_agama);
         xlsWriteLabel($tablebody, $kolombody++, $data->hoby);
         xlsWriteLabel($tablebody, $kolombody++, $data->alamat);
         xlsWriteLabel($tablebody, $kolombody++, $data->tanggal_lahir);
         $tablebody++;
         $nourut++;
     }
     xlsEOF();
     exit;
 }

开发者ID:nurisakbar，项目名称:racode，代码行数:42，代码来源:Mahasiswa.php

示例13: excel

 public function excel()
 {
     $this->load->helper('exportexcel');
     $namaFile = "notas.xls";
     $judul = "notas";
     $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++, "CODIGO_NOTA");
     xlsWriteLabel($tablehead, $kolomhead++, "CODIGO_ALUMNO");
     xlsWriteLabel($tablehead, $kolomhead++, "CODIGO_ASIGNATURA");
     xlsWriteLabel($tablehead, $kolomhead++, "PRIMER_PARCIAL");
     xlsWriteLabel($tablehead, $kolomhead++, "SEGUNDA_PARCIAL");
     xlsWriteLabel($tablehead, $kolomhead++, "NOTA_FINAL");
     xlsWriteLabel($tablehead, $kolomhead++, "FECHA_ING_NOTAS");
     xlsWriteLabel($tablehead, $kolomhead++, "SEMESTRE");
     foreach ($this->model_notas->get_all() as $data) {
         $kolombody = 0;
         //ubah xlsWriteLabel menjadi xlsWriteNumber untuk kolom numeric
         xlsWriteNumber($tablebody, $kolombody++, $nourut);
         xlsWriteNumber($tablebody, $kolombody++, $data->CODIGO_NOTA);
         xlsWriteLabel($tablebody, $kolombody++, $data->CODIGO_ALUMNO);
         xlsWriteLabel($tablebody, $kolombody++, $data->CODIGO_ASIGNATURA);
         xlsWriteNumber($tablebody, $kolombody++, $data->PRIMER_PARCIAL);
         xlsWriteNumber($tablebody, $kolombody++, $data->SEGUNDA_PARCIAL);
         xlsWriteNumber($tablebody, $kolombody++, $data->NOTA_FINAL);
         xlsWriteNumber($tablebody, $kolombody++, $data->FECHA_ING_NOTAS);
         xlsWriteLabel($tablebody, $kolombody++, $data->SEMESTRE);
         $tablebody++;
         $nourut++;
     }
     xlsEOF();
     exit;
 }

开发者ID:actcux，项目名称:ProyectoNotasQr，代码行数:47，代码来源:Notas.php

示例14: excel

 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;
 }

开发者ID:super99199，项目名称:oasystem，代码行数:71，代码来源:Users.php

示例15: do_invoice_download

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;
}

开发者ID:ljhcj，项目名称:IRISCC，代码行数:47，代码来源:pbx_billing.php

示例16: excel

 public function excel()
 {
     $this->load->helper('exportexcel');
     $namaFile = "mahasiswa.xls";
     $judul = "mahasiswa";
     $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++, "th_akademik");
     xlsWriteLabel($tablehead, $kolomhead++, "kd_prodi");
     xlsWriteLabel($tablehead, $kolomhead++, "nama_mhs");
     xlsWriteLabel($tablehead, $kolomhead++, "sex");
     xlsWriteLabel($tablehead, $kolomhead++, "tempat_lahir");
     xlsWriteLabel($tablehead, $kolomhead++, "tanggal_lahir");
     xlsWriteLabel($tablehead, $kolomhead++, "alamat");
     xlsWriteLabel($tablehead, $kolomhead++, "kota");
     xlsWriteLabel($tablehead, $kolomhead++, "hp");
     xlsWriteLabel($tablehead, $kolomhead++, "email");
     xlsWriteLabel($tablehead, $kolomhead++, "nama_ayah");
     xlsWriteLabel($tablehead, $kolomhead++, "nama_ibu");
     xlsWriteLabel($tablehead, $kolomhead++, "alamat_ortu");
     xlsWriteLabel($tablehead, $kolomhead++, "hp_ortu");
     xlsWriteLabel($tablehead, $kolomhead++, "password");
     xlsWriteLabel($tablehead, $kolomhead++, "file_foto");
     xlsWriteLabel($tablehead, $kolomhead++, "status");
     xlsWriteLabel($tablehead, $kolomhead++, "tgl_insert");
     xlsWriteLabel($tablehead, $kolomhead++, "tgl_update");
     foreach ($this->mahasiswa_model->get_all() as $data) {
         $kolombody = 0;
         //ubah xlsWriteLabel menjadi xlsWriteNumber untuk kolom numeric
         xlsWriteNumber($tablebody, $kolombody++, $nourut);
         xlsWriteLabel($tablebody, $kolombody++, $data->th_akademik);
         xlsWriteLabel($tablebody, $kolombody++, $data->kd_prodi);
         xlsWriteLabel($tablebody, $kolombody++, $data->nama_mhs);
         xlsWriteLabel($tablebody, $kolombody++, $data->sex);
         xlsWriteLabel($tablebody, $kolombody++, $data->tempat_lahir);
         xlsWriteLabel($tablebody, $kolombody++, $data->tanggal_lahir);
         xlsWriteLabel($tablebody, $kolombody++, $data->alamat);
         xlsWriteLabel($tablebody, $kolombody++, $data->kota);
         xlsWriteLabel($tablebody, $kolombody++, $data->hp);
         xlsWriteLabel($tablebody, $kolombody++, $data->email);
         xlsWriteLabel($tablebody, $kolombody++, $data->nama_ayah);
         xlsWriteLabel($tablebody, $kolombody++, $data->nama_ibu);
         xlsWriteLabel($tablebody, $kolombody++, $data->alamat_ortu);
         xlsWriteLabel($tablebody, $kolombody++, $data->hp_ortu);
         xlsWriteLabel($tablebody, $kolombody++, $data->password);
         xlsWriteLabel($tablebody, $kolombody++, $data->file_foto);
         xlsWriteLabel($tablebody, $kolombody++, $data->status);
         xlsWriteLabel($tablebody, $kolombody++, $data->tgl_insert);
         xlsWriteLabel($tablebody, $kolombody++, $data->tgl_update);
         $tablebody++;
         $nourut++;
     }
     xlsEOF();
     exit;
 }

开发者ID:Muharir17，项目名称:siakadtutorial，代码行数:69，代码来源:mahasiswa.php

示例17: excel

 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("Cont

鲜花

握手

雷人

路过

鸡蛋

该文章已有0人参与评论

请发表评论

全部评论

专题导读

More+

10-27 六六分期app的软件客服如何联系？(六六分期

11-06 可心卡盟:win10系统火狐flash插件崩溃怎么

11-06 亲亲特价:怎么删除回收站图标

11-06 济南大学虚拟社区:鲁大师节能降温的具体办

11-06 xlueops.exe:无线网络安装向导

11-06 女斗合众国:win7系统cf与主机连接不稳定怎

11-06 0xc000022-[cf烟雾头]cf怎么调烟雾头

11-06 qizideyouhuo:应用程序无法正常启动0xc0000

11-06 ipz-185:win7系统vcf文件怎么打开

11-06 傻哥蹦迪:win10系统s4怎么打开usb调试

11-06 八神浩树gtaste:回收站清空了怎么恢复

11-06 妖尾之黑色守护:win10系统电脑没有1440x900

11-06 校园至尊魔王小说:win7系统浏览网页时字体

11-06 女斗合众国:win10系统访问共享文件夹提示请

11-06 tokyo hot n0654:恢复win7系统默认字体一招

11-06 雨酷仙境:设置win7系统转移临时文件夹腾出

11-06 阿穆纳伊之杖:win7系统开始菜单在右边还原

11-06 tunespotting:win10系统火狐flash插件总是

11-06 甘尔葛分析师：计谋网站seo关键词暴涨有什

11-06 蔡贵霖: 计谋网站seo关键词暴涨有什么秘密

11-06 博益网首页:ao3网页版进入不了解决方法

11-06 漏斗子专栏: 网站数据分析小白易懂精华篇

11-06 见证双虹怎么做:win7系统开启telnet命令的

11-06 颾狐蝶蜋:系统资源不足无法完成请求的服务

11-06 国光中学校歌:提交网站到alexa查询详细步骤

11-06 西安有情天:静态网页和动态网页的区别

11-06 红木雅尚斋:外部链接构造对网站的好处

11-06 前官礼遇：防止域名劫持–增强域安全性的10

11-06 密传二转答案: 中文分词算法有哪些

11-06 金泉家园邮编:百度快照劫持的表现及应对方

PHP xlsEOF函数代码示例发布时间：2022-05-23

PHP xls函数代码示例发布时间：2022-05-23

kostub/iosMath: Beautiful math equation

MATLAB及其信号处理基础

2022-07-18

pallet/zi: Maven plugin for clojure

2022-08-17

CVE-2022-38625

2022-09-18

CVE-2022-20220

2022-07-29

jonathantribouharet/JTMaterialTransition

2022-08-17

阅读排行榜

1 CVE-2022-2345

Use After Free in GitHub repository vim/vim prior to 9.0.0046.

阅读：601|2022-07-29

2 bradtraversy/iweather: Ionic 3 mobile we

bradtraversy/iweather: Ionic 3 mobile weather app

阅读：1585|2022-08-30

3 joaomh/curso-de-matlab

joaomh/curso-de-matlab

阅读：1149|2022-08-17

4 rootnroll/library: Playgrounds library

rootnroll/library: Playgrounds library

阅读：621|2022-08-15

5 断牙刷新位置时间（断牙属性及刷新位置介绍

魔兽世界怀旧服已经开启两个多月了，但作为一个猎人玩家，抓到“断牙”，已经成为了一

阅读：1003|2022-11-06

6 rugk/mastodon-simplified-federation: Sim

rugk/mastodon-simplified-federation: Simplifies following and interacting with r

阅读：1081|2022-08-17

7 Tangshitao/Dense-Scene-Matching: Learnin

Tangshitao/Dense-Scene-Matching: Learning Camera Localization via Dense Scene Ma

阅读：762|2022-08-16

8 nbeaver/why-linux-is-better: Objective r

nbeaver/why-linux-is-better: Objective reasons to prefer Linux to Windows.

阅读：1604|2022-08-15

9 Respring是什么意思?没有越狱设备如何 Resp

相信不少果粉在对自己的设备进行某些操作时，都会碰到Respring，但这个 Respring 到底

阅读：361|2022-11-06

10 lightningtgc/MProgress.js: Material Prog

lightningtgc/MProgress.js: Material Progress —Google Material Design Progress l

阅读：408|2022-08-17

客服电话

电子邮件