Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- <?php
- use PhpOffice\PhpSpreadsheet\Spreadsheet;
- use PhpOffice\PhpSpreadsheet\IOFactory;
- /*
- Bagian ini silahkan anggap tidak ada..
- karena dasarnya ini include composer (autoload.php)
- */
- {
- $paths = [
- __DIR__ . '/../vendor/autoload.php', // In case PhpSpreadsheet is cloned directly
- __DIR__ . '/../../../autoload.php', // In case PhpSpreadsheet is a composer dependency.
- __DIR__ . '/../../../web/example/vendor/autoload.php' //memakai ini
- ];
- foreach ($paths as $path) {
- if (file_exists($path)) {
- require_once $path;
- //echo "run:$path";
- ;
- }
- }
- }
- function sCellPos($row,$col)
- {
- //hanya untuk A-Z (26)
- //$p=ord('A');//65
- $rowInt=64+$row;
- $p=chr($rowInt).$col;
- return $p;
- }
- //echo sCellPos(1,2);echo sCellPos(2,2);echo sCellPos(4,2);
- //die();
- ?>
- <!--
- /**
- ##INFO##
- {"title":"excel Dasar ","detail":"Membuat excel menggunakan PHP Spreadsheet . Memanfaatkan Lock, kunci untuk buka dan posisi ditentukan dengan fungsi bukan huruf.<br>terbatas hanya A-Z"}
- ##INFO##
- **/
- -->
- <?php
- $spreadsheet = new Spreadsheet();
- $spreadsheet->setActiveSheetIndex(0)
- ->setCellValue(sCellPos(1,2), 'Hello')
- ->setCellValue(sCellPos(2,2), 'world!')
- ->setCellValue(sCellPos(3,1), 'Hello')
- ->setCellValue(sCellPos(4,2), 'world!')
- ->setCellValue(sCellPos(5,5), date("Y-m-d H:i:s"));
- $spreadsheet->getActiveSheet()
- ->setTitle('Simple');
- //not working???
- $spreadsheet->getSecurity()->setLockWindows(false);
- $spreadsheet->getSecurity()->setLockStructure(true);
- $spreadsheet->getSecurity()->setWorkbookPassword('php2021');
- $spreadsheet->getActiveSheet()->getProtection()->setPassword('php2021');
- $spreadsheet->getActiveSheet()->getProtection()->setSheet(true); // This should be enabled in order to enable any of the following!
- $spreadsheet->getActiveSheet()->getProtection()->setSort(true);
- $spreadsheet->getActiveSheet()->getProtection()->setInsertRows(true);
- $spreadsheet->getActiveSheet()->getProtection()->setFormatCells(true);
- //properties
- $spreadsheet->getProperties()->setCreator('Gunawan Wibisono')
- ->setLastModifiedBy('Scripter PHP')
- ->setTitle('Learn Document part 2')
- ->setSubject('Office 2007 XLSX Learn Document')
- ->setDescription('membuat dokumen Office 2007 XLSX, memanfaatkan Lock.')
- ->setKeywords('office 2007 openxml php')
- ->setCategory('php excel native');
- /*
- Pada Bagian ini disarankan simpan ke folder dahulu
- sebelum mengeluarkan..
- atau di download
- */
- $file='contoh006.xlsx';
- header('Content-Type: application/vnd.openxmlformats-officedocument.spreadsheetml.sheet');
- header('Content-Disposition: attachment;filename="'.$file.'"');
- header('Content-Length: ' . filesize($file));
- header('Content-Transfer-Encoding: binary');
- header('Cache-Control: must-revalidate');
- header('Pragma: public');
- ob_clean();
- flush();
- $writer = IOFactory::createWriter($spreadsheet, 'Xlsx');
- $writer->save($file);
- $str=file_get_contents($file);
- die($str);
Add Comment
Please, Sign In to add comment