search

iliaal / php_excel

PHP Extension interface to the Excel writing/reading library
http://ilia.ws
533 stars 131 forks source link

phpExcel: excel sheet downloading but content not showing #246

Closed swapnilb0506 closed 3 years ago

swapnilb0506 commented 5 years ago

Need a help to resolve the excel sheet issue with PHPExcel . I'm trying to generate the PHPExcel version 1.8 from database. The problem is that excel sheet get creating and memory also get occupied but the content is not showing so it's showing blank excel sheet when my project in online but so it's showing excel sheet is proper when my project in offline my php version is 5.6

This are my code please check <?php if (session_id() == "") session_start(); include("../../inc/dbConnect.inc_report.php");

error_reporting(E_ALL); ini_set('display_errors', TRUE); ini_set('display_startup_errors', TRUE); date_default_timezone_set('Europe/London');

if (PHP_SAPI == 'cli') die('This example should only be run from a Web Browser');

require("PHPExcel.php"); // Create new PHPExcel object $objPHPExcel = new PHPExcel();

// Set document properties $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

$objPHPExcel->setActiveSheetIndex(0) ->setCellValue('D1', 'DATE WISE ITEM SALE REPORT') ->setCellValue('A2', 'SR No.') ->setCellValue('B2', 'HSN NO') ->setCellValue('C2', 'ITEM NAME') ->setCellValue('D2', 'QUANTITY') ->setCellValue('E2', 'TAXBLE VALUE') ->setCellValue('F2', 'TAX VALUE');

// Miscellaneous glyphs, UTF-8

$objPHPExcel->setActiveSheetIndex(0);

$rowCount = 3; date_default_timezone_set('Asia/Calcutta'); $from_date=$_POST['txt_from_date']; $to_date=$_POST['txt_to_date']; $from_date = date("Y-m-d", strtotime($from_date)); $to_date = date("Y-m-d", strtotime($to_date));
$sales_invoice_id=''; $item_name=''; $hsn_code=''; $quantity=0; $sr_no=1; $total_item_qty=0; $total_taxable_value=0; $total_tax_value=0;

                                $sq_invoice_details = mysqli_query($con,"SELECT distinct(item_id) from sales_invoice_details,sales_invoice where sales_invoice.invoice_date between '$from_date' and '$to_date' and sales_invoice.sales_invoice_id = sales_invoice_details.sales_invoice_id and sales_invoice.organization_id='$_SESSION[ORGID]'");
                                while($row_invoice_details = mysqli_fetch_assoc($sq_invoice_details))
                                {

                                $sq_item_name_price = mysqli_query($con,"SELECT item_name,hsn_no from item_details where item_id='$row_invoice_details[item_id]'");
                                if($row_item_name_price = mysqli_fetch_assoc($sq_item_name_price))
                                {
                                $item_name = $row_item_name_price['item_name'];
                                $hsn_code = $row_item_name_price['hsn_no'];

                                }

                                $sum_qty=0;
                                $taxble_value=0;
                                $tax_value=0;
                                $total_gst=0;
                                $taxble_value_amount =0;
                               $sql = mysqli_query($con,"SELECT * from sales_invoice_details,sales_invoice where sales_invoice.invoice_date  between '$from_date' and '$to_date'  and sales_invoice.sales_invoice_id = sales_invoice_details.sales_invoice_id and sales_invoice_details.item_id='$row_invoice_details[item_id]' and sales_invoice_details.organization_id='$_SESSION[ORGID]'");

                               // $sum_qty=0;
                                while ($row = mysqli_fetch_assoc($sql)){
                                $qty = $row['quantity'];

// $item_price = $row['item_price']; $sum_qty=$sum_qty + $qty; $taxble_value = $row['sale_price'] * $row['quantity']; $total_gst = $row['cgst_rs']+$row['sgst_rs']; $tax_value=$tax_value + $total_gst; $taxble_value_amount = $taxble_value_amount + $taxble_value; }

$objPHPExcel->getActiveSheet()->SetCellValue('A'.$rowCount, $sr_no);
$objPHPExcel->getActiveSheet()->SetCellValue('B'.$rowCount, $hsn_code);
$objPHPExcel->getActiveSheet()->SetCellValue('C'.$rowCount, $item_name);
$objPHPExcel->getActiveSheet()->SetCellValue('D'.$rowCount, $sum_qty);
$objPHPExcel->getActiveSheet()->SetCellValue('E'.$rowCount, $taxble_value_amount);
$objPHPExcel->getActiveSheet()->SetCellValue('F'.$rowCount, $tax_value);

$rowCount++;
$sr_no++;
$total_item_qty = $total_item_qty + $sum_qty;
$total_taxable_value = $total_taxable_value + $taxble_value_amount;
$total_tax_value = $total_tax_value + $tax_value; 
} 

$total_rowCount = $rowCount + 1;    

$objPHPExcel->getActiveSheet()->SetCellValue('A'.$total_rowCount, '');
$objPHPExcel->getActiveSheet()->SetCellValue('B'.$total_rowCount, '');
$objPHPExcel->getActiveSheet()->SetCellValue('C'.$total_rowCount, 'Total:');
$objPHPExcel->getActiveSheet()->SetCellValue('D'.$total_rowCount, bcdiv($total_item_qty,1,2));
$objPHPExcel->getActiveSheet()->SetCellValue('E'.$total_rowCount, bcdiv($total_taxable_value,1,2));
$objPHPExcel->getActiveSheet()->SetCellValue('F'.$total_rowCount, bcdiv($total_tax_value,1,2));

$objPHPExcel->getActiveSheet()->getStyle('A'.$total_rowCount)->getFont()->setBold(true);
$objPHPExcel->getActiveSheet()->getStyle('B'.$total_rowCount)->getFont()->setBold(true);
$objPHPExcel->getActiveSheet()->getStyle('C'.$total_rowCount)->getFont()->setBold(true);
$objPHPExcel->getActiveSheet()->getStyle('D'.$total_rowCount)->getFont()->setBold(true);
$objPHPExcel->getActiveSheet()->getStyle('E'.$total_rowCount)->getFont()->setBold(true);
$objPHPExcel->getActiveSheet()->getStyle('F'.$total_rowCount)->getFont()->setBold(true);

// Rename worksheet $objPHPExcel->getActiveSheet()->setTitle('DATE WISE INVOICE'); $objPHPExcel->getActiveSheet()->getStyle("D1")->getFont()->setBold(true); $objPHPExcel->getActiveSheet()->getStyle("A2")->getFont()->setBold(true); $objPHPExcel->getActiveSheet()->getStyle("B2")->getFont()->setBold(true); $objPHPExcel->getActiveSheet()->getStyle("C2")->getFont()->setBold(true); $objPHPExcel->getActiveSheet()->getStyle("D2")->getFont()->setBold(true); $objPHPExcel->getActiveSheet()->getStyle("E2")->getFont()->setBold(true); $objPHPExcel->getActiveSheet()->getStyle("F2")->getFont()->setBold(true); $objPHPExcel->getActiveSheet()->getStyle("G2")->getFont()->setBold(true); $objPHPExcel->getActiveSheet()->getStyle("H2")->getFont()->setBold(true); $objPHPExcel->getActiveSheet()->getStyle("I2")->getFont()->setBold(true); $objPHPExcel->getActiveSheet()->getStyle("J2")->getFont()->setBold(true); $objPHPExcel->getActiveSheet()->getStyle("K2")->getFont()->setBold(true); $objPHPExcel->getActiveSheet()->getStyle("L2")->getFont()->setBold(true); $objPHPExcel->getActiveSheet()->getStyle("M2")->getFont()->setBold(true);

// Redirect output to a client’s web browser (Excel2007) header('Content-Type: application/vnd.openxmlformats-officedocument.spreadsheetml.sheet'); header('Content-Disposition: attachment;filename="DATE WISE ITEM SALE REPORT.xlsx"'); header('Cache-Control: max-age=0'); // If you're serving to IE 9, then the following may be needed header('Cache-Control: max-age=1');

// If you're serving to IE over SSL, then the following may be needed header ('Expires: Mon, 26 Jul 1997 05:00:00 GMT'); // Date in the past header ('Last-Modified: '.gmdate('D, d M Y H:i:s').' GMT'); // always modified header ('Cache-Control: cache, must-revalidate'); // HTTP/1.1 header ('Pragma: public'); // HTTP/1.0

$objWriter = PHPExcel_IOFactory::createWriter($objPHPExcel, 'Excel2007'); $objWriter->save('php://output'); exit;

Please solve the problem

johmue commented 5 years ago

@swapnilb0506 

https://github.com/iliaal/php_excel != https://github.com/PHPOffice/PHPExcel