/** * Checks that the given argument is valid * To be used as callback in GetOpt argument validation * @param string $arg Command-line option argument to validate * @return bool true if valid */ static function validate($arg) { switch (strtolower($arg[0])) { case 'a': case 't': case '2': self::$format = self::ALL; return true; case 'x': self::$format = self::EXCEL; return true; case 'p': self::$format = self::PDF; return true; default: return false; } }
$xlWS->getPageSetup()->setPaperSize(PHPExcel_Worksheet_PageSetup::PAPERSIZE_A4)->setOrientation(PHPExcel_Worksheet_PageSetup::ORIENTATION_LANDSCAPE)->setFitToWidth(1)->setFitToHeight(0); $xlWS->getPageMargins()->setLeft(0.5)->setRight(0.5); // Page footer $xlWS->getHeaderFooter()->setOddFooter('&L&F' . '&C' . 'APECOVE - http://apecove.ch' . '&R' . date('d.m.Y H:i:s')); // ---------------------------------------------------------------------------- // Save the workbook // $xlWS->setSelectedCells('A1'); // List of generated files $files = array(); if (ExportFileFormat::isExcel()) { $files[] = $filename = $base_filename . '.xlsx'; PHPExcel_Shared_Font::setAutoSizeMethod(PHPExcel_Shared_Font::AUTOSIZE_METHOD_EXACT); save($xl, $filename, 'PHPExcel_Writer_Excel2007'); } if (ExportFileFormat::isPDF()) { $files[] = $filename = $base_filename . '.pdf'; // PDF output relies on ShowGridlines and not PrintGridlines $xlWS->setShowGridlines(false); // With 'exact' autosize method, columns are too narrow, causing cell // contents (e.g. phone numbers) to wrap PHPExcel_Shared_Font::setAutoSizeMethod(PHPExcel_Shared_Font::AUTOSIZE_METHOD_APPROX); save($xl, $filename, 'PHPExcel_Writer_PDF'); } // ------------------------------------------------------------------------ // Send e-mail // if ($opt['send'] || $opt['debug']) { if ($send_email) { $recipients = array('to' => array_unique($recipients), 'bcc' => array_column($profs, 'email')); echo ' ';