*/ private $_zipXlsx; /** * * @access private * @var */ private $_xmlXlTablesContent; /** * * @access private * @var */ private $_xmlXlSharedStringsContent; /** * * @access private * @var */ private $_xmlXlSheetContent; /** * Construct * * @access public */ public function __construct() { } /** * Destruct * * @access public */ public function __destruct() { } /** * * @access public * @return string */ public function __toString() { return $this->_zipXlsx; } /** * Create XLSX * * @access public * @return bool */ public function createXlsx() { $args = func_get_args(); $this->_zipXlsx = new ZipArchive(); $error = $this->_zipXlsx->open($args[0], ZIPARCHIVE::CREATE); if(true !== $error){ $error = $this->_zipXlsx->open($args[0], ZIPARCHIVE::OVERWRITE); } $this->_xmlXlTablesContent = ''; $this->_xmlXlSharedStringsContent = ''; $this->_xmlXlSheetContent = ''; try { $dirname = substr(__FILE__, 0, strpos(__FILE__, '/classes')) . '/excel/'; $this->_zipXlsx->addFile( $dirname . '[Content_Types].xml', '[Content_Types].xml' ); $this->_zipXlsx->addFile( $dirname . 'docProps/core.xml', 'docProps/core.xml' ); $this->_zipXlsx->addFile( $dirname . 'docProps/app.xml', 'docProps/app.xml' ); $this->_zipXlsx->addFile( $dirname . '_rels/.rels', '_rels/.rels' ); $this->_zipXlsx->addFile( $dirname . 'xl/_rels/workbook.xml.rels', 'xl/_rels/workbook.xml.rels' ); $this->_zipXlsx->addFile( $dirname . 'xl/theme/theme1.xml', 'xl/theme/theme1.xml' ); $this->_zipXlsx->addFile( $dirname . 'xl/worksheets/_rels/sheet1.xml.rels', 'xl/worksheets/_rels/sheet1.xml.rels' ); $this->_zipXlsx->addFile( $dirname . 'xl/styles.xml', 'xl/styles.xml' ); $this->_zipXlsx->addFile( $dirname . 'xl/workbook.xml', 'xl/workbook.xml' ); $this->_zipXlsx->addFromString( 'xl/tables/table1.xml', $this->createExcelTable($args[1]) ); $this->_zipXlsx->addFromString( 'xl/sharedStrings.xml', $this->createExcelSharedStrings($args[1]) ); $this->_zipXlsx->addFromString( 'xl/worksheets/sheet1.xml', $this->createExcelSheet($args[1]) ); $this->_zipXlsx->close(); return true; } catch (Exception $e) { echo 'There was an error related to XLSX file: ', $e->getMessage(), "\n"; return false; } } /** * Generate sst * * @param string $num * @access protected */ protected function generateSST($num) { $this->_xml = '__GENERATESST__'; } /** * Generate si * @access protected */ protected function generateSI() { $xml = '__GENERATESI____GENERATESST__'; $this->_xml = str_replace('__GENERATESST__', $xml, $this->_xml); } /** * Generate t * * @param string $name * @param string $space * @access protected */ protected function generateT($name, $space = '') { $xmlAux = ''; $this->_xml = str_replace('__GENERATESI__', $xmlAux, $this->_xml); } /** * Generate c * * @param string $r * @param string $s * @param string $t * @access protected */ protected function generateC($r, $s, $t = '') { $xmlAux = '_xml = str_replace('__GENERATEROW__', $xmlAux, $this->_xml); } /** * Generate col * * @param string $min * @param string $max * @param string $width * @param string $customWidth * @access protected */ protected function generateCOL($min = '1', $max = '1', $width = '11.85546875', $customWidth = '1') { $xml = ''; $this->_xml = str_replace('__GENERATECOLS__', $xml, $this->_xml); } /** * Generate cols * * @access protected */ protected function generateCOLS() { $xml = '__GENERATECOLS____GENERATEWORKSHEET__'; $this->_xml = str_replace('__GENERATEWORKSHEET__', $xml, $this->_xml); } /** * Generate dimension * * @param int $sizeX * @param int $sizeY * @access protected */ protected function generateDIMENSION($sizeX, $sizeY) { $char = 'A'; for ($i = 0; $i < $sizeY; $i++) $char++; $sizeX += $sizeY; $xml = '__GENERATEWORKSHEET__'; $this->_xml = str_replace('__GENERATEWORKSHEET__', $xml, $this->_xml); } /** * Generate pagemargins * * @param string $left * @param string $rigth * @param string $bottom * @param string $top * @param string $header * @param string $footer * @access protected */ protected function generatePAGEMARGINS($left = '0.7', $rigth = '0.7', $bottom = '0.75', $top = '0.75', $header = '0.3', $footer = '0.3') { $xml = '__GENERATEWORKSHEET__'; $this->_xml = str_replace('__GENERATEWORKSHEET__', $xml, $this->_xml); } /** * Generate pagesetup * * @param string $paperSize * @param string $orientation * @param string $id * @access protected */ protected function generatePAGESETUP($paperSize = '9', $orientation = 'portrait', $id = '1') { $xml = '__GENERATEWORKSHEET__'; $this->_xml = str_replace('__GENERATEWORKSHEET__', $xml, $this->_xml); } /** * Generate row * * @param string $r * @param string $spans * @access protected */ protected function generateROW($r, $spans) { $spans = '1:' . ($spans + 1); $xml = '__GENERATEROW____GENERATESHEETDATA__'; $this->_xml = str_replace('__GENERATESHEETDATA__', $xml, $this->_xml); } /** * Generate selection * * @param string $num * @access protected */ protected function generateSELECTION($num) { $xml = ''; $this->_xml = str_replace('__GENERATESHEETVIEW__', $xml, $this->_xml); } /** * Generate sheetdata * * @access protected */ protected function generateSHEETDATA() { $xml = '__GENERATESHEETDATA__' . '__GENERATEWORKSHEET__'; $this->_xml = str_replace('__GENERATEWORKSHEET__', $xml, $this->_xml); } /** * Generate sheetformatpr * * @param string $baseColWidth * @param string $defaultRowHeight * @access protected */ protected function generateSHEETFORMATPR($baseColWidth = '10', $defaultRowHeight = '15') { $xml = '__GENERATEWORKSHEET__'; $this->_xml = str_replace('__GENERATEWORKSHEET__', $xml, $this->_xml); } /** * Generate sheetview * * @param string $tabSelected * @param string $workbookViewId * @access protected */ protected function generateSHEETVIEW($tabSelected = '1', $workbookViewId = '0') { $xml = '__GENERATESHEETVIEW__'; $this->_xml = str_replace('__GENERATESHEETVIEWS__', $xml, $this->_xml); } /** * Generate sheetviews * * @access protected */ protected function generateSHEETVIEWS() { $xml = '__GENERATESHEETVIEWS__' . '__GENERATEWORKSHEET__'; $this->_xml = str_replace('__GENERATEWORKSHEET__', $xml, $this->_xml); } /** * Generate tablepart * * @param string $id * @access protected */ protected function generateTABLEPART($id = '1') { $xml = ''; $this->_xml = str_replace('__GENERATETABLEPARTS__', $xml, $this->_xml); } /** * Generate tableparts * * @param string $count * @access protected */ protected function generateTABLEPARTS($count = '1') { $xml = '__GENERATETABLEPARTS__'; $this->_xml = str_replace('__GENERATEWORKSHEET__', $xml, $this->_xml); } /** * Generate v * * @param string $num * @access protected */ protected function generateV($num) { $this->_xml = str_replace( '__GENERATEC__', '' . $num . '', $this->_xml ); } /** * Generate worksheet * * @access protected */ protected function generateWORKSHEET() { $this->_xml = '__GENERATEWORKSHEET__'; } /** * Clean template row tags * * @access private */ protected function cleanTemplateROW() { $this->_xml = str_replace('__GENERATEROW__', '', $this->_xml); } /** * Generate table * * @param int $rows * @param int $cols * @access protected */ protected function generateTABLE($rows, $cols) { $word = 'A'; for ($i = 0; $i < $cols; $i++) $word++; $rows++; $this->_xml = ''. ''. '__GENERATETABLE__'; } /** * Generate tablecolumn * * @param string $id * @param string $name * @access protected */ protected function generateTABLECOLUMN($id = '2', $name = '') { $xml = '__GENERATETABLECOLUMNS__'; $this->_xml = str_replace( '__GENERATETABLECOLUMNS__', $xml, $this->_xml ); } /** * Generate tablecolumns * * @param string $count * @access protected */ protected function generateTABLECOLUMNS($count = '2') { $xml = '__GENERATETABLECOLUMNS____GENERATETABLE__'; $this->_xml = str_replace('__GENERATETABLE__', $xml, $this->_xml); } /** * Generate tablestyleinfo * * @param string $showFirstColumn * @param string $showLastColumn * @param string $showRowStripes * @param string $showColumnStripes * @access protected */ protected function generateTABLESTYLEINFO($showFirstColumn = '0', $showLastColumn = "0", $showRowStripes = "1", $showColumnStripes = "0") { $xml = ''; $this->_xml = str_replace('__GENERATETABLE__', $xml, $this->_xml); } }