本文整理汇总了PHP中HeaderingExcel函数的典型用法代码示例。如果您正苦于以下问题：PHP HeaderingExcel函数的具体用法？PHP HeaderingExcel怎么用？PHP HeaderingExcel使用的例子？那么, 这里精选的函数代码示例或许可以为您提供帮助。
在下文中一共展示了HeaderingExcel函数的10个代码示例，这些例子默认根据受欢迎程度排序。您可以为喜欢或者感觉有用的代码点赞，您的评价将有助于系统推荐出更棒的PHP代码示例。
示例1: reporte
function reporte($ano, $idEveUsr)
{
global $db, $db2, $workbook, $mscIdUsuario, $hoy;
// HTTP headers
HeaderingExcel('chasisTrackingActual.xls');
// Creating the first worksheet
$worksheet1 =& $workbook->add_worksheet('Hoja1');
$fntTit =& $workbook->add_format();
$fntTit->set_size(12);
$fntTit->set_bold();
$fntTit->set_color('#E0D196');
// Font Black Normal
$fntFit =& $workbook->add_format();
$fntFit->set_size(10);
$fntBlk =& $workbook->add_format();
$fntBlk->set_size(10);
$fntBlk->set_color('black');
$fntBlk->set_bold();
$fntEnc =& $workbook->add_format();
$fntEnc->set_size(10);
$fntEnc->set_color('black');
$fntEnc->set_bold();
$fntEnc->set_align('center');
$fntEnc->set_fg_color('silver');
$fntEnc->set_pattern();
$cliente = getValueTable("cliente", "D_CLIENTE", "id_cliente", $idCliente);
$usuario = getValueTable("Nombre", "USUARIO", "Id_usuario", $mscIdUsuario);
// Encabezado
$pais = getValueTable("pais", "INFO", "id_info", 1);
$worksheet1->write_string(0, 0, "SION :: Mediteranean Shipping Company {$pais}, S.A. DE C.V.", $fntTit);
$worksheet1->write_string(2, 0, "Reporte : Tracking-Actual", $fntFit);
$worksheet1->write_string(3, 0, "Fecha : {$hoy} ", $fntFit);
$worksheet1->write_string(2, 4, "Modulo : Intermodal", $fntFit);
$worksheet1->write_string(3, 4, "Elaboro: {$usuario} ", $fntFit);
// Sub-Encabezado
$worksheet1->set_column(0, 0, 15);
$worksheet1->set_column(1, 1, 7);
$worksheet1->set_column(2, 2, 15);
$worksheet1->set_column(3, 3, 30);
$worksheet1->set_column(4, 5, 13);
$worksheet1->set_column(6, 6, 17);
$worksheet1->set_column(7, 7, 30);
$worksheet1->set_column(8, 8, 20);
$worksheet1->set_column(9, 9, 40);
$worksheet1->write_string(5, 0, "No.Chasis", $fntEnc);
$worksheet1->write_string(5, 1, "Tipo", $fntEnc);
$worksheet1->write_string(5, 2, "Conte", $fntEnc);
$worksheet1->write_string(5, 3, "Movimiento", $fntEnc);
$worksheet1->write_string(5, 4, "Fecha", $fntEnc);
$worksheet1->write_string(5, 5, "Hora", $fntEnc);
$worksheet1->write_string(5, 6, "Transportista", $fntEnc);
$worksheet1->write_string(5, 7, "Predio", $fntEnc);
$worksheet1->write_string(5, 8, "Booking", $fntEnc);
$worksheet1->write_string(5, 9, "Notas", $fntEnc);
$r = 6;
// INCLUIR DATOS
$workbook->close();
}示例2: HeaderingExcel
require_once 'Worksheet.php';
require_once 'Workbook.php';
require_once 'connect.php';
$id_get = $_POST['id_get'];
$semester = $_POST['semester'];
$sy = $_POST['sy'];
function HeaderingExcel($filename)
{
header("Content-type: application/vnd.ms-excel");
header("Content-Disposition: attachment; filename={$filename}");
header("Expires: 0");
header("Cache-Control: must-revalidate, post-check=0,pre-check=0");
header("Pragma: public");
}
// HTTP headers
HeaderingExcel('teacher.xls');
// Creating a workbook
$workbook = new excel("-");
// Creating the first worksheet
$worksheet1 =& $workbook->add_worksheet('teacher');
$worksheet1->freeze_panes(1, 0);
$worksheet1->set_column(0, 0, 25);
$worksheet1->set_column(1, 1, 20);
$worksheet1->set_column(1, 2, 20);
$worksheet1->set_column(1, 3, 20);
$worksheet1->set_column(1, 4, 20);
$worksheet1->set_column(1, 5, 20);
$worksheet1->set_column(1, 6, 20);
//row
$worksheet1->set_row(8, 50);
$query = mysql_query("select * from schedule where teacher='{$id_get}' and semester='{$semester}' and sy='{$sy}'") or die(mysql_error());示例3: HeaderingExcel
}
if (isset($_GET["klui"]) && $_GET["klui"] != "" && $_GET["klui"] != "0") {
$filter .= "AND klui = '" . $_GET["klui"] . "'";
}
$posisi = $_GET["posisi"];
$batas = $_GET["lim"];
$query = "SELECT\n\t\t\t\t\t\t\t\t\ta.id_perusahaan, a.nama, a.alamat,\n\t\t\t\t\t\t\t\t\ta_k.kecamatan, a_kel.kelurahan,\n\t\t\t\t\t\t\t\t\ta.telpon, a.kode_pos,\n\t\t\t\t\t\t\t\t\ta.nomor_akte,a.tgl_pendirian, \n\t\t\t\t\t\t\t\t\ta_j.jenis, a_s.status,\n\t\t\t\t\t\t\t\t\ta.nama_pemilik, a.nama_pengurus,\n\t\t\t\t\t\t\t\t\ta.alamat_pemilik, a.alamat_pengurus,a_m.status,a_mod.modal,\n\t\t\t\t\t\t\t\t\ta_tbl.wnilk, a_tbl.wnipr, a_tbl.wnalk, a_tbl.wnapr, c.nama_bagian ,a.klui\n\t\t\t\t\t\t\t\tFROM\n\t\t\t\t\t\t\t\t\tdb_jamsostek a\n\t\t\t\t\t\t\t\t\tLEFT JOIN t_jenis_usaha a_j ON a.jenis_usaha = a_j.id_jenis_usaha\n\t\t\t\t\t\t\t\t\tLEFT JOIN t_status_milik a_m ON a.id_status_pemilik = a_m.id_status\n\t\t\t\t\t\t\t\t\tLEFT JOIN t_status_modal a_mod ON a.id_status_permodalan = a_mod.id_status\n\t\t\t\t\t\t\t\t\tLEFT JOIN t_status a_s ON a.id_status_perusahaan = a_s.id_status\n\t\t\t\t\t\t\t\t\tLEFT JOIN t_kecamatan a_k ON a.kec = a_k.id_kecamatan\n\t\t\t\t\t\t\t\t\tLEFT JOIN t_kelurahan a_kel ON a.kel = a_kel.id_kelurahan\n\t\t\t\t\t\t\t\t\tLEFT JOIN tbl_tenagakerja_jamsos a_tbl ON a.id_perusahaan = a_tbl.id_perusahaan\n\t\t\t\t\t\t\t\t\tLEFT JOIN kbli c ON a.klui = c.kode_bagian\n\t\t\t\t\t\t\t\t\twhere {$filter}\n\t\t\t\t\t\t\t\t\torder by nama asc \n\t\t\t\t\t\t\t\t\tlimit " . $posisi . "," . $batas . "";
function HeaderingExcel($filename)
{
header("Content-type:application/vnd.ms-excel");
header("Content-Disposition:attachment;filename={$filename}");
header("Expires:0");
header("Cache-Control:must-revalidate,post-check=0,pre-check=0");
header("Pragma: public");
}
HeaderingExcel('Daftar_perusahaan.xls');
$workbook = new Workbook("-");
$worksheet =& $workbook->add_worksheet("Sheet ");
$a =& $workbook->add_format();
$a->set_size(14);
$a->set_bold();
$a->set_align('center');
$b =& $workbook->add_format();
$b->set_border(1);
$b->set_pattern();
$b->set_fg_color('cyan');
$c =& $workbook->add_format();
$c->set_border(1);
$worksheet->write_string(0, 0, "Tabel Data Perusahaan", $a);
//$worksheet->write_string(0,0,$query,$a);
$worksheet->merge_cells(0, 0, 0, 21);示例4: define
//define(K_LIBRARIES,'libraries');
//include("connect.php");
if ($_GET["mode"] == '1') {
define('_FCEE_EXEC', '1');
require_once '../../../libraries/dinsos.php';
$resi = $_GET["link"];
$mode = $_GET["mode"];
function HeaderingExcel($filename)
{
header("Content-type:application/vnd.ms-excel");
header("Content-Disposition:attachment;filename={$filename}");
header("Expires:0");
header("Cache-Control:must-revalidate,post-check=0,pre-check=0");
header("Pragma: public");
}
HeaderingExcel('Laporan_berkas_selesai.xls');
require_once '../../../libraries/excel-lib/OLEwriter.php';
require_once '../../../libraries/excel-lib/BIFFwriter.php';
require_once '../../../libraries/excel-lib/Worksheet.php';
require_once '../../../libraries/excel-lib/Workbook.php';
$workbook = new Workbook("-");
$fJudul =& $workbook->add_format();
$fJudul->set_bold();
$fJudul->set_pattern(1);
$fJudul->set_fg_color($color = 'red');
$fList =& $workbook->add_format();
$fList->set_border(1);
$fList_title =& $workbook->add_format();
$fList_title->set_border(1);
$fList_title->set_bold();
$fList_title->set_merge();示例5: HeaderingExcel
//menyertakan semua class yang diperlukan
require_once 'OLEwriter.php';
require_once 'BIFFwriter.php';
require_once 'Worksheet.php';
require_once 'Workbook.php';
function HeaderingExcel($filename)
{
header("Content-type:application/vnd.ms-excel");
header("Content-Disposition:attachment;filename={$filename}");
header("Expires:0");
header("Cache-Control:must-revalidate,post-check=0,pre-check=0");
header("Pragma: public");
}
//http headers
HeaderingExcel('test2.xls');
//membuat workbook
$workbook = new Workbook("-");
//membuat worksheet pertama
$fBold =& $workbook->add_format();
$fBold->set_bold();
$fItalic =& $workbook->add_format();
$fItalic->set_italic();
$fUnderline =& $workbook->add_format();
$fUnderline->set_underline(1);
$fUnderline2 =& $workbook->add_format();
$fUnderline2->set_underline(2);
$fBesar =& $workbook->add_format();
$fBesar->set_size(50);
$fUnderlineItalic =& $workbook->add_format();
$fUnderlineItalic->set_underline(1);示例6: date
$tahun_ini = date('Y');
if ($bulan > 6) {
$tahun_ajaran = $tahun_ini - 1994;
} else {
$tahun_ajaran = $tahun_ini - 1995;
}
$tahun_ajaran++;
//Query data yang akan di export ke Excel
mysql_select_db($database_cn_dbpas, $cn_dbpas);
$query_rs_calsis = "SELECT * FROM t_calon_siswa WHERE KD_TAHUN_AJARAN = '{$tahun_ajaran}' ORDER BY NO_CALSIS DESC";
$rs_calsis = mysql_query($query_rs_calsis, $cn_dbpas) or die(mysql_error());
$row_rs_calsis = mysql_fetch_assoc($rs_calsis);
$totalRows_rs_calsis = mysql_num_rows($rs_calsis);
$total = $totalRows_rs_calsis;
//http headers
HeaderingExcel('CalonSiswa.xls');
//membuat workbook
$workbook = new Workbook("-");
$worksheet1 =& $workbook->add_worksheet("Calon Siswa");
$judul =& $workbook->add_format();
//Memformat header (judul) tabel dengan font bold, horiz rata tengah dan verical rata tengah
$judul->set_bold();
$judul->set_align('center');
$judul->set_align('vcenter');
$jdl =& $workbook->add_format();
//Memformat Judul dengan font tebal, wanrna biru, hiriz rata kiri, verti rata tengah dan ukuran font 12
$jdl->set_bold();
$jdl->set_color('blue');
$jdl->set_align('left');
$jdl->set_align('vcenter');
$jdl->set_size(12);示例7: HeaderingExcel
//include all support file
require_once 'OLEwriter.php';
require_once 'BIFFwriter.php';
require_once 'Worksheet.php';
require_once 'Workbook.php';
function HeaderingExcel($filename)
{
header("Content-type:application/vnd.ms-excel");
header("Content-Disposition:attachment;filename={$filename}");
header("Expires:0");
header("Cache-Control:must-revalidate,post-check=0,pre-check=0");
header("Pragma: public");
}
//http headers
HeaderingExcel('test4.xls');
//make a workbook
$workbook = new Workbook("-");
//make first worksheet
$fJudul =& $workbook->add_format();
$fJudul->set_bold();
$fJudul->set_pattern(1);
$fJudul->set_fg_color($color = 'red');
$fBesar =& $workbook->add_format();
$fBesar->set_size(20);
$fKutipan =& $workbook->add_format();
$fKutipan->set_align('right');
$fKutipan->set_italic();
$fKutipan->set_size(8);
$fKutipan->set_color('blue');
$fList =& $workbook->add_format();示例8: reporte
function reporte($idNaviera)
{
global $db, $db2, $workbook, $sesIdUsuario, $hoy;
// HTTP headers
HeaderingExcel('recap.xls');
// Creating the first worksheet
$worksheet1 =& $workbook->add_worksheet('Hoja1');
$fntTit =& $workbook->add_format();
$fntTit->set_size(12);
$fntTit->set_bold();
$fntTit->set_color('#E0D196');
// Font Black Normal
$fntFit =& $workbook->add_format();
$fntFit->set_size(10);
$fntBlk =& $workbook->add_format();
$fntBlk->set_size(10);
$fntBlk->set_color('black');
$fntBlk->set_bold();
$fntEnc =& $workbook->add_format();
$fntEnc->set_size(10);
$fntEnc->set_color('black');
$fntEnc->set_bold();
$fntEnc->set_align('center');
$fntEnc->set_fg_color('silver');
$fntEnc->set_pattern();
$usuario = getValueTable("usuario", "USUARIO", "id_usuario", $sesIdUsuario);
$naviera = getValueTable("naviera", "NAVIERA", "id_naviera", $idNaviera);
// Encabezado
$worksheet1->write_string(0, 0, "TRANSPORTES MALEJA S.A. DE C.V.", $fntTit);
$worksheet1->write_string(2, 0, "Reporte : Recapitulación", $fntFit);
$worksheet1->write_string(3, 0, "Fecha : {$hoy} ", $fntFit);
$worksheet1->write_string(4, 0, "Naviera : {$naviera} ", $fntFit);
$worksheet1->write_string(2, 4, "Modulo : Inventario ", $fntFit);
$worksheet1->write_string(3, 4, "Elaboro: {$usuario} ", $fntFit);
// Sub-Encabezado
$worksheet1->set_column(0, 10, 15);
// ----------------------------------------------------------
// EL TREBOL
// ----------------------------------------------------------
$worksheet1->write_string(6, 0, ".:: El Trébol ::.", $fntEnc);
$worksheet1->write_string(7, 0, "Total", $fntEnc);
$worksheet1->write_string(7, 1, "Dañados", $fntEnc);
$worksheet1->write_string(7, 2, "A", $fntEnc);
$worksheet1->write_string(7, 3, "B", $fntEnc);
$worksheet1->write_string(7, 4, "C", $fntEnc);
$worksheet1->write_string(7, 5, "D", $fntEnc);
$worksheet1->write_string(7, 6, "FG", $fntEnc);
$worksheet1->write_string(7, 7, "GC", $fntEnc);
$worksheet1->write_string(8, 0, "20' DC", $fntEnc);
$worksheet1->write_string(9, 0, "40' DC", $fntEnc);
$worksheet1->write_string(10, 0, "40' HC", $fntEnc);
// 20 DC
$dc20DM = getCountConte('trebol', $idNaviera, '20DC', 'DM');
$worksheet1->write_number(8, 1, $dc20DM, $fntFit);
$dc20A = getCountConte('trebol', $idNaviera, '20DC', 'A');
$worksheet1->write_number(8, 2, $dc20A, $fntFit);
$dc20B = getCountConte('trebol', $idNaviera, '20DC', 'B');
$worksheet1->write_number(8, 3, $dc20B, $fntFit);
$dc20C = getCountConte('trebol', $idNaviera, '20DC', 'C');
$worksheet1->write_number(8, 4, $dc20C, $fntFit);
$dc20D = getCountConte('trebol', $idNaviera, '20DC', 'D');
$worksheet1->write_number(8, 5, $dc20D, $fntFit);
$dc20FG = getCountConte('trebol', $idNaviera, '20DC', 'FG');
$worksheet1->write_number(8, 6, $dc20FG, $fntFit);
$dc20GC = getCountConte('trebol', $idNaviera, '20DC', 'GC');
$worksheet1->write_number(8, 7, $dc20GC, $fntFit);
// 40 DC
$dc40DM = getCountConte('trebol', $idNaviera, '40DC', 'DM');
$worksheet1->write_number(9, 1, $dc40DM, $fntFit);
$dc40A = getCountConte('trebol', $idNaviera, '40DC', 'A');
$worksheet1->write_number(9, 2, $dc40A, $fntFit);
$dc40B = getCountConte('trebol', $idNaviera, '40DC', 'B');
$worksheet1->write_number(9, 3, $dc40B, $fntFit);
$dc40C = getCountConte('trebol', $idNaviera, '40DC', 'C');
$worksheet1->write_number(9, 4, $dc40C, $fntFit);
$dc40D = getCountConte('trebol', $idNaviera, '40DC', 'D');
$worksheet1->write_number(9, 5, $dc40D, $fntFit);
$dc40FG = getCountConte('trebol', $idNaviera, '40DC', 'FG');
$worksheet1->write_number(9, 6, $dc40FG, $fntFit);
$dc40GC = getCountConte('trebol', $idNaviera, '40DC', 'GC');
$worksheet1->write_number(9, 7, $dc40GC, $fntFit);
// 40 HC
$dc40HCDM = getCountConte('trebol', $idNaviera, '40HC', 'DM');
$worksheet1->write_number(10, 1, $dc40HCDM, $fntFit);
$dc40HCA = getCountConte('trebol', $idNaviera, '40HC', 'A');
$worksheet1->write_number(10, 2, $dc40HCA, $fntFit);
$dc40HCB = getCountConte('trebol', $idNaviera, '40HC', 'B');
$worksheet1->write_number(10, 3, $dc40HCB, $fntFit);
$dc40HCC = getCountConte('trebol', $idNaviera, '40HC', 'C');
$worksheet1->write_number(10, 4, $dc40HCC, $fntFit);
$dc40HCD = getCountConte('trebol', $idNaviera, '40HC', 'D');
$worksheet1->write_number(10, 5, $dc40HCD, $fntFit);
$dc40HCFG = getCountConte('trebol', $idNaviera, '40HC', 'FG');
$worksheet1->write_number(10, 6, $dc40HCFG, $fntFit);
$dc40HCGC = getCountConte('trebol', $idNaviera, '40HC', 'GC');
$worksheet1->write_number(10, 7, $dc40HCGC, $fntFit);
// ----------------------------------------------------------
// EL PINO
// ----------------------------------------------------------
$worksheet1->write_string(13, 0, ".:: El Pino ::.", $fntEnc);
//.........这里部分代码省略.........
示例9: set_time_limit
<?
//ini_set('max_execution_time', 0);
set_time_limit(10);
require_once($_SERVER['DOCUMENT_ROOT']."/siskeu_smk2/lib/WriteExcel/Worksheet.php");
require_once($_SERVER['DOCUMENT_ROOT']."/siskeu_smk2/lib/WriteExcel/Workbook.php");
require_once("headering_excel.php");
require_once("business/rekap_siswa.class.php");
$idKelas = $_GET['i'];
$jenjangKelas = $_GET['j'];
$nama_file = 'presensi.ods';
HeaderingExcel($nama_file);
$workbook = new Workbook('-');
$h3 = & $workbook->add_format();
$h3->set_bold();
$h3->set_size(11);
$h3->set_align('center');
$h3->set_align('vcenter');
$h3->set_text_wrap();
$h4 = & $workbook->add_format();
$h4->set_bold();
$h4->set_size(10);
$h4->set_align('center');
$h4->set_align('vcenter');
$h4->set_border(1);
$h4->set_text_wrap();示例10: reporte
function reporte($idNaviera)
{
global $db, $db2, $workbook, $sesIdUsuario, $hoy;
$sesIdOficina = $_SESSION['sesIdOficina'];
$oficina = getValueTable("oficina", "OFICINA", "id_oficina", $sesIdOficina);
$oficina = strtoupper($oficina);
// HTTP headers
HeaderingExcel('recap.xls');
// Creating the first worksheet
$worksheet1 =& $workbook->add_worksheet('Hoja1');
$fntTit =& $workbook->add_format();
$fntTit->set_size(12);
$fntTit->set_bold();
$fntTit->set_color('#E0D196');
// Font Black Normal
$fntFit =& $workbook->add_format();
$fntFit->set_size(10);
$fntBlk =& $workbook->add_format();
$fntBlk->set_size(10);
$fntBlk->set_color('black');
$fntBlk->set_bold();
$fntEnc =& $workbook->add_format();
$fntEnc->set_size(10);
$fntEnc->set_color('black');
$fntEnc->set_bold();
$fntEnc->set_align('center');
$fntEnc->set_fg_color('silver');
$fntEnc->set_pattern();
$usuario = getValueTable("usuario", "USUARIO", "id_usuario", $sesIdUsuario);
$naviera = getValueTable("naviera", "NAVIERA", "id_naviera", $idNaviera);
// Encabezado
$worksheet1->write_string(0, 0, "MODULO DE PATIO", $fntTit);
$worksheet1->write_string(2, 0, "Reporte : Recapitulación - {$oficina} ", $fntFit);
$worksheet1->write_string(3, 0, "Fecha : {$hoy} ", $fntFit);
$worksheet1->write_string(4, 0, "Naviera : {$naviera} ", $fntFit);
$worksheet1->write_string(2, 4, "Modulo : Inventario ", $fntFit);
$worksheet1->write_string(3, 4, "Elaboro: {$usuario} // ", $fntFit);
// Sub-Encabezado
$worksheet1->set_column(0, 10, 15);
// ----------------------------------------------------------
// OFICINA X
// ----------------------------------------------------------
$worksheet1->write_string(6, 0, ".:: {$oficina} ::.", $fntEnc);
$worksheet1->write_string(7, 0, "Total", $fntEnc);
$worksheet1->write_string(7, 1, "Dañados", $fntEnc);
$worksheet1->write_string(7, 2, "A", $fntEnc);
$worksheet1->write_string(7, 3, "B", $fntEnc);
$worksheet1->write_string(7, 4, "C", $fntEnc);
$worksheet1->write_string(7, 5, "D", $fntEnc);
$worksheet1->write_string(7, 6, "FG", $fntEnc);
$worksheet1->write_string(7, 7, "GC", $fntEnc);
$worksheet1->write_string(8, 0, "20' DC", $fntEnc);
$worksheet1->write_string(9, 0, "40' DC", $fntEnc);
$worksheet1->write_string(10, 0, "40' HC", $fntEnc);
// 20 DC
$dc20DM = getCountConte($sesIdOficina, $idNaviera, '20DC', 'DM');
$worksheet1->write_number(8, 1, $dc20DM, $fntFit);
$dc20A = getCountConte($sesIdOficina, $idNaviera, '20DC', 'A');
$worksheet1->write_number(8, 2, $dc20A, $fntFit);
$dc20B = getCountConte($sesIdOficina, $idNaviera, '20DC', 'B');
$worksheet1->write_number(8, 3, $dc20B, $fntFit);
$dc20C = getCountConte($sesIdOficina, $idNaviera, '20DC', 'C');
$worksheet1->write_number(8, 4, $dc20C, $fntFit);
$dc20D = getCountConte($sesIdOficina, $idNaviera, '20DC', 'D');
$worksheet1->write_number(8, 5, $dc20D, $fntFit);
$dc20FG = getCountConte($sesIdOficina, $idNaviera, '20DC', 'FG');
$worksheet1->write_number(8, 6, $dc20FG, $fntFit);
$dc20GC = getCountConte($sesIdOficina, $idNaviera, '20DC', 'GC');
$worksheet1->write_number(8, 7, $dc20GC, $fntFit);
// 40 DC
$dc40DM = getCountConte($sesIdOficina, $idNaviera, '40DC', 'DM');
$worksheet1->write_number(9, 1, $dc40DM, $fntFit);
$dc40A = getCountConte($sesIdOficina, $idNaviera, '40DC', 'A');
$worksheet1->write_number(9, 2, $dc40A, $fntFit);
$dc40B = getCountConte($sesIdOficina, $idNaviera, '40DC', 'B');
$worksheet1->write_number(9, 3, $dc40B, $fntFit);
$dc40C = getCountConte($sesIdOficina, $idNaviera, '40DC', 'C');
$worksheet1->write_number(9, 4, $dc40C, $fntFit);
$dc40D = getCountConte($sesIdOficina, $idNaviera, '40DC', 'D');
$worksheet1->write_number(9, 5, $dc40D, $fntFit);
$dc40FG = getCountConte($sesIdOficina, $idNaviera, '40DC', 'FG');
$worksheet1->write_number(9, 6, $dc40FG, $fntFit);
$dc40GC = getCountConte($sesIdOficina, $idNaviera, '40DC', 'GC');
$worksheet1->write_number(9, 7, $dc40GC, $fntFit);
// 40 HC
$dc40HCDM = getCountConte($sesIdOficina, $idNaviera, '40HC', 'DM');
$worksheet1->write_number(10, 1, $dc40HCDM, $fntFit);
$dc40HCA = getCountConte($sesIdOficina, $idNaviera, '40HC', 'A');
$worksheet1->write_number(10, 2, $dc40HCA, $fntFit);
$dc40HCB = getCountConte($sesIdOficina, $idNaviera, '40HC', 'B');
$worksheet1->write_number(10, 3, $dc40HCB, $fntFit);
$dc40HCC = getCountConte($sesIdOficina, $idNaviera, '40HC', 'C');
$worksheet1->write_number(10, 4, $dc40HCC, $fntFit);
$dc40HCD = getCountConte($sesIdOficina, $idNaviera, '40HC', 'D');
$worksheet1->write_number(10, 5, $dc40HCD, $fntFit);
$dc40HCFG = getCountConte($sesIdOficina, $idNaviera, '40HC', 'FG');
$worksheet1->write_number(10, 6, $dc40HCFG, $fntFit);
$dc40HCGC = getCountConte($sesIdOficina, $idNaviera, '40HC', 'GC');
$worksheet1->write_number(10, 7, $dc40HCGC, $fntFit);
$workbook->close();
//.........这里部分代码省略.........