function createXLSAdv(&$rows, $row_labels = null, $row_headers = null, $title = null) { ob_clean(); ob_start(); require_once JPATH_COMPONENT_SITE . DS . 'libraries' . DS . 'pear' . DS . 'PEAR.php'; require_once JPATH_COMPONENT_SITE . DS . 'libraries' . DS . 'Excel' . DS . 'Writer.php'; // Creating a workbook $workbook = new Spreadsheet_Excel_Writer(); $worksheet = $workbook->addWorksheet($title); $BIFF = new Spreadsheet_Excel_Writer_BIFFwriter(); $format = new Spreadsheet_Excel_Writer_Format($BIFF); $format->setBold(1); $format->setAlign('center'); for ($k = 0; $k < count($row_labels); $k++) { $worksheet->write(0, $k, $row_headers[$row_labels[$k]], $format); } for ($i = 0; $i < count($rows); $i++) { for ($k = 0; $k < count($row_labels); $k++) { $worksheet->write($i + 1, $k, $rows[$i][$row_labels[$k]]); } } $workbook->close(); $attachment = ob_get_contents(); @ob_end_clean(); echo $attachment; }
function createXLS($result) { ob_clean(); ob_start(); set_time_limit(0); error_reporting(0); require_once JPATH_COMPONENT_SITE . '/libraries/pear/PEAR.php'; require_once (JPATH_ROOT . '/components/com_bids/libraries/Excel/Writer.php'); // Creating a workbook $workbook = new Spreadsheet_Excel_Writer(); $workbook->setTempDir(JPATH_ROOT.DS.'tmp'); $worksheet = $workbook->addWorksheet('Exported Auctions'); $BIFF = new Spreadsheet_Excel_Writer_BIFFwriter(); $format = new Spreadsheet_Excel_Writer_Format($BIFF); $format->setBold(1); $format->setAlign('center'); $colNr = 0; $worksheet->write(0, $colNr++, "User", $format); $worksheet->write(0, $colNr++, "Title", $format); $worksheet->write(0, $colNr++, "Short description"); $worksheet->write(0, $colNr++, "Description"); $worksheet->write(0, $colNr++, "Initial price"); $worksheet->write(0, $colNr++, "Currency"); $worksheet->write(0, $colNr++, "BIN price"); $worksheet->write(0, $colNr++, "Auction type"); $worksheet->write(0, $colNr++, "Automatic"); $worksheet->write(0, $colNr++, "Payment"); $worksheet->write(0, $colNr++, "Shipment Info"); $worksheet->write(0, $colNr++, "Start date"); $worksheet->write(0, $colNr++, "End date"); $worksheet->write(0, $colNr++, "Param: picture"); $worksheet->write(0, $colNr++, "Param: add_picture"); $worksheet->write(0, $colNr++, "Param: auto_accept_bin"); $worksheet->write(0, $colNr++, "Param: bid_counts"); $worksheet->write(0, $colNr++, "Param: max_price"); $worksheet->write(0, $colNr++, "Published"); $worksheet->write(0, $colNr++, "Category"); $worksheet->write(0, $colNr++, "Highest Bid"); for ($i = 0; $i < count($result); $i++) { $colNr = 0; $worksheet->write($i + 1, $colNr++, $result[$i]->username); $worksheet->write($i + 1, $colNr++, $result[$i]->title); $worksheet->write($i + 1, $colNr++, $result[$i]->shortdescription); $worksheet->write($i + 1, $colNr++, $result[$i]->description); $worksheet->write($i + 1, $colNr++, $result[$i]->initial_price); $worksheet->write($i + 1, $colNr++, $result[$i]->currency); $worksheet->write($i + 1, $colNr++, $result[$i]->BIN_price); switch ($result[$i]->auction_type) { case 1: $worksheet->write($i + 1, $colNr++, 'public'); break; case 2: $worksheet->write($i + 1, $colNr++, 'private'); break; case 3: $worksheet->write($i + 1, $colNr++, 'BIN only'); break; } $worksheet->write($i + 1, $colNr++, $result[$i]->automatic); $worksheet->write($i + 1, $colNr++, $result[$i]->payment_method); $worksheet->write($i + 1, $colNr++, $result[$i]->shipment_info); $worksheet->write($i + 1, $colNr++, $result[$i]->start_date); $worksheet->write($i + 1, $colNr++, $result[$i]->end_date); $params = explode("\n", $result[$i]->params); $tmp = explode("=", $params[0]); // picture param $worksheet->write($i + 1, $colNr++, $tmp[1]); $tmp = explode("=", $params[1]); // add_picture $worksheet->write($i + 1, $colNr++, $tmp[1]); $tmp = explode("=", $params[2]); // auto_accept_bin $worksheet->write($i + 1, $colNr++, $tmp[1]); $tmp = explode("=", $params[3]); // bid_counts $worksheet->write($i + 1, $colNr++, $tmp[1]); $tmp = explode("=", $params[4]); // max_price $worksheet->write($i + 1, $colNr++, $tmp[1]); $worksheet->write($i + 1, $colNr++, $result[$i]->published); $worksheet->write($i + 1, $colNr++, $result[$i]->catname); $worksheet->write($i + 1, $colNr++, $result[$i]->highest_bid); $worksheet->setColumn(0, 0, 9); $worksheet->setColumn(1, 12, 25); } $workbook->close(); $attachment = ob_get_clean(); return $attachment; }