当前位置: 首页>>代码示例>>PHP>>正文


PHP PHPExcel::getSecurity方法代码示例

本文整理汇总了PHP中PHPExcel::getSecurity方法的典型用法代码示例。如果您正苦于以下问题:PHP PHPExcel::getSecurity方法的具体用法?PHP PHPExcel::getSecurity怎么用?PHP PHPExcel::getSecurity使用的例子?那么恭喜您, 这里精选的方法代码示例或许可以为您提供帮助。您也可以进一步了解该方法所在PHPExcel的用法示例。


在下文中一共展示了PHPExcel::getSecurity方法的8个代码示例,这些例子默认根据受欢迎程度排序。您可以为喜欢或者感觉有用的代码点赞,您的评价将有助于系统推荐出更棒的PHP代码示例。

示例1: _writeWorkbookProtection

 /**
  * Write WorkbookProtection
  *
  * @param 	PHPExcel_Shared_XMLWriter 	$objWriter 		XML Writer
  * @param 	PHPExcel					$pPHPExcel
  * @throws 	PHPExcel_Writer_Exception
  */
 private function _writeWorkbookProtection(PHPExcel_Shared_XMLWriter $objWriter = null, PHPExcel $pPHPExcel = null)
 {
     if ($pPHPExcel->getSecurity()->isSecurityEnabled()) {
         $objWriter->startElement('workbookProtection');
         $objWriter->writeAttribute('lockRevision', $pPHPExcel->getSecurity()->getLockRevision() ? 'true' : 'false');
         $objWriter->writeAttribute('lockStructure', $pPHPExcel->getSecurity()->getLockStructure() ? 'true' : 'false');
         $objWriter->writeAttribute('lockWindows', $pPHPExcel->getSecurity()->getLockWindows() ? 'true' : 'false');
         if ($pPHPExcel->getSecurity()->getRevisionsPassword() != '') {
             $objWriter->writeAttribute('revisionsPassword', $pPHPExcel->getSecurity()->getRevisionsPassword());
         }
         if ($pPHPExcel->getSecurity()->getWorkbookPassword() != '') {
             $objWriter->writeAttribute('workbookPassword', $pPHPExcel->getSecurity()->getWorkbookPassword());
         }
         $objWriter->endElement();
     }
 }
开发者ID:Princelo,项目名称:bioerp,代码行数:23,代码来源:Workbook.php

示例2: post_exphutangarmada

 public function post_exphutangarmada()
 {
     $input = Input::all();
     $shift = 'all';
     $saldohutangbymonth = $this->allQuery($input['date'], Auth::user()->pool_id, $shift, 0, 1000);
     if ($saldohutangbymonth) {
         $objPHPExcel = new PHPExcel();
         $objPHPExcel->getProperties()->setCreator(Auth::user()->fullname)->setLastModifiedBy(Auth::user()->fullname)->setTitle("Laporan Harian " . Pool::find(Auth::user()->pool_id)->pool_name . '-' . date('Y-m-d'))->setSubject("Laporan Harian " . Pool::find(Auth::user()->pool_id)->pool_name . '-' . date('Y-m-d'))->setDescription("Laporan harian operasi pool")->setKeywords("Laporan Harian")->setCategory("");
         $styleArray = array('font' => array('bold' => true, 'color' => array('rgb' => 'FF0000'), 'size' => 16));
         $sheet_active = 0;
         $objPHPExcel->createSheet(NULL, $sheet_active);
         $objPHPExcel->setActiveSheetIndex($sheet_active);
         //title
         $objPHPExcel->getActiveSheet()->mergeCells('A2:J2');
         $objPHPExcel->getActiveSheet()->setCellValue('A2', 'LAPORAN HUTANG ARMADA PER TANGGAL ' . Myfungsi::fulldate(strtotime($input['date'])));
         $objPHPExcel->getActiveSheet()->getStyle('A2')->applyFromArray($styleArray);
         // Coloum header
         $objPHPExcel->getActiveSheet()->mergeCells('A5:A6');
         $objPHPExcel->getActiveSheet()->mergeCells('B5:B6');
         $objPHPExcel->getActiveSheet()->mergeCells('C5:D5');
         $objPHPExcel->getActiveSheet()->mergeCells('E5:E6');
         $objPHPExcel->getActiveSheet()->mergeCells('F5:I5');
         $objPHPExcel->getActiveSheet()->mergeCells('J5:L5');
         $objPHPExcel->getActiveSheet()->mergeCells('M5:O5');
         $objPHPExcel->getActiveSheet()->setCellValue('A5', 'NO');
         $objPHPExcel->getActiveSheet()->setCellValue('B5', 'BAPAK ASUH');
         $objPHPExcel->getActiveSheet()->setCellValue('C5', 'PENGEMUDI');
         $objPHPExcel->getActiveSheet()->setCellValue('C6', 'NIP');
         $objPHPExcel->getActiveSheet()->setCellValue('D6', 'NAMA');
         $objPHPExcel->getActiveSheet()->setCellValue('E5', 'BODY');
         $objPHPExcel->getActiveSheet()->setCellValue('F5', 'PEMAKAIAN SPAREPART ARMADA');
         $objPHPExcel->getActiveSheet()->setCellValue('F6', 'PEMAKAIAN');
         $objPHPExcel->getActiveSheet()->setCellValue('G6', 'TABUNGAN');
         $objPHPExcel->getActiveSheet()->setCellValue('H6', 'BAYAR');
         $objPHPExcel->getActiveSheet()->setCellValue('I6', 'SELISIH');
         $objPHPExcel->getActiveSheet()->setCellValue('J5', 'SETORAN ARMADA');
         $objPHPExcel->getActiveSheet()->setCellValue('J6', 'KS');
         $objPHPExcel->getActiveSheet()->setCellValue('K6', 'BAYAR KS');
         $objPHPExcel->getActiveSheet()->setCellValue('L6', 'SELISIH');
         $objPHPExcel->getActiveSheet()->setCellValue('M5', 'SALDO ARMADA');
         $objPHPExcel->getActiveSheet()->setCellValue('M6', 'SALDO SPAREPART');
         $objPHPExcel->getActiveSheet()->setCellValue('N6', 'SALDO KS');
         $objPHPExcel->getActiveSheet()->setCellValue('O6', 'SALDO AKHIR');
         $objPHPExcel->getActiveSheet()->setCellValue('P5', 'SHIFT');
         $no = 1;
         $starline = 8;
         foreach ($saldohutangbymonth as $saldo) {
             $bpkasuh = Anakasuh::where('status', '=', 1)->where('fleet_id', '=', $saldo->fleet_id)->first();
             $bravo = Driver::find($saldo->bravo_driver_id);
             $saldosp = $saldo->tabungan_sparepart + $saldo->hutang_dp_sparepart + $saldo->cicilan_sparepart - $saldo->pemakaian_part;
             $objPHPExcel->getActiveSheet()->setCellValueByColumnAndRow(0, $starline, $no);
             $objPHPExcel->getActiveSheet()->setCellValueByColumnAndRow(1, $starline, $bpkasuh ? User::find($bpkasuh->user_id)->fullname : 'TIDAK ADA BAPAK ASUH');
             $objPHPExcel->getActiveSheet()->setCellValueByColumnAndRow(2, $starline, $bravo ? $bravo->nip : 'NONE');
             $objPHPExcel->getActiveSheet()->setCellValueByColumnAndRow(3, $starline, $bravo ? $bravo->name : 'NONE');
             $objPHPExcel->getActiveSheet()->setCellValueByColumnAndRow(4, $starline, $saldo->taxi_number);
             //pemakaikan sp
             $objPHPExcel->getActiveSheet()->setCellValueByColumnAndRow(5, $starline, $saldo->pemakaian_part);
             $objPHPExcel->getActiveSheet()->setCellValueByColumnAndRow(6, $starline, $saldo->tabungan_sparepart);
             $objPHPExcel->getActiveSheet()->setCellValueByColumnAndRow(7, $starline, $saldo->hutang_dp_sparepart + $saldo->cicilan_sparepart);
             $objPHPExcel->getActiveSheet()->setCellValueByColumnAndRow(8, $starline, $saldosp);
             //setoran armada
             $objPHPExcel->getActiveSheet()->setCellValueByColumnAndRow(9, $starline, $saldo->ks);
             $objPHPExcel->getActiveSheet()->setCellValueByColumnAndRow(10, $starline, $saldo->cicilan_ks);
             $objPHPExcel->getActiveSheet()->setCellValueByColumnAndRow(11, $starline, $saldo->selisi_ks);
             //saldo armada
             $objPHPExcel->getActiveSheet()->setCellValueByColumnAndRow(12, $starline, $saldosp);
             $objPHPExcel->getActiveSheet()->setCellValueByColumnAndRow(13, $starline, $saldo->selisi_ks);
             $objPHPExcel->getActiveSheet()->setCellValueByColumnAndRow(14, $starline, $saldosp + $saldo->selisi_ks);
             $objPHPExcel->getActiveSheet()->setCellValueByColumnAndRow(15, $starline, $saldo->shift_id);
             $no++;
             $starline++;
         }
         $objPHPExcel->getActiveSheet()->getStyle('A5:O' . ($starline + 1))->getBorders()->getAllBorders()->setBorderStyle(PHPExcel_Style_Border::BORDER_HAIR);
         $objPHPExcel->getActiveSheet()->getStyle('A5:O6')->getBorders()->getAllBorders()->setBorderStyle(PHPExcel_Style_Border::BORDER_THIN);
         $objPHPExcel->getActiveSheet()->getStyle('A5:O' . ($starline + 1))->getBorders()->getOutline()->setBorderStyle(PHPExcel_Style_Border::BORDER_THIN);
         $objPHPExcel->getActiveSheet()->getStyle('A' . ($starline + 1) . ':O' . ($starline + 1))->getBorders()->getAllBorders()->setBorderStyle(PHPExcel_Style_Border::BORDER_THIN);
         //end
         //SET TANGGAL UNDUH DAN PASSWORD
         $objPHPExcel->getActiveSheet()->setCellValue('B' . ($starline + 10), 'Tanggal Unduh');
         $objPHPExcel->getActiveSheet()->setCellValue('C' . ($starline + 10), ':');
         $objPHPExcel->getActiveSheet()->setCellValue('D' . ($starline + 10), date('Y-m-d H:i:s'));
         $objPHPExcel->getSecurity()->setLockWindows(true);
         $objPHPExcel->getSecurity()->setLockStructure(true);
         $objPHPExcel->getSecurity()->setWorkbookPassword("FreeBlocking");
         $objPHPExcel->getActiveSheet()->getProtection()->setPassword('FreeBlocking');
         $objPHPExcel->getActiveSheet()->getProtection()->setSheet(true);
         // This should be enabled in order to enable any of the following!
         //$objPHPExcel->getActiveSheet()->getProtection()->setSort(true);
         $objPHPExcel->getActiveSheet()->getProtection()->setInsertRows(true);
         //END
         $objWriter = PHPExcel_IOFactory::createWriter($objPHPExcel, 'Excel5');
         $objWriter->save(path('public') . 'Laporan-hutang-armada.xls');
         return Response::download(path('public') . 'Laporan-hutang-armada.xls');
     }
     //end if
     //var_dump($saldohutangbymonth);
 }
开发者ID:acmadi,项目名称:diantaksi,代码行数:97,代码来源:reportops.php

示例3: date

// Set document properties
echo date('H:i:s'), " Set document properties", EOL;
$objPHPExcel->getProperties()->setCreator("Maarten Balliauw")->setLastModifiedBy("Maarten Balliauw")->setTitle("Office 2007 XLSX Test Document")->setSubject("Office 2007 XLSX Test Document")->setDescription("Test document for Office 2007 XLSX, generated using PHP classes.")->setKeywords("office 2007 openxml php")->setCategory("Test result file");
// Add some data
echo date('H:i:s'), " Add some data", EOL;
$objPHPExcel->setActiveSheetIndex(0);
$objPHPExcel->getActiveSheet()->setCellValue('A1', 'Hello');
$objPHPExcel->getActiveSheet()->setCellValue('B2', 'world!');
$objPHPExcel->getActiveSheet()->setCellValue('C1', 'Hello');
$objPHPExcel->getActiveSheet()->setCellValue('D2', 'world!');
// Rename worksheet
echo date('H:i:s'), " Rename worksheet", EOL;
$objPHPExcel->getActiveSheet()->setTitle('Simple');
// Set document security
echo date('H:i:s'), " Set document security", EOL;
$objPHPExcel->getSecurity()->setLockWindows(true);
$objPHPExcel->getSecurity()->setLockStructure(true);
$objPHPExcel->getSecurity()->setWorkbookPassword("PHPExcel");
// Set sheet security
echo date('H:i:s'), " Set sheet security", EOL;
$objPHPExcel->getActiveSheet()->getProtection()->setPassword('PHPExcel');
$objPHPExcel->getActiveSheet()->getProtection()->setSheet(true);
// This should be enabled in order to enable any of the following!
$objPHPExcel->getActiveSheet()->getProtection()->setSort(true);
$objPHPExcel->getActiveSheet()->getProtection()->setInsertRows(true);
$objPHPExcel->getActiveSheet()->getProtection()->setFormatCells(true);
// Set active sheet index to the first sheet, so Excel opens this as the first sheet
$objPHPExcel->setActiveSheetIndex(0);
// Save Excel 95 file
echo date('H:i:s'), " Write to Excel5 format", EOL;
$callStartTime = microtime(true);
开发者ID:progamr,项目名称:opigno,代码行数:31,代码来源:11documentsecurity-xls.php

示例4: get_expreportdaily


//.........这里部分代码省略.........
     $objPHPExcel->getActiveSheet()->setCellValue('D6', 'NAMA');
     $objPHPExcel->getActiveSheet()->setCellValue('E5', 'BODY');
     $objPHPExcel->getActiveSheet()->setCellValue('F5', 'STATUS');
     $objPHPExcel->getActiveSheet()->setCellValue('F6', 'OPS');
     $objPHPExcel->getActiveSheet()->setCellValue('G6', 'BS');
     $objPHPExcel->getActiveSheet()->setCellValue('H5', 'SETORAN MURNI');
     $objPHPExcel->getActiveSheet()->setCellValue('I5', 'TAB SPAREPART');
     $objPHPExcel->getActiveSheet()->setCellValue('J5', 'DENDA JAM');
     $objPHPExcel->getActiveSheet()->setCellValue('K5', 'DP SPAREPART');
     $objPHPExcel->getActiveSheet()->setCellValue('L5', 'BAYAR  CICILAN');
     $objPHPExcel->getActiveSheet()->setCellValue('L6', 'KS');
     $objPHPExcel->getActiveSheet()->setCellValue('M6', 'S-PART');
     $objPHPExcel->getActiveSheet()->setCellValue('N6', 'DP-KSO');
     $objPHPExcel->getActiveSheet()->setCellValue('O6', 'HUT-LAMA');
     $objPHPExcel->getActiveSheet()->setCellValue('P5', 'BAYAR');
     $objPHPExcel->getActiveSheet()->setCellValue('P6', 'STIKER BANDARA');
     $objPHPExcel->getActiveSheet()->setCellValue('Q6', 'CUCI');
     $objPHPExcel->getActiveSheet()->setCellValue('R6', 'LAKA');
     $objPHPExcel->getActiveSheet()->setCellValue('S5', 'HARUS SETOR');
     $objPHPExcel->getActiveSheet()->setCellValue('T5', 'POTONGAN');
     $objPHPExcel->getActiveSheet()->setCellValue('U5', 'SETOR CASH');
     $objPHPExcel->getActiveSheet()->setCellValue('V5', 'KETEKORAN');
     $objPHPExcel->getActiveSheet()->setCellValue('W5', 'KETERANGAN');
     $no = 1;
     $starline = 8;
     foreach ($financials as $finan) {
         $bs = $finan->potongan >= $finan->setoran_wajib ? 'YA' : 'TIDAK';
         $objPHPExcel->getActiveSheet()->setCellValueByColumnAndRow(0, $starline, $no);
         $objPHPExcel->getActiveSheet()->setCellValueByColumnAndRow(1, $starline, '');
         $objPHPExcel->getActiveSheet()->setCellValueByColumnAndRow(2, $starline, $finan->nip);
         $objPHPExcel->getActiveSheet()->setCellValueByColumnAndRow(3, $starline, $finan->name);
         $objPHPExcel->getActiveSheet()->setCellValueByColumnAndRow(4, $starline, $finan->taxi_number);
         $objPHPExcel->getActiveSheet()->setCellValueByColumnAndRow(5, $starline, $finan->kode);
         $objPHPExcel->getActiveSheet()->setCellValueByColumnAndRow(6, $starline, $bs);
         $objPHPExcel->getActiveSheet()->setCellValueByColumnAndRow(7, $starline, $finan->setoran_wajib);
         $objPHPExcel->getActiveSheet()->setCellValueByColumnAndRow(8, $starline, $finan->tabungan_sparepart);
         $objPHPExcel->getActiveSheet()->setCellValueByColumnAndRow(9, $starline, $finan->denda);
         $objPHPExcel->getActiveSheet()->setCellValueByColumnAndRow(10, $starline, $finan->hutang_dp_sparepart);
         $objPHPExcel->getActiveSheet()->setCellValueByColumnAndRow(11, $starline, $finan->cicilan_ks);
         $objPHPExcel->getActiveSheet()->setCellValueByColumnAndRow(12, $starline, $finan->cicilan_sparepart);
         $objPHPExcel->getActiveSheet()->setCellValueByColumnAndRow(13, $starline, $finan->cicilan_dp_kso);
         $objPHPExcel->getActiveSheet()->setCellValueByColumnAndRow(14, $starline, $finan->cicilan_hutang_lama);
         $objPHPExcel->getActiveSheet()->setCellValueByColumnAndRow(15, $starline, $finan->cicilan_lain);
         $objPHPExcel->getActiveSheet()->setCellValueByColumnAndRow(16, $starline, $finan->biaya_cuci);
         $objPHPExcel->getActiveSheet()->setCellValueByColumnAndRow(17, $starline, $finan->iuran_laka);
         $objPHPExcel->getActiveSheet()->setCellValueByColumnAndRow(18, $starline, '=SUM(H' . $starline . ':R' . $starline . ')');
         $objPHPExcel->getActiveSheet()->setCellValueByColumnAndRow(19, $starline, $finan->potongan);
         $objPHPExcel->getActiveSheet()->setCellValueByColumnAndRow(20, $starline, $finan->setoran_cash);
         //$objPHPExcel->getActiveSheet()->setCellValueByColumnAndRow(20, $starline, $finan->ks);
         $objPHPExcel->getActiveSheet()->setCellValueByColumnAndRow(21, $starline, '=(U' . $starline . '-(S' . $starline . '-T' . $starline . '))');
         $objPHPExcel->getActiveSheet()->setCellValueByColumnAndRow(22, $starline, '');
         //$objPHPExcel->getActiveSheet()->setCellValueByColumnAndRow(14, $starline, $finan->cicilan_lain);
         $no++;
         $starline++;
     }
     $objPHPExcel->getActiveSheet()->mergeCells('A' . ($starline + 1) . ':G' . ($starline + 1) . '');
     $objPHPExcel->getActiveSheet()->setCellValue('A' . ($starline + 1), 'TOTAL SETORAN ');
     $objPHPExcel->getActiveSheet()->setCellValue('H' . ($starline + 1), '=SUM(H8:H' . $starline . ')');
     $objPHPExcel->getActiveSheet()->setCellValue('I' . ($starline + 1), '=SUM(I8:I' . $starline . ')');
     $objPHPExcel->getActiveSheet()->setCellValue('J' . ($starline + 1), '=SUM(J8:J' . $starline . ')');
     $objPHPExcel->getActiveSheet()->setCellValue('K' . ($starline + 1), '=SUM(K8:K' . $starline . ')');
     $objPHPExcel->getActiveSheet()->setCellValue('L' . ($starline + 1), '=SUM(L8:L' . $starline . ')');
     $objPHPExcel->getActiveSheet()->setCellValue('M' . ($starline + 1), '=SUM(M8:M' . $starline . ')');
     $objPHPExcel->getActiveSheet()->setCellValue('N' . ($starline + 1), '=SUM(N8:N' . $starline . ')');
     $objPHPExcel->getActiveSheet()->setCellValue('O' . ($starline + 1), '=SUM(O8:O' . $starline . ')');
     $objPHPExcel->getActiveSheet()->setCellValue('P' . ($starline + 1), '=SUM(P8:P' . $starline . ')');
     $objPHPExcel->getActiveSheet()->setCellValue('Q' . ($starline + 1), '=SUM(Q8:Q' . $starline . ')');
     $objPHPExcel->getActiveSheet()->setCellValue('R' . ($starline + 1), '=SUM(R8:R' . $starline . ')');
     $objPHPExcel->getActiveSheet()->setCellValue('S' . ($starline + 1), '=SUM(S8:S' . $starline . ')');
     $objPHPExcel->getActiveSheet()->setCellValue('T' . ($starline + 1), '=SUM(T8:T' . $starline . ')');
     $objPHPExcel->getActiveSheet()->setCellValue('U' . ($starline + 1), '=SUM(U8:U' . $starline . ')');
     $objPHPExcel->getActiveSheet()->setCellValue('V' . ($starline + 1), '=SUM(V8:V' . $starline . ')');
     $objPHPExcel->getActiveSheet()->getStyle('A5:W' . ($starline + 1))->getBorders()->getAllBorders()->setBorderStyle(PHPExcel_Style_Border::BORDER_HAIR);
     $objPHPExcel->getActiveSheet()->getStyle('A5:W6')->getBorders()->getAllBorders()->setBorderStyle(PHPExcel_Style_Border::BORDER_THIN);
     $objPHPExcel->getActiveSheet()->getStyle('A5:W' . ($starline + 1))->getBorders()->getOutline()->setBorderStyle(PHPExcel_Style_Border::BORDER_THIN);
     $objPHPExcel->getActiveSheet()->getStyle('A' . ($starline + 1) . ':W' . ($starline + 1))->getBorders()->getAllBorders()->setBorderStyle(PHPExcel_Style_Border::BORDER_THIN);
     /*
     $objPHPExcel->getActiveSheet()->setCellValueByColumnAndRow(1, 8, 'Some value');
     
     $objPHPExcel->getActiveSheet()->setCellValue('A1', 'Hello');
     $objPHPExcel->getActiveSheet()->setCellValue('B2', 'world!');
     $objPHPExcel->getActiveSheet()->setCellValue('C1', 'Hello');
     $objPHPExcel->getActiveSheet()->setCellValue('D2', 'world!');
     */
     $objPHPExcel->getActiveSheet()->setTitle('Laporan Harian Tgl ' . $date);
     $objPHPExcel->getSecurity()->setLockWindows(true);
     $objPHPExcel->getSecurity()->setLockStructure(true);
     $objPHPExcel->getSecurity()->setWorkbookPassword("FreeBlocking");
     $objPHPExcel->getActiveSheet()->getProtection()->setPassword('FreeBlocking');
     $objPHPExcel->getActiveSheet()->getProtection()->setSheet(true);
     // This should be enabled in order to enable any of the following!
     $objPHPExcel->getActiveSheet()->getProtection()->setSort(true);
     $objPHPExcel->getActiveSheet()->getProtection()->setInsertRows(true);
     $objPHPExcel->getActiveSheet()->getProtection()->setFormatCells(true);
     $objPHPExcel->setActiveSheetIndex(0);
     $objWriter = PHPExcel_IOFactory::createWriter($objPHPExcel, 'Excel2007');
     //echo path('public');
     $objWriter->save(path('public') . 'Laporan-Harian-Tanggal-' . $date . '.xlsx');
     return Response::download(path('public') . 'Laporan-Harian-Tanggal-' . $date . '.xlsx', 'Laporan-Harian-Tanggal-' . $date . '.xlsx');
 }
开发者ID:acmadi,项目名称:diantaksi,代码行数:101,代码来源:anakasuh.php

示例5: date

    $doc->getActiveSheet()->setCellValue($col . $x, $regNota['CodRegistroNotas'])->getStyle($col . $x)->applyFromArray(estilo(11, "FFFFFF", "", 'FFFFFF', "right", "center", 'none', '000000'));
}
//Creditos
$creditosy = $cantidadalumnos + 10 + 1;
$doc->getActiveSheet()->mergeCells('A' . $creditosy . ":J" . $creditosy);
$doc->getActiveSheet()->setCellValue('A' . $creditosy, "Sistema Académico Administrativo para Colegios - Desarrollado por Ronald Nina Layme")->getStyle('A' . $creditosy)->applyFromArray(estilo(9, "000000", "", 'FFFFFF', "left", "center", 'none', '000000'));
//$doc->getActiveSheet()->getCell('A'.$creditosy)->getHyperlink()->setUrl('http://www.fb.com/ronaldnina');
$dodv = $doc->getActiveSheet()->getCell('A' . $creditosy)->getDataValidation();
$dodv->setShowInputMessage(true);
$dodv->setPromptTitle('Creditos');
$dodv->setPrompt('Sistema Académico Administrativo para Colegios - Desarrollado por Ronald Nina Layme Cel: 73230568');
$doc->getActiveSheet()->setCellValue('A' . ($creditosy + 1), md5($codigocasilleros) . " - " . date("d-m-Y H:i:s"))->getStyle('A' . ($creditosy + 1))->applyFromArray(estilo(9, "000000", "", 'FFFFFF', "left", "center", 'none', '000000'));
//Ocultar Grilla
$doc->getActiveSheet()->setShowGridlines(false);
//Aplicando Seguridad en Excel
$doc->getSecurity()->setLockWindows(true);
$doc->getSecurity()->setLockStructure(true);
$doc->getSecurity()->setWorkbookPassword($contrasenaexcel);
$doc->getActiveSheet()->getProtection()->setPassword($contrasenaexcel);
$doc->getActiveSheet()->getProtection()->setSheet(true);
$doc->getActiveSheet()->getProtection()->setSort(true);
$doc->getActiveSheet()->getProtection()->setInsertRows(true);
$doc->getActiveSheet()->getProtection()->setFormatCells(true);
$doc->getActiveSheet()->getStyle('D8')->getProtection()->setLocked(PHPExcel_Style_Protection::PROTECTION_UNPROTECTED);
//Inmovilizar Paneles
$doc->getActiveSheet()->freezePane('A11');
//Cambiar Nombre a Pestaña
$doc->getActiveSheet()->setTitle('Registro de Notas');
//Seleccionando Pestaña Principal
$doc->setActiveSheetIndex(0);
//Codigo Final de Exportación
开发者ID:anthonycab15,项目名称:colegio,代码行数:31,代码来源:exportar.php

示例6: get_expreportdaily


//.........这里部分代码省略.........
             $objPHPExcel->getActiveSheet()->setCellValueByColumnAndRow(7, $starline, $finan->setoran_wajib);
             $objPHPExcel->getActiveSheet()->setCellValueByColumnAndRow(8, $starline, $finan->tabungan_sparepart);
             $objPHPExcel->getActiveSheet()->setCellValueByColumnAndRow(9, $starline, $finan->denda);
             $objPHPExcel->getActiveSheet()->setCellValueByColumnAndRow(10, $starline, $finan->hutang_dp_sparepart);
             $objPHPExcel->getActiveSheet()->setCellValueByColumnAndRow(11, $starline, $finan->cicilan_ks);
             $objPHPExcel->getActiveSheet()->setCellValueByColumnAndRow(12, $starline, $finan->cicilan_sparepart);
             $objPHPExcel->getActiveSheet()->setCellValueByColumnAndRow(13, $starline, $finan->cicilan_dp_kso);
             $objPHPExcel->getActiveSheet()->setCellValueByColumnAndRow(14, $starline, $finan->cicilan_hutang_lama);
             $objPHPExcel->getActiveSheet()->setCellValueByColumnAndRow(15, $starline, $finan->cicilan_lain);
             $objPHPExcel->getActiveSheet()->setCellValueByColumnAndRow(16, $starline, $finan->biaya_cuci);
             $objPHPExcel->getActiveSheet()->setCellValueByColumnAndRow(17, $starline, $finan->iuran_laka);
             $objPHPExcel->getActiveSheet()->setCellValueByColumnAndRow(18, $starline, '=SUM(H' . $starline . ':R' . $starline . ')');
             $objPHPExcel->getActiveSheet()->setCellValueByColumnAndRow(19, $starline, $finan->potongan);
             $objPHPExcel->getActiveSheet()->setCellValueByColumnAndRow(20, $starline, $finan->setoran_cash);
             //$objPHPExcel->getActiveSheet()->setCellValueByColumnAndRow(20, $starline, $finan->ks);
             $objPHPExcel->getActiveSheet()->setCellValueByColumnAndRow(21, $starline, '=(U' . $starline . '-(S' . $starline . '-T' . $starline . '))');
             $objPHPExcel->getActiveSheet()->setCellValueByColumnAndRow(22, $starline, '=(U' . $starline . '-(Q' . $starline . '+R' . $starline . '))');
             $objPHPExcel->getActiveSheet()->setCellValueByColumnAndRow(23, $starline, $finan->shift);
             //col X
             //$objPHPExcel->getActiveSheet()->setCellValueByColumnAndRow(24, $starline, $finan->shift_id);
             //$objPHPExcel->getActiveSheet()->setCellValueByColumnAndRow(14, $starline, $finan->cicilan_lain);
             //hidden coloumn status operasi
             $objPHPExcel->getActiveSheet()->setCellValueByColumnAndRow(25, $starline, $finan->operasi_status_id);
             //col Z
             $no++;
             $starline++;
         }
         $objPHPExcel->getActiveSheet()->mergeCells('A' . ($starline + 1) . ':G' . ($starline + 1) . '');
         $objPHPExcel->getActiveSheet()->setCellValue('A' . ($starline + 1), 'TOTAL SETORAN ');
         $objPHPExcel->getActiveSheet()->setCellValue('H' . ($starline + 1), '=SUM(H8:H' . $starline . ')');
         $objPHPExcel->getActiveSheet()->setCellValue('I' . ($starline + 1), '=SUM(I8:I' . $starline . ')');
         $objPHPExcel->getActiveSheet()->setCellValue('J' . ($starline + 1), '=SUM(J8:J' . $starline . ')');
         $objPHPExcel->getActiveSheet()->setCellValue('K' . ($starline + 1), '=SUM(K8:K' . $starline . ')');
         $objPHPExcel->getActiveSheet()->setCellValue('L' . ($starline + 1), '=SUM(L8:L' . $starline . ')');
         $objPHPExcel->getActiveSheet()->setCellValue('M' . ($starline + 1), '=SUM(M8:M' . $starline . ')');
         $objPHPExcel->getActiveSheet()->setCellValue('N' . ($starline + 1), '=SUM(N8:N' . $starline . ')');
         $objPHPExcel->getActiveSheet()->setCellValue('O' . ($starline + 1), '=SUM(O8:O' . $starline . ')');
         $objPHPExcel->getActiveSheet()->setCellValue('P' . ($starline + 1), '=SUM(P8:P' . $starline . ')');
         $objPHPExcel->getActiveSheet()->setCellValue('Q' . ($starline + 1), '=SUM(Q8:Q' . $starline . ')');
         $objPHPExcel->getActiveSheet()->setCellValue('R' . ($starline + 1), '=SUM(R8:R' . $starline . ')');
         $objPHPExcel->getActiveSheet()->setCellValue('S' . ($starline + 1), '=SUM(S8:S' . $starline . ')');
         $objPHPExcel->getActiveSheet()->setCellValue('T' . ($starline + 1), '=SUM(T8:T' . $starline . ')');
         $objPHPExcel->getActiveSheet()->setCellValue('U' . ($starline + 1), '=SUM(U8:U' . $starline . ')');
         $objPHPExcel->getActiveSheet()->setCellValue('V' . ($starline + 1), '=SUM(V8:V' . $starline . ')');
         $objPHPExcel->getActiveSheet()->setCellValue('W' . ($starline + 1), '=SUM(W8:W' . $starline . ')');
         $objPHPExcel->getActiveSheet()->getStyle('A5:X' . ($starline + 1))->getBorders()->getAllBorders()->setBorderStyle(PHPExcel_Style_Border::BORDER_HAIR);
         $objPHPExcel->getActiveSheet()->getStyle('A5:X6')->getBorders()->getAllBorders()->setBorderStyle(PHPExcel_Style_Border::BORDER_THIN);
         $objPHPExcel->getActiveSheet()->getStyle('A5:X' . ($starline + 1))->getBorders()->getOutline()->setBorderStyle(PHPExcel_Style_Border::BORDER_THIN);
         $objPHPExcel->getActiveSheet()->getStyle('A' . ($starline + 1) . ':X' . ($starline + 1))->getBorders()->getAllBorders()->setBorderStyle(PHPExcel_Style_Border::BORDER_THIN);
         /* Rekap Pendapatan */
         $objPHPExcel->getActiveSheet()->setCellValue('D' . ($starline + 3), 'Total Setoran  :');
         $objPHPExcel->getActiveSheet()->setCellValue('D' . ($starline + 5), 'Disetor ke Bank  :');
         $objPHPExcel->getActiveSheet()->setCellValue('D' . ($starline + 6), 'Disetor ke KKBD  :');
         $objPHPExcel->getActiveSheet()->setCellValue('D' . ($starline + 7), 'Disetor ke Peduli Laka  :');
         $objPHPExcel->getActiveSheet()->setCellValue('E' . ($starline + 3), '=SUM(U8:U' . $starline . ')');
         $objPHPExcel->getActiveSheet()->setCellValue('E' . ($starline + 5), '=SUM(W8:W' . $starline . ')');
         $objPHPExcel->getActiveSheet()->setCellValue('E' . ($starline + 6), '=SUM(Q8:Q' . $starline . ')');
         $objPHPExcel->getActiveSheet()->setCellValue('E' . ($starline + 7), '=SUM(R8:R' . $starline . ')');
         /* Rekap Unit Operasi */
         $objPHPExcel->getActiveSheet()->setCellValue('H' . ($starline + 3), 'Unit Sirkulasi  :');
         $objPHPExcel->getActiveSheet()->setCellValue('H' . ($starline + 5), 'Unit Operasi  :');
         $objPHPExcel->getActiveSheet()->setCellValue('H' . ($starline + 6), 'Status  B P :');
         $objPHPExcel->getActiveSheet()->setCellValue('H' . ($starline + 7), 'Status  B L :');
         $objPHPExcel->getActiveSheet()->setCellValue('H' . ($starline + 8), 'Status  T D O (Lain-Lain):');
         $objPHPExcel->getActiveSheet()->setCellValue('I' . ($starline + 3), '=COUNT(Z8:Z' . $starline . ')');
         $objPHPExcel->getActiveSheet()->setCellValue('I' . ($starline + 5), '=COUNTIF(Z8:Z' . $starline . ', 1)');
         $objPHPExcel->getActiveSheet()->setCellValue('I' . ($starline + 6), '=COUNTIF(Z8:Z' . $starline . ', 3)');
         $objPHPExcel->getActiveSheet()->setCellValue('I' . ($starline + 7), '=COUNTIF(Z8:Z' . $starline . ', 7)');
         $objPHPExcel->getActiveSheet()->setCellValue('I' . ($starline + 8), '=I' . ($starline + 3) . '-(I' . ($starline + 5) . '+ I' . ($starline + 6) . '+ I' . ($starline + 7) . ')');
         /* Rekap KETEKORAN */
         $objPHPExcel->getActiveSheet()->setCellValue('K' . ($starline + 3), 'Total Ketekoran :');
         $objPHPExcel->getActiveSheet()->setCellValue('K' . ($starline + 5), 'KS Murni  :');
         $objPHPExcel->getActiveSheet()->setCellValue('K' . ($starline + 6), 'KS BP:');
         $objPHPExcel->getActiveSheet()->setCellValue('K' . ($starline + 7), 'KS BL :');
         $objPHPExcel->getActiveSheet()->setCellValue('K' . ($starline + 8), 'KS TDO (Lain-Lain):');
         $objPHPExcel->getActiveSheet()->setCellValue('L' . ($starline + 3), '=V' . ($starline + 1));
         $objPHPExcel->getActiveSheet()->setCellValue('L' . ($starline + 5), '=SUMIF(Z8:Z' . $starline . ',1,V8:V' . $starline . ')');
         $objPHPExcel->getActiveSheet()->setCellValue('L' . ($starline + 6), '=SUMIF(Z8:Z' . $starline . ',3,V8:V' . $starline . ')');
         $objPHPExcel->getActiveSheet()->setCellValue('L' . ($starline + 7), '=SUMIF(Z8:Z' . $starline . ',7,V8:V' . $starline . ')');
         $objPHPExcel->getActiveSheet()->setCellValue('L' . ($starline + 8), '=L' . ($starline + 3) . '-(L' . ($starline + 5) . '+ L' . ($starline + 6) . '+ L' . ($starline + 7) . ')');
         $objPHPExcel->getActiveSheet()->setCellValue('B' . ($starline + 10), 'Tanggal Unduh');
         $objPHPExcel->getActiveSheet()->setCellValue('C' . ($starline + 10), ':');
         $objPHPExcel->getActiveSheet()->setCellValue('D' . ($starline + 10), date('Y-m-d H:i:s'));
         $objPHPExcel->getSecurity()->setLockWindows(true);
         $objPHPExcel->getSecurity()->setLockStructure(true);
         $objPHPExcel->getSecurity()->setWorkbookPassword("FreeBlocking");
         $objPHPExcel->getActiveSheet()->getProtection()->setPassword('FreeBlocking');
         $objPHPExcel->getActiveSheet()->getProtection()->setSheet(true);
         // This should be enabled in order to enable any of the following!
         //$objPHPExcel->getActiveSheet()->getProtection()->setSort(true);
         $objPHPExcel->getActiveSheet()->getProtection()->setInsertRows(true);
         //$objPHPExcel->getActiveSheet()->getProtection()->setFormatCells(true);
         $objPHPExcel->getActiveSheet()->setTitle('Laporan ' . $model->fleet_model . ' - ' . $date);
         $sheet_active++;
     }
     $objWriter = PHPExcel_IOFactory::createWriter($objPHPExcel, 'Excel5');
     //echo path('public');
     $objWriter->save(path('public') . 'Laporan-Harian-' . Pool::find(Auth::user()->pool_id)->pool_name . '-Tanggal-' . $date . '.xls');
     return Response::download(path('public') . 'Laporan-Harian-' . Pool::find(Auth::user()->pool_id)->pool_name . '-Tanggal-' . $date . '.xls', 'Laporan-Harian-' . Pool::find(Auth::user()->pool_id)->pool_name . '-Tanggal-' . $date . '.xls');
 }
开发者ID:acmadi,项目名称:diantaksi,代码行数:101,代码来源:financials.php

示例7: PHPExcel

</div>
<?php 
echo Form::close();
?>

<?php 
if ($salaries) {
    Package::load("phpexcel");
    $excel = new PHPExcel();
    $excel->getProperties()->setCreator("NeoGen Labs")->setTitle("Salary Statement");
    $excel->getActiveSheet()->setTitle('Monthly Salary Statement');
    $excel->getActiveSheet()->setShowGridlines(true);
    $excel->getActiveSheet()->getStyle('A2:U2')->getFill()->setFillType(PHPExcel_Style_Fill::FILL_SOLID)->getStartColor()->setARGB('FFCCFFCC');
    $excel->getActiveSheet()->getStyle('V2:AC2')->getFill()->setFillType(PHPExcel_Style_Fill::FILL_SOLID)->getStartColor()->setARGB('FFCCFFFF');
    $excel->getActiveSheet()->getStyle()->getNumberFormat()->setFormatCode(PHPExcel_Style_NumberFormat::FORMAT_NUMBER_COMMA_SEPARATED1);
    $excel->getSecurity()->setLockWindows(true);
    $excel->getSecurity()->setLockStructure(true);
    $excel->getSecurity()->setWorkbookPassword("admin");
    $excel->getActiveSheet()->getColumnDimension()->setAutoSize(true);
    $m = array('1' => 'Jan', '2' => 'Feb', '3' => 'Mar', '4' => 'Apr', '5' => 'May', '6' => 'Jun', '7' => 'Jul', '8' => 'Aug', '9' => 'Sep', '10' => 'Oct', '11' => 'Nov', '12' => 'Dec');
    $excel->setActiveSheetIndex(0)->setCellValue('B1', $m[$month] . '-' . $year);
    $excel->setActiveSheetIndex(0)->setCellValue('A2', 'No.')->setCellValue('B2', 'Name')->setCellValue('C2', 'Gross')->setCellValue('D2', 'SDXO')->setCellValue('E2', 'Adj. SDX')->setCellValue('F2', 'PFV')->setCellValue('G2', 'PF Adj.')->setCellValue('H2', 'Basic')->setCellValue('I2', 'HRA')->setCellValue('J2', 'LTA')->setCellValue('K2', 'Medical')->setCellValue('L2', 'Travel')->setCellValue('M2', 'PF')->setCellValue('N2', 'Other')->setCellValue('O2', "Leave")->setCellValue('P2', 'Bonus1')->setCellValue('Q2', 'Bonus2')->setCellValue('R2', 'Allowance1')->setCellValue('S2', 'Allowance2')->setCellValue('T2', 'Allowance3')->setCellValue('U2', 'Credit Total')->setCellValue('V2', 'Prof. Tax')->setCellValue('W2', 'PF')->setCellValue('X2', 'Income Tax')->setCellValue('Y2', 'Deduction1')->setCellValue('Z2', 'Deduction2')->setCellValue('AA2', 'Deduction3')->setCellValue('AB2', 'Total Debit')->setCellValue('AC2', 'Net');
    $excel->setActiveSheetIndex(0)->setCellValue('G3', $pf_adjust->value)->setCellValue('H3', $basic->value)->setCellValue('I3', $hra->value)->setCellValue('J3', $lta->value)->setCellValue('K3', $medical->value)->setCellValue('L3', $travel->value)->setCellValue('M3', $pf->value);
    $rowCount = 4;
    foreach ($salaries as $salary) {
        if ($salary->pf_applicable == 1) {
            $pf = 1;
        } else {
            $pf = 0;
        }
        $adj_sdxo = $salary->gross - $salary->sdxo;
开发者ID:cloudetm,项目名称:payroll,代码行数:31,代码来源:payroll.php

示例8: setSecurity

 /**
  * Setea la seguridad de la hoja de cálculo para que sea imposible de modificar su contenido
  *
  * @param \PHPExcel $objPHPExcel
  */
 public function setSecurity(&$objPHPExcel)
 {
     $password = $this->randomPassword();
     //Seguridad al documento
     $objPHPExcel->getSecurity()->setLockWindows(true);
     $objPHPExcel->getSecurity()->setLockStructure(true);
     $objPHPExcel->getSecurity()->setLockRevision(true);
     $objPHPExcel->getSecurity()->setWorkbookPassword($password);
     //Seguridad a las hojas de estilo
     //Se debe de realizar un proceso de seguridad a todas las hojas en excel
     $objPHPExcel->getActiveSheet()->getProtection()->setPassword($password);
     //$objPHPExcel->getActiveSheet()->getProtection()->setSheet(false);
     $objPHPExcel->getActiveSheet()->getProtection()->setDeleteColumns(true);
     $objPHPExcel->getActiveSheet()->getProtection()->setFormatCells(true);
     $objPHPExcel->getActiveSheet()->getProtection()->setInsertColumns(true);
     $objPHPExcel->getActiveSheet()->getProtection()->setInsertHyperlinks(true);
     $objPHPExcel->getActiveSheet()->getProtection()->setInsertRows(true);
     $objPHPExcel->getActiveSheet()->getProtection()->setSort(true);
     //Desactiva la seguridad de una celda especifica
     /*		$objPHPExcel->getActiveSheet()->getStyle('B1')->getProtection()->setLocked(
     		 \PHPExcel_Style_Protection::PROTECTION_UNPROTECTED
     		);
     		*/
     $objPHPExcel->getActiveSheet()->getProtection()->setSheet(true);
 }
开发者ID:blackhack123,项目名称:DISPO-AGRINAG,代码行数:30,代码来源:PHPExcelApp.php


注:本文中的PHPExcel::getSecurity方法示例由纯净天空整理自Github/MSDocs等开源代码及文档管理平台,相关代码片段筛选自各路编程大神贡献的开源项目,源码版权归原作者所有,传播和使用请参考对应项目的License;未经允许,请勿转载。