$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_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);
<?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);
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);
$worksheet->write_string(2, 0, "No", $b);
function createResultXls()
{
require_once "vendor/write_excel/OLEwriter.php";
require_once "vendor/write_excel/BIFFwriter.php";
require_once "vendor/write_excel/Worksheet.php";
require_once "vendor/write_excel/Workbook.php";
global $_fullname_sql, $SEM_TYPE, $SEM_CLASS, $TMP_PATH;
if (is_array($this->sem_browse_data['search_result']) && count($this->sem_browse_data['search_result'])) {
if (!is_object($this->sem_tree)) {
$the_tree = TreeAbstract::GetInstance("StudipSemTree");
} else {
$the_tree =& $this->sem_tree;
}
list($group_by_data, $sem_data) = $this->getResult();
$tmpfile = $TMP_PATH . '/' . md5(uniqid('write_excel', 1));
// Creating a workbook
$workbook = new Workbook($tmpfile);
$head_format =& $workbook->addformat();
$head_format->set_size(12);
$head_format->set_bold();
$head_format->set_align("left");
$head_format->set_align("vcenter");
$head_format_merged =& $workbook->addformat();
$head_format_merged->set_size(12);
$head_format_merged->set_bold();
$head_format_merged->set_align("left");
$head_format_merged->set_align("vcenter");
$head_format_merged->set_merge();
$head_format_merged->set_text_wrap();
$caption_format =& $workbook->addformat();
$caption_format->set_size(10);
$caption_format->set_align("left");
$caption_format->set_align("vcenter");
$caption_format->set_bold();
//$caption_format->set_text_wrap();
$data_format =& $workbook->addformat();
$data_format->set_size(10);
$data_format->set_align("left");
$data_format->set_align("vcenter");
$caption_format_merged =& $workbook->addformat();
$caption_format_merged->set_size(10);
$caption_format_merged->set_merge();
$caption_format_merged->set_align("left");
$caption_format_merged->set_align("vcenter");
$caption_format_merged->set_bold();
// Creating the first worksheet
$worksheet1 =& $workbook->addworksheet(_("Veranstaltungen"));
$worksheet1->set_row(0, 20);
$worksheet1->write_string(0, 0, _("Stud.IP Veranstaltungen") . ' - ' . $GLOBALS['UNI_NAME_CLEAN'], $head_format);
$worksheet1->set_row(1, 20);
$worksheet1->write_string(1, 0, sprintf(_(" %s Veranstaltungen gefunden %s, Gruppierung: %s"), count($sem_data), $this->sem_browse_data['do_search'] ? _("(Suchergebnis)") : '', $this->group_by_fields[$this->sem_browse_data['group_by']]['name']), $caption_format);
$worksheet1->write_blank(0, 1, $head_format);
$worksheet1->write_blank(0, 2, $head_format);
$worksheet1->write_blank(0, 3, $head_format);
$worksheet1->write_blank(1, 1, $head_format);
$worksheet1->write_blank(1, 2, $head_format);
$worksheet1->write_blank(1, 3, $head_format);
$worksheet1->set_column(0, 0, 70);
$worksheet1->set_column(0, 1, 25);
$worksheet1->set_column(0, 2, 25);
$worksheet1->set_column(0, 3, 50);
$row = 2;
foreach ($group_by_data as $group_field => $sem_ids) {
switch ($this->sem_browse_data["group_by"]) {
case 0:
$semester = SemesterData::GetSemesterArray();
$headline = $semester[$group_field]['name'];
break;
case 1:
if ($the_tree->tree_data[$group_field]) {
$headline = $the_tree->getShortPath($group_field);
} else {
$headline = _("keine Studienbereiche eingetragen");
}
break;
case 3:
$headline = $SEM_TYPE[$group_field]["name"] . " (" . $SEM_CLASS[$SEM_TYPE[$group_field]["class"]]["name"] . ")";
break;
default:
$headline = $group_field;
break;
}
++$row;
$worksheet1->write_string($row, 0, $headline, $caption_format);
$worksheet1->write_blank($row, 1, $caption_format);
$worksheet1->write_blank($row, 2, $caption_format);
$worksheet1->write_blank($row, 3, $caption_format);
++$row;
if (is_array($sem_ids['Seminar_id'])) {
$semester = SemesterData::GetSemesterArray();
while (list($seminar_id, ) = each($sem_ids['Seminar_id'])) {
$sem_name = key($sem_data[$seminar_id]["Name"]);
$seminar_number = key($sem_data[$seminar_id]['VeranstaltungsNummer']);
$sem_number_start = key($sem_data[$seminar_id]["sem_number"]);
$sem_number_end = key($sem_data[$seminar_id]["sem_number_end"]);
if ($sem_number_start != $sem_number_end) {
$sem_name .= ' (' . $semester[$sem_number_start]['name'] . ' - ';
$sem_name .= ($sem_number_end == -1 ? _("unbegrenzt") : $semester[$sem_number_end]['name']) . ')';
} elseif ($this->sem_browse_data['group_by']) {
$sem_name .= ' (' . $semester[$sem_number_start]['name'] . ")";
}
$worksheet1->write_string($row, 0, $sem_name, $data_format);
//create Turnus field
$temp_turnus_string = Seminar::GetInstance($seminar_id)->getFormattedTurnus(true);
//Shorten, if string too long (add link for details.php)
if (strlen($temp_turnus_string) > 245) {
$temp_turnus_string = substr($temp_turnus_string, 0, strpos(substr($temp_turnus_string, 245, strlen($temp_turnus_string)), ",") + 246);
$temp_turnus_string .= "...(mehr)";
}
$worksheet1->write_string($row, 1, $seminar_number, $data_format);
$worksheet1->write_string($row, 2, $temp_turnus_string, $data_format);
$doz_name = array_keys($sem_data[$seminar_id]['fullname']);
$doz_position = array_keys($sem_data[$seminar_id]['position']);
if (is_array($doz_name)) {
if (count($doz_position) != count($doz_name)) {
$doz_position = range(1, count($doz_name));
}
array_multisort($doz_position, $doz_name);
$worksheet1->write_string($row, 3, join(', ', $doz_name), $data_format);
}
++$row;
}
}
}
$workbook->close();
}
return $tmpfile;
}
<?
//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();
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);
$fUnderlineItalic->set_italic();
$fBoldItalic =& $workbook->add_format();
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('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('test.xls');
// Creating a workbook
$workbook = new Workbook("-");
// Creating the first worksheet
$worksheet1 =& $workbook->add_worksheet('First One');
// set the column width
$worksheet1->set_column(1, 1, 40);
// set the row height
$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)");
$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);
$tengah =& $workbook->add_format();
$tengah->set_align('center');
<?php
//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('test.xls');
//membuat workbook
$workbook = new Workbook("-");
//membuat worksheet pertama
$worksheet1 =& $workbook->add_worksheet("Sheet 1");
$worksheet1->set_column(1, 1, 40);
$worksheet1->set_row(1, 20);
$worksheet1->write_string(1, 1, "Test Generate Excel");
$workbook->close();
/**
* Set this worksheet as the first visible sheet.
* This is necessary when there are a large number of worksheets and the
* activated worksheet is not visible on the screen.
*
*/
public function setFirstSheet()
{
$this->workbook->setFirstSheetIndex($this->index);
}
function jbxl_download_data($format, $datas, $filename = '')
{
global $CFG;
if (empty($datas->data)) {
return;
}
if (empty($filename)) {
$filename = 'jbxl_download_' . date('YmdHis');
}
//
if ($format === 'xls') {
$excellib_version = 0;
if (file_exists($CFG->dirroot . '/lib/excellib.class.php')) {
$excellib_version = 2;
$tocode = 'UTF-8';
require_once $CFG->dirroot . '/lib/excellib.class.php';
} else {
$excellib_version = 1;
$tocode = 'sjis-win';
require_once $CFG->dirroot . '/lib/excel/Worksheet.php';
require_once $CFG->dirroot . '/lib/excel/Workbook.php';
}
//
header("Content-type: application/vnd.ms-excel");
header("Content-Disposition: attachment; filename=\"{$filename}.xls\"");
/// Creating a workbook
if ($excellib_version == 2) {
$workbook = new MoodleExcelWorkbook('-', 'Excel5');
$workbook->send($filename);
} else {
$workbook = new Workbook('-');
}
$myxls = $workbook->add_worksheet('data');
//
$i = 0;
foreach ($datas->data as $line => $data) {
$j = 0;
foreach ($data as $colm => $val) {
if ($datas->attr[$line][$colm] === 'number') {
$myxls->write_number($i, $j++, $val);
} else {
$myxls->write_string($i, $j++, mb_convert_encoding($val, $tocode, 'auto'));
}
}
$i++;
}
$workbook->close();
} else {
if ($format === 'txt') {
$tocode = 'UTF-8';
//
header("Content-Type: application/download\n");
header("Content-Disposition: attachment; filename=\"{$filename}.txt\"");
foreach ($datas->data as $data) {
foreach ($data as $val) {
echo mb_convert_encoding($val, $tocode, 'auto') . "\t";
}
echo "\r\n";
}
}
}
return;
}
