} $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);
$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++) {
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();
<?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);
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"; }
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();
$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");
$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');
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