PHP Workbook::add_format Exemples

Exemple #1

Fichier : print_excel.php Projet : ibnoe/dinsosnaker2014

}
$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);
$worksheet->write_string(2, 0, "No", $b);
$worksheet->write_string(2, 1, "Nama Perusahaan", $b);
$worksheet->write_string(2, 2, "Alamat", $b);

Exemple #2

Fichier : pengaduan_lap_cetak.php Projet : ibnoe/dinsosnaker2014

 $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_pengaduan.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();
 $fBesar =& $workbook->add_format();
 $fBesar->set_bold();
 $fBesar->set_size(10);
 $worksheet1 =& $workbook->add_worksheet("Sheet 1");
 $worksheet1->set_column(1, 1, 5);
 for ($i = 2; $i < 8; $i++) {

Exemple #3

Fichier : cetak_excel_siswa.php Projet : rischanlab/kerjapraktek

 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();
 
 $hk = & $workbook->add_format();

Exemple #4

Fichier : excelAllriskPeriode.php Projet : Dede1213/PII-FIX

<?php

header("Content-type: application/vnd.ms-excel");
header("Content-Disposition: attachment; filename=daftar_All_risk_periode" . date('dmY_His') . ".xls");
header("Expires: 0");
header("Cache-Control: must-revalidate, post-check=0,pre-check=0");
header("Pragma: public");
$workbook = new Workbook();
$worksheet1 =& $workbook->add_worksheet(date('dmY_His'));
$title =& $workbook->add_format();
$title->set_color('blue');
$title->set_size(16);
$header =& $workbook->add_format();
$header->set_color('blue');
// set warna huruf
//$header->set_border_color('red'); // set warna border
$header->set_size(11);
// Set ukuran font
$header->set_align("center");
// set align rata tengah
$header->set_top(2);
// set ketebalan border bagian atas cell 0 = border tidak tampil
$header->set_bottom(2);
// set ketebalan border bagian atas cell 0 = border tidak tampil
$header->set_left(2);
// set ketebalan border bagian atas cell 0 = border tidak tampil
$header->set_right(2);
// set ketebalan border bagian atas cell 0 = border tidak tampil
$worksheet1->write_string(0, 4, 'List Of All Risk', $title);
// Set Nama kolom
$worksheet1->set_column(0, 1, 10);

Exemple #5

Fichier : metrics.php Projet : Norky/PBS-tools

function result_as_xls($result, $mycolumnname, $filebase)
{
    $myresult = $result;
    $cache = APACHE_CACHE_DIR;
    if (!file_exists("/tmp/" . $cache)) {
        mkdir("/tmp/" . $cache, 0750);
    }
    $xlsfile = $filebase . ".xls";
    $workbook = new Workbook("/tmp/" . $cache . $xlsfile);
    $worksheet =& $workbook->add_worksheet("Sheet 1");
    $format_hdr =& $workbook->add_format();
    $format_hdr->set_bold();
    $format_hdr->set_align('center');
    $rowctr = 0;
    $colctr = 0;
    foreach ($mycolumnname as $header) {
        $worksheet->write($rowctr, $colctr, "{$header}", $format_hdr);
        $colctr++;
    }
    while ($myresult->fetchInto($row)) {
        $rowctr++;
        $colctr = 0;
        $keys = array_keys($row);
        foreach ($keys as $key) {
            if (isset($mycolumnname[$key]) && !($mycolumnname[$key] == 'hidden')) {
                $worksheet->write($rowctr, $colctr, $row[$key]);
                $colctr++;
            }
        }
    }
    $workbook->close();
    echo "<P>Excel file:  <A href=\"" . $cache . rawurlencode($xlsfile) . "\">" . $xlsfile . "</A></P>\n";
}

Exemple #6

Fichier : font-excel.php Projet : deehidayat/geek

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);
$fUnderlineItalic->set_italic();
$fBoldItalic =& $workbook->add_format();
$fBoldItalic->set_bold();
$fBoldItalic->set_italic();

Exemple #7

Fichier : test.php Projet : JackCanada/moodle-hacks

$worksheet1->set_row(1, 20);
$worksheet1->write_string(1, 1, "This worksheet's name is " . $worksheet1->get_name());
$worksheet1->write(2, 1, "http://www.phpclasses.org/browse.html/package/767.html");
$worksheet1->write_number(3, 0, 11);
$worksheet1->write_number(3, 1, 1);
$worksheet1->write_string(3, 2, "by four is");
$worksheet1->write_formula(3, 3, "=A4 * (2 + 2)");
//$worksheet1->write_formula(3, 3, "= SUM(A4:B4)");
$worksheet1->write(5, 4, "= POWER(2,3)");
$worksheet1->write(4, 4, "= SUM(5, 5, 5)");
//$worksheet1->write_formula(4, 4, "= LN(2.71428)");
//$worksheet1->write_formula(5, 4, "= SIN(PI()/2)");
// Creating the second worksheet
$worksheet2 =& $workbook->add_worksheet();
// Format for the headings
$formatot =& $workbook->add_format();
$formatot->set_size(10);
$formatot->set_align('center');
$formatot->set_color('white');
$formatot->set_pattern();
$formatot->set_fg_color('magenta');
$worksheet2->set_column(0, 0, 15);
$worksheet2->set_column(1, 2, 30);
$worksheet2->set_column(3, 3, 15);
$worksheet2->set_column(4, 4, 10);
$worksheet2->write_string(1, 0, "Id", $formatot);
$worksheet2->write_string(1, 1, "Name", $formatot);
$worksheet2->write_string(1, 2, "Adress", $formatot);
$worksheet2->write_string(1, 3, "Phone Number", $formatot);
$worksheet2->write_string(1, 4, "Salary", $formatot);
$worksheet2->write(3, 0, "22222222-2");

Exemple #8

Fichier : export_xls.php Projet : deehidayat/geek

    $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);
$tengah =& $workbook->add_format();
$tengah->set_align('center');
$kanan =& $workbook->add_format();
$kanan->set_align('right');

Exemple #9

Fichier : setup-page-excel.php Projet : deehidayat/geek

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();
$fList->set_border(1);
$worksheet1 =& $workbook->add_worksheet("Sheet 1");
//seting zoom size
//75 is 75% zoom size